Share
Report
8Dear All,
I am trying to automate monthly income tax calculation and recording of journals in D365 using the Allocation journal type. For our requirements, we take 30% of PBT and record 30% income tax as Debit to P&L Income tax expense account and credit to the balance sheet Income Tax provision account (if there is profit before tax).
Using Allocation, I was able to successfully calculate, create and record the journal based on the account series of the P&L accounts (profit before tax, PBT).
The issue I am seeking help for is that the journal that is created is at each account level i.e. if I have 100 accounts that make up PBT, the income tax journal created through allocation is 200 lines (100 for P&L and 100 for Balance Sheet).
Is there a way that I can create and summarise it to only 2 lines i.e. 1 for P&L and 1 for Balance Sheet?
I am trying to automate monthly income tax calculation and recording of journals in D365 using the Allocation journal type. For our requirements, we take 30% of PBT and record 30% income tax as Debit to P&L Income tax expense account and credit to the balance sheet Income Tax provision account (if there is profit before tax).
Using Allocation, I was able to successfully calculate, create and record the journal based on the account series of the P&L accounts (profit before tax, PBT).
The issue I am seeking help for is that the journal that is created is at each account level i.e. if I have 100 accounts that make up PBT, the income tax journal created through allocation is 200 lines (100 for P&L and 100 for Balance Sheet).
Is there a way that I can create and summarise it to only 2 lines i.e. 1 for P&L and 1 for Balance Sheet?
All responses (
Answers (
