Hey guys, question, we want to import one bill pay...
# csvimports
j
Hey guys, question, we want to import one bill payment in the CSV process that applies to 4 bills. However, whenever we do this, it's creating 4 different payments -- 1 for each bill. We're not sure what we're doing wrong. Let me know pictures or more information would help.
r
How does your csv file look like
j
Here's our example import
message has been deleted
So, for example, that's check 40507 -- it's a single bill payment for 4 different bills, and it's creating 4 payments.
Here's the mapping
message has been deleted
r
Your external id has different values, netsuite assumes that each row is a new records. If you want multiple rows to belong in one record, it should have the same external id. Apologies for the late response.
j
No worries, thanks sir we'll give it a shot and I'll let you know our findings
Thanks! We tested a couple things today, and you were right. After we made the External ID the same for a single payment it imported as expected