Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Partial Shipment Check Qty left!
Message
From
11/12/1999 02:11:09
John Kiernan
Kierpro Associates
Los Angeles, California, United States
 
 
To
10/12/1999 23:03:46
Terence Tam
Hong Kong, Hong Kong
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Partial Shipment Check Qty left!
Miscellaneous
Thread ID:
00302169
Message ID:
00302188
Views:
29
What SBT does is ...

QtyOrd field (Quantity Ordered)
QtyShp field (Quantity Shipped)

Shipment process actually decrements QtyOrd while increasing QtyShp.

If you need to know the amount of the original order it's QtyOrd + QtyShp.

Hope this helps...
-- John Kiernan
"Maybe Amelia Earhart was just stealing the plane".
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform