In vf04 and va05 system is not fetching right data..

[former_member542938]

Hi All,

My query is related to order related billing scenario where i want to fetch the data for the order which is not billed yet means all the order which are due for billing.But when i am using va05 and vf04 t code for open sales ordr and billing due list for order related billing system is also showing that orders which are already invoiced can anybody tell me the reason why its showing that order also which is already billed.

Quick response will be appreciated.

Regards

Sourabh

[Jelena]

for order related billing documents system will show as open even if they are completed.

Sorry but this is inaccurate. There is a separate field for the order-related billing status. It should not be set as "complete" until the item/document has been billed.

There are different statuses that are updated in the delivery-related scenario. In that case the order-related billing status would be blank (=irrelevant).

If a document shows as open even though the corresponding document flow has been completed then either there was some bug or configuration is incorrect. This certainly should not happen and it has nothing to do with the billing type.

[VeselinaPeykova]

If you are a business user - contact your local support help desk and provide the examples to make it easier for them to investigate. You will not have sufficient authorizations to troubleshoot and solve the problem on your own.

If you are a developer - request the assistance of a qualified SD consultant working for your company as you will probably not know in details how certain processes are supposed to work and how this is influenced by configuration.

If you are a functional consultant: please search the forum and SAP notes if you are not familiar with the concepts of copy control, billing due list, routines, item category configuration, exits etc. From your question it is not clear whether you have done any research or troubleshooting and it is unlikely that many will be willing to help you out when you have not provided enough information from the beginning.

[former_member542938]

Hi Veselina,

Thanks for the reply.I am an sap sd consultant and i have done all the research but as it is standard so system should not picked the order number which is already invoiced but still system is picking that order number of order related billing order numbers.I have search all the possibilities but couldnot find the root cause of this issue..

Hope i have cleared your doubts.

Regards

Sourabh

[VeselinaPeykova]

If you have done the research already you need to share the outcome of it 🙂

How would anybody know what you see as statuses on header/item level, what are your copy controls, what is your item category config, whether there are any exits active, whether any recent changes to customizing were done, whether somebody updated indexes?

Unless you explain what you have eliminated as possible causes, share screenshots of investigation I see no way that forum members could help you (the alternative is probably contacting SAP and giving them system access, which may be subject to additional payment).

[Jelena]

+1 to Veselina's answer. Use SE16 and simply check the statuses for the documents in question (VBUK/VBUP). You could request assistance from an ABAPer pr a Basis person to run SQL Trace (ST05) and it'd show you exactly what criteria is used to read the data and determine what's opened and what's not.

If your statuses are inconsistent in the database then run one of the correction reports provided by SAP (search in Google or SAP Notes) or contact SAP Support.

[Lakshmipathi]

billing due list for order related billing system is also showing that orders which are already invoiced

Did you check the status of those orders? As long as the order is stored in VKDFS table, system would fetch such of those orders in VF04

[former_member542938]

image-1.pngHello Sir,

I have checked the status of those orders and attachement is also there for your reference.but I also checked one thing that this problem is occuring for F1 billing type not for ZPRI bcoz all the order for zpri billing type data is correct but in vf04 if i am fetching the data for billing type F1 then for all the order number till accounting process is completed and still that oreder number are showing in vf04 ,client is using both the billing type.Can you guide me what is the problem and where i have forgot the things to do..

Regards

Sourabh