Connect Your Acumatica and STACK Account

STACK's integration with Acumatica allows you to quickly transfer various data between the platforms so you can take full advantage of all the tools and features each platform offers and streamline your workflow.

To connect your Acumatica and STACK accounts, you'll need to:

  • Download the STACK Customization Package and install it in Acumatica.

  • Connect Acumatica to STACK.

  • Configure Acumatica in STACK.

Once you complete the connection process (instructions below), you'll be able to use the integration to import/export data between STACK and Acumatica.

TIP
 It is important to set up certain areas of your STACK account and enter certain data in a very specific way to ensure data is exported and mapped to the appropriate data points in each platform. See Best Practices to Use Acumatica with STACK for info on how to do this.

Before You Begin

Before connecting Acumatica to STACK, ensure that:

  • Acumatica 2023 or newer is installed.
  • The latest STACK Customization Package has been downloaded.
  • Customizer role is available in Acumatica.
  • Permission to access Account Settings is available in STACK.
  • Access to the Acumatica projects that will be imported into STACK has been granted.

Key Information

  • The integration is an add-on to your STACK subscription.

  • Only one Acumatica account can be connected to a STACK account.

  • The CRM module is not required.


Download and Install STACK Customization Package

Before you can connect your Acumatica and STACK accounts, you must download the STACK Customization Package and install it in Acumatica.

The instructions below are based on a standard/out-of-the-box version of Acumatica. The process and screens may differ based on the version of Acumatica you're using and the level of customization you have implemented.

NOTE
You must have a Customizer role in Acumatica to install the STACK Customization Package.

  1. Click the link below to download the latest STACK Customization Package:

    1. Download the STACK Customization Package for Acumatica 2025 and newer versions.
      Existing connections continue to work with their current customization package. To use the latest integration features, upgrade the customization package in Acumatica after downloading the latest version.

      When a new customization package is released, first upgrade the package in Acumatica. After the upgrade is complete, click Refresh in the About this Integration section in STACK to update the package version.

      The STACK Customization Package is downloaded and saved to the device's Downloads folder.

  2. In Acumatica, go to the Customization Projects screen (Screenid=204505).

  3. Click IMPORT on the top toolbar.

  4. Click the Choose File button on the Open Package dialog box that opens.

  5. Locate and select the STACK Customization Package zip file that you downloaded in step 1.

    TIP
     It should be in your Downloads folder.

  6. Click UPLOAD on the Open Package dialog box.

    The STACK Customization Package will now be listed on the Customization Projects list.

  7. Check the box to the far left of STACK Customization Package.

  8. Click PUBLISH on the top toolbar.

  9. Click the Publish button on the Compilation dialog box that opens.

  10. When you see the message that it has published successfully, click the Close Compilation pane button on the Compilation dialog box.
    The STACK Customization Package will be marked as published on the Customization Projects list and the Web Service Endpoints page will list STACK.

You can now follow the instructions to Connect Acumatica to STACK.


Connect Acumatica to STACK

Make sure you have downloaded the STACK Customization Package and installed it in Acumatica before proceeding. 

Log in to the Acumatica account from which you want to import/export data to STACK.

Acumatica can be connected from either of the following locations in STACK:

  • Account Settings > App Integrations
  • Estimate Worksheet > More Options > Export > Set Up a New Connection

NOTE
The Acumatica account user must have permissions/access to the projects you want to import.

Create a Connected Application in Acumatica

  1. Click More Items on the left menu.

  2. Scroll to the Configuration section and click Integration.

  3. Under Preferences, click Connected Applications.

    TIP
    You may need to click Show All to expand the list to see Connected Applications.

  4. Enter the Client Name (STACK).

  5. Make sure the Active checkbox is selected.

  6. Click on the Flow dropdown and select Authorization Code

  7. Set the Refresh Tokens settings.

    1. Set Mode to Sliding Expiration.
      For more information on sliding expiration, see Acumatica's help article.

    2. Set Absolute Lifetime to Infinite or as long as you plan to use the integration. (You will need to reconnect after this time period.)

    3. Set the Sliding Lifetime. Generally, 15 - 30 days works well.

  8. Click the Save icon at the top left of the toolbar. (The Client ID field will autofill.)

  9. Copy and save the Client ID. You will need to enter this in STACK.

  10. Click ADD SHARED SECRET.

  11. Enter the Description (STACK).

    NOTE
    If you choose to enter an expiration date, you will have to repeat this process to connect your Acumatica and STACK accounts when that date arrives.

  12. Copy and save the Value. This is the Client Secret you will need to enter in STACK.

    NOTE
    You must copy and save before moving to the next step. You will NOT be able to see the Secret Value after you click OK. 

  13. Click OK.

  14. Click the Save icon at the top left of the toolbar.

  15. Click the REDIRECT URIS tab.

  16. Click the + icon.

  17. Type https://go.stackct.com/OAuth/Callback in the Redirect URI field.

  18. Click the Save icon at the top left of the toolbar.

    Settings Dropdown_Acct Settings marked

  19. You are now finished in Acumatica.

Connect Acumatica to STACK

  1. Continue in STACK

  2. Open the App Integrations page using one of the following methods:

    Account Settings > App Integrations
    App Integration Connection 2.png

  3. Estimate Worksheet > More Options > Export > Set Up a New Connection
    Connection Setup 2.png

  4. Locate the Acumatica tile and click Connect.

    TIP
    Use the Search bar to quickly locate the Acumatica integration.

  1. When STACK uses Agave to connect your data appears, click Continue.

  2. Enter the required connection information.

  3. Enter the URL of your Acumatica instance in the Full Acumatica URL field.
    E.g., https://acme.myacumatica.com or https://acumatica.my-company.com

    NOTE
    The URL should not contain any characters after ".com".

  4. Enter the name of your Acumatica instance in the Instance Name field.

  5. Enter the Client ID saved in step 9.

  6. Enter the Client Secret saved in step 12.

  7. Click CONTINUE.

  8. Click Yes, Allow on the Agave permissions screen.
    If the connection is successful, the Agave screen will close.

    You can now move to the steps to Configure Acumatica in STACK.


