HOW TO MANAGE OVERSOLD STOCK
It is very important that the Dealership manage their oversold stock for a few reasons:
- To keep your inventory levels correct;
- Not allow oversold stock to get out of hand;
- It is dealt within a reasonable time; and
- If your dealership has integrated accounting package, the inventory values remain correct.
What is oversold stock?
- The dealership sells a part on a Customer Order but Blackpurl indicates there is actually no stock on hand.
- When overselling stock, the user would have indicated to Blackpurl that they were forcing an oversold situation when creating the Customer Order and adding that particular line item.
- The status of the line item will now be oversold.
- It may be caused when a Vendor Receiving hasn't been started and/or finalised;
- A user may have sold the wrong part (ie sold a large instead of a small etc) and not noticed; or
- Dealership may have just "found" a part and has sold it without writing it into stock first.
It is also very important that all Oversold stock are investigated as to how it became to be oversold and are fixed accordingly. We would be recommending that you put a process in place on how your dealership deals with oversolds - for example: do they need to be signed off and managers advised etc
How to Find the Oversold Parts
Run a Recent Parts Report and then make a few changes:
- Click on to change the following parameters:
- Change Modified to Anytime - This will allow you to see all oversold parts.
- Click on and choose Oversold Qty
- then click on to update the search results
- Click on and add the column Overstock Qty > then click on
- This search result will now only list the oversold parts
- Click on if you want to print or export the search result.
How to Fix Oversold Parts
- Run the relevant report (see above)
- Investigate each oversold part as to why it is oversold
- To Fix:
2. Click or scroll to the D. Cost Tracking section
3. Review and Investigate where the item became oversold
4. Confirm the quantity that has been oversold
5. Click on
6. From the Actions Menu > Resolve Oversold
8. Review the Oversold Details section
9. Review the Resolved Details section - this is how Blackpurl will resolve the oversold
**If you have accounting integration, you can see what type of transaction and the value that will be integrated to
your accounting package.
10. Click on to confirm that you want to resolve the oversold.
**If you have accounting integration, it is at this point that the relevant transaction will integrate to your accounting package.
11. The oversold has been corrected on the Part record.
12. To see any previous oversold transactions, on the relevant Part record in the D. Cost Tracking section > click on >
14. The fix line item will then appear for review.
If your dealership has accounting integration, the Resolve Oversold action will create a transaction that integrated over to your accounting package to correct your inventory general ledger
For example we resolved oversold and this is the relevant journal:
- Debit - Adjustment General Ledger
- Credit - Inventory General Ledger
What General Ledger accounts the Resolve Oversold action will use is based on the following:
- Debit General Ledger
It would what is setup under Accounting Integration > Control Accounts - Inventory Adjustments
- Credit General Ledger - Inventory General Ledger
It is based on the category indicated on the relevant Part record and then what Inventory General Ledger is attached to that category