Hi,
I’ve recently started a new job, and this is my first experience working with Acumatica. Since we do not have an internal team for Acumatica, I’ve taken on the task of modifying a Generic Inquiry to better suit our needs.
Currently, I’m facing an issue with a Generic Inquiry for Sales Orders with multiple shipments. The problem is that we are seeing duplicate lines in the inquiry. Specifically, the Sales Order lines are not being correctly linked to the Shipment lines, resulting in each item being displayed multiple times—once for each shipment associated with the order.
I have attempted to adjust the table relationships in the Generic Inquiry but have not been successful in resolving the issue. The duplicate lines are causing discrepancies in quantities and amounts, leading to overages in our reports.
Could someone please provide guidance on how to fix the table relationships to avoid these duplicate lines? Any assistance or advice would be greatly appreciated.
Thank you in advance for your help!
