Finance | Project Operations, Human Resources, ...

Apply Cash Discounts on POSTED invoices when importing Vendor Payments

(0) Share

Report

Posted on by SErf

657

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 :)

I have the same question (0)

All responses (4)

Answers (0)

SErf 657 on at

Like (0)

Report

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:

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No
SErf 657 on at

Like (0)

Report

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):

With Cash Discount (error)

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!

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (1)

Report

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

Was this reply helpful? Yes No