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.
What about SQL2012??
For Sql Server 2012 you must do some change in code:
1- Open file in Excel (don't forget to allow using macro)
3- Double Click on ThisWorkbook
4- change this line:<oCompany.DbServerType = dst_MSSQL2008> by <oCompany.DbServerType = dst_MSSQL2012>
5- Save And Run