Skip to main content

Notifications

Announcements

No record found.

Dynamics 365 Community / Forums / Finance forum / Apply Cash Discounts o...
Finance forum
Suggested answer

Apply Cash Discounts on POSTED invoices when importing Vendor Payments

Posted on by 655

Hi,

we are currently using a different IT system for our accounts payable invoices and payment of vendors.

Our AP invoices come from a different system and we are importing them into F&O - unfortunately we don't have Cash Discounts at this point in time.

This means that the invoices are imported and posted in the "Vendor Invoice Journal" without Cash Discounts.

When we then pay these invoices (from our other system), we see if there was cash discount.

Now we want to also import the payments into F&O using the "Vendor Payment Journal".

I can correctly link the payment to a settlement of an invoice using the "Vendor Payment Lines Settlement" Entity.

But I don't know how I can in the import of the Payment specify that Cash discount was taken.

This all leads to one question:

How do I correctly import (Excel) Payments & Settlements with cash discounts of an invoice if the invoice had been posted without cash discount?

Thanks a lot :)

  • SErf Profile Picture
    SErf 655 on at
    RE: Apply Cash Discounts on POSTED invoices when importing Vendor Payments

    I am also still hoping for a) to be possible, but I don't know it yet.

    I think that Dynamics tries to map the Cash Discount to the "Open Vendor Transactions".

    If I add the Cash Discount in the transaction manually, it imports fine. 

    So.. Maybe I could also import the Cash Discount into the transaction? Could that be possible?

    What Entity is this? And I would probably need to get the Voucher Id from somewhere?

    So adding it here into the Voucher (Transaction?) would fix the issue:

    cd.png

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Apply Cash Discounts on POSTED invoices when importing Vendor Payments

    Hi SErf,

    I had a look at some of the standard data entities especially the vendor payment journal line settled invoice one but could not find the field - as you mentioned - that enforces the use of the cash discount.

    I think that you have two options going forward:

    a) You can try to post the invoices with a cash discount code when importing them in the first place

    or

    b) You need a developer modifying the standard entity you use for importing the payments and cash discounts.

    Best regards,

    Ludwig

  • SErf Profile Picture
    SErf 655 on at
    RE: Apply Cash Discounts on POSTED invoices when importing Vendor Payments

    Hi Ludwig,

    front-end wise I am able to do this. I struggle doing this with my Excel - Import.

    When I import my Excel, I get the error that "Cash discount for invoice 2019/12345 was not found"

    Importing WITHOUT cash discount works fine

    This is what my excel looks like WITHOUT CASH DISCOUNT (working fine):

    withoutCashDiscount.png

    With Cash Discount (error)

    withoutCashDiscount.png

    When in frontend you set cash discount to "Always" but it seems I cannot do this in excel? 
    Or do I have to import this in yet another entity / table?

    Thanks!

  • Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Apply Cash Discounts on POSTED invoices when importing Vendor Payments

    Hi SErf,

    In the settlement form you have a parameter available that allows you specifying whether a cash discount shall be taken or not. If you overlooked entering the cash discount term with the invoice posting you should be able to set this parameter to 'always take the cash discount' and enter the cash discount taken.

    Have you tried doing that already?

    Best regards,

    Ludwig

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,696 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,490 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans