Exact Integration

PLANERGY enables you to integrate with Exact for easy synchronization of your financial data between the two platforms, including importing charts of accounts, setting up budgets and user spending limits, and accessing real-time accruals and spending information. 

The integration allows you to import suppliers, general ledger codes, terms, taxes, cost units as cost codes, and cost centers as departments from Exact for efficient management of the procurement processes. Invoices authorized in PLANERGY can be exported to Exact as purchase invoices, with relevant supplier, tax, cost units, cost centers, and item details ready to be processed for payment.  

The PLANERGY – Exact integration lets you control, track, manage, and report on spending efficiently from any device anywhere, ensuring the automation of the process and compliant purchasing.


How Data Is Mapped Between PLANERGY and Exact

Data mapping between PLANERGY and Exact is outlined in the table below.

PLANERGY Exact
GL Code G/L Accounts 
Suppliers Suppliers 
Terms Payment Condition
Tax  VAT codes 
Cost Code Cost Units 
Department Cost Centre

 


How to Integrate PLANERGY with Exact

You can integrate Exact with PLANERGY for efficient management of the procurement process by following the steps below.

Enabling Exact Integration

To enable the Exact integration in PLANERGY, follow the steps below.

    1. Press the Control Panel on the Home page.The Control Panel page is displayed.
    2. Press Integrations under Advanced Controls. The Control Panel > Integrations page is displayed.
    3. Press Setup in the row of Exact. The Control Panel > Exact Settings page is displayed.  

You can now connect Exact with PLANERGY.
For more information, refer to Connecting Exact with PLANERGY.

Connecting Exact with PLANERGY

To connect Exact with PLANERGY, follow the steps below.

  1. Press Connect to Exact on the Control Panel > Exact Settings page.

    Note

    It is important to ensure you have the same company codes in PLANERGY and Exact to connect the two systems.
    The Exact login screen is displayed.
  2. Enter your Exact username in the Username field.
  3. Press Next one. The Login dialog to enter the password is displayed.
  1. Enter the password in the space provided.

 

  1. Press Login. The successful Exact – PLANERGY connection notification is displayed.

Synchronizing Exact with PLANERGY

Once the connection is established, synchronize the companies in PLANERGY with those in Exact by following the steps below.

  1. Press Synchronize with Exact. The companies synchronized with Exact are displayed.

 


How to Import Data from Exact

After configuring the integration and synchronizing the companies between PLANERGY and Exact, you can import the data from Exact to PLANERGY to map data, set up budgets, and control user spending limits, item cataloging, approval routing, and vendor management. 

Note

  • You should ensure a proper connection is established between PLANERGY and Exact and that the companies are synchronized in the two platforms before importing data.  For more connection information, refer to How to Integrate PLANERGY with Exact.
  • You should imperatively know how data mapping works with integration before importing data.  For more information, refer to How Data is Mapped Between PLANERGY and Exact.

You have three options for importing data from Exact to PLANERGY, each of which is further detailed below.

Import All Exact Data Manually

To import all data, follow the steps below.

  1. Press the Control Panel on the Home page. The Control Panel page is displayed.
  2. Press Exact Settings under Advanced Controls. The Control Panel > Exact Settings page is displayed.  
  1. Press Import All Data on the Control Panel > Exact Settings page. The import process is initiated. You will see a confirmation message on the screen.
  1. When the import process completes you will receive confirmation notifications. This includes updates on what data was imported and any relevant errors.

    Note

    Standard notifications will be sent to you by email but you can configure your notification settings. Read Notification Settings to learn how to change your notification settings.

If there are any errors during the import process, they can be reviewed by clicking on the To see the details of this import click here link in the email.  This will open the Integration History – Details page.

Import Individual Exact Data Sets Manually

You can import and update a single data set from Exact before exporting invoices from PLANERGY. This option is useful when you have added a specific piece of data in Exact that you want to incorporate in PLANERGY quickly.

In the following illustration, we are importing Cost Codes from Exact. You can similarly download other datasets.

  1. Press the Control Panel on the Home page.The Control Panel page is displayed.
  2. Press Cost Codes under Finance Functions.The Control Panel > Cost Codes page is displayed.
  3. Select the associated company from the Company dropdown list.
  4. Press Import From Exact. The import process is initiated. You will see a confirmation message on the screen.

    Note

    The Import From Exact button is visible to you only if the Exact integration is enabled in PLANERGY and is properly connected to Exact.
  5. When the import process completes, you will receive a confirmation notification.  This includes updates on what data was imported and any relevant errors.

