Added "Qty available", "Qty to be available" and "Qty to order" columns to “Inventory Items”

The latest version (23.10.21) is enhancing columns under Inventory Items further.

The following new columns have been added:

Qty available

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.

Qty desired

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:


This is excellent @lubos

appreciated :+1: @lubos

Brilliant I have been doing this using Custom Fields and Excel for ages.

1 Like

A post was split to a new topic: Internal error when selecting Inventory Items columns

really like your effort but for your info it do not working properly

@Ahmed_Alhawy, if you are going to claim something is not working, please follow forum rules by:

  • Explaining what you think is not working
  • Illustrating with screen shots.

A post was split to a new topic: Internal Error when drilling down Inventory Items

@lubos The much awaited requirement of REORDER QTY is finally there. Thanks :+1: for this useful feature

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

1 Like

@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.

1 Like

I’m a little confused about this feature, but I’m interested in implementing it in my business.

I hope someone can explain step by step how to record purchases,
should I record a Purchase Quote - Purchase Order - Good Receipt - Purchase Invoice for each purchase? and how to book a Debit Note?

Likewise with sales and sales returns, what is the standard process that I have to carry out?

Thank You…

Start by reading all the Guides about those transaction types.

Of course I started from the guide.

I would like to know if anyone has used this feature and it works perfectly. I would like to know what kind of procedures they use. and maybe I can apply it in my business.

How about trying? I will definitely do it, while I have two months before starting to use the Application Manager for my business

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.

1 Like

I’m only forcing to use sales orders if you want to track Qty to deliver. That’s all.

If you do not want or do not need to track Qty to deliver, then you don’t need to use sales orders.

1 Like

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.

1 Like

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 :slight_smile:

Qty desired takes into account the qty on hand
Any idea why Qty on hand doesn’t take into account the sales invoices?
FYI, I do not use delivery notes
I am using Cloud version

Please refer to the screenshots below.

Qty owned

Qty on hand

1 Like