This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, customer wants to migrate sales information from another system to netsuite with .csv Sending system makes creates debit and credit colums as gross amount. Haven’t figured out yet is it possible to have them that way in netsuite, or must they allways be in form debit/credit as net and then gross amount in separate?

I'm not quite sure I follow the question. When you import cash sale, invoice, or sales order, usually the 'amount' column is a net amount, not a debit/credit. The system will generate the debit/credit GL impact if it is a cash sale or invoice.

Here is an <https://blog.intheblksoftware.com/blog/three-approaches-to-importing-historical-sales-into-netsuite|article on my blog> discussing three approaches I've used with my clients to import historical sales. Happy to chat more if you need help. Send me a DM.

thank you. I see if we can make something up with this