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