Topic: Dimension wise balance sheet items (A/C Payable and Receivables)
I got P&L items that can be split dimension wise but balance sheet items like A/C payables and A/C receivables can't be split dimensionwise.
For a supplier invoice,
Dr. GR/IR Clearing - There is a dimension
Cr. A/C payable - There is no dimension
For a customer invoice:
Dr. A/c Receivable (Customer) - There is no dimension
Cr. Sales - There is a dimension
The end result is, the trial balance/P&L/Balance sheet can not be segregated dimensionwise. In whole trial balance, there is a balance in Sales, COGS, inventory, A/c. Payable, A/c. receivable but in dimensions TB there is no value in the receivable and payable account. Need help in this. We want to have dimensions for both the payable and receivable accounts.