Share
ReportHi,
Can anyone tell me what are the database tables that I should join to get the posted payment journals on a customer basis?
You’re offline. This is a read only version of the page.
10
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 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.
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.
Below are the tables that might be joined.
LedgerJournalTrans
CustInvoiceJour
SalesTable
SalesInvoiceJournalPost
CustTrans
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.
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
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (
