Does this look crazy to anyone? For returns, NetSu...
# suitescriptc
Craig
10/22/2020, 8:09 AMDoes this look crazy to anyone? For returns, NetSuite needs one item receipt for the items to be restocked and one item receipt for the items that will not be restocked (damaged). The fulfilment centre is only sending one JSON back to NetSuite (via Celigo) which mixes 'restock' and 'non-restock' items together. There's no way to split a line item into restock and non-restock on an item fulfilment in standard NetSuite. I have no control of the data structures (or anything) that the fulfilment centre sends to NetSuite, this is considered immutable.
b
battk
10/22/2020, 9:30 AMPerhaps you can have 2 flows, one for good and one for damaged
battk
10/22/2020, 9:31 AMAlternatively ask celigo if they can make 1 flow create 2 records
c
Craig
10/22/2020, 11:27 AMFirst option requires change in the WMS which I can't do
Craig
10/22/2020, 11:28 AMSecond one was my preferred option - 3 weeks with celigo support and they've gotten nowhere.
Craig
10/22/2020, 11:31 AMThen there's the added problem that I can't map the inventory detail subrecord (with Celigo) as it adds an extra subrecord instead of overwriting the existing one. Had this problem for a long time now, could have fixed with SS in a matter of hours
m
matt.graney
10/22/2020, 2:53 PMhi @Craig, can you let me know your Celigo support ticket number on the above? I’d like to take a look. https://netsuiteprofessionals.slack.com/archives/C29HQS63G/p1603366082252900?thread_ts=1603354174.246800&cid=C29HQS63G
4 Views