[Vantage 8.03] Back Order SO

Yahoo Archive
1
I am still on 5.x, but assuming this has not changed on 8. you should
be able to get this off the OrderRel table. There are several fields of
interest:

OurReqQty
OurJobShippedQty
OurStockShippedQty

These same fields also exist for selling qty it you qty is not 1:1 and
you'd rather report of selling qty. see the data dictionary for more
info on each field.

When I've reported off this I usually end up showing a field of our req
qty then another field of shipped qty (which adds the job and stock
shipped qty's together) and then Balance which just subtracts.

-Sarah

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of laidig.systems
Sent: Thursday, May 03, 2007 3:02 PM
To: vantage@yahoogroups.com
Subject: [Vantage] [Vantage 8.03] Back Order SO

I have sales order's with BO shipments pending. I am looking for a
way to determine what my pending ship qty is for my open sales orders.
For instance, i have a SO that with a line item 1234 and selling qty
10. After two separate shipments of 4 pieces of part 1234, is there a
table in the database that shows the total cumulative shipped qty, or
the remaining qty to be shipped? I am trying to write a report off of
this information using SQL database. Any suggestions?



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must
have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder
and Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Yahoo! Groups Links
2
I have sales order's with BO shipments pending. I am looking for a
way to determine what my pending ship qty is for my open sales orders.
For instance, i have a SO that with a line item 1234 and selling qty
10. After two separate shipments of 4 pieces of part 1234, is there a
table in the database that shows the total cumulative shipped qty, or
the remaining qty to be shipped? I am trying to write a report off of
this information using SQL database. Any suggestions?