Category: FICO

How to Copy Header Text to Line Item Text in FB60 and FV60 for better search capability by some Magic?

Introduction

It is very useful to Copy Header Text to Line Item Text in FB60 and FV60 for better search capability by some Magic. Instead of Copy Pasting we can use some shortcut magic.

Solution

Magic done the ++ value in item text is replaced by Header Text.

Conclusion

This is very useful and can be used in most SAP Environment.

Below is the video version

Get update of new blog posts

Name

Country

Email address:

Arghadip Kar December 11, 2020 0 Comments

FICO

Configure all Doc. Splitting line items categories in 1 Min

Document splitting is part of new General ledger functionality that is widely implemented in all new SAP implementations in either ECC or S/4 HANA implementations

I wrote a blog post:

https://blogs.sap.com/2019/10/25/how-to-ensure-document-splitting-has-accurate-item-categories/

Where I got feedback the feedback : It’s complicated.

In this video blog, I tried to simplify the document splitting line item category configuration and I could configure it in full within 1 Minute.

By end of this video following knowledge expected to be covered

Expected results by the end of Part one

1.Understand document splitting concept

2.Know what is Partner profit center !

3.Generate financial statement per mandatory Characteristic ( Profit center)

Expected results by the end of Part two

1.Use Standard “Check item categories program” for finance system health check and for GL assignment derivation

2.Know how to check SAP recommendation for GL item Categories

3.Know how to solve below Errors

There is no item category assigned to account XXXXX/1000
Item category XXXX is missing (obligatory in accounting transaction 1000/0)

Finally

By end of this blog post we emphasis the importance of item categories and its main role that affect document splitting and in turn all financial postings either in General ledger, Subsidiary ledger or financial document flows from other module.

We went through small case that shows small changes in item category configuration can lead to big consequences, error messages that may raise based on incorrect or incomplete item categories and fast way to check and analyze item categories for document splitting.

Till then you can have look at our ebooks.

Get update of new blog posts

Name

Country

Email address:

Ayman Mohmed December 3, 2020 0 Comments

FICOGeneral SAPSD

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:

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:

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.”
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 Type	GSTN Status	Customer Category
Regular	Active	B2B
Tax Deductor	Active	B2G
SEZ Unit	Active	SEZ
SEZ Developer	Active	SEZ
Composition	Active	B2B

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.

Till then you can have look at our ebooks.

Get update of new blog posts

Name

Country

Email address:

ERP College November 28, 2020 0 Comments

FICO

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:

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

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

Then right click on the item and select Post Items

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:-

Execute the node

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

Get update of new blog posts

Name

Country

Email address:

ERP College August 30, 2020 0 Comments

FICO

The Art of creating G/L account

As a SAP consultant many times we underestimate the importance of Master Data
Here we will see how a consultant can provide support using his experience

Ticket raised with description: Need a G/L account 1234 – Cash pool PLN

The company presents in multiple countries
Shares the same chart of accounts

1. Check whether G/L is created in the chart of account or not
2. To find the company code check users parameters in SU01 transaction
3. The G/L is a balance sheet account (can understand from the description)
4. The currency of G/L account is PLN
5. check company code currency, if different than PLN then
6. Need to add this G/L into foreign currency valuation
7. If G/L is not managed as an open item basis then find out the exchange rate difference keys available and assign in G/L master
8. If G/L is managed as open item basis then have to do configuration to include the account in foreign currency valuation (maintain configuration for account key KDF)
9. Generally, cash account is not managed as open items, if it is not a sub-account of any main bank
10. Check the preceding and succeeding Accounts to know is this G/L sub-ledger to the main bank account
11. If it is sub-account (like incoming and outgoing account) then should be open item managed
12. Field status of bank account (with mandatory value date)
13. Description maintenance language (check the maintenance language of the chart of accounts and the local language of user if different then maintain description in local language as well)

And the G/L is created by one sentence of description. Without any need of asking anything to user.

Hope you would find this interesting. If you want to know more about G/L accounts, then you will find this blog helpful Everything about General Ledger account

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.

ERP College August 18, 2020 0 Comments

Get update of new blog posts

Name

Country

Email address:

Category: FICO

How to Copy Header Text to Line Item Text in FB60 and FV60 for better search capability by some Magic?

Configure all Doc. Splitting line items categories in 1 Min

GST India – E-Invoicing

1. Introduction

2. EDOC_COCKPIT

Errors and checks

Tips and tricks on Bank Reconciliation in SAP

The Art of creating G/L account

Contacts