Inventory - Option that tracked inventory not update until after Bill due date
Add the option on Bills to allow businesses to make Tracked Inventory available upon creation of Bill, or unavailable until the Due Date (or available date) of the Bill has passed.
This new option would help businesses manage available inventory when selling products with long production lead-times, so they do not sell inventory that is not yet available despite it being in the system in a future dated Bill.
Additionally, it would be beneficial if Sales Invoices could access the Tracked Inventory from the future dated Bill if the date of the invoice was after the due date (or available date) of the Bill, thus, allowing businesses to create future dated Sales Invoices that need to access Tracked Inventory from future dated Bills.
Hi [Customer Name] ✨, Thanks for taking the time to share this feedback with us, and for explaining the impact this has on your workflow. With tracked inventory in Xero, future-dating a bill or invoice doesn’t delay the inventory movement. Once a tracked inventory bill or invoice is approved, the inventory updates straight away, even if the document date is set in the future. This is how tracked inventory is designed to work in Xero, and the best way to manage future stock is to use the document status and purchasing flow that matches where the stock is in real life:
- if stock has been ordered but not received yet, create a purchase order to record what is on order
- if the supplier bill has been received but the goods haven’t arrived yet, save the bill as a draft or awaiting approval until the stock is received
- once the goods arrive, approve the bill so the stock is added to tracked inventory at that point
- if only part of the order has arrived, create a bill for the supplied items and leave the purchase order open for the remaining items This gives you visibility of stock on order, while ensuring tracked inventory reflects stock that is actually available.
If you need further clarification around this we recommend raising a case with our Support Team