Please check the controlling of updating backorders
One basic way is to create a spreadsheet with various columns for product name, item number, and quantity.You can have a column to deduct what you sell and ship.It requires continuous manual monitoring to ensure every transaction is accounted for.The information is difficult to share, and another huge pitfall is human error.If your needs are very predictable, you can use a fixed quantity control system.With this method, every time you place an order, whether it’s weekly, monthly, semi-monthly, your order will be for the same amount.But Apple has an amazing track record for getting those orders to their customers on-time. Let’s take a look at the logistics problem: When you get a sales order, there might be one or several items that are out of stock. Just create a new purchase order for that one item, and inform the customer when the backordered item will arrive.
It will also help you get a better, more real-time understanding of what’s selling and what isn’t.
If you don’t have a good handle on your inventory you’ll never have a true account for how your business is doing. Don’t let inventory excess or shortages become your downfall.