Incorrect Document flow status for Delivery Document

[Former Member]

Here is the case were the quantities are fully processed, subsequently all documents

such as sales document, Delivery, shipment, Billing and posted to accounting also.

But through document flow, the Delivery status is showing "Being processed".

As a reason these documents are reappearing in VF04 - Billing due list which

Creates confusion to Business.

Sales order - 100 qty - > Completed

Delivery - 100 qty - > Being Processed

Shipment - 100 qty - > Completed

PGI - 100 qty - > Completed

Billing - 100 qty - > Completed.

Even the SKU / Stock are fully invoiced interms of quantity is concerned,

The Status of Delivery document in the document flow is

"BEING PROCESSED" and the Status overview - Status "B" Partially Invoiced". (Were all are properly invoiced)

Key note:

*********

As it's a rare case scenario, we are not able to find replicatable scenario in Development and Testing environment.

Suggestion:

**********

May I know could you please provide the Utility program to fix the issue.

Expected Result:

**************

After execution of the program, the respective Delivery document should not

appear in the Billing document due list through T code - VF04.

[Former Member]

Hi,

This is the problem with the item category triggered in sale order which is having the option 'Delivery related billing' under the billing relevance. So with this setting the item category has already triggered in your sale order and so this item category cannot be cleared from VF04 until billing was done.

The only solution for this is to change the status of the delivery document in tables VBUK and VBUP. If there are many documents which you cannot change that each and everyone then ask your abaper to write a program (based on sale order type and item category (or anything as per your requirement) in selection screen) to change the status of the selected documents. What ever the way is, you have to change the status of the documents in tables. After completion of changing the status you have to run a program RVV05IVB to update the inconsistency in VF04 for those documents.

Check the item category settings properly for not repeating this for newly creating documents.

This is the same thing which we did for many of our clients.

Hop this will help you !!

Regards,

Krishna O

[Former Member]

Hi Krishna,

Thanks ...

It's not the issue with item category, the issue is even the all the SKU quantity is fully Invoiced (sales order, delivery, pgi, invoiced) . still the delivery document staus shows "Being Processed" but it should be "Completed".

I found due to incosistency Billing status and overall status is "Being processed" (through VBUK table) . This inconsistency is resolved using the T code - VL_COMPLETE.

Thanks once again.

Thanks& Regards,

Pugal

[Former Member]

Hello Pugal

Try running Reports SDVBUK00 and RVV05IVB once. Go through OSS note 128947 once for info on RVV05IVB. Hope this helps. Let us know your results/next steps etc.

[Former Member]

Hi Chandrasekar,

Thanks you so much ...

I've already tried these Utility program but there is no luck. When I was double checking the delivery document through table -VBUK I found the Billing status and Overal status is "Being processed". As a result the system shows Being processed for Delivery document even the delivery document SKU quantities are completely processed to Billing and posted to accounting. Subsequently I picks in VFO4 -While processing Billing duelist.

May I know the approach of changing the Billing status to completely processed in VBUK table.

Is there any Utility program which we can use to clear the change the status of VBUK table.

Or is there any approach to change the status of Billing status in Delivery document to "completely processed". (not the direct table update)

I would like to share a Key Learning :

Even all the documents are completed status still it appears in while executing VFO4, then we can use this program - It will clear from VF04 but won't work for delivery document which is status of Being processed but the qtys are completely Invoiced and posted to accounting

Thanks & Regards,

Pugal Stalin

[Former Member]

Hello Pugal

I suggested this for another poster and it may work for you also.

Use Z-code to change the status. See OSS notes 1177165 and 617501, the second one particularly because it has Document # in the selection criteria. They are meant to correct the Revenue Recognition status of sales documents and may be you can copy and adapt one of them to suit your situation. Or best ask SAP to provide one as they developed the program from note 1177165 based on customer request.

1177165 - Revenue Recognition: Updating RRSTA in VBUP and VBUK

617501 - Incorrect status for VBUP-RRSTA

Let me know how it goes. Thanks.