This article will explain the Category Type: Vendor Product - Step 7F



Category Type - Vendor Product 


This type of Category is assigned to Sublets / Warranty Plans and Deal Options that are used in Blackpurl


If you are unsure what a sublet is, please review this article - What is a Sublet / How to Setup a Sublet


This Vendor Product Category is setup as follows:



Let's discuss what these fields are:


A.  Type - this is where you would select Vendor Product 


B.  Name - Just the name of this Vendor Product Type Category 


C.  Income GL - This is the Income General Ledger account where the income from selling a Vendor 

Product will integrate to, in your accounting package


D.  COGS GL  - This is the COGS General Ledger account where the income from selling a Vendor Product 

will integrate to, in your accounting package


E.  Inventory GL - While we never keep a running inventory value for Vendor Products, we do indicate an 

Accrual General Ledger account that is used as a clearing account to make sure that all Vendor Products are accounted for. You would need to indicate a liability General Account which would be a true clearing account




How to use this Vendor Product Category


This Vendor: Smith & Co has a few sublets setup and they have been assigned the Vendor Product Category of Sublet Sales 



This means that when one of the Vendor: Smith & Co Sublets are processed in Blackpurl then there will be several transaction that will integrate from Blackpurl to your accounting package.  Examples are:

  • when a VR (Vendor receiving) for a sublet is processed - a journal transaction will integrate from Blackpurl to your accounting package 
  • when a VI (Vendor invoicing) for a sublet is processed - a Vendor Invoice document will integrate from Blackpurl to your accounting package 
  • when a Customer Order is finalised and it has a Sublet - a journal transaction will integrate from Blackpurl to your accounting package

How these transactions integrate to your accounting package and what General Ledger accounts they integrate to is set by what has been setup on the relevant Vendor Product Category


When a VR for a sublet is processed in Blackpurl, a journal integrates to your accounting package as:

Debit - BP Sublet Accrual General Ledger - as what is setup on the relevant Vendor Product Category for the Inventory GL field 

Credit - Received Inventory Accrual General Ledger.  It will remain in this clearing account until the VI is processed

Here is an example:

When the VI for a Sublet is processed in Blackpurl, a transaction will integrate to your accounting package as: 

The Vendor Invoice document will be created with the offset General Ledger being your Received Inventory Accrual General Ledger  


Received Inventory Accrual General Ledger  

This will then balance out your Received Inventory Accrual General Ledger for the VR and VI transactions

 BP Sublet Accrual General Ledger / Income / COGS entries

  • Left over from the VR journal, there is still an amount sitting in the BP Sublet accrual waiting for the relevant Sublet to be invoiced out through the Customer Order in Blackpurl
  • Once the Customer Invoice in Blackpurl is finalised, the invoice will integrate over to your accounting package:


The Customer Invoice document will be created in your accounting package with the offset General Ledger being your Income General Ledger (as per the General Ledger indicated in the Income GL field on the relevant Vendor Product Category) 

 

  • A journal will also integrated that will clear the BP Sublet Accrual General Ledger and the offset will be to the COGS General Ledger (as per the General Ledger indicated in the COGS GL field on the relevant Vendor Product Category) 

 


This transaction has now balanced out the VR transaction to BP Sublet Accrual General Ledger for that relevant Sublet 


**Warranty Plans and Deal Products will also be assigned with a Category Type: Vendor Product

We would suggest that you setup new Categories for Warranty Plans and Deal Products with the relevant General Ledgers