Try ERPNext Buy Support Partners Foundation

Stock not reducing when the Sales Order is generated

When I generated order, my stock on POS should reduce so that I know how much is left that I need to sell more

The stock reduces only when delivery note is generated

Why is the flow like this?



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/333e1786-6f2f-481f-b950-305f9717b320%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Stock either reduces based on Sales Invoice with update stock checked, or Delivery Note. Order is just a promise of a Sale / Delivery, but not the actual deed.

Thanks,
Anand Doshi.


On Thu, Jul 24, 2014 at 7:16 PM, Tahseen Jamal <ta...@gmail.com> wrote:
When I generated order, my stock on POS should reduce so that I know how much is left that I need to sell more


The stock reduces only when delivery note is generated

Why is the flow like this?



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/333e1786-6f2f-481f-b950-305f9717b320%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF1i9gm5z%3DdZ1a9XRCeFPyDVLGL42bLJyLs8Ok5__NFtxw%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Anand,

Let us consider Ebay, where the stock is blocked for me certain period when I order even when I have not paid. As in till I reach the payment gateway, the stock is blocked for me.

Like booking tickets on Yatra or Makemytrip, the seat is blocked while am filling details and moving towards payment


Need total stock to be shown on POS
Stock to reduce on order and again add up on cancelling an order
Delivery date to be shown on Order generation





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/18aadb53-7635-45da-8387-752642578374%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

When you book a Sales Order, “Reserved Qty” is increased for all items and if you can cel the order it’s decreased. You can get all the qty components like actual qty, reserved qty, ordered qty etc in “Stock -> Main Reports -> Stock Projected Qty” report.

But those reserved qty is just for reference, it does not tagged with any order. Hence, even if an item is reserved against a SO, it can be delivered via another SO.

We will implement actual blocking of reserved items while integrating payment gateway with ERPNext.

On Aug 11, 2014, at 11:26 AM, Tahseen Jamal <ta...@gmail.com> wrote:

Anand,

Let us consider Ebay, where the stock is blocked for me certain period when I order even when I have not paid. As in till I reach the payment gateway, the stock is blocked for me.

Like booking tickets on Yatra or Makemytrip, the seat is blocked while am filling details and moving towards payment


Need total stock to be shown on POS
Stock to reduce on order and again add up on cancelling an order
Delivery date to be shown on Order generation






You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/18aadb53-7635-45da-8387-752642578374%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/480AE8D6-C729-4378-A7DF-7C344C9900F2%40iwebnotes.com.

For more options, visit https://groups.google.com/d/optout.

Nabin,

We want Quantity blocking on Sales Order generation. We are willing to pay for this customisation. We don't need payment gateway





On Monday, 11 August 2014 17:44:51 UTC+5:30, Nabin Hait wrote:
When you book a Sales Order, “Reserved Qty” is increased for all items and if you can cel the order it’s decreased. You can get all the qty components like actual qty, reserved qty, ordered qty etc in “Stock -> Main Reports -> Stock Projected Qty” report.

But those reserved qty is just for reference, it does not tagged with any order. Hence, even if an item is reserved against a SO, it can be delivered via another SO.

We will implement actual blocking of reserved items while integrating payment gateway with ERPNext.

On Aug 11, 2014, at 11:26 AM, Tahseen Jamal <ta...@gmail.com> wrote:

Anand,

Let us consider Ebay, where the stock is blocked for me certain period when I order even when I have not paid. As in till I reach the payment gateway, the stock is blocked for me.

Like booking tickets on Yatra or Makemytrip, the seat is blocked while am filling details and moving towards payment


Need total stock to be shown on POS
Stock to reduce on order and again add up on cancelling an order
Delivery date to be shown on Order generation






You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/18aadb53-7635-45da-8387-752642578374%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/6dfbe59c-0710-4bbe-9114-bb58cb06f5a3%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.

Hi Tahseen,

We will take it up as a generic requirement. Here's the issue I've created on GitHub: https://github.com/frappe/erpnext/issues/2054

Thanks,
Anand.


On Tue, Aug 12, 2014 at 1:44 PM, Tahseen Jamal <ta...@gmail.com> wrote:
Nabin,

We want Quantity blocking on Sales Order generation. We are willing to pay for this customisation. We don't need payment gateway





On Monday, 11 August 2014 17:44:51 UTC+5:30, Nabin Hait wrote:
When you book a Sales Order, “Reserved Qty” is increased for all items and if you can cel the order it’s decreased. You can get all the qty components like actual qty, reserved qty, ordered qty etc in “Stock -> Main Reports -> Stock Projected Qty” report.


But those reserved qty is just for reference, it does not tagged with any order. Hence, even if an item is reserved against a SO, it can be delivered via another SO.

We will implement actual blocking of reserved items while integrating payment gateway with ERPNext.

On Aug 11, 2014, at 11:26 AM, Tahseen Jamal <ta...@gmail.com> wrote:

Anand,

Let us consider Ebay, where the stock is blocked for me certain period when I order even when I have not paid. As in till I reach the payment gateway, the stock is blocked for me.

Like booking tickets on Yatra or Makemytrip, the seat is blocked while am filling details and moving towards payment


Need total stock to be shown on POS

Stock to reduce on order and again add up on cancelling an order

Delivery date to be shown on Order generation






You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/18aadb53-7635-45da-8387-752642578374%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/6dfbe59c-0710-4bbe-9114-bb58cb06f5a3%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF2kgSiVmgfHtBOhqyJ-%2B%2B3H0fsb5PJcX2Wkk9m3hTt%3Dgg%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

@Tahseen,

Clarification: we will block the qty on "Submission" of Sales Order.

-Anand.


On Tue, Aug 12, 2014 at 2:10 PM, Anand Doshi <an...@erpnext.com> wrote:
Hi Tahseen,

We will take it up as a generic requirement. Here's the issue I've created on GitHub: https://github.com/frappe/erpnext/issues/2054

Thanks,
Anand.


On Tue, Aug 12, 2014 at 1:44 PM, Tahseen Jamal <ta...@gmail.com> wrote:
Nabin,

We want Quantity blocking on Sales Order generation. We are willing to pay for this customisation. We don't need payment gateway





On Monday, 11 August 2014 17:44:51 UTC+5:30, Nabin Hait wrote:
When you book a Sales Order, “Reserved Qty” is increased for all items and if you can cel the order it’s decreased. You can get all the qty components like actual qty, reserved qty, ordered qty etc in “Stock -> Main Reports -> Stock Projected Qty” report.


But those reserved qty is just for reference, it does not tagged with any order. Hence, even if an item is reserved against a SO, it can be delivered via another SO.

We will implement actual blocking of reserved items while integrating payment gateway with ERPNext.

On Aug 11, 2014, at 11:26 AM, Tahseen Jamal <ta...@gmail.com> wrote:

Anand,

Let us consider Ebay, where the stock is blocked for me certain period when I order even when I have not paid. As in till I reach the payment gateway, the stock is blocked for me.

Like booking tickets on Yatra or Makemytrip, the seat is blocked while am filling details and moving towards payment


Need total stock to be shown on POS

Stock to reduce on order and again add up on cancelling an order

Delivery date to be shown on Order generation







You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/18aadb53-7635-45da-8387-752642578374%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/6dfbe59c-0710-4bbe-9114-bb58cb06f5a3%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.





You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/CAAQzbF15vmgs%2BrtF14ZO9eSPb6wkOv7_3QaWe6fGy3MikcETVA%40mail.gmail.com.

For more options, visit https://groups.google.com/d/optout.

Anand / Nabin,

When can we look at this feature go live? Also

Sales Order should have a delivery date. Most of the Sales Order require a delivery date so that the client can agree and then ask us to raise invoice

And on POS, total stock for each item should be shown so that the sales person can sell as much as shown 



You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/51e28837-4f2e-4cad-aa0e-73501ce510a5%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.


On Aug 13, 2014, at 10:38 AM, Tahseen Jamal <ta...@gmail.com> wrote:

Anand / Nabin,

When can we look at this feature go live? Also

We can’t commit any date for the feature, but we will try to implement it asap.


Sales Order should have a delivery date. Most of the Sales Order require a delivery date so that the client can agree and then ask us to raise invoice

Sales Order already have “Expected Delivery Date” field.


And on POS, total stock for each item should be shown so that the sales person can sell as much as shown 

Will discuss with team




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/51e28837-4f2e-4cad-aa0e-73501ce510a5%40googlegroups.com.

For more options, visit https://groups.google.com/d/optout.




You received this message because you are subscribed to the Google Groups “ERPNext User’s Forum” group.

To unsubscribe from this group and stop receiving emails from it, send an email to erpnext-user-forum+un…@googlegroups.com.

To view this discussion on the web visit https://groups.google.com/d/msgid/erpnext-user-forum/AF94121E-B5FB-4667-894C-2A27938FB5EE%40iwebnotes.com.

For more options, visit https://groups.google.com/d/optout.

Hi, this is the only topic I found where it talks about the reserved stock of sales orders should block future sales.

As mentioned in the examples, if on eBay you make a purchase, and generates this a sales order, the stock does not leave until not deliver, which is fine, but allows you to continue selling and this causes a problem because you do not have stock of it surely.

Is there any control that I am losing between resrved qty and current qty or any configuration that enables this?
I understand that there is the report they mention, but this forces us to be aware of it.

Thank you

Why would you block future sales if you can replenish by going across the street and buying a few more and then selling or if you can drop ship items. If you have trouble stocking items, then you can indicate it is on backorder before selling (so the customer can choose whether to buy or not). Or stock up or set your reorder point to a place where you auto generate orders to replenish.

In the end, the system does what it is supposed to. The user/business needs to have a “strategy” on what to do if this happens or that happens. If you ask your sales guy to only sell if there is 100 items left and dont sell when items fall below 20, then that is the rule they need to follow.

But i guess that’s up to the users / business.

That’s really a good discussion though you all taking ebay or similar business as an example, we are in Medical devices field and usually we need to block quantity against sales order (Doesn’t mean reducing stock) but we also need the ability to unlock these items if needed.

For example we made a sales order for 10 units from 15 units in stock (5 units are free) , system must not allow invoicing 7 units from 15 in stock as as long as 10 units still reserved against SO.

1 Like