Introduction
Last updated
Last updated
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