Hello everyone,
Recently my company acquired another smaller company who used Quickbooks for their accounting purposes. We've been in the process of transforming and integrating all that data into NetSuite, almost entirely successfully, but one of the snags is this:
When we imported their accounts receivables, their Invoices and Payments didn't have any form of tying numbers or indicators. Their journal entries ran in a bit of a circle, and while it makes the accounts balance out properly, now that they're imported as Journal Entries into NetSuite, NetSuite thinks that there is a large amount of unpaid items and our A/R aging is messed up.
We were trying to fix it by hand. Create a new "Accept Client Payment" for the unmatched Journal Entries, then delete the imported entries causing the problem. This works for a few of them, but there are about 250 more accounts that aren't quite as simple. Some clients would pay ahead of time, some sent credits alongside the payments, etc. The situation is a bit unwieldy.
Does anyone know if there is a cleaner/easier/faster way to fix this than going in by hand and manually changing all of this? We need it done by the 21st, so time is a definite factor.
Please let me know if you would like me to explain anything in regards to the problem more clearly and I will do my best to do so.