on 07-30-2015 11:49 AM
Dear Friends,
We have order relates billing (no deliveries). I am trying to develop an ABAP report which shows the open sales orders with outstanding sales values.
I am using the table VBAK for sales order data and VBUK to find out the open sales orders. However in case of partially billed sales orders I am not able to find the outstanding sales value.
For example: Sales Order No 120119923 has net value 1000 USD. Created a partial invoice against sales order No 120119923 for 300 USD. My resport should show below along with other regular fields:
Sales Order No Due Net Value
120119923 700
I am not sure which table would have 700 as in above example.
Thanks & Regards,
Rajesh Singh
The subject conveys a different meaning to your post. Ideally, it should have been Open Sale Order value. Nevertheless, did you check VA05 where you have the option to choose "Open sale orders" ?
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In your development, then you need to use tables VBRK/VBRP, to get the already billed values. Use this value along with sales order value to find the remaining value that needs to be billed. You can't directly read from any tables, I think.
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
108 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
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.