Announcements
No record found.
Hi ,
Soptype value for invoice is 4 in sopentry window but it is saving in 3 in GP table .. Can someone explain how does it works or changes from 4 to 3 ?
Please site a specific example. In GP SOP type = 3 is an order and SOP type = 4 is an invoice. It has always been this way. If you transfer an order to an invoice and post the invoice you will find both documents in the SOP30200 and SOP30300 tables.
Hi,
Here the value of invoice in sales transaction entry window is 4
And in the database the value of invoice is stored as 3
As per the GP SDK plus Tools->Resource Descriptions->Tables the values of SOP10100.SOPTYPE are:
1-Quote
2-Order
3-Invoice
4-Return
5-Back Order
It appears this tool is offset by 1. What keystrokes are you using to bring up that screen?
I just noticed that using GP Power Tools(GPPT) it is also off by one. I just checked the other document types and found:
4-Invoice
5-Return
6-Backorder
My suspicion is that in the code, it uses these numbers and 3 is reserved for Fulfillment Order/Invoice. The code then converts when writing to the database.
Actually, I just confirmed that the value you are seeing is the position in the document type list not the value to be written to the database.
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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Giorgio Bonacorsi 608
André Arnaud de Cal... 591 Super User 2026 Season 1
CP04-islander 430
