E-invoice Management in SAP Business One

E-invoice Management

Businesses in India need to file ‘E-Way Bills’ on the common government GST portal to facilitate the transportation and movement of goods across the country. The GST council of India has decided to use a new system of e-invoicing to make the process a bit easier. SAP Business One can help small and medium-sized companies to generate and manage e-invoices easily and efficiently.

What is E-invoicing

E-invoicing is the process where a business submits their invoice generated from the ERP system to the Invoice Registration Portal (IRP). The business then receives a QR code as well as a unique Invoice Reference Number (IRN) from the portal. This IRN and QR code should be displayed or printed on their invoice and should be easily visible. Businesses should create the invoice using their own software and not the government’s software system.

E-invoice should adhere to the GST invoicing rules and also accommodate the invoicing policies or system that is followed by every company in India. Businesses need to make certain information mandatory while they can keep the rest of it optional if required. Every e-invoice needs to be registered individually.

How to Generate E-Invoice in SAP Business One

Here is the process you need to follow to create an E-invoice in SAP Business One. You’ll use the generic eDoc protocol for the Indian localization of SAP B1 and get the JSON files released by the Indian government.

Step 1: Updating Queries

  1. Go to Tools > Queries > Query Manager from the SAP Business One menu bar.
  2. Under the E-Billing category in the Query Manager window, select E-Billing-Invoice and choose OK.
  3. Go to the upper left corner of the E-Billing-Invoice window and choose Edit.
  4. Download and enter the new query in E-Billing-Invoice.txt from the SAP Note 2902401 and delete the old query. Choose Execute and then Save.
  5. Update the queries E-Billing-CreditMemo-Lines, E-Billing-CreditMemo, and E-Billing-Invoice-Lines in the same way.

Step 2: Updating the eDoc Formats

  1. Run the following query in the SAP HANA studio or the Microsoft SQL Server management studio:
    update OFRM set “IsSystem” = ‘N’ where “Name” = ‘E-Billing-Invoice’
    update OFRM set “IsSystem” = ‘N’ where “Name” = ‘E-Billing-CreditMemo’
  2. Go to Administration > Setup > General > Electronic File Manager from the SAP Business One Main Menu
  3. Right-click the E-Billing-Invoice in the Electronic File Manager – Setup window and choose Update.
  4. Next, select the E-Billing-Invoice.app downloaded from the SAP Note 2902401.
  5. Download the E-Billing-CreditMemo.app from SAP Note 2902401 and update the E-Billing-CreditMemo

Step 3: Configuring the Electronic Document Generation

  1. Choose Administration > System Initialization > Document Settings from the SAP Business One Main Menu.
  2. Under the Generic eDoc protocol, on the Electronic Documents tab, perform the following:
    1. Select the Enable Protocol checkbox.
    2. Select Generate in the Default eDoc Generation Type dropdown list.
    3. Double-click the Processing Target Setup field, and in the Processing Targets for Protocol window, clock on the B1i Event Sender tab. Under the Business One Client – B1i Event Sender, select the Active checkbox.
    4. Select E-Billing in the User Query Category dropdown list.
    5. Double click the Documents Mapping Determination field. Also, define the export formats in the Export Format column of the Electronics Documents Export Setup window to correspond to the E-Billing-Invoice to A/R invoices and E-Billing-CreditMemo to A/R credit memos respectively.
  3. Choose Update in the Document Settings window.

Step 4: Creating A/P Credit Memos or A/R Invoices

  1. Choose Sales – A/R > A/R Invoice or Sales – A/R > A/R Credit Memo from the SAP Business One Main Menu.
  2. Make sure you have defined the Digital Series field in the A/R Invoice or A/R Credit Memo window for the selected series in the Series – <Document> – Setup window.
  3. Choose Add in the A/R Credit Memo or A/R Invoice. The electronic documents will get generated.

Step 5: Exporting JSON Files

  1. In the SAP Business One Main Menu, choose Reports > Electronic Document Monitor.
  2. Find the Protocol dropdown list in the Electronic Document Monitor Window. You can find the generated electronic documents by selecting the Electronic Invoice.
  3. Select the file you want to export as a JSON file, right click on it and choose Advanced > Export.
  4. The file type .json will appear automatically in the Save As window. You can choose Save to get the exported JSON files.

Best Practices for Generating the E-Invoice

Make sure to follow these settings to have the correct results in the JSON files.

  • Check that in the Duty Status column, there are no checkboxes selected in the Define Tax Amount Distribution window. You find it in the Tax tab of the document under the Duty Status dropdown after you select Without Payment of Duty.
  • All the tax types in the document row must have the same base amount. You can go to the Define Tax Amount Distribution to check the base amount.
  • The tax codes for rows and freights should have either zero or 100 Reverse Charge % along with all the tax types of the tax codes.
  • There should be at least one document row in the documents.
  • The freight tax codes must follow the GST tax rule and should use IGST for inter-state cases and CGST+SGST for intra-state cases.
  • The tax base amount of the freight in the same row must have the same freight value in the document row. For instance, the base amount of freight 1 tax should be equal to the value of freight 1. You can click the link arrow in the Freight Tax column in the Define Tax Amount Distribution to check the base amount.

