We have the ability to distribute expense among different subaccounts in one single bill, but is there is a way we can post the same proportions into different AP subaccounts?
Currently, there is only one AP subaccount we can enter when creating a bill.
Thank you
Page 1 / 1
Hello @apallawala21
When creating an AP bill the user can manually add the sub-account-wise lines and the system will post the amount of those sub-accounts.
Otherwise, the user can use the GL allocation functionality.
Set up an allocation rule
Create a bill for the source account
Run Allocations
The system will allocate the source account amount to the destination accounts based on the percentage in the allocation rule
Thanks
Hello @YasasWithanage76
Yes, it is possible to enter multiple subaccounts on the detail level, but actually I’m referring to the credit leg subaccount which you see in the financial tab.
Is there any way we can post the credit amount to different subaccounts, so the Accounts Payable is also getting drill down to different subaccounts same as the expense.
Thank You!
Hello,
You are correct, an AP Bill with 3 expense subaccounts will not post the credit side of the transaction to three subaccounts without customization.
I recommend that you Do Not use GL Allocations to allocate your AP account to different subaccounts. Doing so could make a mess of AP Aged Period Sensitive Aging to GL monthly reconciliation. GL Allocation changes the GL balances thout changing the underlying AP documents that still have the full credit amount posted to one AP subaccount.
I recommend marking the AP Account as a Control account in Chart of Accounts, with “Allow Manual Entry” not selected → to keep the AP control account in balance with the Aging.