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
Please see line items for Journal - we are importing data into 365 in order to action a payment to a vendor.
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?
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.
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.
André Arnaud de Cal...
291,965
Super User 2025 Season 1
Martin Dráb
230,817
Most Valuable Professional
nmaenpaa
101,156