Skip to Content

Sales Return - COGS Value of PGR should be the same as PGI

Hello,

I'm a SD Consultant and I'm new to this forum.

Below is the document flow of our current sales return process:
Sales Order --> Delivery Order --> Post Goods Issue --> Billing --> Return Order --> Return
Delivery --> Post Goods Receipt
Return Order --> Credit Note

Credit Note has reference to Return Order, not to Return Delivery.

The requirement:
The managements have requested that COGS value posted from Post Goods Receipt and Credit Note should be the same as COGS value posted from Post Goods Issue and Billing.
Our companies are using Price Control = S for Distributors, and Price Control = V for
Factories. Both Factories and Distributors can sell, but each has their own different customers.
The managements have already aware about its effect to costing, and they've accepted it.

Example:
In September, COGS value of item A is 10$. From Accounting Document of Goods Issue material document, we can see the COGS of item A is 10$.
In October, COGS value of item A is 11$. If the Billing from September is used as Return Order reference, and the Return Order is processed until Credit Note, we want to use 10$ as COGS value posted from Post Goods Receipt and Credit Note - whereas the standard process will take 11$.

The idea is to put a code in an User Exit triggered when User clicked "Post Goods Issue" button in tcode VL02N or VL06G. This code will fetch COGS value (VPRS) per line item from Billing that has been used as Return Order reference and overrides the original COGS value when the Accounting Document of Goods Receipt material document is made.
Some has mentioned to use BADI LE_SHP_GOODSMOVEMENT, but we can't find it, for we're still using SAP 4.6c version.

I've read several threads I found below - but none mention definite answer.
https://archive.sap.com/discussions/thread/3489972
https://archive.sap.com/discussions/thread/3307720
https://archive.sap.com/discussions/thread/3343155
https://archive.sap.com/discussions/thread/3306800
https://archive.sap.com/discussions/thread/1428245

The question:
Is there any User Exit we can use when User clicked "Post Goods Issue" button in tcode VL02N or VL06G in SAP 4.6C version? Or, if there's other idea, I'm open to suggestion.


Thank you and regards,


Trisno S.

Add a comment
10|10000 characters needed characters exceeded

Related questions

9 Answers

  • Posted on Oct 27, 2018 at 01:41 PM

    First of all, good that you made some attempts to search before posting here and also for explaining your requirement clearly. Now coming to your requirement, you can include the form routine USEREXIT_VPRS_UPDATE in include RV60AFZZ and add your own logic

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 28, 2018 at 06:32 AM

    Hello Sir,


    This is the second time I write this post, I don't see where my first post anywhere.

    User Exit RV60AFZZ is for Billing. I'm not sure if it's related to COGS value in Accounting Document of GR Material Document. Does RV60AFZZ get executed when we clicked Post Goods Issue button?
    Also, I don't see USEREXIT_VPRS_UPDATE in my own RV60AFZZ. Can you please elaborate about it?

    Thank you and regards,


    Trisno S.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 28, 2018 at 06:33 AM

    Hello Sir,

    Thanks for replying.

    If I'm not mistaken, RV60AFZZ is for Billing, while my requirement is to use user exit when Post Goods Issue button is clicked, before any Credit Note is made, therefore, changing COGS value in Accounting Document of GR material document. Can you tell me their relation or explain further?

    I've seen my current RV60AFZZ, but it doesn't have form USEREXIT_VPRS_UPDATE.

    Thanks and regards,

    Trisno S.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 29, 2018 at 04:18 AM

    I don't see any button to edit my initial post, so I'm going with new post to clarify my requirements.

    My requirement is to change BSEG-WRBTR field of COGS value in Accounting Document created by GR Material Document when we're doing Post Goods Receipt through tcode VL02N.

    Basically, the flow is as follow:

    1. User creates Return Order with reference to Billing with VA01
    2. User creates Return Delivery with VL01N
    3. User process Return Delivery with VL02N by clicking Post Goods Issue button
    4. GR Material Document created
    5. Accounting Document created (before Accounting Document is created, we want to change BSEG-WRBTR based on VRPS in Billing that has been used as reference for related Return Order, instead of using its original value)

    I've found almost similar thread like mine below - but it doesn't have an answer:

    https://archive.sap.com/discussions/thread/3656307

    BADI LE_SHP_GOODSMOVEMENT and AC_DOCUMENT aren't found in my current SAP (4.6c). As for BTE, I don't have any idea about it.

    Kindly need your help.

    Thanks and regards,

    Trisno S.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 29, 2018 at 04:22 AM

    Take the inputs from OSS note 1933844. Else, try with program SDVPRSUPDATE

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 30, 2018 at 03:53 AM

    Hello Sir,

    I've been reading the OSS Note, but it's not what I'm looking for.

    I'm not trying to recalculate VPRS in existing Billing. The existing transactions will be left as they are. I'm talking about new transactions, so that the value of BSEG-WRBTR can be changed automatically using user exit or enhancements when Users doing Post Goods Receipt.

    I noticed that this thread below has some success regarding MSEG-DMBTR but not BSEG-WRBTR:

    https://archive.sap.com/discussions/thread/3958368

    Kindly need anyone's input.

    Thanks and regards,

    Trisno S.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 02, 2018 at 02:11 AM

    Hello,


    Anyone?

    If you have experience regarding this, whether you did it by providing user exits or convincing the users to change, please kindly share your insight or solution.

    Thanks and regards,

    Trisno S.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 05, 2018 at 02:52 AM

    Hello, anyone?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 28, 2018 at 07:53 AM

    Hello,

    I've been searching for weeks and still haven't found any solution. I start to believe that it is impossible to achieve my goal.

    Therefore, is there any insights or ways to convince the users that the goal is impossible to be achieved except for reason that system is unable to do so?

    Thank you.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.