Announcements
No record found.
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
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.
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.
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?
Please see line items for Journal - we are importing data into 365 in order to action a payment to a vendor.
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.
Congratulations to our 2026 Super Stars!
Thanks to all of our 2025 Community Spotlight stars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
André Arnaud de Cal... 590 Super User 2026 Season 1
Giorgio Bonacorsi 349
Diego Mancassola 263
