View source for Troubleshooting: Stock Card average cost not the same as Item Maintenance Up to Date Cost

'''Question :''' Why the (Item code 888) average cost show at Stock Card is different as Item Maintenance’s up to date cost? I’ve have checked there is no any future date transaction and already run recalculate stock costing but the amount still not matching.

<b>Version :</b> 1.8 / 1.9 / 2.0

[[File:Stock card average1.png|1100px]]


<u><b>Possible Reason :</b></u>

Someone has edited the Stock Item Cost Encoding String


<u><b>Solution :</b></u>

Go to <span style='color:red'>Tools > Options > Stock > General Stock Setting</span>, check on the <span style='color:red'>Stock Item Cost Encoding String</span> setting.

[[File:Stock card average2.png]]


The first letter/number/symbol will represent '0', the second one represents '1', the third one represents '2' ... and so on till '9'.<br/><br/>
Now the Encoding string is <span style='color:red'>12</span>3456789,.-<br/><br/>
<span style='color:red'>1</span>=0 , <span style='color:red'>2</span>=1<br/><br/>
This is why the cost 1 0 0 will show in <span style='color:red'>2 1 1</span> . <br/><br/>

If this was unintentionally edited, then change it from <span style='color:red'>123456789,.-</span> to <span style='color:red'>0123456789,.</span> and click on <span style='color:red'>OK</span>. So that the up to date cost will show as usual.<br/><br/>

If this was purposely encoded, then you’ve to remember such encoded string when reading the cost.



By : Lay Swan 180928, P181016


{{NavigateForUser}}