SOPTYPE value for invoice

(0) Share

Report

Posted on by Community Member

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 ?

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (5)

Answers (0)

Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

I just noticed that using GP Power Tools(GPPT) it is also off by one. I just checked the other document types and found:

1-Quote

2-Order

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.

Was this reply helpful? Yes No
Richard Wheeler 75,848 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No