4.5. Inventory Management Systems

Streamline integrates with various accounting and inventory management systems. Each integration has a built-in connection in Streamline that imports all the necessary data to make forecasts and create replenishment plans.

There are two types of integrations: unidirectional and bidirectional. The difference is that the bidirectional integration allows exporting the recommended replenishment orders (POs, TOs, MOs) back to the system.

Almost all integrations are bi-directional except for Shopify connection.

The table below shows the imported and exported data for each of the systems.

Integrated system	Import								Export
	Item info	Sales history	On-hand history	Orders to ship	Orders to receive	BOM	Batches	Promotions	Purchase order	Transfer order	Manufact. order
Cin7							N/A	N/A
DEAR							N/A	N/A
Dynamics NAV							N/A	N/A
Dynamics GP							N/A	N/A			N/A
Dynamics 365 BC								N/A
Exact Online								N/A
Fishbowl
Oracle NetSuite								N/A
Odoo							N/A	N/A
QuickBooks Desktop							N/A	N/A		N/A
QuickBooks Online			N/A			N/A	N/A	N/A		N/A	N/A
SAP Business One								N/A
SellerCloud			N/A			N/A	N/A	N/A		N/A	N/A
Shopify			N/A	N/A		N/A	N/A	N/A	N/A	N/A	N/A
Skubana			N/A			N/A	N/A	N/A			N/A
Pronto							N/A	N/A
Spire							N/A	N/A
Unleashed			N/A					N/A

The table consists of four sections:

• Imported – shows data chunks that is imported into Streamline.
• Exported – contains the exported information.

The Imported section is divided into the following subsections based on the data type:

• Item info – contains static information about the planning item.

• Sales history – sales transactions representing what (item), where (location), when (sale date), how much (quantity sold/returned), and by what means (sales channel) was sold/returned.

• On-hand history – transactions representing all your inventory movements, e.g. sales, purchases, transfers between locations, manufacture orders, stock adjustments, sale/purchase returns, write-offs, and others.

• Orders to ship – describes items that are going to leave the system or are to be shipped.

• Orders to receive – describes items that are going to enter the system or are to be received.

• Bill of materials – describes receipts containing components of finished goods.

• Batches – describes data required to account for a product expiration date when generating replenishment recommendations.

• Promotions – describes data allowing Streamline to take into account future promotions when it generates the forecasts.

Next: Cin7

Download PDF