[Jeff Roe]

We are seeing invoices in the SOP10106 table with a soptype of 3 and 4.

In some cases we are see the same invoice number with a soptype of 3 and soptype of 4.

What drives the soptype in the SOP10106 table?

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————

[Thaddeus Suter]

They are not both Invoices.
The primary key in SOP10106 is both SOPTYPE and SOPNUMBE.
To avoid confusion on SOPNUMBE since they are not unique, use a different numbering schema for each SOPTYPE (DOCID) in your SOP Setup.
SOPTYPE 3 = INVOICE
SOPTYPE 4 = RETURN
We have an “I” usually in the Invoices and an “R” in the Returns

——————————
Thaddeus Suter
Retus, Inc
Helotes TX
——————————
——————————————-

[David Musgrave]

For a full list

1 – Quote
2 – Order
3 – Invoice
4 – Return
5 – Back Order
6 – Fulfilment Order

Note that Fulfilment Order is normally listed after Orders in the drop down list, so that the positions in the drop down list do not match the data in the database.

There are Dexterity functions that convert the values for you and most windows have an extra field which can be used from VBA.

For example the SOP_Entry window has fields SOP Type and SOP Type Database.

David

——————————
David Musgrave MVP, GPUG All-Star

Managing Director
Winthrop Development Consultants

Perth, Western Australia

http://www.winthropdc.com
——————————
——————————————-

[Jeff Roe]

Thanks

Clearly I was not looking at the details correctly

——————————
Jeff Roe
Kele Inc
Bartlett TN
——————————
——————————————-