Enterprise Resource Planning Blogs by Members
Gain new perspectives and knowledge about enterprise resource planning in blog posts from community members. Share your own comments and ERP insights today!
Showing results for 
Search instead for 
Did you mean: 
Former Member
0 Kudos

This is an Excel file for accounting entries directly via Excel without losing much time.

To download the file: Download

Before starting make sure that the reference (the DLLs) it up correctly.

1 - Open the file

2 - click ALT + F11

3 - Add the appropriate reference, depending on your version of SAP Business One

4 - click save and close this window.

5 - Change the connection settings in SAP Business One in the excel sheet.

6 - Save the file.

7 - The Excel workbook is composed of two sheets: one for the header of the accounting entry, and one for the lines of writing.

8 - the header is composed of the following columns:

  ID: An incremental counter for headers of the accounts, it starts with 1.

series: the numbering series of writing in your SAP Business One.

How to determine the proper value of the series in SAP Business One:

  1.   Open SAP Business One.
  2.   Petite View / Enable System Profiler, or simply with all the key shortened   CTRL+SHIFT+I.
  4.   Open the "journal entry" SAP Business One.
  5.   By placing the cursor on the series of writing in the information bar at the bottom, is recovered in the series.


Cal.Auto.TVA: To inform SAP if we will apply an automatic calculation of VAT,

this cell must contain either tYES or tNO   (note this value is case-sensitive).

Date Comp.: Accounting Date.

Date Ech.: Date due.

Date Doc.: Date document.

Memo: wording

Reference1: ref. 1

Reference2: ref.  2

9 - For lines (sheet EJ) the ID column refers to the ID of the header.

10 - click on Valider to commit transactions.


Note: do not insert rows before the column headers or

reorder the columns.

Do not hesitate to contact me.

Labels in this area