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
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?