Mark Stock Items as Consumables

Go to: Main menu > Maintenance module > Maintenance menu > Database Maintenance > Stock Maintenance > Mark Stock Items as Consumables.

This routine will mark the nominated stock records in an analysis group as consumable products.

It will automatically create a stock adjustment removing the stock onhand amount from the stock record.

• If the stock on hand is a positive amount, the stock adjustment journal will decrease your stock control account by the value of the stock on hand and increase your Cost of Sales account by the same amount.
• If the stock on hand is a negative amount, the stock adjustment journal will increase your stock control account by the value of the stock on hand and decrease your Cost of Sales account by the same amount.

Note: Depending on the size of the stock adjustment, this may cause an increase or decrease in your Cost of Sales in the month that you turn stock products into consumables. Therefore, this may then result in a higher or lower profit figure for the month.

If you wish to use your consumables for automatic reordering you will need to stocktake your consumables in order to enter the correct stock onhand amounts.

You can choose to attach a particular purchase or expense general ledger account to each stock item.

You can also choose to allow VisionVPM to:

• calculate the Pack Cost from the last supplier invoice.
• apply $1.00 to the Pack Cost, if there are no previous supplier invoices on the stock record.

The following message will be displayed when you run the procedure:

1. Click Yes to the above message and the following window will be displayed:

   

2. Click the Selected Analysis Group arrow to select the Analysis Group which contains the stock records that you wish to mark as consumables.
3. Optional items:
   1. Click the Change the purchase group to arrow and double-click to attach a purchase or an expense general ledger account.
   2. Select the Calculate the cost from the purchase activity for items without a cost check box.
   3. Select the Calculate the cost as $1 if there is no purchase activity check box.

   If you choose to leave the last two fields blank, the Pack Cost will remain as it was prior to running this procedure.

4. Click OK.

   VisionVPM will:

   • run through every stock item in the selected analysis group,
   • mark them as consumables,
   • remove any stock on hand,
   • apply any of the optional items you have selected.

   You can display a list of your consumable stock records by going to Main menu > Stock module > Reports menu > Stock List > select Consumable > OK.