Hi
I am trying to join the General Journal Account Entry with Custtrans using the Voucher field.
Select T1.*, T2.*
GeneralJournalAccountEntry T1, CustTrans T2
Where T1.Voucher = T2.Voucher.
But I am getting a lot of nulls on the AR front (data from CustTrans) after joining.
Could you please assist me with correct join. Also the possible reasons to the nulls.
Hi Mahek,
The table GeneralJournalEntry should be linked as well. This table has the AccountingDate field to be used for the link with the CustTrans table.
Hi Calavon,
Thank you, could you also help me with more details about which posting dates can be considered. Should more focus be on Accounting Date/Document Date etc. from GJAE table or any posting dates from CustTrans table to select only Closed transactions.
Or maybe, is there any field to identify customer transaction in the GeneralJournalAccountEntry among other transactions.
Hi Mahek,
Next to the voucher, you also need to have a range on the posting date. Make sure you have an inner join as there are accounting entries not related to customer transactions.
Hi,
I would recommend taking a look at the transaction origin report in GL and how it is designed.
It allows you combining vouchers and including subledger details.
Best regards,
Ludwig
#1
André Arnaud de Cal...
294,261
Super User 2025 Season 1
#2
Martin Dráb
233,013
Most Valuable Professional
#3
nmaenpaa
101,158
Moderator
Share
Report
All responses (
Answers (
