Journal entries in SAP Business one with Excel

[Former Member]

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.