Integration template into 365 but there are duplicate invoice numbers

(0) Share

Report

Posted on by PPECB-Charlene

HI Community,

Any problem solvers out there? :)

Creating a template EDI file to pull information into 365 to make payments to a vendor in F&O but there are two fields (lines) standard and no VAT for the invoice but they have the same INVOICE number and the system does not allow duplicate invoices for vendors in the system.

Any ideas or solution for this that can assist with this process when importing the template into 365.

Much appreciated

Charlene

I have the same question (0)

All responses (4)

Answers (0)

Komi Siabi 13,107 Most Valuable Professional on at

Like (0)

Report

Hello PPECB-Charlene,

If I get you right, you want to bring some records in the Invoice table, but two records could have same Invoice number.

Was this reply helpful? Yes No
PPECB-Charlene 5 on at

Like (0)

Report

We have an excel template with certain fields of data one of fields is the invoice number but for example with an airticket some is standard price and then part there is NO vat so there is tow lines of data for the same invoice and so the invoice number is the same and 365 does not allow dulpicate invoice numbers. On the physical invoice it is one cost but need to split cost when pulling into 365.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,035 Super User 2025 Season 2 on at

Like (0)

Report

Hi Charlene,

Can you provide screenshots of the source file and the journal which got created in Dynamics 365 Finance? Are you creating an invoice or payment journal?

Was this reply helpful? Yes No
PPECB-Charlene 5 on at

Like (0)

Report

Please see line items for Journal - we are importing data into 365 in order to action a payment to a vendor.

Was this reply helpful? Yes No