Sage GL Consolidation Module Integrate with Navision & SAP

SOLVED

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. 

  • 0
    SUGGESTED

    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. 

  • 0 in reply to Dana B. Stidsen

    Dana, thanks for your reply. Then, how Accpac GL consolidation standard import function can import the files from the other systems which are in the correct format and no control file needed. Import function always required control file. In the setup, I can't find an option to turn it off .

  • +1 in reply to EdwinH
    verified 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.