Skip to main content
Solved

can't search in Sales Order Lines


Forum|alt.badge.img

Copyright © 2005-2022 Acumatica Inc. All rights reserved.
Acumatica Cloud ERP 22.110.0018
Build 22.110.0018 +

 

All, we can’t search by Sales Order Lines -- if we enter a string in the search field (magnifying glass), we simply get a spinning blue circle. Log out and log back in and it seems the main screen seems to hang and can take about 30 to draw/display.

Known bug? Something we can try to alleviate?

Best answer by darylbowman

Try disabling those conditional value columns.

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

11 replies

darylbowman
Captain II
Forum|alt.badge.img+13

First stop, try holding the shift key and clicking the browser refresh button. This recaches the page and fixes weird stuff sometimes.

Next stop, when did this start happening? Has anything changed recently, like an upgrade, new customization, etc?


Forum|alt.badge.img
  • Author
  • Freshman II
  • 129 replies
  • June 1, 2023
darylbowman wrote:

First stop, try holding the shift key and clicking the browser refresh button. This recaches the page and fixes weird stuff sometimes.

Next stop, when did this start happening? Has anything changed recently, like an upgrade, new customization, etc?

Sorry Daryl, should’ve mentioned in original post I tried the usual suspects, clearing cache, different browsers, etc.

When: unsure. I don’t work w/ sales orders and mostly do report designer/GIs. I just asked someone in Customer Service and they said about two years, lol!

I will ask our main dev who deals with our VAR. Currently the workaround in customer service is to use column filters. I just tested in Sales Orders and Purchase Orders and they both behave as expected… even a simple string that should return a lot of results only takes 2-3 seconds. Sales Order Lines will sit there for 45-60 seconds.


darylbowman
Captain II
Forum|alt.badge.img+13

Is this on a custom generic inquiry, or what screen ID? Perhaps there is simply too many results. Could you try changing the GI to limit to the past year’s worth of orders or something?


Forum|alt.badge.img
  • Author
  • Freshman II
  • 129 replies
  • June 1, 2023
darylbowman wrote:

Is this on a custom generic inquiry, or what screen ID? Perhaps there is simply too many results. Could you try changing the GI to limit to the past year’s worth of orders or something?

GIOZ3255

Sales Orders are about 21000 records and searches are almost instantaneous. Sales Order Lines are about 41000 and it hangs for close to a minute.

I duplicated the GI and changed the default display 100 records to 35 and it didn’t make a difference.

Looking in the results grid there are 56 columns, and 6 of the columns have VisibleExpr like

“=iif( [SOLine.RequestDate] < [SOShipLine.ShipDate] , 'Late' , 'On Time')”

So I’m not sure if the number of columns plus a handful of visibility expressions would cause it to crawl with 41000 records.

By comparison, Sales Order has 35 columns with no visibility expressions and half the records.


darylbowman
Captain II
Forum|alt.badge.img+13

Try disabling those conditional value columns.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 129 replies
  • June 1, 2023
darylbowman wrote:

Try disabling those conditional value columns.

Will do. I also just noticed this:

 

Looks like I might need to re-do the relationships?


darylbowman
Captain II
Forum|alt.badge.img+13

I doubt that's the issue, but you could disable that too.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 129 replies
  • June 1, 2023
darylbowman wrote:

I doubt that's the issue, but you could disable that too.

Yeah, those pop up occasionally but never noticed a negative impact.

Disabling the visibility conditions made an instant improvement. That’s not the solution I wanted because CS will not want to turn those off, lol. But at least I know. Thanks Daryl!


darylbowman
Captain II
Forum|alt.badge.img+13

You could try doing conditional formatting instead. Keep the values as actual fields, but if an order is 'late', turn it red.


Forum|alt.badge.img
  • Author
  • Freshman II
  • 129 replies
  • June 1, 2023
darylbowman wrote:

You could try doing conditional formatting instead. Keep the values as actual fields, but if an order is 'late', turn it red.

Ahhhh dude, that is a big brain moment. yes, hadn’t thought of that! I wish I could like your comment twice!


darylbowman
Captain II
Forum|alt.badge.img+13

Haha, just an idea. If it works, I can't tell you why that's faster, cuz it seems like it would be doing all the same processing.


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