GST India – E-Invoicing

1.     Introduction

GST E-invoice is introduced to reduce the evasion of GST. It is an electronic invoice generated by supplier on the government portal. It is mandatory to issue e-invoice for Business to Business (B2B) transactions provided that the supplier has crossed the threshold limit of 500 crore turnover in previous financial year.

E-invoice solution provided by SAP:

For more details refer OSS – 2884058 – SAP solution for eInvoice/IRN India

SAP has provided two solutions for eInvoicing

  • Automated Solution

This is a solution developed by SAP which will provide direct integration between the SAP and the eInvoicing (IRN) via certifiedGSPs using the SAP Cloud Integration Platform. 

GSP:  GST Suvidha Provider (GSP) is considered as an enabler or authorised intermediary for businesses to access GST portal services.

In automated solution user has to upload the invoices from SAP, then in the backend it will be send to IRP portal via GSP and generate an 64 digit IRN (Invoice reference number) along with signed QR code; returned it back to SAP and assigned to the invoice or stored in the database.

  • Manual Solution:

SAP manual process will read the response file and store the information of IRN, QR code & digital signature in the standard table and it will link the original invoice with IRN along with the current status in the table. The preparation of a standardized format (JSON request file) needs to be generated offline by the customer.

2.     EDOC_COCKPIT

In eInvoicing solution SAP has introduced the cockpit to manage the all activities related to edocument. How to use it and what we can do with the cockpit we will see in below part:

Execute transaction code EDOC_COCKPIT

Below screen will be prompted:

EDOC_COCKPIT

Default variant is executed in the background after executing the cockpit

To change the variant value click on Change button:

We can use above parameters to filter the edocument

In the cockpit there are only two status of the document on broad level

 

In process

 Completed

Once the status is completed, there will no further processing can be done on the document.

To generate an edocument and get IRN number select the document:

And click on the submit

That’s it, within couple of seconds system will reach to the IRP portal and generate an IRN number and get back to the SAP

You can notice even after generating an edocument status is still yellow (in process)

Scroll to the extreme right to see the Invoice Reference Number

The highlighted number is the 64 digit alpha numeric IRN

Cancellation of IRN

Cancellation of E-document is only possible if we are cancelling it before 24 hours and the invoice is not finalize in the SAP

Select the E-document and click on Cancel eDocument

Enter the cancellation reason code from below available options:

  • Duplicate
  • Data Entry Mistake

Click on save

And the edocument does not get cancelled, to check the error select the document and click on ‘goto’ button

Click on application log

Errors and checks

Duplicate IRN:

IRN will not be generated for invoices with identical key parameters (Eg: Supplier GSTIN, Invoice Number/ODN, Document type, Financial Period, etc.). In case there are invoices generated with identical ODN, assign a separate number range in the view EDOINEWBCONFIGV.

RCM cases:

IRN is only required for B2B RCM invoices from the supplier perspective and not from the buyer and receiver perspective as this is not a legal requirement and there is no API available for the same in Govt. portal.

Finalize:

After finalizing, no action can be performed on the e-Document. The status color will be green once finalizing the e-Document is done.

Cancellation:

According to govt, IRN cancellation can only happen within 24 hours of its generation. Any cancellation after 24hrs could not be possible on IRN, however one can manually cancel the same on the GST portal before filing the returns.

If the source document needs to be canceled in SAP post 24 hours of IRN generation:

  1. Perform the ‘Cancel eDocument’ action under ‘More’ in EDOC_COCKPIT and it should fail with the error “Error Code 2270: The allowed cancellation time limit is crossed, you cannot cancel the IRN.”
  2. Use the ‘Allow Cancellation’ action under ‘More’ in EDOC_COCKPIT to enable the cancellation of the source document. The status will be changed to ‘ALLOW_CANCEL’ to allow source document cancellation.

Note: This does not have any impact on IRP portal data and only allows to cancel source document in the SAP system. After canceling the source document, ensure to cancel the outward liability while filing GSTR1 returns.

Below customer categories requires to generate edocument.

GSTIN / UIN Status

Tax Payer TypeGSTN StatusCustomer Category
RegularActiveB2B
Tax DeductorActiveB2G
SEZ UnitActiveSEZ
SEZ DeveloperActiveSEZ
CompositionActiveB2B

