Journal entries in SAP Business one with Excel
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:
- Open SAP Business One.
- Petite View / Enable System Profiler, or simply with all the key shortened CTRL+SHIFT+I.
- Open the “journal entry” SAP Business One.
- 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.
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.