Hi team! We are currently building a Celigo flow ...
# integrations
t
Hi team! We are currently building a Celigo flow to import item receipts for NetSuite Inbound Shipments, and we are testing scenarios where a line item's actual received quantity exceeds its expected quantity. During our testing (as shown in the attached screenshots), we were able to receive the full quantity of 4000 for one line item, which exceeded its expected quantity of 2500. However, we were unable to replicate this for other line items, despite receiving no error messages from Celigo or NetSuite. Has anyone experienced this issue before? Could you please advise what might be causing this inconsistency and whether all line items under the inbound shipment should be able to receive quantities larger than their expected quantity? Thank you!
m
Do you receive the same problems running that code as a suitelet in NS? What about in UI?
a
Hi @Tianyao Ma sorry I won’t be much help here but I am trying to build the same flow and wondered if you had any advice for me. When posting the recipt do you tie it to both the PO and Inbound shipment? Or just the shipment?
t
Thank you @mightyd3! We haven't got the Suite script set up, but that's something we are looking into.
No worries @AI1! We have tied the post to the line item using the Shipment Number, ItemID, and PO to account for scenarios where the same item may be listed with different POs.
s
Hi - you’ll need to uplift the PO quantity for that line, then uplift the Inbship quantity then receipt it. You also need to guard for any dialogue boxes that Netsuite pops up. It’s not easy. We tried it but didn’t get it production ready.