Notifications
Announcements
No record found.
Hi Experts,
Any idea on how the GeneralJournalEntry table is populated after posting customer transaction like "Free Text Invoice".
Thanks,
Ysrael
*This post is locked for comments
Hi Ysrael,
When you post a free text invoice, accounting distributions are used within the subledger framework. Subledger entries are created. Then from these subledger entries the accounting entries are created. The GeneralJournalEntry table is one of the tables related to the accounting entries. Transferring the subledger entries is a task that can be setup to be run synchronous with the posting, asynchronous or using the batch framework to have it periodically transferred.
What is the background of your question?
What would i do if i want to change the Description on the GL>>Reports>>Transactions>>Ledger Transaction List report(LedgerTransListAccount) from say Free text Invoice to the actual description on the original transaction line.
Hi Mr Andre,
Thanks for the response.
The background of my question is, when posting Free Text Invoice the first Line(s) of (custInvoiceline.description) should be the value appear in Voucher Transaction form description which is GeneralJournalAccountEntry.Text that's the requirements.
And this could be solved by adding New parameter in the Default Description setup, but this option is limited to selected region which my country is not included.
So my first aproach is to find how the GeneralJournalEntry and GeneralJournalAccountEntry is being populated while posting Free Text Invoice, then on that stage I could use the custinvoiceline.description to be the value of GeneralJournalAccountEnrty.Text, but unfortunately I could not find where on the posting stage might happened of populating the GeneralJournalAccountEntry.
My next approach is to wait the Free Text Invoice is posted find the link from CustInvoiceTable to GeneralJournalAcountEntry then do update the record.
Do you have other way that much easier than my second approach?
Hi Reginald,
if your current region has available option to add parameter in the Default Description setup. Please refer on the link below.
technet.microsoft.com/.../jj677363.aspx
If not, then i guess this need customization, same my approach on the above of this thread.
My issue is the Quantity from the Free Text invoice line isn't being brought over to the
GeneralJournalAccountEntry Quantity field. I am trying to find out which object or class is calling it so I can make sure I populate. If I set the customer invoice transaction quantity, will it flow down to the general journal account entry?
Hi Andre,
I have a similar issue. Trying to post a FreeTextInvoice and validating the vouchers soon after. I'm using DemoData company USMF. The vouchers don't appear until after a few minutes. Would you be able to let me know where to set the subledger transfer to be synchronous?
Never mind..I found it..In GL Parameters under Batch transfer you can set it to synchronous. Also, if you want to see the code of the transfer. It should be class SubledgerJournalTransferController which is run under GL\Periodic Tasks\Batch Transfer for subledger journals
Hi ,
Once I debugged I found SubledgerJournalTransferCommand class having insert statement
insert_recordset generalJournalEntry( AccountingDate, FiscalCalendarPeriod, PostingLayer, Ledger, SubledgerVoucher, SubledgerVoucherDataAreaId, TransferId, JournalNumber, FiscalCalendarYear, JournalCategory )
In insertGeneralJournalEntryRelated method. Just run debugger without CIL Business logic.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Martin Dráb 4 Most Valuable Professional
Priya_K 4
MyDynamicsNAV 2
