[coffeeguy]

Every day we import data in Netsuite from our freighting system via a CSV file. It is a file that consists of the Transaction ID and the carrier's consignment note reference. As we ship a combination of Cash Sales and Invoices we need to do two imports each time.

Is there a way to have a single import which will update both Cash Sales and Invoices?

Coffeeguy
This is a cached copy. Click here to see the original post.

[Olivier Gagnon NC]

Not out-of-the-box, but if you want to go scripting you can custom-create a smart functionality that is able to do this.

[coffeeguy]

Is it a simple exercise?

[Olivier Gagnon NC]

Difficult to answer. Simple for me? Sure. Simple for someone that doesn't know scripting like I do? Nope…

Probably not a great answer but not sure how else to answer…

[coffeeguy]

I'll put it on my growing wishlist of scripting requirements.

It's like top baseball players find top grade baseball easy, while less mortals may have trouble hitting those curve balls.

[EnablingSolutions]

How often will you need to import them? If it's going to be a regular task, then maybe you need to seriously consider creating an intermediary custom record type which you can import all data into, and then create a User Event which creates the associative Transactions off the back of it.

[coffeeguy]

At the moment we import twice per day using two Saved CSV Imports. It's not that we are creating new transactions, just wanting to populate some of the fields with the consignment information.

The import file only has three fields for update plus the Trans # as the key. We are looking at increasing this to four times per day which is 8 CSV imports.

So you suggesting bring that into a customer record, which then triggers a workflow to update the original records?

[Author]

Posts