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.