Like most things in nuQ, the rules for converting earnings, deductions and cost codes to their general ledger equivalents are held in tables which can be easily modified or added to as required. It would be difficult in a limited space to set out all the conversion possibilities catered for.
On a simple payroll it is normally just a matter of entering all the general ledger account numbers in a table and in another table specifying the general ledger code associated with a particular earning or deduction. This can be amplified by specifying that combinations of earnings and all or portions of a cost code go to different general ledger accounts.
For more complex general ledgers a host of other options and tick boxes are made available in the tables, which cannot be described here. Suffice it to say that nuQ has successfully created general ledger interface files for some very complex general ledgers.
A further option that is available is to specify (again through entries in a table) the contents of each field of a file or Excel spread sheet which is to be created for a particular general ledger. This has been used to successfully create files to interface with a complex Accpac general ledger.
This same facility has been used to generate Excel spread sheets for complicated reports that are required, obviating the need for a special report to be written.
As we come across new apparently impossible to solve requirements, we develop new or enhance existing generalised facilities to make it comparatively easy for a user to meet their requirements. We do not believe in solving problems by writing special programs but would rather provide enhanced facilities (which are then available to all users) which non-programmers can use to produce the desired results.
For GL journal integration, we currently support clients on the following systems, but keep in mind that we can easily add additional ones (the basic logic will not change only the output format):
- Sage Pastel Partner
- Sage Pastel Evolution
- Sage X3
- Sage Line 500
- Microsoft Dynamics GP
- Microsoft Dynamics AX
- Microsoft Dynamics NV
- SAP R/3
- SAP BusinessOne
- SAP HANA
Also, please keep in mind that some of the above may be customized for a specific client, so there may be a bit of work required to make it work for someone else.