How do i Link ARInvoice Report to SOShipment

You will need to use the SOOrderShipment table for the join as there could be multiple shipments on an invoice.

​@SandyA 

Please check if below relations will help you!
 

Hey ​@smuddurthi81 ,
The other answers correctly identified the need to use the SOOrderShipment table for the query. 
The AI generated answer does not provide the correct solution, and contains a lot of unnecessary, extra information, which will confuse users who aren’t familiar with the Acumatica database schema.

ChatGPT and other LLMs can be very helpful for solving specific problems, but it is the user’s responsibility to understand the output, and to verify its accuracy. 

Everyone has access to these LLMs and are hopefully using them as applicable. When attempting to help people find solutions to their questions, it is important to respect their effort and only respond within our personal areas of expertise to maximize the value that this forum provides.

Regards,

Hi ​@SandyA 

You can use below tables to Join the ARInvoice to SOShipment.

Results:

Hope, it helps!

​@Ankita Tayana how did you join the ARTran to SOShipment

• for some reason there is no relatedd tables for me