Configure Acumatica in STACK

Configure the integration to map STACK Cost Types to Acumatica Account Groups and Acumatica User Defined Fields (UDFs) to STACK Tags. These mappings are used when exporting data between Acumatica and STACK.

You only need to do this process once, unless you want to change your selections or you add/edit Cost Types in STACK.

  1. In STACK, click the Settings icon (person with gear) at the right of the main navigation toolbar.

  2. Select Account Settings from the dropdown menu.

  3. Click App Integrations at the left of your screen.

  4. Locate the Acumatica tile and click Configure.

    TIP
    You can use the Search... bar so you don't have to scroll through every integration to find it.

  5. (Optional) If you want to be able to map your STACK Tags to an Acumatica User Defined Field during export, click on the Acumatica User Defined Fields section of the Configure Acumatica dialog box.
    STACK currently supports user-defined fields (UDFs) from these Acumatica screens:

    1. Project Quote(Screen PM304500)|
      To find in Acumatica:

      1. Go to the Estimation tab

      2. Scroll to the Products grid

    2. Sales Quote (Screen CR304500)
      To find in Acumatica:

      1. Go to the Details tab

      2. Scroll to the Products grid
        Make sure your UDFs are added to these sections in Acumatica. STACK will retrieve these values so you can easily map them to a STACK Tag or Label during export.

  6. Click on the Projects Quotes tab or Sales Quotes tab to add the fields that will be available for that type of export.

  7. Click +Add User Defined Field from Acumatica.

  8. Click in the Choose Acumatica Field cell and select the desired Acumatica field ID.

  9. Click in the Type Field Name and enter a name for the field.

  10. Click the associated toggle to determine if the field will be Required or Optional at the time of export.*
    *If needed, repeat steps 5-10 to add additional User Defined Fields from Acumatica.

    TIP
    If you need to remove an Acumatica field that you've added in STACK, just click the Trash icon next to it to delete it.

  11. Click on the Map STACK Cost Types to Acumatica Account Groups section of the Configure Acumatica dialog box.

  12. For each of the STACK Cost Types listed, click in the corresponding Acumatica Expense Account Group cell and Acumatica Revenue Account Group and select the Acumatica Account Group to which you want that STACK Cost Type data mapped when data is transferred from STACK to Acumatica.

    NOTE
     If your Acumatica account does not use the Account Group module, you will not need to make these selections. Instead you will see a message that no Account Groups were found.* Proceed to step 

    *If you see the message and your account DOES use Account Groups in Acumatica, click Try Again to try and pull your Account Group options into STACK to make your selections.

  13. Configure the Additional Settings:
    Skip Cost Assignment for 0$ Line Items: (Optional) By default, when line items that have a $0 cost in STACK are exported to Acumatica, the $0 value is sent to Acumatica and the Acumatica cost is set to $0. If you do not want the value sent and the Acumatica cost automatically set to $0 for these line items, click on the Additional Settings section of the Configure Acumatica dialog and check the Skip Cost Assignment for $0 Line Items box.
    Order Created Line Items: (Optional) When selected, allow users to export their estimate data to Acumatica using the same sort order they set up in their STACK Estimate Worksheet—including the order of takeoffs and the items inside assemblies.

  14. Click Save.

Anyone in your STACK account with the necessary role/permissions can now import/export project data between Acumatica and STACK.

TIP
See Best Practices to Use Acumatica with STACK for instructions on how to enter data in STACK to ensure successful exports.   


Update the STACK Customization Package

You may occasionally need to update your STACK Customization Package. If you need to update the package, you will receive a warning message when using one of the Acumatica features in STACK - E.g., The version of your customization package is not supported. Please update your customization package.

If you receive the warning, simply follow the instructions below, then you can proceed using the Acumatica features in STACK again.

  1. In STACK, click the Settings icon and select Account Settings.

  2. Click App Integrations.

  3. Locate the Acumatica tile and click Configure.

    TIP
    You can use the Search... bar so you don't have to scroll through every integration to find it.

  4. Go to the About this Integration section.

  5. If needed, download the latest customization package.

  6. After upgrading the package in Acumatica, click Refresh.
    The Customization Package version is updated and the message above the Refresh button displays You are currently up to date.


Disconnect Acumatica from STACK

If you ever need to disconnect your STACK and Acumatica accounts, you can do so by following the instructions below.

Once you disconnect Acumatica from STACK, you will no longer be able to export data between the two platforms. However, data that has already been exported will still be available.

Configure Button marked.jpg

  1. In STACK, click the Settings icon (person with gear) at the right of the main navigation toolbar.

  2. Select Account Settings from the dropdown menu.

  3. Click App Integrations at the left of your screen.

  4. Locate the Acumatica tile and click Configure.

  5. Click the Disconnect Acumatica button.

  6. Click the red Disconnect Acumatica button to confirm.

TIP
If you want to reconnect your accounts, you can follow the instructions above to Connect Acumatica to STACK


Related Articles

Create a Project from an External Source
Export Item Quantities to Acumatica
Export Estimate Worksheet Data to Acumatica


See how others use this feature in the STACK Community.

If you need additional assistance, please Contact Us.

Was this article helpful?
0 out of 0 found this helpful

Comments

Please sign in to leave a comment.