RE: Uploading a Sales Order with 1,700 lines times out
I have a few of SOs with between 1,100 and 1,700 lines, containing a total of a few thousand items. We upload them with the status “Pending Approval”, but when we go to approve them, the approval times out. After several minutes and we get a generic “Error: An unexpected error occurred”. Occasionally we’ll get a webserver-style “The gateway request timed out”.
I’ve opened a case, but the answers don’t make sense. The initial answer I got was “The limit for a CSV is 5000 lines”, but I’m clearly well under that. When I asked for clarification, I was told “The limit is 5000 lines for uploading, but if you want to approve a big CSV via the web, the limit is really 500″.
They suggested we try and upload the same ~1,700 line CSV with the status “Pending Fulfillment”. When we do that, we get a different error:
Error;int ID;Status An unexpected SuiteScript error has occurred;5387598;Pending Fulfillment
I’m (just) an intern, so I don’t know about the long-term impact. But we have to do these large Sales Orders about 30-40 times per year, at a guess. They are used when wholesalers place orders for a new collection (Spring, Fall, etc.)
AFAIK there are no complex scripts or workflows. Right now it’s more of an annoyance, and a good amount of “It’s hard to accept that NetSuite doesn’t provide this functionality”.
Support just emailed me to say they handed my case off to the SuiteCloud people…
(edited to add) The trouble with splitting up the big SO into three SOs, e.g. 500 lines per SO, is that now we have three SOs but only one PO from the customer, only one invoice, etc. It’s a lot of added hassle.