Skip to main content

I added the SOShippingAddress table with the Inner join type to the SOOrder parent table. this was done as I am making a copy of the report but one that tracks ship to address data for country, city and state. after doing so the report goes from loading in seconds to taking a minute or longer to load.

is there a better way to do this join so it doesn’t take so long to run and parse data?

 

 

Take another look at the join conditions. You're joining [SOOrder] OrderType to SOOrder.OrderType and [SOOrder] OrderNbr to SOOrder.OrderNbr.

You need to join [SOOrder] ShipAddressID to [SOShippingAddress] AddressID

Take another look at the join conditions. You're joining [SOOrder] OrderType to SOOrder.OrderType and [SOOrder] OrderNbr to SOOrder.OrderNbr.

You need to join [SOOrder] ShipAddressID to [SOShippingAddress] AddressID

thank you very much @darylbowman implementing that fixed the issue, it only takes a few seconds to run the report now rather than a minute or more.

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved