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:

1.   Open SAP Business One.
2.   Petite View / Enable System Profiler, or simply with all the key shortened   CTRL+SHIFT+I.
3.    
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.

Download

Note: do not insert rows before the column headers or

reorder the columns.

Do not hesitate to contact me.