Stock Ledger Entry Table and its behaviour in saving the Valuation Rate

Hi,

I just noticed that the stock ledger table which stores the valuation rate for items is doing one thing wrong according to me. The one thing wrong being done by the table according to me is that the valuation rate becomes ZERO when the quantity of the item in a particular warehouse becomes ZERO.

Now please note that I think that the valuation rate should not become zero since that looses the integrity of the table. I would like to explain the problem due to this behaviour with the help of a real life example. I am enclosing a stock ledger of an item in a warehouse in my system.

Date

Time

Item

Qty

Balance

Warehouse

Rate

Value

Voucher No

Voucher Type

29-06-2013

2:52:55

RH10REP5ZL7

-198.2

0

O_RM-DEL20A

0

0

STE131401380

Stock Entry

22-06-2013

16:20:38

RH10REP5ZL7

198.2

198.2

O_RM-DEL20A

535

106037

GRN131400179

Purchase Receipt

21-06-2013

11:29:23

RH10REP5ZL7

-32.9

0

O_RM-DEL20A

0

0

STE131401241

Stock Entry

20-06-2013

16:44:39

RH10REP5ZL7

-515

32.9

O_RM-DEL20A

504

16581.6

STE131401223

Stock Entry

20-06-2013

16:15:28

RH10REP5ZL7

15

547.9

O_RM-DEL20A

505.861471

277161.5

GRN131400175

Purchase Receipt

20-06-2013

16:15:28

RH10REP5ZL7

500

532.9

O_RM-DEL20A

505.913868

269601.5

GRN131400175

Purchase Receipt

23-05-2013

16:39:55

RH10REP5ZL7

-7

32.9

O_RM-DEL20A

535

17601.5

STE131400766

Stock Entry

09-05-2013

17:33:06

RH10REP5ZL7

-10

39.9

O_RM-DEL20A

535

21346.5

STE131400565

Stock Entry

18-03-2013

14:19:46

RH10REP5ZL7

-223.15

49.9

O_RM-DEL20A

535

26696.5

STE121303575

Stock Entry

12-03-2013

12:06:10

RH10REP5ZL7

-223.95

273.05

O_RM-DEL20A

535

146081.75

STE121303496

Stock Entry

09-03-2013

18:10:53

RH10REP5ZL7

-6

497

O_RM-DEL20A

535

265895

STE121303478

Stock Entry

05-03-2013

18:31:42

RH10REP5ZL7

-6.3

503

O_RM-DEL20A

535

269105

STE121303409

Stock Entry

05-03-2013

12:05:46

RH10REP5ZL7

503

509.3

O_RM-DEL20A

534.567053

272255

GRN121300530

Purchase Receipt

08-02-2013

7:56:29

RH10REP5ZL7

6.3

6.3

O_RM-DEL20A

500

3150

GRN121300470

Purchase Receipt

21-06-2012

13:35:00

RH10REP5ZL7

-248.1

0

O_RM-DEL20A

0

0

STE121300702

Stock Entry

19-06-2012

10:10:00

RH10REP5ZL7

248.1

248.1

O_RM-DEL20A

575

142657.5

GRN121300103

Purchase Receipt

 

 

 

 

 

 

 

 

 

 

30-05-2012

20:50:00

RH10REP5ZL7

-7.3

0

O_RM-DEL20A

0

0

STE121300543

Stock Entry

05-04-2012

14:10:00

RH10REP5ZL7

-115.7

7.3

O_RM-DEL20A

0

0

STE121300031

Stock Entry

22-03-2012

9:40:00

RH10REP5ZL7

-105

123

O_RM-DEL20A

0

0

STE111203591

Stock Entry

22-03-2012

8:00:00

RH10REP5ZL7

228

228

O_RM-DEL20A

0

0

SR/000053

Stock Reconciliation



