Haven’t found a topic that mirrors my feable attempts, so creating my own topic.
First to discuss is that NEtSuite now allows importing CSV bulk fulfillments.
I can successfully import bulk fulfillments using this field mapping…
I can use that saved import and the CSV templae for both lot numbered items and non-lot numbered items.
Field values for the NetSuite CSV import (and what I’m trying copy via Celigo)
Created From = Sales Order Internal ID
External ID = I’m using the actual sales order number
Status = static “Picked” (could use “Packed” as well")
Date = today
Item = actual item name/ID (ex: 2895_CS50031)
Location = warehouse name
Order Line = actual order Line ID
Quantity = the total qty order for this item/line
Bin = The bin I want the item to be picked from
Serial Numbers = the Lot Number for the item in the bin location
Lot Qty = the qty to be picked from that Lot/Bin
Order Line = this is a re-used field. Same value as above. But the NetSuite CSV import would not work without this mapped to the very stangly named “Surrogate Subrecord”.
Secondly, I’m working in the netSuite Sandbox at the moment. The sample file I’m using to test the Celigo flow works 100% in a NetSuite CSV import. I’ve actually done that, then deleted the fulfillments created.
Now we’re to the question of field mapping. In some cases, the field names shown in Celigo do not exactly match the filed names in NetSuite. And there certainly is no “Surrogate Subrecord” in Celigo.
My connecitons are setup and working re-used connections that I’ve used many times.
A portion of my sample data appears thusly…
For this flow, the relevant portion of the NetSuite connector looks like…
Fulfillment fields are mapped thusly…
and inventory detail fields are mapped as…
The error I get when running the test is not helpful
I guess the only other thing I could show you is…
I have tried many stupid iterations as I am stubborn!
I’ve tried things like usign the item internal ID and changing the mapping.
I’m stuck.
Any help would be much appreciated.
Tom A.