Skip to main content
Solved

Adding new Table to Sales order Summary makes it run significantly slower.


Forum|alt.badge.img

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?

 

 

Best answer by darylbowman

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

View original
Did this topic help you find an answer to your question?

2 replies

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1593 replies
  • Answer
  • October 4, 2024

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


Forum|alt.badge.img
  • Author
  • Jr Varsity III
  • 51 replies
  • October 4, 2024
darylbowman wrote:

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings