I'm curious about status information in Transfer Orders.
I created a query and dashboard to show information about transfer
orders.
One tab shows Open Orders, which is just a query of tfordhed where
openorder = true. However I see orders there where the
tforderhed.shipped flag for the entire order is also true, and there's
no remaining balance. If I open the TF order in TF Order Entry, the
status is shown as "Shipped" but not "Closed". I also have plenty of
Closed transfer orders.
Looks like the underlying dataView for the screen has an OrderStatus
flag, which I'm guessing returns "Shipped" if Shipped = True and
OpenOrder = False, and "Closed" if both are false.
So I think my query is correct and the orders really are still "Open",
although there's no remaining balance and all lines have been shipped
and received. Why?
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]
I created a query and dashboard to show information about transfer
orders.
One tab shows Open Orders, which is just a query of tfordhed where
openorder = true. However I see orders there where the
tforderhed.shipped flag for the entire order is also true, and there's
no remaining balance. If I open the TF order in TF Order Entry, the
status is shown as "Shipped" but not "Closed". I also have plenty of
Closed transfer orders.
Looks like the underlying dataView for the screen has an OrderStatus
flag, which I'm guessing returns "Shipped" if Shipped = True and
OpenOrder = False, and "Closed" if both are false.
So I think my query is correct and the orders really are still "Open",
although there's no remaining balance and all lines have been shipped
and received. Why?
--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix
bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>
[Non-text portions of this message have been removed]