How to correct Overall Status of Sales Orders

[Former Member]

Hello all,

I know that this question has been discussed several times in the past, but none of the threads I've read or solutions I've seen have addressed the specific situation I'm in, or have resolved the issue I've got.

One of our sales orgs needed a new set of Item Categories, and in setting those up, the Schedule Line category was incorrectly set to CN (No mat.planning) instead of CD (Without delivery).

That problem has been fixed, but there are a number of Sales Orders that have completed billing (these are Credit Memo sales orders with no deliveries - services only), so the doc flow is Sales Order - Billing Document - Accounting Document.

They are on the Open Order (VA05N) list, since the sales orders have the status "Being processed".

I need to find a way to complete these sales orders so they no longer show on the open orders report.

I have tried the following:

* VA02 to update the order status. Did not work, as the dropdown list is not modifiable.
* VA02 to update the schedule line category to CD. Save the order and then run SDVBUK00 in SE38. Did not work.
* VF11 to reverse the billing document, then update the sales order and re-bill. Did not work

Looking for additional suggestions.

Thank you.

[former_member330246 · Accepted solution]

Hi Steve,

1-) Check note 1472007 - Document flow status needs to be corrected,

or

2-) Create a new rejection reasons (or use one available) for this sales orders,

or

3-) Try to solve it with transaction V_MACO

Please inform the result,

FM

[Former Member · Accepted solution]

Fausto,

1) I've read the note (and the referenced note in there), and don't see any applicable solutions. I agree that it is the document flow status that needs to be updated.

2) Please educate me on the Reson for Rejection, and what that will do to the overall order. These are Credit Memos being applied to customer accounts. Will the credit be removed if the rejection is added? I am unfamiliar with the rejection process.

3) Running V_MACO does not give me any orders to process when I run it, so apparently, it will not help.

Thank you for your continued help!

Steve

[former_member330246 · Accepted solution]

Steve,

please, check if the Schedule Line Allowed is flagged in VOV7. Probably this is the error route cause.

To avoid the wrong items still appearing in VA05N, tag a reason for rejection following the steps bellow:

Click in Reason for Rejection TAB and tag a reason for rejection in items.

Check the delivery status. They still pending but will appear a field with message Overall Delivery Status Complete.

Execute the VA05N again and check; the order doesn’t will appear as pending.

FM

[former_member330246]

Steve,

please, check if you item category (transaction VOV7) has checked the Schedule Line Allowed.

If your scenario is Order - Billing based, and you don’t need to create and process a delivery, this check should be blank.

I think that here is the problem.

Fausto Motter

[former_member183501]

Hi,

If this transaction is Order Related Billing, even after using Schedule line category CD, what is the purpose?

Regards

Kamlesh

[Former Member]

Am I not required to set a Schedule line category on each line item of a Sales Order? CD is "Without delivery"...

[former_member183501]

Therefore, I asked that what is the purpose of using the schedule line category here ?

You can process this transaction without schedule line category.

[Former Member]

Now I understand. Yes, there was a configuration error on my part in having that box checked in the Item Category.

My question here, though, is what can I do to "complete" the existing orders? What can I do to change the order status from "Being Processed" to "Complete"?

Thanks,
Steve

[Lakshmipathi]

They are on the Open Order (VA05N) list, since the sales orders have the status "Being processed"

Only possibility is some of the line items are still to be invoiced in which case, you can set Reason for Rejection so that the status would get changed to "Completed". On the other hand, if you say all line items were billed but still the status is showing "Being Processed", then, your configuration itself is wrong and you need to check your item category and copy control configurations.

[Former Member]

I have replicated the behavior by creating single-line Credit Memo orders, and billing them. The orders are completely billed, and yet do not go to the status of "Complete".

[tao_sun2]

Hi, I tested in my internal system but didn't encounter the same issue. Could you please check what is the LFSTA and GBSTA in VBUP&VBUK for the sales order?

[Former Member]

Tao,

Thank you for your reply.

LFSTA - 'A' and GBSTA - 'B' in VBUP in both tables.

Steve

[tao_sun2]

Normally, with schedule line category CD, sales order should have delivery status 'blank', which means not relevant for delivery. And after billing creation, overall status should be set to completed.

Could you please whether configuration of schedule line category CD is correctly set? Especially, indicator "item rel.f.dlv".

If the setting is correct, you may consider run SDVBUK00 and debug FM RV_XVBUP_MAINTAIN to check why system set VBUP-LFSTA to A in your case.