Settlements Deduction Types Export Details

What You Should Know About Settlement Deduction Data Integration

• Ditat TMS will request an updated Chart of Accounts and Item List from QuickBooks before each sync.

• Ditat TMS does not retrieve vendor information from QuickBooks — it only creates and updates vendors.

• Before exporting, Ditat TMS checks whether a vendor with the same Accounting ID already exists in QuickBooks. If it does, the vendor record will be updated with any new information. If it does not, a new Vendor will be created using the Accounting ID as the vendor name.

• Ditat TMS checks whether a Vendor Bill with the same reference number already exists in QuickBooks. If it does, the bill will not be exported.

• If a duplicate Vendor Credit is found in QuickBooks, Ditat TMS will mark it as exported and log a warning in the export report.

• Ditat TMS only exports certain fields to QuickBooks (see below). All other fields in QuickBooks can be modified independently and will not be affected by the export.

• Transaction numbers are sent in the format ST-[Settlement Number]-[Sequence]. For example, ST-65-27 indicates Settlement 65, transaction 27.

Fields Exported to QuickBooks

Header Data

Detail Data