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
8 - the header is composed of the following columns:
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.
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:
![]() 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.
|