SOPType vs SOPTypeDatabase Translation on GP SOP Entry Window
The following table is the translation of the SOP Type value in GP versus the SOP Type that is stored in the database SOPTYPE column.
| Sales Document Type | SOPTYPE Value (value in database, SopTypeDatabase in code) | GUI Drop Down Field Index Position (SopType in code) |
| Quote | 1 | 1 |
| Order | 2 | 2 |
| Invoice | 3 | 4 |
| Return | 4 | 5 |
| BackOrder | 5 | 6 |
| Fulfilment Order | 6 | 3 |