Dear All,
Could you please guide for me how to get relationship between tables in Sales Line Invoice?
I try get from some tables: CUSTINVOICETRANS, CUSTINVOICEJOUR but I loss some rows data.
Many thanks
Hi partner,
Please give us more details about your business requirement.Also please check the CustInvoiceSalesLink table, it links Sales orders and invoices.
Dear Will WU,
Please guide for me.
How many tables is created from Sales Line Invoice?
And if better, you no worry please show me relationship this.
Many thanks.
Hi Khoa Phan Tan,
Not sure what you need, you could get invoice account and customer name from CUSTINVOICETRANS.
And please check INVENTTRANSID.
CUSTINVOICETRANS.INVENTTRANSID=SalesLine.INVENTTRANSID
Hope this helps.
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,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156