Skip to Content
avatar image
Former Member

order status shall complete with single reference

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • avatar image
    Former Member
    Sep 03, 2015 at 12:10 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 02, 2015 at 09:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Sep 02, 2015 at 09:23 AM

    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)?
    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Sep 15, 2015 at 08:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 15, 2015 at 02:43 PM

    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


    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 21, 2015 at 02:11 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded