need help on Partial payment(migration)

(0) Share

Report

Posted on by Community Member Microsoft Employee

Scenario-

In my old system(xyz ERP) i have a invoice of $100, i recived payment of $80 against the $100 invoice. So in new system(that is GP) should i take the $20 invoice against $100(that is left) and not ? or what should i do with the partial payments?

P.S - I am migrating the data from old system(xyz erp) to GP.

*This post is locked for comments

All responses (3)

Answers (0)

Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: need help on Partial payment(migration)

Hi,

I'm actually suggesting that you import the 100 gross invoice with the $80 set in the check amount field. It's as if the customer paid the $80 at the same time you posted the invoice. You wouldn't post an $80 cash receipt separately. Take a look at your destination mapping in IM and you'll see the bit for where you can put a payment.

You have an invoice of 100 that has received two payments against it, one for $40 and another for $30. I would take a similar approach to this one only I would use Cash and Check for the 2 payments. Your transaction would import looking something like this:

I'm confused about the credit memo comment. Is this really a credit memo of 100 with it being applied 30 to one invoice and 40 to another. Thus leaving your credit memo with a 30 balance. The question of how to handle partial transactions can be a tough one. The easiest way to do it is to just import the leftover as an open transaction. In the invoice side, you could also import the 100 invoice with an 80 trade discount to lower the balance to 30. You can do something similar with credit documents. What kind of volume are you dealing with here? Ho many partially paid transaction exist in all of the modules,

Kind regards,

Leslie
Community Member Microsoft Employee on at

Like (0)

Report

RE: need help on Partial payment(migration)

so you are suggesting me that i should only import the amount left(i.e $20) only?

and can you help me in one more Scenario?

like--

I have a invoice of $100 and in which $40 and $30 is paid( $100 -$40-$30) and the left amount is $30 and this $30 is in credit memo, so what should i do in this case?

--------------------------------------------------------------------------------------------

and apart from open invoices should i have to migrate Credit and Debit memos too?
Suggested answer

L Vail 65,271 on at

Like (0)

Report

RE: need help on Partial payment(migration)

Hi,

Partial payments are always a complication. You should for sure bring over the open $20, but do you want to also record that it started at 100 and then paid down 80. If there was only one payment, I would import the full value of the receivable with an $80 payment applied at the time of import. You'll get the history of the full value of the invoice and the 80 payment. If you're using Integration Manager, just put an amount in the Checks destination with the appropriate payment number and check number.

Kind regards,

Leslie