Discussions

Check out Oracle NetSuite upcoming events and conferences here
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
Update your Profile with your Support type to get your Support Type badge.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.
Community Poll: What sort of content would you like to see more of?

NSC | CSV import: Customer Payment with Account and Deposited Status

edited May 16, 2024 4:04PM in Accounting / ERP

Scenario

User wants to CSV import a customer payment and set the Account as internal ID but it didn't work. After importing, user noticed that "Undeposited Funds" is still the one selected on the transaction instead of the Account set on the import file. User wants to set the Account from the CSV file and the status should be "Deposited".

Solution

In order to fill up the Account, you need to add an additional column for Undeposited Funds and set it to F on the excel file. As per SAID 9965 - "If you import customer payment records with a value of 

Clarisa De Torres | Ask a Guru

  • Earn Community badges now! Refer a Member | Answer Accepter |
  • Expand your NetSuite knowledge by joining this month's Ask A Guru Live about SuiteScript. RSVP on this event now!

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!

Leaderboard

Community Whiz

Quarter 2 ((Apr-Jun 2024) )

This Week's Leaders

This Month's Leaders

All Time Leaders