This blog will be update time to time as this is new thing in India and government seems to be serious with the edocument concept looks like we will see more changes in near future.

Sign up with us to get an update of a new blog post.

Till then you can have look at our ebooks.

Read More
SAP College November 28, 2020 0 Comments

Ways to find Tables and Transaction codes in SAP

One thing is for sure that we cannot remember every table and transaction related to any or all modules, and processes. So to make there are couple of ways which we can use to find out T-codes and tables without knowing anything.

1.    From scratch

If you don’t know the tcode or table you are searching for then the transaction SE16T will be useful for you.

Here let’s say for example, you have to find out the tcodes related to the production order

Go to SE16T

SE16T

Double click on the Find Transaction – Execute Function

On the left hand side a new option will be visible at the top, which is to search transaction term.

Now in the inputable search field we will enter ‘Production Order’ and press enter

And here you go, there are 45 transactions displayed which description contains name of the searched term.

If you look at the result it is much satisfying, this SE16N can be very useful, if we remember it and used it instead of wasting time on Google to find transactions.

Same way it works for tables, in SE16N double click on the Find Tables – Execute Function

Press enter

And we have the all tables related to accounting.

2.    From fields

This is very common way of getting the name of the tables. All we have to do is to press F1 in the field of the document.

For e.g. in Accounting document we need to check in which table header data of the document is recorded.

Select document number field and press F1

Click on the technical information

In the pop up window highlighted field usually contains the name of the fields.

3.    From the structures

Now in above scenario not all the time we get the name of the tables by pressing F1 on the field, many times we only get the structure names.

So in this block we will try to figure out, how to get table names for the fields in structure

For e.g. if we similarly go into the MIGO transaction and try to search for the table for header level of the document by pressing F1 – Technical information, we will get the structure ‘GOHEAD’

Double click on the structure GOHEAD

We will get the list of fields in the structure, now suppose we want to know the field MBLNR is used in which tables à then double click on the field

SE11

Select where used button

Tick the table fields option and press enter

Below window will pop up with the list of tables which contains the material document number field

The list will be alphabetically arranged.

Okay so I hope you enjoyed reading the blog, and hope you learned something new.

Read More
SAP College November 9, 2020 1 Comment

Useful reports in Material Management

If someone asks what makes ERP so special? My answer would be the ability to manage inventory. ERP enables us to track live movements of inventory. And if that’s the biggest part of ERP, then we should definitely explore the biggest ERP-SAP.

In this blog, we will know about different kinds of reports in Material Management and how they can help us to track the material’s movement/to manage inventory.

Let’s start with a transaction which will guide you to find available reports in SAP:

Execute SAP1 transaction code

SAP1

This transaction will redirect you to easy access of the report selection screen, expand any of the above folders, and find out the reports specific to each module.

We will see the reports available in Material Management

SAP1 – Material Management

The reports further sorted with IM, WM, Purchasing and Physical Inventory.

Let’s expand the Warehouse Management – Master data folder:

SAP1 transaction is worth to remember, it will help you to find reports/data easily across any module.

MB51 – Material Document List

This report is used roughly in MM and really useful for a consultant and end user as well for analyzing the movements of material.

Selection screen:

MB51

The report can be executed with the various combination of Material, Plant, Vendor, Movement type, and sales order. Which gives us the flexibility to view material movement from various aspects.

In and Out of the Material is colored with green and red respectively.

This series of report keeps going on like this:

  • MB51: Material Document List
  • MB52: List of Warehouse Stocks on Hand
  • MB53: Display Plant Stock Availability
  • MB54: Consignment Stocks
  • MB58: Consgmt and Ret Packag at Customer
  • MB59: Material Document List

MMBE – Stock Overview

This transaction is one of the tools that can be considered as a display at any given moment of information about the stock situation of an individual material. It gives a material stock position on every organizational level along with the information of batches and special stock.

Selection screen:

MMBE

It can be noticed this transaction can be executed for specific plant and/or storage location and/or batch.

On lower side of the selection screen we can select the display level of stock.

On the left-hand side of this report, the organization levels can be seen. And the highlighted area displays whether the stock is in unrestricted use or blocked under the order or in quality inspection.

So this report will be read like Material 1234 of qty. 20 under plant ABC is in unrestricted use and material 1234 of qty. 50 is blocked in order.

