Finance | Project Operations, Human Resources, ...

InvoiceID and PackingslipID

(2) Share

Report

Posted on by Kulsum

I am trying to create a report that has customer invoiceid and packingslipid, there is not easier relation between the custpackingslipjour and custinvoicetrans. Is there a way I can get the information in a query?

Categories:

Dynamics 365 Finance

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Sohaib Cheema 48,300 User Group Leader on at

Like (2)

Report

InvoiceID and PackingslipID

There are many standard methods in the Dynamics that explain this concept and have the code that you can use as inspiration to get it work for you.

here is an example Table>> CustInvoiceTrans >> Methods >> deliveryDate

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

CA Aman Agrawal 48 on at

Like (0)

Report

InvoiceID and PackingslipID

Hi @Kulsum,

As I understood your question you wanted to create a report which contains the Customer invoice ID and Packingslip ID.

So, instead of directly using custpackingslipjour or custpackingslipjour table you can use the inventtrans table with combination of inventtransorigin table to get the required data.

Please find the below screenshot for your reference.

Hope this will help you.

Regards,
Aman

1 people found this reply helpful.

Was this reply helpful? Yes No