Best Of

@Pierre_Plourde ,

Thanks for confirming. And I also noticed your comments in responding to @Jeremy Guimaras -Oracle.

My immediate thought is that how payment will be received/made against if there were no open transactions?

When we migrated our system, we faced similar dilemma, but we decided that importing open transactions is the way to do. For one thing it will eliminate the aging issue. And below is how we dealt with the volume of line items.

All transactions just would just contain one line : Opening Balance (non-Inventory part for sale on invoice and on-inventory part for purchase on vendor bill). The G/L impact of an open invoice would look something like below:

The accumulated amount of all open transactions should equal the opening balance of A/R or A/P, respectively.

On go-live date, we created a journal entry to clear our the opening balance G/L account. Again using A/R as an example, below is what the JE looks like:

We believe this way it would preserve the financial records while greatly reduce the burden for importing transaction line details.

Just wanted to share my past experience and provide some ideas.

Thanks again @Pierre_Plourde ! Appreciate the help.

Hey @Avinash A,

Every NetSuite Implementation is unique and has its unique challenges.

I recommend doing an implementation listing detailed business requirements rather than attempting a SuiteSuccess implementation, which rarely works as expected.

It is also crucial to have Standard Operating Procedures for each key function to ensure NetSuite features can be correctly and efficiently mapped to the business requirements.