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 :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / I want to change poste...
Microsoft Dynamics GP (Archived)

I want to change posted SOP Docuement Number

(0) ShareShare
ReportReport
Posted on by Ramzy N.Ebeid 255

Dear All
i am working with GP10, SP4
We make stock count month 12-2010 and everything is working very good.
We are using customizations for creating the new serial for the SOP documents.

But after all invoices are posted we recognized that some of the invoices are created on GP,
SOP Document Number of year 2011.
So around 370 Invoices are created with Serial of year 2011.
Serial 2010: SAL10-00000001
Serial 2011: SAL11-00000001

So I am asking you is there a way that I can change all these invoice number from the tables directly or not.

Otherwise there will be a big problem with us for the whole year.

Thanks,

*This post is locked for comments

I have the same question (0)
  • Ramzy N.Ebeid Profile Picture
    Ramzy N.Ebeid 255 on at
    Re: I want to change posted SOP Docuement Number

    More  Clarification:

    The SOP Document is Posted in year 2010 but with Serial of 2011 Like SAL11-00000001

    so what i want to do is change the SOP Number from Serial 2011 to Serial 2010 SAL10-00000001

  • Community Member Profile Picture
    Community Member on at
    Re: I want to change posted SOP Docuement Number

    Hi, yes in theory you could update the data through SQL. However, before you try this, could you:

    1. Restore to a backup prior to the import, change the document numbers, and re-import all docs properly? or...

    2. Void the 370 documents an re-enter them? or...

    3. Run with the document numbers as is...or do you have reports or processes using the logic of the SOP Number in some way?

    Updating the document numbers through SQL, while possible, could be troublesome. For example, we don't know what modules / features you are using (other than SOP) - you could be tracking Salesperson commisson - in which case the salesperson commission tables would also have to be updated. If you are using VAT Daybooks - these tables woud also have to be updated. The list of possible tables could be long and it would be very easy to miss one.

    If it was me...I'd void the documents and reenter them. It might seem like a big task - but at least you would know that every required field would be updated properly. The SQL approach could be quick and easy...but then again, if you missed a field, it would cause issues later on...and no matter what way you look at it, the integrity of your data would be compromised. Voiding really would be the safest and surest way, and with 370 documents, it would probably take no longer than the SQL approach when you take into account backing up data, re-searching the tables, running the queries, checking the results etc.

    Ian.

  • Suggested answer
    Richard Whaley Profile Picture
    Richard Whaley 25,195 on at
    Re: I want to change posted SOP Docuement Number

    There are too many tables to hit to do this cleanly and easily.  It would be easier, like Ian suggested, to restore to backup or void the incorrect transactions and redo the day's work.  Sounds like a lot but the way you want to do it, even if we knew ALL of the possible tables, would be more work.  Plus, typically only one person can fix tables while you possibly have a group of people that can help with the re-entry of the transactions.

    First issue I can hear is that you may have already sent out some of the documents to customers.  You should use notes on the new documents to record the original document number as well as keeping a manual list of Wrong Number/Right Number.  It will come in handy when posting payments for those customers that have the incorrect 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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

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…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans