Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am working on some project and i want to combine the following data:
Current Stock
- Amount of articles in stock for each article. Only what the stock looks like right now.
Transaction History
- For each article it gives the transaction history. So for example:
Article | TransactionDate | Transaction |
---|---|---|
TestArticle1 | 02-02-2013 | -20 |
TestArticle2 | 04-02-2013 | +5 |
I want to make the transaction history visible, how can i do this?
I am looking for an example how to do something like this.
Right now I'm going to try the previous(); function
Hi
U need to create a Calender Master Based on Transaction Date.
Set Variable vMaxYear= Max(Year)
Exp : For Currentyear = Sum({<Year={$(vMaxYear)}>}Transaction)
For Lastyear = Sum({<Year={$(=Max(Year(Year))-1)>}Transaction)
It will show Year wise Transaction,If u want to put month,then inside exp include month
Regards,
Bika