Dynamics Community Forum Thread Details

How to interpret the Flags column in SOP10100

I think I have this figured out, but wanted to post here in case others are struggling with it as well. The SOP10100 Flags column stores various on/off switches for the following settings of a sales document (order, invoice, etc.):

1 = SOPFLAGS_ADDREDITED (Address Edited)
2 = SOPFLAGS_COMMENTEDITED (Comment Edited)
3 = SOPFLAGS_PACKINGSLIPPRINTED (Packing Slip Printed)
4 = SOPFLAGS_PICKINGTICKETPRINTED (Picking Ticket Printed)

So here is how I was able to query whether the setting was active or not, using SQL server and the bitwise function (& position):

SELECT SOPNUMBE, Flags,
CASE WHEN Flags & 1 > 0 Then 1 Else 0 END AS Address_Modified,
CASE WHEN Flags & 2 > 0 Then 1 Else 0 END AS Comment_Modified,
CASE WHEN Flags & 3 > 0 Then 1 Else 0 END AS PackingSlip_Printed,

CASE WHEN Flags & 4 > 0 Then 1 Else 0 END AS PickingList_Printed

FROM SOP10100

WHERE NOT Flags=0

You could also search for documents that have a certain setting enabled, however it will be slow (table scan), so you should limit the results down in other ways first.

SELECT RTRIM(SOPNUMBE), Flags FROM SOP10100 WHERE SOPTYPE=2 Flags & 1 = 0 --Returns orders with non-modified addresses

SELECT RTRIM(SOPNUMBE), Flags FROM SOP10100 WHERE Flags & 3 > 0 --Returns orders with packing slips printed