on 01-13-2009 5:13 PM
hi friends
In MCSI report, we select S907 info structure in the combination of Dist channel, Divi, Sales office,Sold to party and period
I Hav given dc-10,div-10, soldtoparty-50301and period 1.9.08 to 30.9.08 then screen displays with following details
Sales Billing Qty Returns incom Return billing qty Netvalue Billing Qty
00 00 15,00000- 148- 150000- 148
so, for this customer in this month no sales but sales returns are created
now the issue is last billing qty should show 148- becoz only returns happnd in that period but it is showing as positive, but when we r downloading to excel it is cominng like below
Sales Billing Qty Returns incom Return billing qty Netvalue Billing Qty
00 00 15,00000- 148- 150000- 148-
how can we make billing qty -ve in the above screen
plz reply me
Hi
So when you are running the report as you said it is showing the following data in negative check the returns feild data
Input data : Sales Billing Qty Returns income Return billing qty Net value Billing Qty
So check in the configuration only that what feild and table you have assigned and also check what update grp you have maintained for Returns & Incoming Returns .
Check that the update grp for returns should be 00012 ,and because of this only it might be showing in negative figures
Regards
Srinath
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
7 | |
7 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.