i am try to create a report, but for some reason i can’t link ARinvoice to Soshipment
Answer
How do i Link ARInvoice Report to SOShipment
Best answer by Ankita Tayana
Hi @SandyA,
Please find the below screenshot for relation of ARTran with SOShipment.
I have attached GI xml.
Hope, it helps!
+15You will need to use the SOOrderShipment table for the join as there could be multiple shipments on an invoice.
Dermot Comerford
+15
Please check if below relations will help you!
Acumatica Functional Consultant & Customer Experience Supervisor
+5Hey
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,
Michael Shirk, Pine View Buildings, LLC - If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi
You can use below tables to Join the ARInvoice to SOShipment.
Results:
Hope, it helps!
- for some reason there is no relatedd tables for me
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.