Skip to main content

General Ledger with SAP Business One GL

General Ledger file format for SAP Business One

Updated over a month ago

Exporting General Ledger information from WageEasy to SAP Business One requires some initial configuration in WageEasy. Go to Setup, General Ledger, Export Format and select the export format you want to use is SAP Business One.

There are a couple of SAP Business One versions to choose from:

  • SAP Business One

  • SAP Business One (CSV)

  • SAP Business One V9

  • SAP Business One V9.3

From Setup, General Ledger, Configuration enter the database and SAP Business One connection parameters relevant to your installation of SAP Business One.

The settings provided in this article directly map to the connection service published by SAP Business One and should be readily available in the configuration settings of your software. The same setting would have been provided by SAP Business One when setting up the software for the first time.

Running Wage Easy SAP Business One GL Export

WageEasy connects to SAP Business One, starts a journal transaction and then adds each of the general ledger entries to that journal. If no errors are encountered the journal is closed, committing it to SAP Business One.

Each journal line item contains the following information:

  • Transaction Date

  • GL Sub Account Name

  • GL Account Number

  • Line Item Amount

  • Line Item Hours

Architecture

WageEasy uses a proxy DLL to provide and manage communication between the WageEasy application, and the COM services published by SAP Business One. The DLL imports business object definitions and communication protocol published by the SAP COM interface and manages connection to and disconnection from the SAP COM services, journaling and error reporting. The following SAP Business Objects are used by WageEasy

  • ICompany

  • IJournalEntries

  • IJournalEntries_Lines

  • IRecordset

  • ISBObob

The proxy DLL connects to SAP Business One by creating a company object and filling it with information required by SAP, namely

  • Database Server Host

  • Database Name

  • Database User Name

  • Database Password

  • Business One User Name

  • Business One Password

  • Database Server Type

and calling the ICompany.Connect method

Note: For Version Mismatch Error (when trying to do the Export), use sa. To prevent this from happening, fix the SQL Database roles\permissions for the user.

Did this answer your question?