Skip to Content
Author's profile photo Former Member

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.

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Gonzalo Gomez
      Gonzalo Gomez

      What about SQL2012??

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      For Sql Server 2012 you must do some change in code:

      1- Open file in Excel (don't forget to allow using macro)

      2- ALT+F11

      3- Double Click on ThisWorkbook

      4- change this line:<oCompany.DbServerType = dst_MSSQL2008> by <oCompany.DbServerType = dst_MSSQL2012>

      5- Save And Run