In the above table you would see a stock ledger of a particular item. Now the problem is that on 21-Jun-2012 when the stock qty became zero in the WH then the valuation rate also became zero. The problem is that if I would try to make a stock reconciliation of this item on this date or after that date then the system would ask for a valuation rate from the person making a stock reconciliation but since that person would be from stores department he would not be very well aware about the valuation rate and hence he would try and put the valuation rate as 1 to get his quantity through.

My suggestion is that the system should not do away with the Rate since that would still mean ZERO value of stock since the quantity is ZERO.

I am posting this on forums since I am unable to fathom the reason of this kind of design in this table. Is there some particular reason for this kind of design?

Would love to hear on this issue from the team.

Regards,

Aditya Duggal



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/653e4144-5c78-4155-b2c1-966c09eb5df6%40googlegroups.com.

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

We never thought in that way, from the usability point of view. I agree with you, we can maintain valuation rate, even if available qty is zero. And we can use that valuation rate as default rate, in the next incoming stock entry.
Can you please raise an github issue for this? We will fix this in version 4.0.


On 16-Mar-2014, at 4:33 pm, Addy <ad...@gmail.com> wrote:

Hi,

I just noticed that the stock ledger table which stores the valuation rate for items is doing one thing wrong according to me. The one thing wrong being done by the table according to me is that the valuation rate becomes ZERO when the quantity of the item in a particular warehouse becomes ZERO.

Now please note that I think that the valuation rate should not become zero since that looses the integrity of the table. I would like to explain the problem due to this behaviour with the help of a real life example. I am enclosing a stock ledger of an item in a warehouse in my system.

Date

Time

Item

Qty

Balance

Warehouse

Rate

Value

Voucher No

Voucher Type

29-06-2013

2:52:55

RH10REP5ZL7

-198.2

0

O_RM-DEL20A

0

0

STE131401380

Stock Entry

22-06-2013

16:20:38

RH10REP5ZL7

198.2

198.2

O_RM-DEL20A

535

106037

GRN131400179

Purchase Receipt

21-06-2013

11:29:23

RH10REP5ZL7

-32.9

0

O_RM-DEL20A

0

0

STE131401241

Stock Entry

20-06-2013

16:44:39

RH10REP5ZL7

-515

32.9

O_RM-DEL20A

504

16581.6

STE131401223

Stock Entry

20-06-2013

16:15:28

RH10REP5ZL7

15

547.9

O_RM-DEL20A

505.861471

277161.5

GRN131400175

Purchase Receipt

20-06-2013

16:15:28

RH10REP5ZL7

500

532.9

O_RM-DEL20A

505.913868

269601.5

GRN131400175

Purchase Receipt

23-05-2013

16:39:55

RH10REP5ZL7

-7

32.9

O_RM-DEL20A

535

17601.5

STE131400766

Stock Entry

09-05-2013

17:33:06

RH10REP5ZL7

-10

39.9

O_RM-DEL20A

535

21346.5

STE131400565

Stock Entry

18-03-2013

14:19:46

RH10REP5ZL7

-223.15

49.9

O_RM-DEL20A

535

26696.5

STE121303575

Stock Entry

12-03-2013

12:06:10

RH10REP5ZL7

-223.95

273.05

O_RM-DEL20A

535

146081.75

STE121303496

Stock Entry

09-03-2013

18:10:53

RH10REP5ZL7

-6

497

O_RM-DEL20A

535

265895

STE121303478

Stock Entry

05-03-2013

18:31:42

RH10REP5ZL7

-6.3

503

O_RM-DEL20A

535

269105

STE121303409

Stock Entry

05-03-2013

12:05:46

RH10REP5ZL7

503

509.3

O_RM-DEL20A

534.567053

272255

GRN121300530

Purchase Receipt

08-02-2013

7:56:29

RH10REP5ZL7

6.3

6.3

O_RM-DEL20A

500

3150

GRN121300470

Purchase Receipt

21-06-2012

13:35:00

RH10REP5ZL7

-248.1

0

O_RM-DEL20A

0

0

STE121300702

Stock Entry

19-06-2012

10:10:00

RH10REP5ZL7

248.1

248.1

O_RM-DEL20A

575

142657.5

GRN121300103

Purchase Receipt

 

 

 

 

 

 

 

 

 

 

30-05-2012

20:50:00

RH10REP5ZL7

-7.3

0

O_RM-DEL20A

0

0

STE121300543

Stock Entry

05-04-2012

14:10:00

RH10REP5ZL7

-115.7

7.3

O_RM-DEL20A

0

0

STE121300031

Stock Entry

22-03-2012

9:40:00

RH10REP5ZL7

-105

123

O_RM-DEL20A

0

0

STE111203591

Stock Entry

22-03-2012

8:00:00

RH10REP5ZL7

228

228

O_RM-DEL20A

0

0

SR/000053

Stock Reconciliation



In the above table you would see a stock ledger of a particular item. Now the problem is that on 21-Jun-2012 when the stock qty became zero in the WH then the valuation rate also became zero. The problem is that if I would try to make a stock reconciliation of this item on this date or after that date then the system would ask for a valuation rate from the person making a stock reconciliation but since that person would be from stores department he would not be very well aware about the valuation rate and hence he would try and put the valuation rate as 1 to get his quantity through.

My suggestion is that the system should not do away with the Rate since that would still mean ZERO value of stock since the quantity is ZERO.

I am posting this on forums since I am unable to fathom the reason of this kind of design in this table. Is there some particular reason for this kind of design?

Would love to hear on this issue from the team.

Regards,

Aditya Duggal



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/653e4144-5c78-4155-b2c1-966c09eb5df6%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/BB8B35E9-52C6-49AF-9872-15FD34D77141%40iwebnotes.com.

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

Hi Nabin,

I have created 2 issues regarding this as below:

  1. Regarding the retention of Valuation Rate in Stock Ledger entry table
  2. Regarding the system allowing the stock entries to be saved but not submitted when the valuation rate for an item in a warehouse is =< zero.

On Tuesday, March 18, 2014 11:14:27 AM UTC+5:30, Nabin Hait wrote:
We never thought in that way, from the usability point of view. I agree with you, we can maintain valuation rate, even if available qty is zero. And we can use that valuation rate as default rate, in the next incoming stock entry.
Can you please raise an github issue for this? We will fix this in version 4.0.


On 16-Mar-2014, at 4:33 pm, Addy <ad...@gmail.com> wrote:

Hi,

I just noticed that the stock ledger table which stores the valuation rate for items is doing one thing wrong according to me. The one thing wrong being done by the table according to me is that the valuation rate becomes ZERO when the quantity of the item in a particular warehouse becomes ZERO.

Now please note that I think that the valuation rate should not become zero since that looses the integrity of the table. I would like to explain the problem due to this behaviour with the help of a real life example. I am enclosing a stock ledger of an item in a warehouse in my system.

Date

Time

Item

Qty

Balance

Warehouse

Rate

Value

Voucher No

Voucher Type

29-06-2013

2:52:55

RH10REP5ZL7

-198.2

0

O_RM-DEL20A

0

0

STE131401380

Stock Entry

22-06-2013

16:20:38

RH10REP5ZL7

198.2

198.2

O_RM-DEL20A

535

106037

GRN131400179

Purchase Receipt

21-06-2013

11:29:23

RH10REP5ZL7

-32.9

0

O_RM-DEL20A

0

0

STE131401241

Stock Entry

20-06-2013

16:44:39

RH10REP5ZL7

-515

32.9

O_RM-DEL20A

504

16581.6

STE131401223

Stock Entry

20-06-2013

16:15:28

RH10REP5ZL7

15

547.9

O_RM-DEL20A

505.861471

277161.5

GRN131400175

Purchase Receipt

20-06-2013

16:15:28

RH10REP5ZL7

500

532.9

O_RM-DEL20A

505.913868

269601.5

GRN131400175

Purchase Receipt

23-05-2013

16:39:55

RH10REP5ZL7

-7

32.9

O_RM-DEL20A

535

17601.5

STE131400766

Stock Entry

09-05-2013