Now we will discuss about the most unknown but most useful report:

MBMAPCHANGES – Report for Moving average price analysis

This report gives us a detailed breakdown of moving average price, how the MVP changes with every movement of material, it can be analyzed in this report.

Execute SA38 and enter the program name MBMAPCHANGES and execute

MBMAPCHANGES

Selection screen requires Plant and Material number

And here you go with the old price and new price changed with each material document

And this brings us to the end of the blog… we will keep updating this blog with new and useful reports in MM and WM…. Stay tuned.

If you have any suggestions or questions do let us know in the comment section or you can also write us directly. 

Sign up with us to get an update of a new blog post.

Till then you can have look at our ebooks.

Read More
SAP College September 10, 2020 0 Comments

Tips and tricks on Bank Reconciliation in SAP

In this blog post, we will explore Manual and electronic Bank Reconciliation and hidden features in it. I am assuming that you already know the configuration and end-user process of EBS and BRS, if not you can refer this eBook to dive deep into it.

Transaction FF67 is used to post bank statement manually and front screen look like this:

FF67

Here bank key and account number have to be entered of the bank for which bank statement should be posted.

But don’t you think, it is too hard to remember the bank key and account number of each bank account, especially when we have a shortcut ID to house bank and account.

So let’s change this:

GoTo Menu – Settings – Specification

Click on the specification

Specification

Here tick the internal bank determination

And press enter

And here you go, bank key replace with House bank, and Account ID takes place of Account number

Also Read: Functioning of CO-PA in make to order scenario

Now let’s go to the transaction FEBAN

It is used to post-process the bank statements if in case of any error. But FEBAN is only useful when FF67 is not run in batch input job because in that case system considers that the user somehow managed to do posting and the statements are posted. These are some limitations of ECC because submodules are not consolidated to the G/L

Execute the FEBAN


The Red ones did not get posted in FF67, there is some problem while posting these entries

But now how we can know about the errors? Let’s see:

GoTo Edit – Posting Mode – In Foreground

Here select in foreground option, this will trigger system to perform posting in foreground

Post Item

Then right click on the item and select Post Items

FB01

And the document is getting posted in front of our eyes.. look for the error and rectify it.

Read eBook: SAP DME – A Simplified Guide

Do you know we can use interpretation algorithm in manual bank reconciliation as well

It is possible to use interpretation algorithm, where posting rules are assigned to the business transactions. In below path:-

Configuration Path

Execute the node

SPRO

There are a total of 42 types of interpretation algorithms available to choose from. It is not possible to explain the use of all those here, but you can download this document, where you can find detail explanation of each interpretation algorithm

We will keep updating this blog, as per your suggestions and necessity…. stay tuned.

If you have any suggestions or questions do let us know in the comment section or you can also write us directly. 

Till then you can have look at our ebooks.

If you enjoy the blogpost, then you can stay connected with us on below platforms:

YouTube

LinkedIn FICO Page

LinkedIn ABAP Page

LinkedIn Logistics Page

Instagram

Also subscribe below to receive update of new blogpost

Read More
SAP College August 30, 2020 0 Comments

How to play Games like 2048 in SAP?

Get bored migrating the data or writing a bunch of code and need some refreshment, you should know this transaction where you can relax by playing some Games.

May be many of you knows or maybe don’t but yes you can play games in SAP GUI and it is much more user friendly.

So let’s find out how:-

Go to transaction code ABAPDOCU

Yes, this transaction is an SAP’s documentation about ABAP language. We will have a separate blog to discuss how you can use this transaction to learn ABAP or how it could be helpful to the functional consultant.

ABAPDOCU

Follow the below path

ABAP References – ABAP syntax – ABAP Statements – Operators and Expression – Example of expressions-oriented programing

ABAPDOCU – Path

And here you go – Jawbreaker, Minesweeper, and 2048 Game

Double click on the game which you want to play

On the right side of the screen we can see the code written for the game and under the source code we have a execute button – click on it

A new window will be open, allowing you to select size and target of the game

Click on enter

And let’s play…..

2048

Use Arrow key to make tiles move

I know, you know how to play it….

If you have any suggestions or questions do let us know in the comment section or you can also write us directly. 

Sign up with us to get an update of a new blog post.

Till then you can have look at our ebooks.

Read More
SAP College August 30, 2020 0 Comments