Invoice import and payment terms

(0) Share

Report

Posted on by Dwight00

We are trying to load both customer and vendor invoices from 3rd-party source systems via DMF through a general journal. The customer and vendor masters have a payment terms code on the master. We would like to have the invoices determine the due date from the payment terms. This does not seem to be happening. Instead, the due date seems to be set to the invoice date. We are trying to load older invoices for testing purposes.

Any thoughts?

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

A.Prasanna 8,223 on at

Like (0)

Report

Refer to the " Validation" section at

docs.microsoft.com/.../optimize-data-migration

as I can remember by enabling " Run business logic in insert or update method" will do the trick.

Regards,

AP

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Dwight00,

If you have updated "Terms of payment" on customer/vendor card, it will be populated on the journalline when you choose customer/vendor. So, Due date will be generated to in regards to "voucher date".

"General journal" does not include "Terms of payment" field so we can not use this field while importing to generate due date. It means that if you do not use due date field in the source file that you want to import via DMF, due date will not be generated in regards to the customer/vendor's terms for payemt.

As alternative, you can send customer and vendor information to your 3rd-party source systems that they can generate due date based on the "Terms of payment" when they send data to D365FO.

Was this reply helpful? Yes No
Dwight00 10 on at

Like (0)

Report

Thanks,

1. There is a due date field in the target mapping mapping for the general journal entity in DMF.

2. Should I be using a different staging entity for the vendor and customer invoices?

Was this reply helpful? Yes No
Suggested answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Dwight00,

1-Yes. Entity "General journal" have field for "Due Date" while it does not have a field for "TERMS OF PAYMENT".

2-Entity "Vendor invoice journal line" has fields for Terms of payment and due date. So you can import terms of payment to manage the due date or you can delete these fields in the source file and let the D365FO use terms of payment from the vendor card. In the following example, I have imported journal line for vendor invoice via "Vendor invoice journal line" without having "DueDate" and "TermsOfPayemnt" in the Excel file. Then, while importing the value for terms of payment have taken from vendor card and have updated the due date for the invoice.

Was this reply helpful? Yes No
Dwight00 10 on at

Like (0)

Report

Thanks Alireza, I thought I was going to end up heading in this direction for a solution.

What about for a customer invoice? We want to load customer invoices from 3rd-party system into D365 and use collections module. I do not believe there is an AR equivalent of the vendor invoice journal?

Dwight

Was this reply helpful? Yes No
Verified answer

Alireza Eshaghzadeh 14,679 Super User 2025 Season 2 on at

Like (0)

Report

Hi Dwight,

For customer invoice, there can be used free text invoice.

Using general general give this possibility to decide over invoice number while you need to import due date information via 3rd-party system integration.

You can raise a ticket on experience.dynamics.com/.../ so that Microsoft will add Terms of payment field to the standard entity "General journal" so while importing data for customer and vendor due date can be manged by "Terms of payment",the same behavior like "Vendor invoice journal line" entity, or you can create a customized entity for "General journal" where you can import "Terms of payment". The other alternative that is already mentioned that you can import due date from 3rd-party system integration while importing customer and vendor invoices.

Was this reply helpful? Yes No