Dear Friends,

We want to upload urgently.

1. Open entries of ACP & ACR into system.
2. Open Purchase Order
3. Open Sales Order.

Need help from you, which are the tables, where data will be uploaded through exchange scheme.

or any other method.

Thanks in advance for your help.

To create open AR in a new company it is best to create an scheme to have the system create your open entries from a spreadsheet with all the needed information on it. Before you do so it is important to make sure all the customers are setup in your new system since you will need to use the new customer number in the import.

On the AP side you will have 3 groups, The PO's that are open with no receipt or invoice in the system (just create new PO in new system and process as usual), PO with full receipt but no invoice- you will need to see if you can clear as many as possible in your old system and those still open at cut over will need to be entered into excel or as a report with the details and then when the invoices come in for them you will enter them in the new system as a cost invoice with an account for the expense that is the same number as your goods received not invoiced account you bring from the old system (need cutover new number for this) so when these are all done that account should balance to zero. New PO's and those without receipts will use your long term account for goods received not invoiced that you create in the new system.

Hope this helps. If you have questions, feel free to give me a call.
Katie Kelley
740-816-8763
15 years Senior Baan/LN finance consultant