You’re offline. This is a read only version of the page.
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
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.
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.
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
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (