Introduction
This guide outlines Sage Intacct - Treez Integration and provides systematic instructions to install and configure Treez GL Entry and Sage Intacct integration. Treez is added as a connector and will be available to set up integration with Sage Intacct. Note: For testing purposes, integration is setup with our development sandbox.
Treez is the enterprise seed to sale & cannabis retail software platform powering dispensaries and cultivators.
We have incorporated Treez as a connector in our GUMU™ cloud. With phase I; we are just importing summarized GL entries in Sage Intacct against Sales, Refund, discount, tax, and payment entries from Treez
For Sales, Sales Refund, Discount, and Discount Refund we are tagging the item dimension and showing it as individual entries by product type
We kept separate GL account to put rounding differences
We are tagging the customer id dimension from the GUMU™ configuration in Sage Intacct on each line
We have verified the Sales and Sales Refund records from Treez Sales Report.
For getting the required details from Treez we have utilized the Treez Ticket APIs and fetched the record based on the last updated date field of the Ticket record. Since we are not getting the cost-related fields from API’s we haven’t included the same to create GL Entries.
Field Mapping Below are the field mapping of Sage Intacct GL Entry fields with API fields:-
Sage Intacct | API |
Journal | Configuration |
Posting Date | last_updated_at |
Description | 1. Sales: GL Entry for Sales Ticket record 2. Refund: GL Entry for Refund Ticket record |
Reference Number | Batch for Update date - last_updated_at |
Entries | |
Accounts | Payment Account, Discount Account, Sales Account, Sales Tax account, Rounding Account, City of Chico Tax Account , CA Excise Tax Account, Cash Account, AERO Payment Account, Credit Card Payment Account. |
Doc | order_number |
Debit (Sales) | Total, Disc, Rounding |
Credit (Sales) | Tax, Subtotal, Rounding |
Debit (Refund) | Tax, Subtotal, Rounding |
Credit (Refund) | Total, Disc, Rounding |
Memo | ticket_id |
Location | Configuration |
Department | Configuration |
CustomerID | Configuration |
ItemID | Product_Type |
Filter Fields Below are the filters we have included to get the tickets records:-
Field | Expression | Field |
Last synch date | >= | last_updated_at |
order_status | = | Completed |
payment_status | = | Paid, Refunded |
Total | <> | 0 |
Last updated