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

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)

Receipt

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 23.11.2.1119

Please refer to the screenshots below.

Qty owned

Qty on hand

1 Like

If those Sales Invoices are linked to Sales Order then those sales invoices won’t have an impact on Qty on hand.

So the question is why do you use Sales Orders and not Delivery Notes ? I mean you can but then you can’t track Qty on hand, Qty to order etc. Only Qty owned.

Have a look at this guide on Qty on hand.

https://www.manager.io/inventory-items#qtyonhand

Thanks @lubos

We use sales orders to capture orders (qty only) placed by the customers. Two different teams are responsible to take orders and issue invoices.

Once the rates are agreed and goods ready to be delivered, sales orders are converted to sales invoice. Sales invoice is generated at the same time as delivery of goods. Therefore we do not use delivery notes.

We want to use new feature of reorder qty.

Qty desired takes into account qty on hand only.

If the edit columns had two separate columns for qty desired where one is qty reorder less qty on hand and the other is qty reorder less qty owned, it can address our issue.