New Price List based on Average Cost of item required

[william_fernandes]

Hi Everyone,

My client requires a seperate Price List based on the Average Cost of the item. All items have Valuation Method as 'Moving Average'. I ran the Inventory Audit Report which then updated the Average Cost in 'Last Evaluated Price List'. But is there any way to automatically update the 'Last Evaluated Price' with the Average Cost or is there some way to create a seperate Price List based on Average Cost ?

Regards,

William

[Former Member]

Hi William,

The 'Last Evaluated Price' cannot be automatically updated. This is by system design. You may setup a alert to run the required report regularly if you need.

Thanks,

Gordon

[william_fernandes]

Hello Naresh,

My client wants a seperate Price List based on the Average Cost of the item. I know that by running the Inventory Audit Report or Inventory Valuation Report, the 'Last Evaluated Price List' is updated. But how can this be automated. The required Price List has to be used during Sales Invoice for some selected customers (through Special Prices). Can I create a Price List based on 'Average Cost' , or can this 'Last Evaluated Price List' be automated.

Regards,

William

[Former Member]

Hi

You can check Inventory --> Inventory Reports --> Inventory Valuation Simulation Report...... you can select the Moving Average price and check the Average price of Items

Regards

NKS