Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

Integration template into 365 but there are duplicate invoice numbers

(0) ShareShare
ReportReport
Posted on by 5

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

  • PPECB-Charlene Profile Picture
    PPECB-Charlene 5 on at
    RE: Integration template into 365 but there are duplicate invoice numbers

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

    pastedimage1681191165057v1.png

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,965 Super User 2025 Season 1 on at
    RE: Integration template into 365 but there are duplicate invoice numbers

    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?

  • PPECB-Charlene Profile Picture
    PPECB-Charlene 5 on at
    RE: Integration template into 365 but there are duplicate invoice numbers

    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.

  • Komi Siabi Profile Picture
    Komi Siabi 12,759 Most Valuable Professional on at
    RE: Integration template into 365 but there are duplicate invoice numbers

    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.

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.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,965 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 230,817 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans