How to use reorder level + report?

Hi, let say I want to maintain an item for quantity 1000 so let say:

Physical stock qty "ABC" is 600.
I process a customer order for 100 qty (left 500 available)
An outstanding order to supplier for 200 qty (700 if arrive)

So a report to tell me I need to raise a PO to supplier for another 300 to maintain 1000 quantity?

How do I achieve or general formula or report for this? Can I do workflow to automatically raise a material request when it hit a minimum stock level of let say 500 and the outstanding qty taking into consideration those already order from supplier but yet to be delivered?



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.

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

Hello Joven,

This feature is already available in the ERPNext.

Following are the setup which needs to be completed for auto-creation of Material Request when item's stock goes below re-order level.
  1. You should active feature of auto-creation of Material Request based on item's stock level from:

    Stock >> Stock Setting >> Raise Material Request when stock reaches Re-Order level.

  2. Define Re-Order Level and Re-Order Qty in the Item master.

Check for reference:

http://erpnext.org/item-master

http://erpnext.org/material-request

Hope this helps.



On Tue, Jan 7, 2014 at 1:58 PM, Joven Chiew <jo...@gmail.com> wrote:
Hi, let say I want to maintain an item for quantity 1000 so let say:

Physical stock qty "ABC" is 600.
I process a customer order for 100 qty (left 500 available)
An outstanding order to supplier for 200 qty (700 if arrive)

So a report to tell me I need to raise a PO to supplier for another 300 to maintain 1000 quantity?

How do I achieve or general formula or report for this? Can I do workflow to automatically raise a material request when it hit a minimum stock level of let say 500 and the outstanding qty taking into consideration those already order from supplier but yet to be delivered?
Hi, I did the following test and I did not see a new material request.

1. Raise Material Request when stock reaches re-order level - enable

2. Create an item G1234, Re-order level is 10, Re-order Qty is 5.

3. Raise a PO to supplier for 10 x GA1234

4. PO Received 8, rejected 2.

5. Issue DN for 6 qty of G1234 to customer

In Stock Projected Qty it shows:

Actual Qty: 2   Ordered Qty: 2   Projected QTY: 4   Reorder Level: 10   Reorder Qty: 5

Question:

1. It did not automatically raise Material Request for quantity 6 to replenish stock to 10.
2. Is there somewhere I can see that the shortage to make up stock level of 10 is 6?

Thanks.

On Tuesday, 7 January 2014 17:10:28 UTC+8, Umair Sayyed wrote:
Hello Joven,

This feature is already available in the ERPNext.

Following are the setup which needs to be completed for auto-creation of Material Request when item's stock goes below re-order level.
  1. You should active feature of auto-creation of Material Request based on item's stock level from:

    Stock >> Stock Setting >> Raise Material Request when stock reaches Re-Order level.

  2. Define Re-Order Level and Re-Order Qty in the Item master.

Check for reference:

http://erpnext.org/item-master

http://erpnext.org/material-request

Hope this helps.

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.

On Wednesday, 8 January 2014 13:43:37 UTC+8, Joven Chiew wrote:
Hi, I did the following test and I did not see a new material request.

1. Raise Material Request when stock reaches re-order level - enable

2. Create an item G1234, Re-order level is 10, Re-order Qty is 5.

3. Raise a PO to supplier for 10 x GA1234

4. PO Received 8, rejected 2.

5. Issue DN for 6 qty of G1234 to customer

In Stock Projected Qty it shows:

Actual Qty: 2   Ordered Qty: 2   Projected QTY: 4   Reorder Level: 10   Reorder Qty: 5

Question:

1. It did not automatically raise Material Request for quantity 6 to replenish stock to 10.
2. Is there somewhere I can see that the shortage to make up stock level of 10 is 6?

Thanks.

On Tuesday, 7 January 2014 17:10:28 UTC+8, Umair Sayyed wrote:
Hello Joven,

This feature is already available in the ERPNext.

Following are the setup which needs to be completed for auto-creation of Material Request when item's stock goes below re-order level.
  1. You should active feature of auto-creation of Material Request based on item's stock level from:

    Stock >> Stock Setting >> Raise Material Request when stock reaches Re-Order level.

  2. Define Re-Order Level and Re-Order Qty in the Item master.

Check for reference:

http://erpnext.org/item-master

http://erpnext.org/material-request

Hope this helps.



On Tue, Jan 7, 2014 at 1:58 PM, Joven Chiew <jo...@gmail.com> wrote:
Hi, let say I want to maintain an item for quantity 1000 so let say:

Physical stock qty "ABC" is 600.
I process a customer order for 100 qty (left 500 available)
An outstanding order to supplier for 200 qty (700 if arrive)

So a report to tell me I need to raise a PO to supplier for another 300 to maintain 1000 quantity?

How do I achieve or general formula or report for this? Can I do workflow to automatically raise a material request when it hit a minimum stock level of let say 500 and the outstanding qty taking into consideration those already order from supplier but yet to be delivered?



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.

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





Thanks and Regards,

Umair Sayyed
www.erpnext.com



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.

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

System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.



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.

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

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.



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.

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

Also, how did the system determine which email to send notification to?

On Wednesday, 8 January 2014 17:06:27 UTC+8, Joven Chiew wrote:
Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.



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.

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

Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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




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.

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

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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




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.

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

Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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




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.

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

The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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




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.

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

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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




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.

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

Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly. 

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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




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.

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

Thanks for helping Nabin.

I set email digest to send email for "To Do", I create an "To Do" for myself and in the setting, there is an indication that says "Next email will be sent on: 11-01-2014 midnight" and of course it is now 2:13am and I did not see the email. I know my SMTP is working because I receive password reset when creating user.

Cron job should be OK because I saw all status in the log file are OK, backup were created accordingly that means the function were being called.

I am not familiar with Python (yet), how do I call stock/utils/reorder_item() function from python shell?

On Saturday, 11 January 2014 02:07:11 UTC+8, Nabin Hait wrote:
Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly. 

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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




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.

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

I just got this so the scheduler is working but why it didn't raise material request?
How can I provide here in order to help myself?

Test Email Digest

Graphical Application

10-01-2014


Income / Expenses

Income Year to Date: SGD 86,275.75


No Updates For:

To Do

New Material Requests: 0

Scheduler didn't encounter any problems.


On Saturday, 11 January 2014 02:07:11 UTC+8, Nabin Hait wrote:
Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly. 

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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




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.

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

Ensure that item is in question, is a purchase item or sub-contracted item, and obviously a stock item. Also check End of life value of that item.

On 10-Jan-2014, at 11:47 PM, Joven Chiew wrote:

Thanks for helping Nabin.

I set email digest to send email for "To Do", I create an "To Do" for myself and in the setting, there is an indication that says "Next email will be sent on: 11-01-2014 midnight" and of course it is now 2:13am and I did not see the email. I know my SMTP is working because I receive password reset when creating user.

Cron job should be OK because I saw all status in the log file are OK, backup were created accordingly that means the function were being called.

I am not familiar with Python (yet), how do I call stock/utils/reorder_item() function from python shell?

On Saturday, 11 January 2014 02:07:11 UTC+8, Nabin Hait wrote:
Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly. 

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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





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.

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




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.

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

Hi, It is working now after I set the timezone.

Coming back on the Reordering count.

My Projected Qty is 1,250.00
Reorder Level is 500.00
Reorder Qty is 1,000.00

The system made an automatic material request of 1,000.00 but I want the system to calculate to order 2,250.00 instead so I can maintain a stock level of 1,000.00 after taking into consideration of the projected 1,250.00 qty.

Another question. If I did not process this current automatic material request, will the system raise another new one tomorrow because it still hit the reorder level?

Many Thanks.

On Saturday, 11 January 2014 21:31:59 UTC+8, Nabin Hait wrote:
Ensure that item is in question, is a purchase item or sub-contracted item, and obviously a stock item. Also check End of life value of that item.

On 10-Jan-2014, at 11:47 PM, Joven Chiew wrote:

Thanks for helping Nabin.

I set email digest to send email for "To Do", I create an "To Do" for myself and in the setting, there is an indication that says "Next email will be sent on: 11-01-2014 midnight" and of course it is now 2:13am and I did not see the email. I know my SMTP is working because I receive password reset when creating user.

Cron job should be OK because I saw all status in the log file are OK, backup were created accordingly that means the function were being called.

I am not familiar with Python (yet), how do I call stock/utils/reorder_item() function from python shell?

On Saturday, 11 January 2014 02:07:11 UTC+8, Nabin Hait wrote:
Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly. 

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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





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.

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




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.

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

I think you had misunderstood the calculation. Here projected qty 1250 is including auto requested qty after reaching below reorder level (250 + 1000). 

