Default Value in Price list filed in inventory transaction forms

[Former Member]

Hi expert

I would like to know how can i change default value in price list filed in inventory transaction forms?

is it possible to have this option base on Item Cost which has been calculated by system, becasue as I found out the last evaluated price needs to run Inventoory evaluation report and it is not on hand automatically.

thanks

Edited by: Farhadn on Apr 26, 2010 5:48 PM

[Former Member · Accepted solution]

Hi,

Please clarify what do you mean for inventory transaction forms. Do you mean any forms like Goods Receipt or Inventory Transfer?

Thanks,

Gordon

[Former Member · Accepted solution]

yes,

you know I found out , when user makes mistake in Price in AP invoice and then cancels it by credit memo , system doesnot care about this correction, and assume incorect price as LAST purchase price, on the other hand when warehouse people issue or recipt or transfer related Item , system brings incorrected price as last purchase price , so on the accounting side , related account affected in not proper way.

how can I solve it ? I thought maybe I can change the defult Price list to Item Cost, but there is no any option in system.

how can I solve the previous data? by Inventory revaluation? but what is the Increase and decrease account?

[Former Member · Accepted solution]

For all user mistakes, you have to accept something first. There is no way to change back all historical records in a simple way. The variance might not be avoidable. It is because, that is the variances due to user errors.

Inventory revaluation would be the way to correct those unfortunate events.

[Former Member · Accepted solution]

Thanks , So how can I prevent this mistake in future? and How can I change defualt value in Price list in inventory transactions

[Former Member · Accepted solution]

You may only reduce those errors but may not be able to prevent. A good training to all users is very important. Always ask users double confirm their input are correct before clicking on ADD. That is all the system message box try to help you to have correct entries.

[Former Member · Accepted solution]

The transfer & issue transactions will always be completed at item cost, the value that displays on the form is informational only.

The only real issue is with receipts & making sure the correct price is used here. You could limit authorisation on these to a small number of users to make sure they are properly checked if your volumes are not high?