on 11-08-2013 5:45 AM
Hi,
I need some help to get the open and closed billing orders. What tables do i need to access and is there any FM to get the billing orders.
Input will be : payer(kunnr) and sales organization(vkorg).
output will be : The output will display the sales order list with address details.
Any help appropriate will be appreciated.
Thanks
Amaranatha,
You can use two tables -
1. VBRK - input VKORG (Sales organisation) and KUNRG (Payer)
get VBELN (billing doc)
2. VBUK - input VBELN (billing doc from 1), GBSTK (overall status) not equal to C
get VBELN (billing doc which are not status complete)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
As rightly said by Lakshmi Sir please define closed and open billing documents?
Fully invoiced material/partialy invoiced materials
Invoice created but not posted in FI
Invoice posted in FI but not yet cleared
What is your open invoice now
Thank$
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I need some help to get the open and closed billing orders
First of all, what do you mean by "Open" and "Closed" billing orders ? How would you consider if a sale order is fully invoiced but there were some returns against that particular sale order ? Similarly, "Closed" means only fully invoiced or payment received fully. How would you consider if a sale order is fully invoiced but partial payment received ?
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Amaranatha,
G Lakshmipathi has raised some valid questions to get more clarity on the requirement. So that suggestions can be given.
But please note table VBUK has all status related information e.g. Overall status, Posting status (accounting document generated etc.) and other status related information - for billing documents, for sales orders.
So when the business requirement is clear, then explore table VBUK. It shall help you to create the functional specifications.
Note - Re-reading your post, please clarify "billing orders" - Are you discussing about Sales orders or Billing documents or.....
User | Count |
---|---|
91 | |
10 | |
10 | |
6 | |
5 | |
5 | |
5 | |
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.