Projected qty = Actual qty + Ordered qty + Requested Qty + Planned Qty - Reserved Qty

After creation of auto material request, Requested Qty has been increased by 1000, which resulted projected qty to 1250. As projected qty is already greater than reorder level, the system will not raise another new material request tomorrow.


On 11-Jan-2014, at 10:07 PM, Joven Chiew wrote:

Hi, It is working now after I set the timezone.

Coming back on the Reordering count.

My Projected Qty is 1,250.00
Reorder Level is 500.00
Reorder Qty is 1,000.00

The system made an automatic material request of 1,000.00 but I want the system to calculate to order 2,250.00 instead so I can maintain a stock level of 1,000.00 after taking into consideration of the projected 1,250.00 qty.

Another question. If I did not process this current automatic material request, will the system raise another new one tomorrow because it still hit the reorder level?

Many Thanks.

On Saturday, 11 January 2014 21:31:59 UTC+8, Nabin Hait wrote:
Ensure that item is in question, is a purchase item or sub-contracted item, and obviously a stock item. Also check End of life value of that item.

On 10-Jan-2014, at 11:47 PM, Joven Chiew wrote:

Thanks for helping Nabin.

I set email digest to send email for "To Do", I create an "To Do" for myself and in the setting, there is an indication that says "Next email will be sent on: 11-01-2014 midnight" and of course it is now 2:13am and I did not see the email. I know my SMTP is working because I receive password reset when creating user.

Cron job should be OK because I saw all status in the log file are OK, backup were created accordingly that means the function were being called.

I am not familiar with Python (yet), how do I call stock/utils/reorder_item() function from python shell?

On Saturday, 11 January 2014 02:07:11 UTC+8, Nabin Hait wrote:
Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly. 

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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





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.

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





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.

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




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.

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

Thanks. I understood now. So the reordering quantity is always fix at 1000? If I need to raise only the shortage (700) to maintain (1000 - 250) I need customization?
Also in Query Report: Stock Projected Qty, is it possible to add another column to calculate the shortage (700)?

On Sunday, 12 January 2014 01:28:34 UTC+8, Nabin Hait wrote:
I think you had misunderstood the calculation. Here projected qty 1250 is including auto requested qty after reaching below reorder level (250 + 1000). 

Projected qty = Actual qty + Ordered qty + Requested Qty + Planned Qty - Reserved Qty

After creation of auto material request, Requested Qty has been increased by 1000, which resulted projected qty to 1250. As projected qty is already greater than reorder level, the system will not raise another new material request tomorrow.


On 11-Jan-2014, at 10:07 PM, Joven Chiew wrote:

Hi, It is working now after I set the timezone.

Coming back on the Reordering count.

My Projected Qty is 1,250.00
Reorder Level is 500.00
Reorder Qty is 1,000.00

The system made an automatic material request of 1,000.00 but I want the system to calculate to order 2,250.00 instead so I can maintain a stock level of 1,000.00 after taking into consideration of the projected 1,250.00 qty.

Another question. If I did not process this current automatic material request, will the system raise another new one tomorrow because it still hit the reorder level?

Many Thanks.

On Saturday, 11 January 2014 21:31:59 UTC+8, Nabin Hait wrote:
Ensure that item is in question, is a purchase item or sub-contracted item, and obviously a stock item. Also check End of life value of that item.

On 10-Jan-2014, at 11:47 PM, Joven Chiew wrote:

Thanks for helping Nabin.

I set email digest to send email for "To Do", I create an "To Do" for myself and in the setting, there is an indication that says "Next email will be sent on: 11-01-2014 midnight" and of course it is now 2:13am and I did not see the email. I know my SMTP is working because I receive password reset when creating user.

Cron job should be OK because I saw all status in the log file are OK, backup were created accordingly that means the function were being called.

I am not familiar with Python (yet), how do I call stock/utils/reorder_item() function from python shell?

On Saturday, 11 January 2014 02:07:11 UTC+8, Nabin Hait wrote:
Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly. 

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py  

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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





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.

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





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.

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




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.

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

If you mention reorder qty and shortage qty is less than reorder qty, system will raise a material request for reorder qty. But if shortage qty is greater than reorder qty MR will be for shortage qty.
If you always want to raise wiyh shortage qty, remove reorder qty from item master.

We will try to put shortage qty in the report, can you raise a github issue for this?

