Running Total (Part Transactions)

Yahoo Archive
1
As in.... IIF (RunningTotal = 0,TransDate,0) then Aggregate this to find the Minimum Date? Something like that do it?
-Todd C.


-----Original Message-----
From: Norm Watkins [mailto:nwatkins@...]
Sent: Thursday, April 01, 2004 2:31 PM
To: Vantage@Yahoogroups. Com
Subject: [Vantage] Running Total (Part Transactions)


Using Report Builder or Crystal Reports, has anyone found a way to extract
the date that the "Running Total" (a column of data in part tracker
"transaction history") of a part in stock reached zero?

I'm trying to track some inventory value changes that occurred within a
certain month due to undervalued receipts from manufacturing occurring after
the inventory quantity reached zero.

Any help would be greatly appreciated.

Thanks!


Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307



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 Report Builder or Crystal Reports, has anyone found a way to extract
the date that the "Running Total" (a column of data in part tracker
"transaction history") of a part in stock reached zero?

I'm trying to track some inventory value changes that occurred within a
certain month due to undervalued receipts from manufacturing occurring after
the inventory quantity reached zero.

Any help would be greatly appreciated.

Thanks!


Norm Watkins
Engineering Mgr.
ELECPAC
847-639-2307