Inventory On Hand accuracy is flawed
There are two flaws in lightspeed that prevent inventory on hand from being accurate.
1) Layaways are not handled consistently. When a layaway is created, inventory will be deducted if it exists. If there is no inventory, then inventory does not get deducted. Even after a PO is received to create inventory, the system does not deduct for the layaway items that were not previously deducted. This inconsistent treatment makes it confusing about whether to include layaway items in the physical count or not. Then the person counting thinks that an adjustment is needed and makes a manual adjustment and then when the layaway is completed as a sale, it gets deducted again. The solution - all layaways should deduct from the inventory count even when it causes the count to go negative.
2) If we enter an item and mistakenly put it to layaway instead of special order, the inventory count is reduced. When we correct our mistake and move that line to special order, the inventory count is unaffected. We will create a purchase order to get more inventory in to cover it. Everything will work out when we eventually close the sale. The problem is, the inventory count is out of sync during that interim. When we take a physical count, we have no way to know that the adjustment was already made for a special order item. So, we mistakenly make a manual adjustment to get it back in sync. The solution - the deduction to inventory should be reversed when layaways are removed from layaway status. If done for everything, that still works for regular layaways because the inventory will then be deducted when the item is sold.