550
We are using Supply Chain Module in GP 9.0
We had closed our fiscal year in December and now we need to generate Sales Invoices with new IDs. For that we have create new Invoice ID in Sales Setup and change it with Old ID in existing Batches.
However, while generating Invoices for New Year, the serial Number of Invoice ID does not change.
Can anyone suggest to fix that problem.
Best Regards./Irfan.*This post is locked for comments
The Transfer Document to Invoice docment type is stored in the order when the order is first created in the field USDOCID2 of the SOP10100 table. If you are comfortable with SQL, execute this:
UPDATE SOP10100 SET USDOCID2='newid' WHERE USDOCID2='oldid'
Richard, Thanks for your reply.
Currently we enter Sale Order in system and upon availablity of Inventory, we Transfer document to Invoice. In Order ID Setup window we have linked New Invoice ID in "Transfer Order to Invoice" filed. Invoice ID is assigned to an auto generated number.
For those orders, which are saved in system earlier, when we generate invoices, system pull the Invoice number which link to Old Invoice ID. But for new Sale orders, this probelm does not arises. I assumes that it is timing difference. Can you suggest any other option for fetching new Invoice ID on already saved Orders.
Thanks.
/Irfan
If you mix letters and numbers, for instance N12N00101 - the digit part of the number starts over. I've seen it happen. It doesn't advance the letters. For example, when N12N99999 is reached the system starts over with the numbers. It doesn't advance the letters. Of course if you run out of numbers and have used all of the numbers up to that point you will get the 'A unique document number could not be found. Please check setup.' error message.
Are you strictly using Invoices? Or do you start with an order or even quote and transfer the order to an invoice?
First, the default invoice form needs to be set in SOP Setup. This will cause the new Type ID to default in to the Sales Transaction Entry window when it is opened.
Second, there are two places where the next Invoice Number can be loaded, the SOP Setup/Numbers and in the Document Type ID configuration. Which did you use? If you leave the next number field in the type id blank it pulls from the default id in setup.
Now, if you are using orders...look at the order type id configuration for the transfer to Invoice field and make sure your new type is selected.
Another thing to look at is the format of the number in the Next Number field. You can start the number with an alpha prefix followed by numbers. But I do not think you can mix them. For example, the next number can be INV000101 but I have never seen anyone try N12N00101. What is your next number format?
If this does not help, post back with more details and we will try again.
And you might want to look at our book Understanding Sales Order Processing which explains in detail how to setup chains of SOP document types.
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
