Skip to Content
Author's profile photo Bisweswar Sahu

Auto Reversal Purchase Invoice on GR Material Document Cancelation

Scenario:

               Certain Vendor(s) supply ordered materials along with invoice, for self-billing invoice.

               So background ERS carryout on each day/periodically to generate Invoice(s) against GR(s) received.

Requirement:

Sometimes, these GR documents need to cancel due to various reasons, after auto IV generated.

Business wants to cancel these auto generated IV automatically, on cancellation of GR material document.      

Solution:            

                Allow Cancelation on GR reversal Movement Type even if the invoice relating to the goods receipt document has already been posted.

                Run ERS to auto generate Credit memo on cancelled GR.

Example:

Step-1 : Create a PO

Step-1_PO.png

Note:

  1. PO line item must be GR-based, ERS checked with Input Tax code maintained.

Step-2 : Do a Goods Receipt with Standard Movement Type: 101.

          After running ERS, PO history will get update like bellow.

  Step-2_ERS History.png

Step-3 : Once you will try to cancel the GR document (with Movement-Type: 102), system will restrict with bellow error message.

  Step-3_Cancellation.png

So you must cancel the invoice before you enter the reversal of the goods receipt or the return delivery.

Here the requirement is to allow GR cancellation even if the invoice relating to the goods receipt document has already been posted.

On this regard, we’ll go for new movement type for allow cancellation of GR which will carry the feature as need.

Configuration:

Create 2 movement types for specific purpose (GR & Reversal on the same)

Movement Type:

Y01 (Identical Copy of 101); Reversal Movement Type: Y02

Movement Type:

Y02 (Identical Copy of 102); Reversal Movement Type: Y01

Allow Reversal of GR Despite Invoice through bellow path

MM -> Inventory Management and Physical Inventory -> Goods Receipt -> For GR-Based IV, Reversal of GR Despite Invoice

  Step-4_AllowCancellation.png

Follow bellow link for ERS related configuration procedures.

http://help.sap.com/saphelp_srm2007/helpdata/en/59/756a41f1af7f47e10000000a1550b0/content.htm

Now we can start the process from GR with Y01

Step-2(Revised from 101 to Y01): Do a Goods Receipt with Movement Type: Y01

Step-2-1_GR_Y01.png

& on after running ERS, PO history will get update like bellow. (Similar to earlier 101)

Step-2-2_ERS History.png

Step-3 (Revised from 102 to Y02):
Once you will try to cancel the GR document (with Movement-Type: Y02), system will not restrict for the same.

  Step-3-1_CancellationY02.png

So PO history will update as bellow.

  Step-5_Cancellation History.png

Now once ERS will run after the same, PO history will like bellow.

  Step-5_CancellationERS History.png

Here system auto generate a credit memo w.r.t. GR document has been cancelled.

Details can be checked.

  Step-5_CreditMemo.png

In this way, we can get the result by using 2 features together.

  1. Allow For GR-Based IV, Reversal of GR Despite Invoice on movement type.
  2. ERS functionality

Note:

The same functionality can be activated on standard movement type: 102 & get desired result,

as I prefer to use Z movement for any customization rather than changes on standards, I presented my topic with Y01 & Y02.

Hope it’ll clear & easy to understand.

It’s my first document in SCN, suggestions need for improvement.

Thanks & Regards,

Bisweswar

Assigned Tags

      12 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Abu Fathima
      Abu Fathima

      Hello,

      Thanks for sharing the Knowledge...it is really very useful

      Thanks

      Faisal

      Author's profile photo Former Member
      Former Member

      Hello Bisweswar,

      Very help full document and nice explaination.

      Regards

      Priyaranjan

      Author's profile photo Jürgen Lins
      Jürgen Lins

      I know what you want to say, but to make it clearer you have to write it explicitely.

      Right now I could ask why should I create a new movement Y01 and Y02 as I can right away allow the 102 Reversal of GR Despite Invoice and would have the same effect.

      Explain the advantages of new movement types in this case

      Author's profile photo Bisweswar Sahu
      Bisweswar Sahu
      Blog Post Author

      Hi Jürgen,

      Yes,we can do on the standard movement type(102) & we'll get the same effect.

      I demonstrated on Z Type for a basic reason that I prefer to not to change any standard movement type & use copy of that with customize to get required functionality.

      Regards,

      Bisweswar

      Author's profile photo Former Member
      Former Member

      What changes (other than OMBZ) you did in Y01 & Y02 movement types when they compare to 101 & 102?

      Author's profile photo Bisweswar Sahu
      Bisweswar Sahu
      Blog Post Author

      Hi,

      That is the only change I had included.

      Regards,

      Bisweswar

      Author's profile photo Rakesh M Choudhary
      Rakesh M Choudhary

      Hi

      Informative Document.I have two questions:

      1. Why is this process better than just reversing the ERS document or creating credit memo and then reversing the GR. Is it because of manual work?

      2. What will happen to the "101 - ERS document" already in the system. What is required for the transition to new movement type for the existing documents.

      If you feel, you can add these points to the document.

      Thanks

      Author's profile photo Bisweswar Sahu
      Bisweswar Sahu
      Blog Post Author

      Hi Rakesh,

      Thanks for your comment.

      Ans1:

      Yes, only to minimize human effort, I had recommended the process.

      Ans2:

      You can active on standard movement type:102, but I prefer better to customize on z movement type rather than standard.

      Regards,

      Bisweswar

      Author's profile photo Amala Srinivasa Rao
      Amala Srinivasa Rao

      Good One 😆

      Author's profile photo Dibyendu Patra
      Dibyendu Patra

      Good document...

      You can mention the new movement type creation reason in your document.

      It just for the reversal of GR configuration in customizing...

      Thanks for sharing you knowledge...

      Author's profile photo Bisweswar Sahu
      Bisweswar Sahu
      Blog Post Author

      Thanks Dev. Added the same.

      Regards,

      Bisweswar

      Author's profile photo Former Member
      Former Member

      Hi,

      Thanks your knowledge sharing, Good document. Keep it up.

      Regards,

      Manikandan G