Hi <@U03HQ088UKY>, Happy New Year! I've run into...
# integrations
s
Hi @Tyler Lamparter, Happy New Year! I've run into an issue and was wondering if you might have any experience of it. We need to develop a flow to update the Gross Amt on a Cash Refund (there was an issue with an upstream Shopify system so that tax was charged twice and we're trying to correct that). I've created a data loader to update the cash refund. However, I'm getting 2 errors: 1. Initially it threw the error Please configure the inventory detail for this line. 2. So, I'm trying to update the inventory detail - but now just getting the dreaded Failed to save record because null Possible reasons include > Something went wrong on NetSuite side. > You might have specified an invalid field value for a field. > You may have submitted an invalid record Have you ever come across that one - I've never been all that confident with the inventory details, it's tended to be a bit of trial and error Kind Regards, Stewart
t
Happy new year!
So you are adjusting the amount on the cash sale lines?
s
Thanks! Yes, that's the intention.
t
I'll have to config some netsuite env similar to test. Do you use bins? Serial numbers?
s
We just use bins, no serial numbers
t
Want to just provide me your flow zip and sample JSON from export step? I can work without it, but would be easier to start from where you are at
s
Yes - give me 5mins
👍 1
Hi Tyler - here's a Zip and the sample file that I'm using
t
Stumping me a bit as well. Checking with engineering
@Stewart do you have to map the inventory details in? I'm able to update the amount of the line item without mapping in inventory details
I get the same error you do when I try to map in inventory details
s
Hi @Tyler Lamparter - I was hoping not to map the inventory details in, but when I don't Netsuite throws an error "Failed to save record because Please configure the inventory detail for this line." I'm wondering if there might be a script involved - I'll take a look at that
👍 1
t
Sounds good. I was able to get with no inventory detail mapping and I have bins and inventory status on. I did add a transform step to the export to get line items into an array because sometimes I've seen it act wrong if "items" is mapped to a non array
Note that adding a transform 2 will break the previewing of your import though. That will be fixed in upcoming Jan release
s
OK - I'll give that a try. (I tried turning off the scripts but that didn't fix it.)
t
s
Many thanks
Just in case anyone else ever looks at this - fix was to use Line ID as the key rather than Item Name. Netsuite issue with Cash Refunds I think.
🙌 1