New Item Import Into NetSuite

Integrator.io
, , ,
1

We currently import items using record type SubZero Item. We think this was set up in error as we dont do anything with a "SubZero Item". All our items are set up as either serialized inventory or inventory items (accessories).

I was looking at the list of item record types in the dropdown in the screenshot and there are a handful of item record types: Item, Inventory Part, Inventory Number and Serialized Inventory Item.

The image shows a software interface for importing records, where "Inventory Part" is selected as the record type and "Add" is chosen as the operation. (Captioned by AI)
The image shows a software interface for importing records, where "Inventory Part" is selected as the record type and "Add" is chosen as the operation. (Captioned by AI)518×476 20 KB

Im wondering what the difference in these record types is.

Thanks!

2

You can reference the NetSuite record schema browser here: https://www.netsuite.com/help/helpcenter/en_US/srbrowser/Browser2016_2/script/record/inventoryitem.html

In your case, Inventory Part = inventoryitem.

1 Like
3

Ok, this is what we are currently mapping

The image shows a mapping interface connecting source record fields from FTP with destination record fields in NetSuite. (Captioned by AI)
The image shows a mapping interface connecting source record fields from FTP with destination record fields in NetSuite. (Captioned by AI)1178×349 21.8 KB

The import errored out

image

However, our source FTP file doesn't include tax schedule or vendor bill credit - other charge item, and per NetSuite, those item fields are required.

Do we need our partner to send us these two pieces of data for our import to work?

4

I attempted to make these fields not mandatory but looks like NetSuite forces them to be mandatory?

The image displays a checklist of various account types with options to show or set them as mandatory, with "Tax Schedule" highlighted and marked as both shown and mandatory. (Captioned by AI)
The image displays a checklist of various account types with options to show or set them as mandatory, with "Tax Schedule" highlighted and marked as both shown and mandatory. (Captioned by AI)653×484 15.5 KB

A table displays several options with checkboxes under "Show" and "Mandatory," with the "Vendor Bill Credit - Other Charge Item" highlighted and checked in both columns. (Captioned by AI)
A table displays several options with checkboxes under "Show" and "Mandatory," with the "Vendor Bill Credit - Other Charge Item" highlighted and checked in both columns. (Captioned by AI)663×182 6.16 KB

5

I doubt your partner would give you this. You'd need to check with the finance team and see where they should go and then just hardcode the mapping value.

1 Like
6

Makes sense, Tyler. Let me check and ill get update when i can. THanks!

7

Hey Tyler, our partner says they will send us the item Brand in a new file.

During the item import process, the goal is to populate the item field below since its mandatory.

A field help dialog describes the purpose and handling of an "Other Charge Item" for vendor bill credits in an application interface. (Captioned by AI)
A field help dialog describes the purpose and handling of an "Other Charge Item" for vendor bill credits in an application interface. (Captioned by AI)591×352 14.8 KB

There will be three BRANDS each with their own associated Vendor BIll Credit Item:

Brand Vendor Bill Credit - Other Charge Item
Wolf Vendor Bill Credit Item - Wolf Appliance
SubZero Vendor Bill Credit Item - SubZero
Cove Vendor Bill Credit Item - Cove

So when an item is being imported, can a lookup identify the Brand in the source file, then pick the appropriate vendor bill credit item?

Not sure how complicated this is, but having the Brand data, i hope there might be some sort of lookup we can apply.

Thanks!

8

Here is the Brand item field

A dialog box titled "Field Help" describes that the field labeled "BRAND" with the value "Wolf" represents the brand classification. (Captioned by AI)
A dialog box titled "Field Help" describes that the field labeled "BRAND" with the value "Wolf" represents the brand classification. (Captioned by AI)538×292 5.52 KB

9

I’d suggest checking out Celigo U training since this is a pretty fundamental mapping scenario. We also have a great doc here that covers both static and dynamic lookup mappings, which sounds like exactly what you’re trying to do.

Since the Brand field will have one of three known values, a static lookup mapping should work well. You can define a mapping like:

Wolf => Vendor Bill Credit Item - Wolf Appliance  
SubZero => Vendor Bill Credit Item - SubZero  
Cove => Vendor Bill Credit Item - Cove

Once set up, the import flow can use the brand from the file to automatically populate the correct Vendor Bill Credit item.

10

Thank you! I will test when i receive the file.
I also appreciate the educational resources you provided.