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

Any suggestions?

Thanks!

Chris

bitpushr Rookie Asked on December 4, 2019 in Billing.
Add Comment
5 Answers

KAJ710, thanks for the reply. For your second bullet, do you mean that I should create an “empty” SO with status approved, and then import the CSV containing all of my lines?

(edited to add this) When I create a new SO via Transactions -> Sales -> Enter Sales Orders, the only options I see for Status are “Pending Fulfillment” and “Pending Approval”. Or should I start with a CSV with only headers, and then add another CSV with the transaction lines?

Rookie Answered on December 5, 2019.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.