Greytrix is considered an integration specialist. We have developed a good number of integrations of Sage Intacct with various 3rd party software, Treez being one of them efficiently integrated with Sage Intacct.
We want to walk you through one of its functionality, the Integration Configuration of the GUMU™ for Treez – Sage Intacct Integration. At the same time, the subsequent coming up blogs would elaborate more on how this Integration works.
If I need to specify what this Integration does, in elementary words, it carries the sales and refund transactions from Treez POS into Sage Intacct as a General Ledger transaction.
How does this data Integration work?
We follow the import methodology to integrate the data from Treez to Sage Intacct. However, while doing so, we need to ensure that the critical entity of General Ledger is GL accounts used in the Integration should be pre-existing in Sage Intacct. As for the amounts of Sales, Refund, Discount, Tax, and Payment will be retrieved from Treez and grouped based on ticket number, wherein each ticket in Treez represents the Sale or Refund transaction. Based on these entries, we understand that the summarized GL entries get created within Sage Intacct .
Let’s go through the significance of the “Integration Configuration Screen”. We have explained above that all these amounts (Sales, Refund, Discount, Tax, and Payment) carry to Sage Intacct as GL Entries; thus, we need to know the accounts to map for each entry type.
The above explanation will help one understand the significance of the screen, which allows one to define maps and make the Integration smoother. You can refer to the images below to get an idea of it.
| Field | Description |
| Payment account | Specify Payment account. Total amount will be display in the Debit. |
| Discount account | Specify discount account. Discount amount will be display in the Debit. |
| Journal | Select desired Journal to which entries will be added. |
| Sales account | Specify Sales account. Amount of this account will be display in credit. |
| Sales Tax account | Specify tax account. Tax account will be display in credit. |
| Rounding account | Specify Rounding account. Any rounding differences are tagged to a different GL accounts for reconciliation purpose. |
| Cash Refund account | Specify Cash Refund account. Amount of this account will be display in credit. |
| Discount Refund account | Specify Discount Refund account. Amount of this account will be display in credit. |
| Sales Refund account | Specify Sales Refund account. Amount of this account will be display in credit. |
| Sales Tax Refund account | Specify Sales Tax Refund account. Amount of this account will be display in credit. |
| Location | Specify the location dimension. Here you have to select default Location id. |
| Department | Specify the department dimension. Here you have to select default Location id |
| CustomerID | Specify the Customer dimension (A generic Customer needs to be setup in Sage Intacct which will represent transactions from particular client/store from Treez.) |
| State | Draft or Posted. Specify the stage of journal entries posted in Sage Intacct |
You can see all these account entries generated under Journal Entries (GJ) as shown in the below image for Sales and Refund entries.
This how Integration Configuration screen is used to map sales, refund, discount, tax and payment values from Treez POS into Sage Intacct.
About Us
Greytrix – a globally recognized and one of the oldest Sage Development Partner is a one-stop solution provider for Sage ERP and Sage CRM organizational needs. Being acknowledged and rewarded for multi-man years of experience and expertise, we bring complete end-to-end assistance for your technical consultations, product customizations, data migration, system integrations, third party add-on development and implementation competence.
Greytrix has a wide product range for Sage Intacct- a Cloud ERP. This includes migrations from QuickBooks | Sage 50 | Sage 100 | Sage 300 to Sage Intacct. Our unique GUMU™ integrations include Sage Intacct for Sage CRM | Salesforce | FTP/SFTP | Rev.io | Checkbook | Dynamics 365 CRM | Magento | Rent Manager | Treez | Avalara Avatax | Blackline SFTP. We also offer best-in-class Sage Intacct Development Services, Consulting services, integrated apps like POS | WMS | Payroll | Shipping System | Business Intelligence | eCommerce for Sage Intacct to Sage business partners, resellers, and Sage PSG worldwide. Greytrix constantly develops apps, products, and add-ons to enhance user experience. Sage Intacct add-ons include AR Lockbox File Processing.
Greytrix GUMU™ integration for Sage CRM – Sage Intacct, Sales Commission App for Sage Intacct, and Checkbook.io ACH/Digital Check Payments for Sage powered by GUMU™ are listed on Sage Intacct Marketplace.
The GUMU™ Cloud framework by Greytrix forms the backbone of cloud integrations that are managed in real-time for the processing and execution of application programs at the click of a button.
For more information on Sage Business Cloud Services, please contact us at sagecloud@greytrix.com. We will like to hear from you.