This article will explain the Category Type: Unit for Step 7H
Category Type - Unit
Every stocked Unit is required to have a Unit Category assigned to it. See below of an example of where the Category sits on a Unit Record:
The Unit Category is assigned to the Unit at the time of stocking ie Unit Ordering / Trade In etc
Here is an example of when Unit Ordering, assigning a Category:
It is this Unit Category that tells Blackpurl what General Ledgers it needs to use when the relevant accounting entries integrate from Blackpurl to your accounting package
Here is an a example of a Unit Category and that you will be required to indicate:
Name
simply the name of this category. In this example - the name of the category is New Unit
Income GL
when you sell a Unit that has this category, the income will integrate to this General Ledger
COGS GL
when you sell a Unit that has this category, the COGS will integrate to this General Ledger
Inventory GL
when you sell a Unit that has this category, the Inventory will integrate to this General Ledger
when you purchase a Unit that has this category, the Inventory will integrate to this General Ledger
Let's put this into practice:
- When you process a Unit Vendor Receiving, it will create a Vendor Invoice document that will integrate to your accounting package with the offset to be what General Ledger Account is indicated in the Inventory GL field on the Category attached to the Unit
Using the example of a Unit Category above, this would mean that when Unit Vendor Receiving, the Inventory value will debit GL1310- BP New Unit Inventory
- When a Unit is sold, they may be a few transaction (depending on what is on the Unit Deal ie Options etc). As an example we will use a basic sale of a unit for $4,395 and the customer did pay a deposit of $100 which was processed onto the relevant Customer Order
Transaction 1 - The Deposit transaction journal will be
Transaction Type | Num | Adj | Name | Memo/Description | Account # | Account | Debit | Credit |
Journal Entry | CODN-00000019 | No |
| CODN-00000019;Jaxon Price Park;CO-0000090;Cash;Deposit |
| Undeposited Funds | 100.00 |
|
|
| No |
| CODN-00000019;Jaxon Price;CO-0000090;Cash;Deposit | 1010 | 1010 BP Customer Deposits |
| 100.00 |
Line 1 – is as per your Accounting Integration for Undeposited Funds under that relevant payment type you used ie Cash
Line 2 – is as per your Accounting Integration for Customer Deposits
* The Deposit is held in the Customer Deposit GL until it is used
* Until you bank the $ and then allocate the payment in the bank to Undeposited GL – it will remain there
Transaction 2 - The customer pays the balance of the Customer Order by Cash for $4295. The journal is
Transaction Type | Num | Adj | Name | Memo/Description | Account # | Account | Debit | Credit |
Journal Entry | COIP-00000100 | No |
| COIP-00000100;Jaxon Price;CO-0000090;Cash;Payment |
| Undeposited Funds | 4,295.00 |
|
|
| No |
| COIP-00000100;Jaxon Price;CO-0000090;Cash;Payment | 1010 | 1010 BP Customer Deposits |
| 4,295.00 |
Line 1 – is as per your Accounting Integration for Undeposited Funds under that relevant payment type you used ie Cash
Line 2 – is as per your setup in your Accounting Integration for Customer Deposits
* The funds are held in the Customer Deposit GL until it is used
* Until you bank the $ and then allocate the payment in the bank to Undeposited GL – it will remain there
Transaction 3 and Transaction 4 - You are finalising the Invoice and checking out
Transaction Type | Num | Adj | Name | Memo/Description | Account # | Account | Debit | Credit |
Sales Receipt | INV-00000080 | No | Jaxon Price CTM-0000073 |
| 1010 | 1010 BP Customer Deposits | 4,395.00 |
|
|
| No |
| 2022 Truck; SKU-00103;50ZBE1212NN028974 | 4100 | 4100 BP New Unit Sales |
| 4,395.00 |
Line 1 – You are now using the Customer Deposit $$ so it must clear out of the relevant General Ledger for the full amount $100 + $4,295 = $4395
Line 2 – You have sold the unit so the income is going into your income GL (as per the Income GL indicated in the Category attached to the Unit)
Journal Entry | INV-00000080 | No |
| Jaxon Price;CO-0000090;Costing;SKU-00103;50ZBE1212NN028974;Base cost; 1.00@3215.00 | 1310 | 1310 BP New Unit Inventory |
| 3,215.00 |
|
| No |
| Jaxon Price;CO-0000090;Costing;SKU-00103;50ZBE1212NN028974;Base cost; 1.00@3215.00 | 5100 | 5100 BP New Unit COGS | 3,215.00 |
|
Line 1 – You have sold the unit so the value of the unit must come out of your Inventory GL (as per the Inventory GL indicated in the Category attached to the Unit)
Line 2 – You have sold the unit so the cost value of the unit must be allocated to COGS GL (as per the COGS GL indicated in the Category attached to the Unit )