Please allow sales order to reduce inventory qty on hold

we are Australian based retail shop and we import from different countries
some time customer give us order in advance pay deposit and we store in our warehouse
physical stock is there but it has been sold out so if someone check the balance qty it should show available qty after all hold qty so we wont runout for paid customers

this would help us to plan our import orders as well so we can check which one sold out and we can order more of that

could you please allow this feature added in existing system please please

i know sales order has not effect currently but sales order made to plan inventory so please consider this and give update please


Would using Managers inventory location capability help? Sold and paid for items could be transferred to a suitably named virtual location.

Why wouldn’t you issue an invoice for the products that are sold and apply the deposit to the invoice. The invoice itself will deduct from inventory and show the balance due.

This situation calls for sales invoices when items are sold and delivery notes when delivered. There are reasons to consider obligating inventory when committed to a sales order, but this is not one of them.

1 Like

if i issue invoice i have to pay tax same qtr.
some times customer require goods in 4 to 6 months time

you know better in australia we report GST every qtr. and if we issue Tax Invoice then we have to pay that GST to ATO hence customer hasnt paid us full amount
customer pay full amount when they require materials and then we issue TAX invoice.
we issue sales order to confirm their purchase. but my staff check qty available and they might sale to someone else as well so if you could provide way to reflect the hold items and balance should show after all deductions.

means i have 100 sqm of Concrete tiles
john came to my shop and he ordered 30sqm but he needs in july
Paul came and order same tile 40 sqm but he needs in September

so we gave them sales order and took token amount to hold qty - (for deposit account receivable is perfect in manager)

when my staff check qty of concrete tile then it should show 70sqm on hold and 30sqm available.

what can we do to implement this in manager software please

It would be good if Manager could “quarantine” inventory items that are on sales orders.

However, a workaround solution was suggested in the second post of this thread.

That is, create a location called, say, “Layby” or “On Order” and complete an “Inventory Transfer” to transfer the stock relating to the “delayed delivery orders” to this location.

Physical separation of this stock would also probably be a good idea by having a separate area in your warehouse where this “On Order” stock is stored.

Out of interest, why would you not order the tiles for Paul from your supplier and have them delivered in september?

Or is the order delivery delay very long?

Holding stock in reserve for customers is an expense and may result in foregoing sales to another customer

It would be completely wrong to use invoice for this situation. An invoice is issued for services or goods already delivered to demand for payment.

In some countries issuing invoice calls for effecting withholding tax and paying to tax authorities. Issuing invoice also calls for GST or VAT.

Also an order is not revenue an order is a step towards securing revenue, an issued invoice registers revenue which will affect corporate tax.

This feature will only help to manage inventory better and see the level of inventory really needed at all times. The work flow is Quotes to Orders to invoice to delivery notes.

The reason why an inventory location won’t be appropriate to manage this situation is that, the location won’t have any effect on how inventory balances are reported in the inventory tab.

What the user needs is a column in th inventory tab showing inventory reserved for orders going out (different from quantity to deliver which is generated with an invoice)
A column or a simple report that would show sales orders presented customer wise and supplierwise in the case of purchase orders would be very useful in managing inventory.

Thank you very much for perfect explanation @Abeiku

Developers please look into this and have this implemented please please

@lubos please consider this request

Not necessarily. The invoice makes demand for payment according to the terms of sale. @letap said in post #1, “… it has been sold out ….” If the goods have been sold, an invoice can be appropriate, whether the goods have been delivered or not. My original comment was based on that statement.

@letap’s more recent posts suggest that perhaps the goods described have not really been sold. That is a different situation and goes back to the notion of sales orders obligating inventory. That has been in the Ideas category for almost two years. See Finding items that are on sales orders.

In my first post i said sold means let me explain my business
I have tile shop i import in good quantity like one design and size 600 sqm and stock in warehouse now
Customer give order in advance and pay deposit when they start building their house but paul require 90sqm and john require 150sqm but when their house is finish they take delivery and pay the full amount
Lay by
I have been using manager desktop from 2014 to 2017 and i liked software
Then i moved to another software but we really not comfortable like manager now from july we are going to get cloud version of manager but if you could do this sales order feature then we would be happy and other thing we know how to manage

So, @letap, the question is whether Paul and John are obligated to take delivery when they place their orders and make a deposit. If so, those are sales; sales invoices are appropriate, although the due dates could be many months in the future when delivery of the tile is planned. As I first mentioned, this is when using delivery orders would probably be helpful.

If Paul and John are not really obligated to take delivery, then no sales have occurred. Then you are down to deciding whether to hold inventory as a courtesy, hoping they will actually purchase it. In that case, there are no accounting transactions except the deposits, which can be held in their accounts against possible future sales. You need to manage the inventory by segregating it somehow. Ideas have already been shared.

Of course, there are GST and income tax considerations to all of this. So you need to consider the full impact and costs of either approach: selling inventory without being paid (and therefore having the carrying costs, tax liabilities, etc.) or stocking inventory you will not sell because you have reserved it for someone who might not actually buy it. Neither is a particularly attractive choice. Understand that in the second option, receipt of a deposit becomes an unrelated transaction.

You can now if you follow @generalegend suggestion: