Quantity on hand calculation

Yahoo Archive
1
Create multiple PartBin links for various aliases for each partbin warehouse location and then add them together with a plain calculated field? If you don't have a huge number of warehouse codes and they don't change real often this might work. Or also perhaps setting a bunch of calculated fields with value = QtyOnHand if warehouse = X else zero for each warehouse then adding them up for the part. Again useful mainly if warehouses are static otherwise report needs to be changed when warehouses do.
-Todd C.

-----Original Message-----
From: Jasper Recto [mailto:jrecto@...]
Sent: Monday, February 23, 2004 1:05 PM
To: Vantage Groups (E-mail)
Subject: [Vantage] Quantity on hand calculation


Using the Partbin table, I'm trying to add up the total quantity-on-hand of a particular part. It needs to take into account the quantity in every warehouse bin location. I need to be able to add up all quantities using a calculated field. I CAN NOT use an aggregate field. Any ideas on I can create a statement that would calculate this?

Thanks,
Jasper





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



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


* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* 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]
2
Using the Partbin table, I'm trying to add up the total quantity-on-hand of a particular part. It needs to take into account the quantity in every warehouse bin location. I need to be able to add up all quantities using a calculated field. I CAN NOT use an aggregate field. Any ideas on I can create a statement that would calculate this?

Thanks,
Jasper





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