Managing Inventory in ConnectWise > Advanced Setup Option


Many partners who use Inventory are aware of some of the nuances on the way that ConnectWise Handles Inventory. Wise-Sync has developed some proprietary ways of managing the inventory flow, based on some settings that you can define in Wise-Sync Setup for each company that you are syncing out to.


These options include:

  1. Drop-Ship Inventory Posting Override

    This option will force all Drop-Shipped inventory through a designated Asset Account, to ensure that the Cost of Sale is reported together with the Revenue. Traditionally ConnectWise will record the Cost of Sale of a Drop-Shipped Item at the time of receipt into ConnectWise, as this is not defined as a "Warehoused Item". Wise-Sync will provide the option to pass all Drop Shipped items through an asset account that you define in the setup settings in Wise-Sync.

  2. Inventory Part / Class Compliance

    ConnectWise will only account for Inventory if the following conditions are true. a) That the Inventory is a "Inventory" class product item, and b) That the Product Type as defined in the TypeXRef is set to "Inventory Part". Several balancing issues can occur if both of these settings are not set correctly. Wise-Sync will provide for the flexibility to treat all items of an Inventory Part based on a compliance level as defined in the article below.

Part 1: Drop-Ship Inventory Posting Override


Drop Ship Inventory Override:

Items that are drop shipped may still need to be treated as inventory to ensure that revenue correctly aligns to Cost of Goods Sold (COGS) based on the timing of the purchase and sale of Drop Ship. Partners that wish to defer the "COGS" to the time of sale can set the option to post Drop Shipped Items to an Inventory (Asset) account and treat them in the same manner as all Inventory Items. 


Note: It is recommended that you set the Account to different (or exclusive) account for the purpose of Drop Shipped items. This will assist in the tracing / tracking of items which have been drop shipped separately to those items held in your Warehouse Inventory Accounts.

Part 2: Inventory Part / Class Compliance Options:


When processing Inventory Transactions, Wise-Sync can be configured to check the settings of the parts which can affect Inventory in ConnectWise.


Product Type : Inventory Part


Product Class : Inventory


Drop Ship: True / False



Setting Wise-Sync to either of the following compliance options will determine when Wise-Sync will check the various settings in ConnectWise used to define an Inventory Transaction. To ensure strict or less strict compliance against the products settings in ConnectWise.


Options Settings in Wise-Sync

[Set Compliance Screenshot]


Inventory Transaction Posting ConnectWise Item Compliance:

  1. Product Class (Inventory) + Product Type (Inventory Part) *
  2. Product Class (Inventory)
  3. Product Type (Inventory Part)


1. Product Class (Inventory) + Product Type (Inventory Part)


When set, Wise-Sync will only process transactions where the conditions match. I.e. That the Product Class = 'Inventory', and the Product Part Type is an 'Inventory Part'. Where both of these conditions are not met; a Transaction will NOT be posted through to your accounting package.


2Product Class (Inventory) 


When set, Wise-Sync will only process transactions where the condition matches. I.e. That the Product Class = 'Inventory'. Where a product type is not set to a "Inventory Part" type, then a warning will display advising that the item should be reviewed in ConnectWise; a Transaction WILL be posted through to your accounting package.

3Product Type (Inventory) 


When set, Wise-Sync will only process transactions where the condition matches. I.e. That the Product Type = 'Inventory Part'. Where a product Class is not set to a "Inventory" class, then a warning will display advising that the item should be reviewed in ConnectWise; a Transaction WILL be posted through to your accounting package.

As you can see from the above options, the settings range from "Strict" compliance in option 1: through to less strict compliance on whether the item is classified as Inventory in ConnectWise.



Drop Ship Inventory Override:

Items that are drop shipped may still need to be treated as inventory to ensure that revenue correctly aligns to Cost of Goods Sold (COGS) based on the timing of the purchase and sale of Drop Ship. Partners that wish to defer the "COGS" to the time of sale can set the option to post Drop Shipped Items to an Inventory (Asset) account and treat them in the same manner as all Inventory Items. 


Note: It is recommended that you set the Account to different (or exclusive) account for the purpose of Drop Shipped items. This will assist in the tracing / tracking of items which have been drop shipped separately to those items held in your Warehouse Inventory Accounts.