Hello all
Does anyone know why on one particular Sage 50 company the SORT_ORDER column from the Sage.CATEGORY ODBC query would not be populated?
It works as normal on all other sage data but for some reason I have one dataset where it does not. Hopefully it is an easy fix within the Sage COA.
Thanks in advance for your advice.
Kind regards
Jeremy
Replies (3)
Please login or register to join the discussion.
Sort Order
My guess (and it is just a guess) is that the data has been upgraded from an earlier version at some point and the field was not populated correctly during the upgrade procedure. Either that or the data file is corrupt...
John
v12
I've just checked in my copy of v12 and the SORT_ORDER field does not exist on the CATEGORY table in v12...
John