RE: Csv Import for Cash Sales

in NetSuite after Logged in
Setup/(Import/Export)/import csv records
import Type (Transaction)
Record Type (Cash Sale)
after that We will Enter to Field Mapping now there is a Item Sub list Which I need to Import but it is not Showing Plus mark to add one more Item but in the Billable Time Sub list it is showing plus mark to add more then one Billable Time now I need that Plus mark in the Item too So that i can add 2 Items.
is there any work around for this?

Gurudeep_Naik Rookie Asked on September 12, 2023 in Items.

also asked/answered in #csvimports and in #general

on September 12, 2023.
Add Comment
1 Answers

I’m not sure I’m fully following your question, but it sounds like you are trying to import Cash Sales with multiple items, and expecting a separate sublist mapping for each item line (on the right side) in NetSuite. That’s not how it works. You only map the sublist fields once and then you can have multiple items in your import file.  You need to make sure that all the lines are linked together with an External ID (that you also need to map).  Doesn’t matter what it is, just has to be unique across transactions.  So for example, if you were importing a cash sale with two items, you’d have two lines on your file, each with External ID of let’s say 123, and then for the items, rate, etc. columns you’d have the different item, rate, etc. values.  Hope that helps!

Intermediate Answered on September 12, 2023.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.