Finance | Project Operations, Human Resources, ...

What is the relation between CustPackingSlipTrans and CustInvoiceTrans tables using X++

(1) Share

Report

Posted on by D365FO DEV

406

Hello everyone,

I need your help to provide the relation between CustPackingSlipTrans and CustInvoiceTrans tables to get the data from CustPackingSlipTrans to show on the CustInvoiceTrans to use them on the ssrs report.

this is the custpackingsliptrans table. i want the data showing here to show on the custinvoicejournal form in custinvoicetrans table.

in the standard functionality, its already done but im new to this one and facing issues, so please if anyone can just give me the relation and my issue will be resolved.

thanks

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

I don't have access to any environment now but I think in general there was a relation between these two tables:

CustPackingSlipTrans.InvoiceTransRefRecId = CustInvoiceTrans.RecId

Thanks,

Layan Jweihan

Please mark this answer as "Verified" if it solved your issue. In order to help others who will face a similar issue in the future

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report
Copy link

Link copied!

i tried but its not working, because we can have on a sales order mutlitple packing slips and each one has different values than the others

Was this reply helpful? Yes No
Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Check if those old threads help

https://community.dynamics.com/forums/thread/details/?threadid=132958ba-b6cc-4931-b3cb-af6d70af6a85

https://community.dynamics.com/forums/thread/details/?threadid=03e30e19-8251-4635-bbdd-f0f49422f4f8

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report
Copy link

Link copied!

i checked them, but theres no correct answers

Was this reply helpful? Yes No
Suggested answer

Deepak Agarwal 8,770 on at

Like (0)

Report
Copy link

Link copied!

If you could have the system, its very easy to find,

Was this reply helpful? Yes No
D365FO DEV 406 on at

Like (0)

Report
Copy link

Link copied!

i know about this one but i dont think this one is enough because for 1 sales order, we may have mutlitple packing slips for different invoice journals

Was this reply helpful? Yes No