Total QOH field in Vantage?

Yahoo Archive
1
This has been a terrible hassle in our report writing. When a part has multiple bin locations, and you group by part and then sub-group by another part, you get inaccurate ONHand Qtys. This has made somewhat simple report requests very complicated. My solution is to use Crystal Reports and retrieve the OnHand Qty using a subreport. This slows the report down somewhat, but it works.

Troy Funte
Liberty Electronics

----- Original Message -----
From: jwapner@...
To: vantage@yahoogroups.com
Sent: Wednesday, September 19, 2001 4:25 PM
Subject: [Vantage] Total QOH field in Vantage?



Is there a field in Vantage that contains the total Quantity on Hand
for a part (total of all bins)? Because of the grouping in a Report
Builder report I don't get correct results trying to use the PartBin
table.

Thanks all,

John Wapner
Bracalente Mfg.


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]
2
Is there a field in Vantage that contains the total Quantity on Hand
for a part (total of all bins)? Because of the grouping in a Report
Builder report I don't get correct results trying to use the PartBin
table.

Thanks all,

John Wapner
Bracalente Mfg.
3
Try creating a calculated field like "IIF(PartBin.PartNum = XXX,
PartBin.OnHandQty,0)". Then create an Aggregate sum of that calculated
field no-reset.


Ed Giallombardo
Computer Technician
Major Industries, Inc.
7120 Stewart Ave.
Wausau, WI 54402
phone: 715-842-4616 ext. 322
email: egiallombardo@...

-----Original Message-----
From: jwapner@... [mailto:jwapner@...]
Sent: Wednesday, September 19, 2001 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Total QOH field in Vantage?



Is there a field in Vantage that contains the total Quantity on Hand
for a part (total of all bins)? Because of the grouping in a Report
Builder report I don't get correct results trying to use the PartBin
table.

Thanks all,

John Wapner
Bracalente Mfg.



Yahoo! Groups Sponsor

ADVERTISEMENT

<http://rd.yahoo.com/M=194081.1566666.3122752.1261774/D=egroupweb/S=17050071
83:HM/A=766942/R=0/*http://www.ediets.com/start.cfm?code=3225> Click Here!


<http://us.adserver.yahoo.com/l?M=194081.1566666.3122752.1261774/D=egroupmai
l/S=1705007183:HM/A=766942/rand=540678445>

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/.
<http://groups.yahoo.com/group/vantage/files/.>
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
<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
<http://groups.yahoo.com/group/vantage/links>

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .




[Non-text portions of this message have been removed]
4
Have you tried changing the "Accumulation" setting in the aggregate field?
You can set it so that, instead of adding up every line, it only adds when a
grouped item changes (similar in concept to the "Reset on..." option). This
eliminates the problem of adding duplicate values to an aggregate field.

Jon Hellebuyck
Stremel Manufacturing
-----Original Message-----
From:
sentto-20369-23969-1000931155-jhellebuyck=stremel.com@...
[mailto:sentto-20369-23969-1000931155-jhellebuyck=stremel.com@...
t.com]On Behalf Of jwapner@...
Sent: Wednesday, September 19, 2001 3:26 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Total QOH field in Vantage?



Is there a field in Vantage that contains the total Quantity on Hand
for a part (total of all bins)? Because of the grouping in a Report
Builder report I don't get correct results trying to use the PartBin
table.

Thanks all,

John Wapner
Bracalente Mfg.


Yahoo! Groups Sponsor
ADVERTISEMENT




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

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]