Standard Report at: Accounts Receivable > Reports > External > Customer account statement
i need to show the Invoice Account/Name of each Line, then group them by Invoice Account.
I traced the Lines are at CustTrans, now I need to link them to the Invoice Account.
please help me find the tables and relations to get it. thanks.
*This post is locked for comments
CustTrans and CustTable are joined using following relationship
CustTrans.AccountNum == CustTable.AccoutNumber
Apart from your question I have a question for you.
what is benefit of this Grouping.
This report, Customer Account Statement, is opened for one customer at a time. So all the records which you see at screen by running this report are belonging to one customer. Now what will give by grouping it with CustTable.InvoiceAccount...???
Hi - There are two accounts on the CustTrans table. CustTrans.AccountNum and CustTrans.OrderAccount. CustTrans.AccountNum represents the Invoice account. Logically, its the account where the invoice is posted too, where Order account represents the customer account where the order was sent or placed. They can be different, but many times they are the same.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,219 Super User 2024 Season 2
Martin Dráb 230,056 Most Valuable Professional
nmaenpaa 101,156