Notifications
Announcements
No record found.
Hi,
Can anyone tell me what are the database tables that I should join to get the posted payment journals on a customer basis?
Hi Nav2985,
Posted payment information is stored in CustTrans table and it can be linked to customer by AccountNum field with filter by TransType = Payment.
From CustTrans you can get related original journal line in LedgerJournalTrans by Voucher and TransDate relation.
In all cases, DataAreaId and Parition should be included in the link as
HI Nav2986,
There is a report called Customer posted payment journal. (CustPostPaymJournal).
You can check its DP class there.
Thanks for your help, Sergei.
Thanks for your help, Blue Wang.
Thanks, Blue Wang. But I would like to pull the data (payment journal, on which invoice the payment has made and customer details) from databases.
Below are the tables that might be joined.
Sergei, is there any other tables that should I join.
I would like to pull the data (payment journal, on which invoice the payment has made and customer detilas) from databases.
LedgerJournalTrans
CustInvoiceJour
SalesTable
SalesInvoiceJournalPost
CustTrans
Hi Nav2986,
Invoices are also stored in CustTrans and original document can be found via voucher and InvoiceDate in CustInvoiceJour.
CustSettlement table is used to keep settlement information between 2 CustTrans transaction (payment and invoice in your case). This table contains referenrce by RecId to CustTrans in fields TransRecId and OffsetRecId.
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 672 Most Valuable Professional
André Arnaud de Cal... 534 Super User 2025 Season 2
Sohaib Cheema 289 User Group Leader
