Inventory Management #2

Problem

Handling Inventory
Part 2 of 2-- entering materials into inventory, withdrawing from inventory, getting list of inventory items from MacNail accounting software

Diagnosis

When you purchase materials that will be stored in inventory, follow these steps:
1. Open the Material Log.
2. Scroll down to the first blank line.
3. Enter information just as you would if it were being used on a jobsite, but use Inventory as the jobsite.

Solution

When you take materials out of inventory and use them on a jobsite, follow these steps:

1. Open the Material Log.
2. Scroll down to the first blank line.
3. Enter information just as you would if it were purchased from a supplier, but use Inventory as the supplier. This step will make sure the materials are job costed to the correct job.
4. Duplicate the previous line transferring materials from inventory to a jobsite, but change the quantity to a negative number, and change the jobsite to Inventory. This step will remove the items from inventory, and make sure they are not expensed twice in MacNail construction accounting software.

To see all the inventory transactions entered into the Material Log, follow these steps:
1. Enter the Inventory job number into the Query Box.
2. Choose Extract Special from the Data menu. A list of all inventory transactions will be created.

Comments

HINT-- Goldenseal accounting software has much better inventory tracking!

Entered 6/8/95 by Randy. Updated 11/8/2010.