When the Unit Cost of an item has incorrect margins, profit and average cost can be drastically affected. If the Unit Costs needs to be edited, you can do so in the sale or by adjusting the inventory information for the item. It is recommend that an Asset report be exported on a monthly basis to keep yourself aware of discrepancies or changes.
Using a report such as Margins Per Line, any unusual margins can be easily detected. Navigate to a sale by clicking on the blue Sale ID then navigate to the Lines section.
In the section titled Inventory Lines, the Inventory ID 470 will show all transactions that will be affected by changing the Unit Cost. Not only will the change affect this past transaction it will also adjust the Unit Cost of any remaining stock from the same lot.
In the image above, the FIFO Cost (First In, First Out) is what the Unit Cost currently is for this item. To adjust the cost click on the Inventory ID or the FIFO cost.
To view the details of a particular lot of units, you can:
- Click on an Inventory ID in the History tab of the item or
- Click on its Unit Cost or the Inventory ID in the Inventory Lines of a specific sale
From here, you can edit the cost of the units in this particular lot:
- Cost/Unit: Cost for each unit in the lot
- Qty In: How many units were added in this lot
- Qty On Hand: How many units from this lot remain
- Qty Out: How many units have left from this lot
- Adjustments: Number of units manually removed
Instances where the inventory was changed can be seen in the following sections:
- Inventory Transactions: All transactions with units from this lot
- Inventory Adjustments: Log of each adjustment
Lightspeed highly recommends exporting your Asset report on a monthly basis. The Asset report will give you information on all your current assets. This report will also help to identify any potential issues with your inventory by correcting any abnormal margins, costs or prices. Exporting this report on a regular basis will allow you to easily look back at your inventory over time.