Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
Posted on by angelpriya 130

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
  • RR-07061806-0 Profile Picture
    RR-07061806-0 81 on at
    Invoice ID got changed from Order00567 to Order00567001 automatically. why gp added 001 to invoice number?
    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
  • RR-07061806-0 Profile Picture
    RR-07061806-0 81 on at
    Invoice ID got changed from Order00567 to Order00567001 automatically. why gp added 001 to invoice number?
    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
     
     
     
     
  • VInquiry Profile Picture
    VInquiry 20 on at
    RE: Invoice ID got changed from Order00567 to Order00567001 automatically. why gp added 001 to invoice number?

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

  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    RE: Invoice ID got changed from Order00567 to Order00567001 automatically. why gp added 001 to invoice number?

    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..

  • angelpriya Profile Picture
    angelpriya 130 on at
    RE: Invoice ID got changed from Order00567 to Order00567001 automatically. why gp added 001 to invoice number?

    Hi David ,

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

  • David Musgrave MVP GPUG All Star Legend Moderator Profile Picture
    David Musgrave MVP ... 13,965 Most Valuable Professional on at
    RE: Invoice ID got changed from Order00567 to Order00567001 automatically. why gp added 001 to invoice number?

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

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,403 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans