Sage Intacct
Before starting, please ensure the following pre-requisites are completed in Sage Intacct
Sage Intacct
Sender ID Web service authorization
Why this is needed? Sender ID is a token used for web services call made by GUMU™ integrations, Sage Intacct provides this Sender ID to development partner to enable successful calling of web services from external application. This Sender ID needs to be authorized by the client in their Sage Intacct company which will be used in the integration.
Important Note: This is a mandatory Setting.
How it is done? Web services should be authorized in Sage Intacct for the integration to execute correctly, to achieve this follow the steps mentioned below
Click on the link mentioned below https://www.intacct.com/ia/acct/login
Login into Sage Intacct Company using Company ID, User ID, Password.
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252Fy6igtH7smsy3io6vhSxZ%252Fimage.png%3Falt%3Dmedia%26token%3D57273ee0-bdcb-4bc9-a655-d51eceb25ed7&width=768&dpr=4&quality=100&sign=683ee6d2&sv=1)
3. Add Web Service Authorizations for Sender id – ajax How it is done? Navigation path - Company > Company Information > Security tab. Scroll down to the Web Services authorizations section set the following fields: a. Add Sender ID – ajax b. Status – Active.
4. Add web service authorization for Sender id – GreytrixMPP. Greytrix will provide this sender ID. User needs to provide access to this sender id in their company as it is an important part of the security rights for the integration. How it is done? Navigation path - Company > Company Information > Security tab. Scroll down to the Web Services authorizations section set the following fields. a. Add Sender ID – GreytrixMPP b. Status – Active.
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FfDLMIeWmWq714rmMfVR5%252Fimage.png%3Falt%3Dmedia%26token%3D88367952-373b-4615-9595-db693be1aa93&width=768&dpr=4&quality=100&sign=4fa1c94d&sv=1)
Create Web service user
Why this is needed? Create a new web service user in Sage Intacct. This user will be used in the integration setting in GUMU configuration for making all Web service API calls in Sage Intacct.
Important Note: This is a mandatory Setting.
How to create a new web service user? Navigation Path - Company > Admin > Web Services users
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FTglFXXk91FvpOPTLM3Be%252Fimage.png%3Falt%3Dmedia%26token%3Db693eaa8-7b54-4046-ac49-a9bc63aaafef&width=768&dpr=4&quality=100&sign=27360418&sv=1)
Click on the New button, enter the details.
User ID – xml_Integration
User type – Business
Admin privileges – Full
Status - Active
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FsmSzC6FdJakfjw7cJbSr%252Fimage.png%3Falt%3Dmedia%26token%3De0f7b927-b7e0-4c67-957d-13986a6aff8e&width=768&dpr=4&quality=100&sign=131704d&sv=1)
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FcISx7Xw3dpO3Ub2hGO92%252Fimage.png%3Falt%3Dmedia%26token%3D277f0f70-7871-4d78-886f-7f94cb5cd5af&width=768&dpr=4&quality=100&sign=af85614&sv=1)
GL Entity Mapping
When integrating Treez Ticket data into Sage Intacct, we map Treez product categories to GL Accounts in Sage Intacct. This configuration is set up on the GL Account Mappings screen.
Navigation for GL Account Mappings Screen : Journal Entries Imports --> GL Account Mappings --> GL Account Mappings
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252Fz9Gvd8FU2oFuRP3UkPFG%252FMicrosoftTeams-image%2520%2812%29.png%3Falt%3Dmedia%26token%3D61dd83dd-5bea-4f23-91d9-c75e3b9c0061&width=768&dpr=4&quality=100&sign=2e6c36a&sv=1)
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FZpWX1yMtFWMoOig1STbz%252FMicrosoftTeams-image%2520%2813%29.png%3Falt%3Dmedia%26token%3D0ba6145d-5db1-4031-9869-8ac7a1c3cf15&width=768&dpr=4&quality=100&sign=75a08322&sv=1)
o add the mentioned data, just click on "New GL Account Mapping"
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FLqAKihAEdic4FOM6O1IF%252FMicrosoftTeams-image%2520%2815%29.png%3Falt%3Dmedia%26token%3Ddf2ef918-e073-4895-a5f9-e9c90f0a4c9b&width=768&dpr=4&quality=100&sign=453d3034&sv=1)
Bulk data can also be imported using Following Import template. You can input your data in the template format provided below and then import the file to bring in your data.
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FQxBCwsrSX4ZwJOU9FdRU%252FMicrosoftTeams-image%2520%2816%29.png%3Falt%3Dmedia%26token%3D93d605ee-352f-41db-b35b-e92822fc9011&width=768&dpr=4&quality=100&sign=dc2f97f4&sv=1)
Each Field Description as follows:
Entity : Sage Intacct Entity ID
Source_GL : Product Category from Treez sales Ticket
Source_GL_Description : Treez sales Ticket discription (it is an optional field)
Target_GL : Sage Intacct GL Account ID
Target_GL_Description : Description of Sage Intacct GL Account (it is an optional field)
After entering all the data which have mentioned above go to following screen to import data.
File format should be always .CSV
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FZi6aS7BP33AJ7r8AZtFo%252FMicrosoftTeams-image%2520%2814%29.png%3Falt%3Dmedia%26token%3Dbf287245-9a48-465b-894c-80cf27bc7bde&width=768&dpr=4&quality=100&sign=a414800a&sv=1)
After clicking on the Import button, you'll be directed to the following screen. Choose the file with the .csv format, select "Online" as the import mode, and then click on Next.
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FNC93wiJqnVVAsBcsVD31%252FMicrosoftTeams-image%2520%2818%29.png%3Falt%3Dmedia%26token%3D624bf329-18f9-4741-b194-e7895bb7a856&width=768&dpr=4&quality=100&sign=20ac64f1&sv=1)
After clicking on Next button you will see below screen. Here, we need to set mappings as shown in below screen. After that if you want to save same mappings for future reference click on "save map" button.
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FezHODArM11rX3lzqn9ti%252FMicrosoftTeams-image%2520%2819%29.png%3Falt%3Dmedia%26token%3Dbb20f469-a344-4342-930d-00a8d0c01847&width=768&dpr=4&quality=100&sign=62635197&sv=1)
After click on Save Map button below screen will appear, enter name of map and click on Save button.
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FSlPPGPH6epTTEnUnW6HT%252FMicrosoftTeams-image%2520%2820%29.png%3Falt%3Dmedia%26token%3Deab71506-e2d1-4b31-ab85-4508f70b27d5&width=768&dpr=4&quality=100&sign=16ae41ce&sv=1)
After that click on import button on same screen as shown below
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252FrKcM1A1bPH1dtaZUVgn8%252Fimage.png%3Falt%3Dmedia%26token%3D5137d161-f2fc-4d0a-9aaf-b10b9d78e042&width=768&dpr=4&quality=100&sign=cb2e16af&sv=1)
After click on import button following screen will appear and your data will be imported successfully in sage intacct.
![](https://docs.greytrix.com/~gitbook/image?url=https%3A%2F%2F794987320-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252F-MCRVg-TYx3gVa2Tqtf_%252Fuploads%252F4jaXgA8w64HxiwXsMeGU%252FMicrosoftTeams-image%2520%2822%29.png%3Falt%3Dmedia%26token%3D084782f3-2605-4a77-8d79-bc2d5a160b8f&width=768&dpr=4&quality=100&sign=f7803f72&sv=1)
Last updated