https://netsuiteprofessionals.com logo
Join Slack
Powered by
Hi All, I'm trying to import sales orders via CSV ...
# general
d
Hi All, I'm trying to import sales orders via CSV import to NetSuite - These are historical test orders - I am constantly getting "Invalid item reference key 48330 for subsidiary 2." errors on the import. The customer is mapped to the correct internal ID and is active The item is mapped to the correct internal ID and active (this is the 48330 in the message) Subsidiary 2 is active. Any thoughts on how to resolve this?
m
Make sure the primary subsidiary for you customer is included in the subsidiary list on the item record.
d
the subsidiary is included on the item and customer
m
Did you change your mapping type in the Csv import to map internal id instead of name?
d
Yes mapping internal id of customer and item
m
Check if you have really used ID of the item
d
I created the item specifically for this purpose, the internal id is correct
m
@David Hall I think we are just confirming that in the mapping of the CSV import you have updated the mapping settings using this pencil icon here
And changed the reference type to Internal ID
m
Yes exactly that Mavencloud explain
d
It is set to internal ID
m
Also this subsidiary field on the item record needs to include whatever Subsidiary 2 is (either by selecting subsidiary 2 directly or using the Include Children box
Lastly, check the system info tab and see if the item is set to inactive
Also check the custom form you are using in your import...does it have an Item Filter on custom form?
Try importing using the standard sales order form
And turn off "Trigger Custom Scripts and Workflows"
d
tried using the standard sales order form and turning off "Trigger Custom Scripts and Workflows" - same result
same error message
m
If you check scripted records are there any scripts deployed to the sales order?
Also what role are you using?
d
administrator role
m
Are you importing into a date in the past?
d
yes
m
Do you have an accounting period created that covers that date?
d
yes
m
Do you use display name on your items?
d
We will if we can get the import to work - for now I'm using a test item with a known internal ID and mapping to that item internal ID
m
Can you try importing using the name instead just to see?
Also are there any phantom spaces in your excel file?
Any special characters in your excel file?
d
no special characters, by phantom spaces do you mean unmapped fields?
m
No like maybe your file has 48330[SPACE]. And you can’t easily see the extra character in the cell in Excel
Or maybe a space before 48330
d
i'll check
Ok, not sure what did it, but it looks like changing to names worked
m
Well that's good (kind of)
Concerning Internal ID doesn't work as that is the thing I always use as the most reliable
Just note if using Display Names on your items you have to do the item name/number + display name in your import to get it to work
d
Internal id has always worked for me so I agree it’s weird. We do not have number + display name in the import
Attempting a larger import now to see if it’s resolved
m
Maybe try with an existing item using internal ID?
40 Views
Open in Slack
PreviousNext
Powered by