The ACCPAC General Ledger Interface (Sage300) is an enhancement to the existing General Ledger functionality. This article should be used in conjunction with the General Ledger training manual.
Prerequisites
MicrOpay Evo and Sage 300 (Accpac ERP) must be successfully installed on the PC.
Please refer to your Sage 300 (Accpac ERP) Support person concerning the installation of Sage 300 (Accpac ERP)
Please refer to your MicrOpay consultant concerning the configuration of the Integration module in MicrOpay Evo.
A complete install of Sage 300 or Workstation setup is required on the MicrOpay server.
To check that Sage 300 is installed on the machine:
Go to Start, Programs, Accpac. If Accpac is not in the start list, it is probably not installed. Though it could be installed, and the folder removed from the start list. Or
The registry key: HKEY_LOCAL_MACHINE\SOFTWARE\Accpac International, Inc.\Accpac\Configuration\Programs will ALWAYS exist on a machine that has Accpac installed and working correctly.
The following functionality should only be set up when a valid MicrOpay Evo registration code for ACCPAC General Ledger Interface (Sage300) has been entered into MicrOpay Evo and when the Cost Accounts have been defined.
Add General Ledger Accounts (ACCPAC/Sage 300)
Go to General Ledger Integration, Maintenance, Accounts to define your General Ledger Accounts. The ACCPAC or Sage 300 accounts are pre-defined and selected from a drop-down list.
When you click Add, an Add New Ledger Account window specifically for the ACCPAC interface is displayed. And the following fields are available:
Accounting System contains the options ACCPAC or Generic. ACCPAC should be selected when using ACCPAC software.
Company contains a list of the ACCPAC databases. This option determines the options in Account Code.
Account Code is a lookup of the accounts available in the selected ACCPAC Company database. The lookup button takes you to ACCPAC and the list of Account Codes.
Source Code is a lookup of the Source types found in the ACCPAC database. This can be left blank and selected in the General Ledger Batch. This field tells the ACCPAC database the source of the information, e.g. JE = GL Journal Entry. The lookup button takes you to ACCPAC and the list of sources.
Description is the Account Code description. This field is not editable and is populated by the ACCPAC database.
Account Type groups Account Codes and determines where the account displays in the financial statements. The Account Type defaults from the Account Code. This field can be edited. For an explanation of Account Types, see the table of Account Types in the General Ledger Manual.
Untick the Active Account checkbox to prevent the account being selected or printed in reports of active accounts.
To delete an Account, untick the Active Account checkbox to ensure it is not used and then wait until all transactions that use this Ledger Account are no longer in the Company database. This may take up to 36 months due to the way in which MicrOpay stores transactions.
Batch File definition (ACCPAC/Sage300)
Go to General Ledger Integration, Maintenance, Batches, Batches to enter the Batch File parameters. The following fields in the Batch File tab are NOT used when the batch file is generated using ACCPAC.
File Layout
Filename
These fields can be left with default values. Any values entered in these fields will be ignored as the data is added directly to the ACCPAC database.
The Details tab is used to map Pay Components and Cost Accounts to the General Ledger Accounts. The setup of this tab is the same for all General Ledgers. Refer to the Online Help or the General Ledger manual for further assistance.
The ACCPAC tab is only available when you have the ACCPAC Integration module.
Select the Company with which the Batch will be integrated. The User name and Password will be automatically populated. If the information is not populated, enter the User Name and Password used to log into ACCPAC. And click OK.
A list of the Source Accounts is returned from ACCPAC and a source account can now be selected.
Source Code is a lookup of the Source types found in the ACCPAC database. This field tells the ACCPAC database where the information has come from, eg JE = GL Journal Entry. The lookup button takes you to ACCPAC and the list of Source Accounts available
Note: When the lookup button is selected, you must log in to ACCPAC to retrieve the list of Source Accounts.
General Ledger Source Codes
Although not required, it might be useful to setup a unique General Ledger Source Code for MicrOpay transactions that are imported into Sage Accpac ERP.
Batch Entries (ACCPAC/Sage 300)
General Ledger entries are created in General Ledger Integration, Transactions, Batch Process. To create the batch, enter the parameters and click Process. The batch is sent to ACCPAC using Transfer to Accounting.
Once transferred, a message will display in the window advising that the batch has been transferred to ACCPAC with the Batch Number.
Tip: The ACCPAC interface does not need to upload a file. Clicking Transfer to Accounting replaces the requirement to select Generate File.
ACCPAC MicrOpay Evo Interface
Sage 300 (Accpac) Requirements
Sage 300 (Accpac ERP) Series and Modules
At least MicrOpay 7.1.1 SP1 B2 with Sage Accpac ERP integration is compatible with the 100, 200, 300 and 500 series of Sage Accpac ERP. (Formerly Accpac Advantage Small Business, Corporate, and Enterprise Series respectively.)
System Manager version 5.2a or higher, and General Ledger 5.2a or higher are required irrespective of which Sage Accpac ERP series is being used.
Sage Accpac ERP version information can be found by selecting Help/System Information menu in Accpac
Sage Accpac ERP Security
If security is enabled in Sage Accpac ERP, the Accpac user ID used to create journals through MicrOpay Evo, must have a user group assigned to them for General Ledger that gives them access to Journal Entry in General
Ledger:
This is the minimum security level required for Sage Accpac ERP. More access can be given if required. Integration will fail if Journal Entry access is not given.
