This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Maybe add the checkbox to the line items?

id imagine asynchronous line level exports to be a pain

then you really need to keep track of what changed when

I'm sending the whole record at once. I won't send on a line level basis

I'd only send the delta if an edit is made and the warehouse will accept or reject the whole delta.

you would need to keep track of which revision contains which line to update a status field on the line

Once celigo has the message, it will send to 3pl, if 3pl accepts then celigo will write back a TRUE value to each item from the JSON message

at the moment it just writes back to the mainline of the SO

by accept, do you mean a checkbox to indicate its been sent to your 3pl

in that context accept is a HTTP 204 from the warehouse

or that there is a checkbox to indicate that the revision wasnt rejected later

once I get the HTTP 204, I then access the SO and check a box on the SO mainline

I could easily just check boxes on the line items as celigo knows which items were sent to 3pl

a checkbox to indicate that the 3pl has received the data is easy

the checkbox to handle the asynchronous part is hard

That final step in the celigo flow can set checkboxes on line level just as easily as the mainline

actually that flow is sync, in an async scenario, the 3pl could call a Celigo end point with a JSON message showing all of the items that were accepted

then I map each item in the JSON to the item on the SO

I'm trying to work out what would be hard based on your comments. I'm only going to deal in whole orders via JSON and not individual line items sent one at a time.

im assuming the 3pls api was asynchronous

it is - that may change but for now it is

meaning you would not be able to tell if it suceeded

Correct, I will have to rely on them sending me something later

ideally a copy of the order with OK or FAIL

if OK, I can check boxes against each item code. If fail, they remain unticked

if your 3pl includes the data that was submitted in their response, then you wont need logic to figure out which revision contains which lines

Best way to really do this is cancel the SO and create a new one.. then again I'm not the one having to do that so easy for me to say :slightly_smiling_face:

i wouldnt expect your 3pl to include data unless they post the status to your endpoint when the revision is processed

but it's a WMS so it will have that data anyway

but yes I can easily see pushback from them