Schedule Automated Imports of All Exact Data

When you regularly update Exact data and want to ensure data is regularly synced to PLANERGY, scheduling automated imports of all Exact Data is the best option. 

To set up scheduled imports, you should contact the support team and they will help get these in place for you. Here is How to create a support ticket.


How to Export an Invoice

You can create and export an invoice to Exact once the general ledger codes, taxes, departments, charges to accounts, and suppliers are successfully imported from Exact.

You have three options for exporting data from PLANERGY to Exact d which are as follows:

Note

  • An invoice cannot be exported more than once to Exact.  A notification message is displayed if you attempt to export an already exported invoice.
  • Exported invoices will be marked as posted and cannot be re-exported. Additionally, the date of export will be tracked.

Exporting Individual Invoices to Exact Manually

To export an invoice to Exact from PLANERGY, follow these simple steps.

  1. Navigate to Accounts Payable > Your Invoices and press Authorized.The Authorized Invoices page is displayed.
  2. Press anywhere in the invoice row you wish to export to Exact. The View Invoice page is displayed.
  3. Press Export to Exact.The invoice will be exported and you will see a confirmation message on screen.

The invoice is exported to Exact.

Note

  • You will be notified if any Supplier/General Ledger Code/Term/Tax has not been previously imported to  Exact or if any other general errors are generated by Exact.
  • You will be notified each time an invoice is successfully exported to Exact.
  • An invoice can be successfully exported to Exact only once and if you attempt to export it again, you will receive a notification alerting you about the same.
  • The exported invoice will be marked as posted and the date of export will be tracked to avoid repetition of exporting it again to Exact.

Exporting All Invoices with the Status ‘Authorized, Not Posted’ To Exact

To export invoices with the status ‘Authorized, Not Posted’ to Exact from PLANERGY, follow the steps below.

    1. On the Accounts Payable Home page, press Reports & Searches in the left sidebar menu.
    2. Press Invoice Search. The Invoice Search page is displayed.
    3. Click Advanced Search. The Advanced Search section is displayed.
    4. Press Export to Exact to export data in bulk.

      Note

      You can use the search filters to export only specific invoices.  For example, invoices for a specific company only can be filtered and exported. The export process is initiated.  You will see a confirmation message on the screen.
    5. When the export process completes, you will receive standard notifications by email but you can configure your notification settings. This includes updates on what data was exported and any relevant errors.
      For more information regarding how to change your notification settings, refer to Notification Settings.

Automate Export of Authorized Invoices 

When you want to get invoices to Exact as fast as possible while reducing manual steps, an Account Owner can set invoices to export automatically as soon as they have been authorized. 

    1. Press the Control Panel on the Home page.The Control Panel page is displayed.
    2. Press Advanced Account Settings under Advanced Controls.The Control Panel > Advanced Account Settings page is displayed.
    3. Scroll down the page to the Purchase Settings section.
    4. Enable the button Automatically Push After Invoice Authorization?
    5. Scroll down and press Save. The Settings saved successfully notification is displayed.

Note

It may take up to 5 minutes to apply the changes and update your account.

How to View Integration Import History

You can view the import history of the individual objects by pressing Integration Import History in their respective sections.  

In the following example, we are showing you the integration import history of Suppliers.  You can similarly view the integration import history of Taxes, General Ledgers, Departments, and Cost Codes.

  1. Press the Control Panel on the Home page. The Control Panel page is displayed.
  2. Press Suppliers under Catalogue. The Control Panel > Suppliers page is displayed.
  3. Click Integration Import History. The Suppliers > Integration Import History page is displayed.The Integration Import History page provides you with a detailed record of all the imports from Exact for the specified object.

How to Disconnect from Exact?

You can temporarily disconnect from Exact when you want to stop the integration with your PLANERGY account and restore the connection anytime you need to.

To disconnect from Exact, follow the steps given below.

  1. Navigate to Control Panel >  Advanced Controls > Exact Settings. The Exact Settings page is displayed.
  2. Click DisconnectThe Exact successful disconnection notification is displayed and the Connect to Exact button is visible.

 


How to Disable an Integration?

You can disable the Exact connection permanently by removing the existing connection.  If you want to connect again, you need to go through the complete process of integration from scratch.

  1.   Navigate to Control Panel > Advanced Controls > Integrations. The Integrations Settings page is displayed. 
  2. Click the Disable button in the row of the Exact integration. The integration is disabled, and the button changes to Setup.
Updated on December 2, 2024
Was this article helpful?

Related Articles