The latest version (23.10.21) is enhancing columns under Inventory Items further.
The following new columns have been added:
Qty available indicates the stock that is physically available for new sales or use. It’s calculated by subtracting Qty to deliver from Qty on hand. Essentially, it shows the inventory on hand minus the quantity that is already committed to open Sales Orders.
The real value of Qty available column becomes evident when a business has regular sales orders and there’s a time gap between order placement and delivery. It helps in understanding how much of the stock on hand is already committed and how much is free for fresh sales or uses.
Qty to be available
This column gives a forward-looking perspective of stock levels. It sums up the current available quantity Qty available with the quantity expected to be received from open Purchase Orders (Qty to receive). In essence, it predicts the amount of stock that will be available once all outstanding purchase orders are fulfilled.
It’s a column but it’s also a field on Inventory Item form where you can set up your Reorder Point.
Qty to order
It shows the quantity that needs to be ordered (or manufactured) to maintain the desired quantity. It’s calculated as: Qty desired - Qty to be available.
You can view full guides and how these columns all work together here:
Thanks so much this has very much been awaited. My idea is on colour now. if it is possible we can have the qty owned in red once it is less than the qty deisred. and the qty to order in Red too. i thank it will make it more visible
@lubos The obsolete “Quantity to deliver” column displayed the amount to be delivered to customers (customers in the customer tab, not the walk-in customers) after a receipt had been generated. This was particularly beneficial for a business that received payments from remote customers for their orders, as it allowed them to track the quantity to be delivered to those customers all within the context of payments received in advance. Importantly, this method circumvented the necessity of issuing invoices. However, the new “Quantity to Deliver” column in the inventory tab no longer considers customer receipts. As a result, this change will increase their workload, as they now need to use a “Sales Order” to record the quantity to be delivered and then create a separate “Receipt” to document the received payment and then finally create an invoice to mark the Sales Order completed.
Nonetheless, the quantity to be delivered is still visible in the Customer tab. To maintain consistency, the new “Quantity to Deliver” column in the Inventory Items tab should also consider receipts from Customers registered in the Customer Tab. The same principle should apply to the “Quantity to Receive” for payments (If inventory item movement is being tracked)
That’s fine in theory but if you have a lot of transactions, it falls apart because if there is discrepancy, it’s sometime impossible to reconcile because you are faced with full ledger of all receipts and delivery notes from the beginning of times. Sometime you pay for item A and receive item B. When you realize there is an issue with quantities, it’s like finding needle in a haystack.
That’s why I insist on using Sales Orders to track deliveries. You divide this full ledger into separate “units of work” and if something does not reconcile, it’s a matter of finding open sales order.
My view is that Receipts are really for when you get paid and dispatch goods at the same time. If there is a time gap between when money is received and when delivery of goods is made, businesses will have to use Sales Orders to group these related transactions together.
If business does not want to use Sales Invoices, it’s perfectly fine. You can use Sales Orders just to track Qty to deliver. Under Sales Orders tab you can use Edit column button to disable columns related to invoicing.
Obviously the workflow can be simplified further by it needs to be in logical way.
I am not sure if this is right, why issue a receipt against a Sales Invoice, that would be unnecessary then. Invoices are not about receipts and payments but record the sales or purchase. Forcing the use of Sales orders when managing inventory is not common and may bring order to some of the issues that were raised around inventory quantities and the related status but maybe you could adopt approaches that Point of Sales systems have been using that often mainly depend on Sales invoices and not even have the possibility of Sales orders.
The business uses Sales Invoices, permitting select customers to make purchases on credit, allowing them a grace period to clear their debt. These transactions necessitate the issuance of invoices.
Could we explore the implementation of a “Copy To” feature between Sales Orders and Receipts? This functionality would enable users to seamlessly generate Sales Orders from Receipts and vice versa.
Your consideration of this request is appreciated, as it aligns with the common practice of using advance payments as order confirmation in many businesses, including this one. It also makes the use of the Sales Order tab more attractive.
I support this request, but would like to see the automatic Sales Order creation at time of invoicing and receipt. Many business that sell in shop and online or online only invoice and get paid in advance. Often these goods may be tracked through post/courier systems but not always. Meanwhile many online shops show quantity in stock in real time. As soon as the customer finished the transaction the QTY available changes well before it ever was delivered. The current implementation is an improvement but very much from a bricks and mortar point of view where payments follow delivery and not of the ever increasing online sales and transations point where payments are made well before delivery. There must be a better way