This article will explain the Category Type: Sublet - Step 7F
Category Type - Sublets
This type of Category is assigned to Sublets 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
You would also use this Category Type for Warranty Plans and Deal Options but in this article we are covering off Sublets:
This Sublet Category is setup as follows:
Let's discuss what these fields are:
Name - Just the name of this Sublet Type Category
Income GL - This is the Income General Ledger account where the income from selling a Sublet will integrate to, in your accounting package
COGS GL - This is the COGS General Ledger account where the income from selling a Sublet will integrate to, in your accounting package
Inventory GL - While we never keep a running inventory value for Sublets, we do indicate an Sublet Accrual General Ledger account that is used as a clearing account to make sure that all Sublets are accounted for. You would need to indicate a liability General Account which would be a true clearing account
How to use this Sublet Category
This Vendor: Smith & Co has a few sublets setup and they have been assigned the Sublet Category: 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 Sublet 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 Sublet 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 Sublet 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 Sublet 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: Sublet. We would suggest that you setup new Categories for Warranty Plans and Deal Products with the relevant General Ledgers