Finance | Project Operations, Human Resources, ...

duplicate Invoice numbers different customers error

(0) Share

Report

Posted on by Ramon L

149

Hi All

Quick question, I picked up an error in my project invoicing. I found 2 invoice numbers that are identical however they are for 2 seperate customers. Both postings were succesful but differnet dates and differnet amounts, however this should not have happened. Anyone have an idea how is it possible to post 2 invoces for 2 seperate customers and get the exact same Invoice number, surly it should have failed with the note that the inocmve number already exists. Can someone just point me in a direction to check that my systems is not causing issues

I know this should not happen as we have checks and balances in play that checks for duplicates.

regards

I have the same question (0)

All responses (6)

Answers (0)

Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hello,

I assume you are missing one validation in GL parameter- General- Check for voucher used - from there you can setup if you want to restrict duplicate invoices, or you can warn as well.

Please check and update if this meet your requirement.

Was this reply helpful? Yes No
Ramon L 149 on at

Like (0)

Report

Hi Ramit

not really .. i just checked and found the error. check here and let me know what think

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

You shared the transaction print screen and that states number is same but date isnt, like I mentioned duplicate number can be warned, errored if you want to set this up.

If I am missing something, please share to understand.

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi Ramon,

As per system logic, The ID of the project invoice numbers are automatically assigned when you post an invoice proposal and not keyed by business user.

Do you use Number Sequence Group with customer because in that case system will allow different customers to have their own Number sequence?

Is there any customization on customer invoice?

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Good morning Ramon,

Can you share the headers of the lines that you shared in your previous screenprint?

What do the different columns show?

Also, can you please check your project contract and there the funding source details?

In the funding source details form one has the option to setup an invoice number sequence group.

Is it possible that they have been defined for your customer and that there is some overlap in those sequences?

Best regards,

Ludwig

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 300,911 Super User 2025 Season 2 on at

Like (0)

Report

Hi Ramon,

Another possible cause could be that someone did change number sequence values manually. On the number sequence details, you can find the history to check if someone manually changes certain values. If this happened, the parameter shared by Ramit can prevent posting duplicates.

Do you have customizations or ISV solutions?

Was this reply helpful? Yes No