Dear Systems

The data from Dear Systems can be imported in just a few clicks into Lokad thanks to a native integration that leverages the Dear Systems API. In this page, we detail how to make the most of this native Dear Systems integration.

Setup of the Lokad/Dear Systems data connector

The suggested process to connect your Lokad and Dear Systems accounts is the following:

The last step will redirect you to your Lokad account, where the project DearSystems data source will have been created.

Two remarks:

Annex: Tables reference

Lokad retrieves extensive data from Dear Systems which include:

All data are aggregated per product and per warehouse. They are pushed to your Lokad account into the following files:

On Lokad’s side, the information about purchase orders has to be extracted from 2 files (DearSystems_PurchaseOrderLines, DearSystems_Purchases), that about sales orders from 4 (DearSystems_SaleOrderLines.tsv, DearSystems_SaleItems.tsv, DearSystems_Sales.tsv, DearSystems_SaleOrders.tsv). See later for more details about the tables fields.

Additional information can be found at the Dear Systems’s support page.

DearSystems_AdvancedPurchase.tsv

DearSystems_AdvancedPurchasePutAway.tsv

DearSystems_AdvancedPurchaseStocks.tsv

DearSystems_AttributeSets.tsv

DearSystems_BOMProducts.tsv

DearSystems_BOMServices.tsv

DearSystems_Customers.tsv

DearSystems_FinishedGood.tsv

DearSystems_ProductAvailabilities.tsv

DearSystems_ProductCategories.tsv

DearSystems_ProductFamilies.tsv

DearSystems_ProductFamilyAttachments.tsv

DearSystems_ProductFamilyLines.tsv

DearSystems_ProductMovements.tsv

DearSystems_Products.tsv

DearSystems_ProductSuppliers.tsv

DearSystems_PurchaseOrderAdditionalCharges.tsv

DearSystems_PurchaseOrderLines.tsv

This is the basic table about purchase orders. Additional information can be imported from DearSystems_Purchases.tsv

DearSystems_PurchaseOrders.tsv

DearSystems_Purchases.tsv

DearSystems_PurchaseStocks.tsv

DearSystems_SaleOrderAdditionalCharges.tsv

DearSystems_SaleOrderLines.tsv

This is the basic table about sale orders. Additional information can be imported from DearSystems_SaleOrders.tsv and DearSystems_SaleItems.tsv.

DearSystems_SaleOrders.tsv

DearSystems_SaleItems.tsv

DearSystems_Sales.tsv

DearSystems_StockAdjustmentExisting.tsv

DearSystems_StockAdjustmentNew.tsv

DearSystems_StockAdjustments.tsv

DearSystems_StockAdjustmentTransaction.tsv

DearSystems_StockTakeExisting.tsv

DearSystems_StockTakeNew.tsv

DearSystems_StockTakes.tsv

DearSystems_StockTakeTransaction.tsv

DearSystems_StockTransferLines.tsv

DearSystems_StockTransfers.tsv

DearSystems_SupplierAddresses.tsv

DearSystems_SupplierContacts.tsv

DearSystems_Suppliers.tsv

DearSystems_UnitsOfMeasure.tsv