On 11 Jan 2014 23:18, "Joven Chiew" <jo...@gmail.com> wrote:
Thanks. I understood now. So the reordering quantity is always fix at 1000? If I need to raise only the shortage (700) to maintain (1000 - 250) I need customization?
Also in Query Report: Stock Projected Qty, is it possible to add another column to calculate the shortage (700)?

On Sunday, 12 January 2014 01:28:34 UTC+8, Nabin Hait wrote:
I think you had misunderstood the calculation. Here projected qty 1250 is including auto requested qty after reaching below reorder level (250 + 1000).

Projected qty = Actual qty + Ordered qty + Requested Qty + Planned Qty - Reserved Qty

After creation of auto material request, Requested Qty has been increased by 1000, which resulted projected qty to 1250. As projected qty is already greater than reorder level, the system will not raise another new material request tomorrow.


On 11-Jan-2014, at 10:07 PM, Joven Chiew wrote:

Hi, It is working now after I set the timezone.

Coming back on the Reordering count.

My Projected Qty is 1,250.00
Reorder Level is 500.00
Reorder Qty is 1,000.00

The system made an automatic material request of 1,000.00 but I want the system to calculate to order 2,250.00 instead so I can maintain a stock level of 1,000.00 after taking into consideration of the projected 1,250.00 qty.

Another question. If I did not process this current automatic material request, will the system raise another new one tomorrow because it still hit the reorder level?

Many Thanks.

On Saturday, 11 January 2014 21:31:59 UTC+8, Nabin Hait wrote:
Ensure that item is in question, is a purchase item or sub-contracted item, and obviously a stock item. Also check End of life value of that item.

On 10-Jan-2014, at 11:47 PM, Joven Chiew wrote:

Thanks for helping Nabin.

I set email digest to send email for "To Do", I create an "To Do" for myself and in the setting, there is an indication that says "Next email will be sent on: 11-01-2014 midnight" and of course it is now 2:13am and I did not see the email. I know my SMTP is working because I receive password reset when creating user.

Cron job should be OK because I saw all status in the log file are OK, backup were created accordingly that means the function were being called.

I am not familiar with Python (yet), how do I call stock/utils/reorder_item() function from python shell?

On Saturday, 11 January 2014 02:07:11 UTC+8, Nabin Hait wrote:
Are you getting other emails through scheduler like Daily Email Digest? It will ensure you that scheduler has called properly.

Also you can try to debug by calling stock/utils/reorder_item() function from python shell directly.


On 10-Jan-2014, at 5:14 PM, Joven Chiew wrote:

Any advice for me regarding automatic material request?

On Friday, 10 January 2014 14:03:47 UTC+8, Joven Chiew wrote:
The log file "erpnext-sch.log" shows status OK for every 3mins.

I have stock item:

Reserve Qty: 2
Projected Qty: -2
Reorder Level: 5
Reorder Qty: 10

There is no auto material request or email, yes the function has been turn on and I can receive email from the system.
What else do I investigate?

On Wednesday, 8 January 2014 19:35:13 UTC+8, Nabin Hait wrote:
Cron job settings:

*/3 * * * * cd erpnext_path && python2.7 lib/wnf.py --run_scheduler >> erpnext-sch.log 2>&1

On 08-Jan-2014, at 3:50 PM, Joven Chiew wrote:

Thanks again Nabin.
Is there instruction/documentation about erpnext scheduler?
So I run cron job to executive the script scheduler_handlers.py?

On Wednesday, 8 January 2014 17:59:14 UTC+8, Nabin Hait wrote:
Check whether you have set cron to call erpnext scheduler. And you can set scheduler frequency for checking reorder level, check scheduler_handlers.py

And system sends notification to all users having Material Manager or Purchase Manager role. To send auto notification, you have to check "Notify by Email on creation of automatic Material Request" from Stock Settings.

On 08-Jan-2014, at 2:36 PM, Joven Chiew wrote:

Oh nice! Why isn't this mentioned in the manual or I am blind? Do I need to configure any cron or setting in order for the notification to work?
Also, is the interval something that is configurable?

On Wednesday, 8 January 2014 17:02:23 UTC+8, Nabin Hait wrote:
System checks for reorder level through scheduler once every day. You can expect notification email and automatic material request, at the beginning of tomorrow.

On 08-Jan-2014, at 1:53 PM, Joven Chiew wrote:

Can anyone confirm this? The "Raise Material Request when stock reaches re-order level" is not working.




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.

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





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.

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





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.

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





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.

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





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.

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




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.

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



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.

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