Hi guys,
I'm just after a little bit of help with a report I am writing for work. I'm a relative newbie when it comes to Crystal Reports. I'm using CR XI. Here is my problem...
I am trying to write a report that lists how much usage we have used on certain stock, whilst ignoring any reverse transactions.
Whenever an item is issued, the transaction itself gets a Unique Transaction Number. If (for whatever reason) the transaction is reversed and added back into stock, our system gives the reversal its own transaction number and also writes the original transaction number to a field called 'originaltransactionid'. So for example...
Qty Description Type Transactionid Originaltransactionid
20 M6 Nuts Standard 12345
50 M6 Nuts Standard 67890
20 M6 Nuts Reversal 98765 12345
where the 3rd line is the reversal of transactionid 12345.
I would like the report to disregard any of the REV items (which is easy) but also to disregard the original transaction based on the 'originaltransactionid' number stored in the reversal transaction (so on my example above, only the 2nd line would show up on my report and only 50 nuts would be deducted from stock).
Thanks in advance for your help.
Edited by loismustdie - 19 Jun 2009 at 4:19am
IP Logged
