Hello everyone! CSV updates to existing journal entries caused over 3700 invoices to be unapplied from their payments. NetSuite applied random journal entries to these payments. Is there a way to reverse that or reapply these invoices in a faster way than manual? Because of NetSuite's limitation regarding customer payments, there is no way to apply credits also. Huge problem!

I learned this the painful way one time. It was quite the undertaking to fix it.

I can imagine! Do you mind sharing some details? Did you have to do that manually or was able to use other solutions?

I was able to torture a CSV import to figure it out - but the bigger issue was figuring out which payments were applied to which transactions

Interesting! Were you able to reapply credits using CSV import? I do have a record of which transactions belong to which payments.

I recall being able to do so - but I do know I spent a boat load of time figuring it out

I know that NetSuite doesn't do this natively. Was it a Suitelet?

NetSuite Professional Services learnt this the hard way on our account once. That was fun times 😄 lol . The poor dude wished he'd never hit execute on the Map/Reduce

NetSuite Professional Services are hands down the worst! They are the reason why I got into this fiasco. We had to restructure our whole accounting. Can I restore the copy from sandbox to production?

No, unfortunately

Will the following work? 1- delete the problematic payment 2- create a new payment manually, apply all necessary credits, and any line from the invoice sublist. 3- Do CSV import to update the new payment with all the invoices (replace the one applied manually with the correct list)

why do you care if the credit is applied from the payment?

the payment amount is not the same as the total invoices. Are you suggesting applying the deduction via the disc. taken field?

No. I'm saying you should be able to do a zero dollar payment and have it re-apply both transactions against one another