Businesses operating in India need to follow the GST rules and regulations thoroughly. Failing to do so can affect the company financially as well as morally. SAP Business One is an excellent tool that can help SMEs take care of their GST reports, returns and more. E-invoicing in SAP is also quite easy to do and can prove really beneficial for the company.


Subscribe to Our Newsletter

Related Articles

Top Trending

bucks stumble first round exit
Bucks Stumble Again: First-Round Exit for Second Straight Year
gomovies
Legal Alternatives to Gomovies That Won't Break The Bank in 2024 [Price Analysis]
kentucky derby 2024
2024 Kentucky Derby: Date, Time, Horses & Everything You Need to Know
Luxury FintechZoom
The Growing Impact of Luxury FintechZoom on Wealth Management [An Analysis]
kendrick 616 la rap feud with drake
Kendrick Doubles Down: "6:16 in LA" Heats Up Rap Feud with Drake

LIFESTYLE

Anne hathaway sobriety journey
Anne Hathaway Celebrates Five Years of Sobriety
Most Expensive Handbags for Women in the World
Elegance Redefined: 10 Most Expensive Handbags for Women in the World
Gift Ideas for Men
10 Thoughtful and Unique Gift Ideas for Men Who Have Everything
pohela boishakh 2024
Pohela Boishakh: Celebrating Bengali Culture and Heritage Festivities
Korean Beauty Secrets
10 Korean Beauty Secrets for Youthful Energy: Stay Young & Vibrant

Entertainment

gomovies
Legal Alternatives to Gomovies That Won't Break The Bank in 2024 [Price Analysis]
kendrick 616 la rap feud with drake
Kendrick Doubles Down: "6:16 in LA" Heats Up Rap Feud with Drake
aiyifan
Aiyifan Features, Quality, and Top 100 Alternatives in 2024 [A Detail Guide]
Jewel's Unexpected True Love Revealed
Jewel's Unexpected True Love Revealed! Exclusive Scoop Inside
hbo may 2024
Exciting TV Shows and Movies Coming to HBO May 2024 [Complete Schedule]

GAMING

unblocked games 911
A Guide to Play Unblocked Games 911 at School or Home [100 Top Alternatives]
protect child from excessive gaming
How Can You Protect Your Child from Gaming Too Much?
wpc16
Top 20 Alternatives to WPC16 with WPC16 Dashboard Login [Image Guide]
20 Best Alternatives to WPC18 with Its Dashboard Login in 2024
20 Best Alternatives to WPC18 with Its Dashboard Login [Image Guide]
F95zone
How to Get Started on F95zone and Increase Community Interaction in 2024 [Gamer's Guide]

BUSINESS

Luxury FintechZoom
The Growing Impact of Luxury FintechZoom on Wealth Management [An Analysis]
How to Select Lab Equipment Service Providers
How to Evaluate and Select Lab Equipment Service Providers
Tech giant huawei profit growth and apple sales
Huawei Profits Soar 564%, Cutting Deeply into Apple's Market Share
Elon Musk in China as rivals show new electric vehicles
Elon Musk in China: Tesla Faces Rising EV Competition
covid 19 impact on cleaning industry
The Impact of COVID-19 on the Cleaning Industry and How Businesses are Adapting

TECHNOLOGY

Luxury FintechZoom
The Growing Impact of Luxury FintechZoom on Wealth Management [An Analysis]
instagram algorithm update wooing tiktok fans
Instagram's Algorithm Update: Wooing TikTok Fans
elon musk cancels tesla summer internships
Elon Musk Cancels Tesla Summer Internships: Impact on Students
alphabet apple deal impact tech giants
Alphabet's $20B Apple Deal: Tech Giants' Game-Changing Impact
tips for remote tech talent attraction
Ways to Attract High-Quality Tech Talents in the Remote World

HEALTH

top 3 muscle recovery tech devices
3 Innovative Muscle Recovery Technology Devices
6 Ways Mindfulness Can Alleviate Your Pain
6 Ways Mindfulness Can Alleviate Your Pain
King Charles Resumes Duties After Health Update
King Charles Resumes Duties After Health Update on Cancer Battle
What to Do When Testosterone Levels Drop
What to Do When Testosterone Levels Drop Too Low and How to Treat
Can Tonsils Grow Back After Being Removed? - Tymoff
Can Tonsils Grow Back After Being Removed? - Tymoff