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.
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.
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.
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.
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.
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.
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:
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.
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.