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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 632 Super User 2026 Season 1
Giorgio Bonacorsi 624
CP04-islander 301
