web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Invoice ID got changed...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Invoice ID got changed from Order00567 to Order00567001 automatically. why gp added 001 to invoice number?

(0) Share

Report

Report

Posted on by angelpriya

140

HI All,

Invoice ID got changed from Order00567 to Order00567001 automatically. why GP added 001 to invoice number?

In order history table sop30200 correct order number is present "Order00567".But in apply open table RM20101 and GL table its shows as "Order00567001".

is there any open bug or feature which added 001 to invoice ID ?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (0)

David Musgrave MVP ... 14,095 Most Valuable Professional on at

Like (0)

Report

Is this a recurring batch or was there already a transaction with Order00567?

Was this reply helpful? Yes No
angelpriya 140 on at

Like (0)

Report

Hi David ,

its not recurring batch. No there was no transaction with transaction ID Order00567

Was this reply helpful? Yes No
Suggested answer

Beat Bucher GP Gee... 28,058 Moderator on at

Like (0)

Report

Hi,

it's unlikely that GP added the "001" to the order number.. it's not in the habit of GP of doing that.. and as David said, if you already had an invoice posted to history with the same number, you can't post that twice.. which means someone (or some 3rd-party add-ons) changed the document number to append that 001.

Are you using any external software or application to GP ? like SalesPad or any integration tools (Smartconnect or IM).. there might be some logic built outside of GP that could have done that..

Was this reply helpful? Yes No
VInquiry 20 on at

Like (1)

Report

Do you have a recurring batch? This is where I've seen GP append the Order or Invoice number.

Was this reply helpful? Yes No
RR-07061806-0 627 on at

Like (0)

Report

Good day,

The same is happening intermittently with a 3rd party app we currently use. When the invoices are exported to GP this month 2 documents were incremented with the 001. I am seeing this when I run the Reconcile to GL Receivables, is it then there may be a duplicate receipt number.

On the GL side I am seeing the correct invoice number, e.g., 394199, potentially matched I'm seeing 394199001. When I search for 394199001 via Receivables inquiry I see the document, when I click on document number I get to 394199 in SOP.

In as much as I don't understand what/why this is happening, the export option is a standard daily option, I am able to source the documents on either side should I be concerned?

Regards

Rosemary

Was this reply helpful? Yes No
RR-07061806-0 627 on at

Like (0)

Report

Good day,

I checked the history tables and I found a document with the same number so I guess that's why GP responded as it did.

Relative to the date of the documents it means we need to do some removal of history.

angelpriya, you need to check your history tables, that order number number exists somewhere else.

Regards

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

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

#1

Martin Dráb 451 Most Valuable Professional

#2

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

#3

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans