Loading AR History - How've you done this?

Dezz17

I've got a customer that wants Sales History loaded. This is history that's already closed. So how have you done this? How? I've posted sales invoices and washed it by hitting the AR acount as the balancing side of the transaction so there's a net effect on the G/L. But now how do you suggest I offset the payment side of the transaction?

Just looking for ideas.

Thank you!

ara3n

Hello Dezz17. If you are going to bring them through Sales orders, On payment method there is a balancing account. and you can setup a gl account to hit. So money will move the for example the cash account. The question is that are you going to bring the payment history as well? if yes then you don' t want to use payment method code.

My general question is are you bringing just the customer history or also items etc. If it's customer history. Just create Gen. journal lines for the customer. Don't need to bring it through sales invoice. Bring also the payment history as well and do the application if they have this info. and if you don't then set application to automatic on customer card.


Now to not have any effect on GL, you need to setup Posting groups so that it flushes out GL. So that the invoice and the payment hit the same account and net effect on that account is zero.

Alex_Chow

A/R history is typically just A/R history, no item details.

To properly bring over A/R history, you will need a payment application information from your legacy system. Once you have that, you'll have to:
1. import invoice
2. import payments and credit memos,
3. import the application data into the applies-to doc. no.
4. post the invoice
5. post the payment/credit memos with the applies-to doc no.
6. manually apply the rest

kriki

[Topic moved from Dynamics NAV forum to Navision forum]