Stock Ageing report

My initial understanding of this report is that it measures how long inventory of a particular item code is in a specified warehouse.  I thought this applied only to items that are *still* in the warehouse as of the date specified.

Now, I'm not sure.  I've seen an item with a high aging value but there is currently no stock in the location. 

Does this mean that the Stock Ageing report only measure average age of a report since the first day until the date specified in report?



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.

Laurence,

In your account, if you selected old date in To Date field, it will show all the items you had in Warehouse at that point of time. Probably, the item in question was there in warehouse then, but not now.


On Wed, Sep 4, 2013 at 7:50 AM, lxnow <la...@union.ph> wrote:
My initial understanding of this report is that it measures how long inventory of a particular item code is in a specified warehouse. I thought this applied only to items that are *still* in the warehouse as of the date specified.

Now, I'm not sure. I've seen an item with a high aging value but there is currently no stock in the location.

Does this mean that the Stock Ageing report only measure average age of a report since the first day until the date specified in report?



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
Thanks Umair. Can you elaborate on the logic behind how stock ageing is computed?

On Wednesday, September 4, 2013 3:06:39 PM UTC+8, Umair Sayyed wrote:
Laurence,

In your account, if you selected old date in To Date field, it will show all the items you had in Warehouse at that point of time. Probably, the item in question was there in warehouse then, but not now.


On Wed, Sep 4, 2013 at 7:50 AM, lxnow <la...@union.ph> wrote:
My initial understanding of this report is that it measures how long inventory of a particular item code is in a specified warehouse.  I thought this applied only to items that are *still* in the warehouse as of the date specified.

Now, I'm not sure.  I've seen an item with a high aging value but there is currently no stock in the location. 

Does this mean that the Stock Ageing report only measure average age of a report since the first day until the date specified in report?



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
Thanks Umari. Can you elaborate what the computational logic is behind the ageing report?

On Wednesday, September 4, 2013 3:06:39 PM UTC+8, Umair Sayyed wrote:
Laurence,

In your account, if you selected old date in To Date field, it will show all the items you had in Warehouse at that point of time. Probably, the item in question was there in warehouse then, but not now.


On Wed, Sep 4, 2013 at 7:50 AM, lxnow <la...@union.ph> wrote:
My initial understanding of this report is that it measures how long inventory of a particular item code is in a specified warehouse.  I thought this applied only to items that are *still* in the warehouse as of the date specified.

Now, I'm not sure.  I've seen an item with a high aging value but there is currently no stock in the location. 

Does this mean that the Stock Ageing report only measure average age of a report since the first day until the date specified in report?



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.




On Thu, Sep 5, 2013 at 1:12 PM, lxnow <la...@union.ph> wrote:
Thanks Umari. Can you elaborate what the computational logic is behind the ageing report?


On Wednesday, September 4, 2013 3:06:39 PM UTC+8, Umair Sayyed wrote:
Laurence,

In your account, if you selected old date in To Date field, it will show all the items you had in Warehouse at that point of time. Probably, the item in question was there in warehouse then, but not now.


On Wed, Sep 4, 2013 at 7:50 AM, lxnow <la...@union.ph> wrote:
My initial understanding of this report is that it measures how long inventory of a particular item code is in a specified warehouse. I thought this applied only to items that are *still* in the warehouse as of the date specified.


Now, I'm not sure. I've seen an item with a high aging value but there is currently no stock in the location.

Does this mean that the Stock Ageing report only measure average age of a report since the first day until the date specified in report?



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.




--
Thanks and Regards,
Umair Sayyed
www.erpnext.com
Laurence,

In Item ageing report, it shows three types of age. Latest, Earliest and Average. Let's understand each one with example.

Below is the purchase detail of item ABC.

1-6-2013 ..................... 8 units
15-6-2013 ................... 10 units
20-6-2013 .................... 5 Units

If I checked stock ageing report for item ABC on 30th June, following will be the values.

Earlier Age - 30 days (considering first batch)

Latest Age - 10 days (considering last batch)

Average Age - Based on weighted average method
= 8*30 + 10*15 + 5*10 / 8+10+5
= 240 + 150 + 50 / 23
= 19 days




On Thu, Sep 5, 2013 at 1:12 PM, lxnow <la...@union.ph> wrote:
Thanks Umari. Can you elaborate what the computational logic is behind the ageing report?


On Wednesday, September 4, 2013 3:06:39 PM UTC+8, Umair Sayyed wrote:
Laurence,

In your account, if you selected old date in To Date field, it will show all the items you had in Warehouse at that point of time. Probably, the item in question was there in warehouse then, but not now.


On Wed, Sep 4, 2013 at 7:50 AM, lxnow <la...@union.ph> wrote:
My initial understanding of this report is that it measures how long inventory of a particular item code is in a specified warehouse. I thought this applied only to items that are *still* in the warehouse as of the date specified.


Now, I'm not sure. I've seen an item with a high aging value but there is currently no stock in the location.

Does this mean that the Stock Ageing report only measure average age of a report since the first day until the date specified in report?



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.




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.