Hi Andre,
The request comes for budget control purposes. From my understanding, the business would like to have the main account be switched in GL entries to a specific budget control account for certain accounting groups (i.e. supplies, tools, etc.). However, the financial voucher transaction lines should maintain the original main account. It is a strange request but they insist that it is the route they want to take.
Goal here is to swap out the main account used at the time of the GL journal creation to separate the financial journal transaction vouchers for what is actually hitting the ledger budgets for analytics purposes while also maintaining budget control.
Currently, I have added an additional column called "Budget Control Account" on the Invent Posting form which will be populated with the budget control main account that they want for each Inventory Posting type (see screenshot below). This number would be different than the main account column number for certain posting types and accounting groups.
After the Journal is posted, the logic will look inside the item details for the transaction and retrieve the accounting group assigned to it
Additionally, the logic will go into the financial voucher transactions to retrieve the Posting Type
Finally, when the journal is posted, it should insert 533104-5990-520-3-20- for a debit of 4.34 as the only line within the GL journal for this specific example in the screenshots. We don't need to insert a line in the GL entry for the offset account because this information will be stored and referenced in the original financial voucher transactions.
I imagine that I would have to write a method to generate a new ledger dimension RecID, but instead pointing main account to the new budget control account column. Any tips on the best way to go about this would be much appreciated.
Thanks so much!
