on 01-02-2015 11:25 AM
Hi All,
I have developed an inventory ageing report where Ageing Buckets are showing negative values...If I add those bucket values those are matching my total quantities... Please find the attached screen below
in above image I have calculated 0-7 quantity based on below values.
RECEIPT TOTAL STOCK restricted by POSTING DATE
ISSUING TOTAL STOCK restricted by POSTING DATE
then
0-7 quantity = (RECEIPT TOTAL STOCK - ISSUING TOTAL STOCK)
Now I do not want want those negative values in my report. I need to display only those positive values if I add them those values should be equal to my total Quantity.
Please help me on this....
Regards,
G S Ramanjaneyulu.
Hi Rama,
You can use Conditions and apply the condition to display the Data which are above 0 (Zero) by this way only positive will be displayed for those KFs.
Also you can use Total Quantity-KF instead of Issue and Receipt Separately
If this is not the Requirement can you explain further so that we can give appropriate solution.
rgds
SVU
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.