17:33:06

RH10REP5ZL7

-10

39.9

O_RM-DEL20A

535

21346.5

STE131400565

Stock Entry

18-03-2013

14:19:46

RH10REP5ZL7

-223.15

49.9

O_RM-DEL20A

535

26696.5

STE121303575

Stock Entry

12-03-2013

12:06:10

RH10REP5ZL7

-223.95

<span style=""

...



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/0ad6d6a1-0bdb-46e2-a1fb-b09764fac600%40googlegroups.com.

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

Hi Nabin,

I have created a github issue for this valuation rate, where we could have a doctype for valuation rate which could be warehouse wise something like a mixture of Item Price and also the re-order level which are warehouse wise.

The github issue is #2126.

I know that you people don't want to add doctype for each and every thing but I think a doctype for Valuation rate would be better off. I am willing to do the addition on the erpnext but I guess I would need some hand holding since I have never contributed on this front to the team.

On Tuesday, March 18, 2014 3:01:33 PM UTC+5:30, Addy wrote:
Hi Nabin,

I have created 2 issues regarding this as below:

  1. Regarding the retention of Valuation Rate in Stock Ledger entry table
  2. Regarding the system allowing the stock entries to be saved but not submitted when the valuation rate for an item in a warehouse is =< zero.

On Tuesday, March 18, 2014 11:14:27 AM UTC+5:30, Nabin Hait wrote:
We never thought in that way, from the usability point of view. I agree with you, we can maintain valuation rate, even if available qty is zero. And we can use that valuation rate as default rate, in the next incoming stock entry.
Can you please raise an github issue for this? We will fix this in version 4.0.


On 16-Mar-2014, at 4:33 pm, Addy <ad...@gmail.com> wrote:

Hi,

I just noticed that the stock ledger table which stores the valuation rate for items is doing one thing wrong according to me. The one thing wrong being done by the table according to me is that the valuation rate becomes ZERO when the quantity of the item in a particular warehouse becomes ZERO.

Now please note that I think that the valuation rate should not become zero since that looses the integrity of the table. I would like to explain the problem due to this behaviour with the help of a real life example. I am enclosing a stock ledger of an item in a warehouse in my system.

Date

Time

Item

Qty

Balance

Warehouse

Rate

Value

Voucher No

Voucher Type

29-06-2013

2:52:55

RH10REP5ZL7

-198.2

0

O_RM-DEL20A

0

0

STE131401380

Stock Entry

22-06-2013

16:20:38

RH10REP5ZL7

198.2

198.2

O_RM-DEL20A

535

106037

GRN131400179

Purchase Receipt

21-06-2013

11:29:23

RH10REP5ZL7

-32.9

0

O_RM-DEL20A

0

0

STE131401241

Stock Entry

20-06-2013

16:44:39

RH10REP5ZL7

-515

32.9

O_RM-DEL20A

504

16581.6

STE131401223

Stock Entry

20-06-2013

16:15:28

RH10REP5ZL7

15

547.9

O_RM-DEL20A

505.861471

277161.5

GRN131400175

Purchase Receipt

20-06-2013

16:15:28

RH10REP5ZL7

500

532.9

O_RM-DEL20A

505.913868

269601.5

GRN131400175

Purchase Receipt

23-05-2013

16:39:55

RH10REP5ZL7

-7

32.9

O_RM-DEL20A

535

17601.5

STE131400766

Stock Entry

09-05-2013

17:33:06

RH10REP5ZL7

-10

39.9

O_RM-DEL20A

535

21346.5

STE131400565

Stock Entry

18-03-2013

14:19:46

RH10REP5ZL7

-223.15

49.9

O_RM-DEL20A

535

26696.5

<td width="108" valign="bottom" style="width:81pt;border-style:none dotted dotted none;border-bottom-color:rgb(166,166,166);border-bottom-width:1pt;border-right-color:rgb(166,166,166);border-right-width
...



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/c08c879e-664e-41a4-9c3a-980052ba6295%40googlegroups.com.

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