Sage GL Consolidation Module Integrate with Navision & SAP

Question

My company is using Accpac system but the sister organisations are using Navision and SAP. To consolidate the GL transaction, we plan to develop the interface files which generated from Navision and SAP. However, Accpac GL Consolidation Import required control file which is encrypted. Anyone have any ideas how to create the control file? Impossible the accpac GL consolidation module not allow to integrate with other financial system.

Dana B. Stidsen · Accepted Answer

Importing into Accpac has been a standard feature for as long as I've supported it. 
 In this case you would be importing into the General Ledger. You create a new GL Batch, On the batch entry screen you select File > Import and the screen below opens that allows you to choose a file to import. That's it. 
 You should discuss this with your Sage Accpac business partner. They should be able to help you.

Dana B. Stidsen · Answer

The GL Consolidations Module in Accpac is designed to consolidate the GL's from multiple companies in Accpac. Why must Accpac be setup to integrate with other systems like SAP and Navision? Also, why isn't Navision and SAP designed to integrate with Accpac? 
 The GL Consolidations Module in Accpac uses the standard import processing in Accpac. That is, it exports data from several companies in Accpac and imports those files into the consolidated ledger using the included export/import processing function in Accpac. 
 If the files from the other systems are in the correct format (no control file needed) then the standard import function can be used to import those files.

Sage 300

Sage GL Consolidation Module Integrate with Navision & SAP

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING