Suggestion required

navuser1

Hi ALL,

I have created a New Database.All master data and setups are present in this db.
Our Client wants there some old transaction data into this DB.

Is there any problem if old transactions(customers outstanding, suppliers outstanding,employees advances pending purchase & sales orders) are present?

kine

Best is to fill appropriate journals and poste them. Do not try to move the entries by just copying the data from one table to another (I am talking about the posted transactions tables, not Customer, Item, Vendor etc. tables).

But to be precise, why you created new DB? It is some upgrade? Between which versions? Or it is just Native => SQL migration?? :?:

navuser1

Thank you for your precise suggestion.
Actually Our Client Db size is almost 70GB.
There are many wrong entries in this Db Because Of Wrong Customization.

So we are removing that customization and creating a new DB from the old db .

kine

Than if you are doing new "go live", than take it as update from another system - use the journals to enter the open balances etc. to have them correctly created...