order status shall complete with single reference

[former_member233940]

Dear Experts,

business requirement:  they want to make the status complete once the order is been delivered and invoiced. Again they dont want to use the order for futher processing.

For ex: if they created a sales order with Material X and quantity 100, they will deliver 20 and invoice 20.

for remaining quantities in order they dont want further processing and it shall not appear in open order list in VA05.

please advice me how to configure in standard. if not any userexit/enhancement.

Thanks in advance.

Regards

PK

[former_member233940]

Dear All,

Thanks for your replies.

we simply rejected all of the line items in the sales orders once been processed till invoice.

and the status of the order become complete. this is done manually.

[Former Member]

Hi,

How do you know when a delivery is the last one for a customer sales order?

If it´s not fixed and depends on needs of your customers, manually in sales order, go to partially delivered materials line items and set B to partial deli/item field in shipping tab. If there are materials not delivered yet just reject them. Your sales order will be completed.

If say customer accepts only one delivery you can set B in sold-to master material shipping tab partial deli/item and in sales order reject not yet delivered line items. Again, sales order will be completed.

Regards,

JM

[Former Member]

Hi

I think we cannot map in standard sap we have to go for enhancement  If you go to SE16n and enter the VBUK (Sales Document: Header Status and Administrative Data)

and RFGSK is the fields in that you can finds out the status ,take the table and fields

thanks

[Former Member]

Hi,

please try using a userexit or Badi to set the delivery status field LFSTK to complete and billing status field FKSTK to complete in table VBUK.  You will need the help of ABAPer.

Use an userexit or Badi which is triggered after invoice is saved to set the above two fields in VBUK table.

Try SD - FI interface userexit .See Note 301077 - User exits for the interface to accounting, perhaps the most suitable will be the first userexit (EXIT_SAPLV60B_001).

In the userexit abap code should be written to find the relavant Order number in VBFA table using irelated delivery number. Then write apab code to update the  status of two fields LFSTK and FKSTK  to complete in VBUK table that order number in VBUK table

Regards

Ganesh

[VeselinaPeykova]

Before providing an advice on the exact approach, here are a couple of unanswered questions that you may need to clarify with the business users:

• Should this requirement be valid across all order types in a specific sales area for the process order->delivery->billing or just for some order types?
• Will there be an exception of the rule for some customers or some products?
• Is the problem only related to partially delivered items in sales order?
• What about not delivered order items - what is the expectation from the business?
• What about partially invoiced/not invoiced items (this could happen in DSD in certain cases)?

[Former Member]

Hi ,

Completion rule works only between sales document to sales document.

Example : Quotation to Order - because both are sales documents.

It does not work between Order and Delivery because delivery is not a sales document.

So completion rule cannot be used as solution for this issue.

Regards

Ganesh

[Lakshmipathi]

At item category configuration, there would be a field for "Completion rule"  where there is an option to set "completed at first reference".  Set this to your item category and try with one full cycle.

G. Lakshmipathi

[jignesh_mehta3]

Hello Lakshmipathi,

SAP Standard help mentions that Completion Rule field in Item Category is only applicable for Quotation or Contract.

Infact I remember having explored the same solution at a client site and it did not work for Sales Orders.

Thanks,

Jignesh Mehta

[former_member233940]

Dear lakshmipathi,

i activated completion rule as completion with single reference but it still allowing me to create further deliveries and invoice.

is there any other option we could look for?

[Lakshmipathi]

Yes Jignesh.  The completion rule is applicable to Quotations and Contracts but some 8 years back, I did for sale order and I forget whether it has been achieved via standard or coding.  From your comments, it seems, through standard, it is not possible.  By the way, in copy control for sale order to delivery, did you maintain plus indicator and tested ?

G. Lakshmipathi

[jignesh_mehta3]

Yes. Even after maintaining the Plus indicator in Sales order to Delivery Copy control the desired result was not achieved.

Thanks,

Jignesh Mehta

[VeselinaPeykova]

Well, part of the solution could be setting partial deliveries/item for the sold-to parties to 'A' either in the customer master or in the CMIR (for the second option it should be set in VOV8 to read CMIR as well). The interesting part is how to deal with not delivered items (should they be rejected - when and how), also how the system should behave if an additional order item is added in the same sales order after a delivery is created.

Some of the changes depend on the billing releavnce of the order items and what additional processes you use - e.g. billing relevance G, DSD process, on-delivery return (the complete visit is rejected). Normally you update the order with return items and execute billing, but in some countries it is illegal to issue zero invoices, so you reject the items during FSR, because simply having a billing block would not complete the order.

[former_member200027]

Hello,

Have you created new orders and deliveries to test the scenario after changing completion rule?

Or just check existing orders?

After changing customizing, please create new documents to test the scenario again.

Best regards,

Crystal Lin