web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Suggested answer

Vendor Invoice with "hidden" dash character, system not recognizing it as a duplicated invoice number

(1) ShareShare
ReportReport
Posted on by 10

Hi All,

We have encountered an issue where a vendor invoice was manually entered (no excel add-in used) and posted through an invoice journal.

Several days later, the same invoice number was used for the same vendor. Rather than throwing any error for reusing a duplicate invoice number, the system found nothing wrong with it.

In the screenshot below, you'll see what looks like identical invoice numbers.

Duplicate-invoice-number-within-D365.png

(Ignore the reversal transactions) 

However, when I export out these records into excel, I can see that the 12/31 transaction has an additional "-" included in it. For some reason though, this dash is not recognized within Dynamics.

Duplicate-invoice-number-within-Excel.png

Also, if I go to the original journal that had the 12/31 posted invoice on it, and then open the journal with the excel add-in, the excel cell shows two dashes, but the invoice journal only shows the one:

Excel-Journal.png

I'm very confused about how this might've happened, and am looking for an explanation of what would have caused this?

Any information or suggestions would be appreciated. Thank you all in advance!

- David

I have the same question (0)
  • dgamble Profile Picture
    10 on at
    RE: Vendor Invoice with "hidden" dash character, system not recognizing it as a duplicated invoice number

    Hi Andre,

    Thank you for your suggestions. I'm searching for any known issues, and if I don't happen to find the issue reported I will open up a ticket.

    Thank you,

    David

  • dgamble Profile Picture
    10 on at
    RE: Vendor Invoice with "hidden" dash character, system not recognizing it as a duplicated invoice number

    Hi Ludwig,

    Thank you for your reply. I think it is very unlikely that the parameter was switched off and then back on to allow this posting, but I will check the database logs to be sure.

    As far as I'm aware, there haven't been any modifications made to the invoice number field, across any forms.

    This is the only instance where I have noticed this behavior as well, and I haven't been able to replicate the issue with any success.

    Thanks,

    David

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Vendor Invoice with "hidden" dash character, system not recognizing it as a duplicated invoice number

    Hello David,

    Is it possible that somebody disabled the duplicate check parameter when posting those invoices?

    Are you aware of any system modifications that have been made to the invoice number field?

    Best regards,

    Ludwig

  • André Arnaud de Calavon Profile Picture
    298,740 Super User 2025 Season 2 on at
    RE: Vendor Invoice with "hidden" dash character, system not recognizing it as a duplicated invoice number

    Hi David,

    I haven't heard of the double dash before. I would suggest that you reach out to Microsoft Support and create a ticket for this. Before doing that, first check if there is a known issue on LCS issue search.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,339

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 824 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 600 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans