on 03-09-2010 9:32 AM
Hi Experts
I have a issue where we ran an customised query for the return billing documents the value for the return items is not showing the negative value in the report , Pls help me to know how does the Query report the billing values shows,
Please advi
is there ant report or query which gives the value of the retuned
sales orders or and the cost with neagtive values
As already Reazuddin pointed out, no report will show the value with sign positive or negative. But in order to differentiate this, definitely, you should be having a different sale order types and billing types for normal sales and return sales. So in that way, to check the returned sales value, go to SE16, key in VBRK and execute. There input return billing type (credit memo) and execute. Whatever value populates there can be treated as returns. Else if you want to see the for how much value, return order is created, the same logic applies. In SE16 table, key in VBAK and execute. There give return sale order type and execute. You will get the desired result.
thanks
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Fyi,
Queries are only used to extract the data from the required tables. It will not do any kind of calculation / derivations.
Query doesnt understand that, if billing doc type= RE,t hen value / amount should show in "-ve" etc..,
If you want to extract the data, then use queries ( Tx:SQVI is more helfpul & easy to use)
else you want to do some calculations such as above, then go for the report.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
first define in short names the needed fileds you (e.g Billing Type , net Value;) create a new local filed called; net value +/-.
add a calculation in the new local field 1 Line: Billtype = 'RE' (RE-Credit for Returns) ; formular Netvalue + -1 ; else Netvalue.
Put the new local Filed in the Query, should work
User | Count |
---|---|
85 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.