Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

need help on Partial payment(migration)

Posted on by 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

  • Suggested answer
    L Vail Profile Picture
    L Vail 65,271 on at
    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:

    Import-RM-Trx-with-pmts-attached.png

    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 Profile Picture
    Community Member Microsoft Employee on at
    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 Profile Picture
    L Vail 65,271 on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,151 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,993 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans