Share your ideas for improving. Vote on ideas and discuss them with the MYOB product development team.

Product Ideas

Inventory: Definable period of Average Cost

Cover User

6Posts

6Kudos

0Solutions

6 Posts
Cover User

What: Display Item Average Cost based upon a defineable rolling period.

How: Add a setting where the Average Cost for items can be defined as either a set rolling period or all-time.

 

As we are a wholesaler importing goods form overseas it would be useful if we could have an average cost that is based on only the prior 1, 2 or 3 years so as to better reflect the current exchange rate situation and allow us to set our sell prices more intelligently.

 

"Defineable Period for Item Average Cost"

Current Status: Archived
Last Changed: October 2018

Thank you for the idea. Unfortunately, this request has had no support from the community since it was submitted, so we are moving this idea to the Archived status. For more information on Idea Statuses, please read this article: Changes to our Idea Exchange pages

3 Comments
Jennifer_Kelly
Super Partner
492 Posts
Super Partner

 Hi,

 

You would be able to get this type of flexible reporting from some of the MYOB Add-on solutions.

See - http://myob.com.au/addons/

 

As an example using our software Business Intelligence for MYOB you could do the report below.

 

This is Analysing Item purchases for the Financial year 2014 (this date range is can be anything you define), I have it Pivoting on Purchases by Quarter ( you could do this by Month , by year etc).

This shows the Ave Purchase price for each period, I have the Items grouped by Supplier and displaying the Supplier Item number too. 

 

You could also display a Custom List or Field against each Item row too if you wanted ( from your other post).

 

Average Purchase by Qtr.png

 

We have a 14 day free trial on our website at www.BIforMYOB.com, you are welcome to sign up and get some of these historidal purchase reports if you like.

 

Jennifer Kelly CA

Business Intelligence for MYOB

www.BIforMYOB.com

Steven_M
45,180 Posts
Former Staff

Hi @pingpong

 

Thank you for your idea in regards to AccountRight and average cost of items

Currently average cost of an item is determined via the current value divided by the number of hand at the time, its not back calculated or predefined. I would encourage other users that would like to set the average of the an item to vote and comment if required for this idea.

A possible workaround would be, as indicated by @Jennifer_Kelly, an add on solution 

Steven_M
45,180 Posts
Former Staff

Thank you for the idea. Unfortunately, this request has had no support from the community since it was submitted, so we are moving this idea to the Archived status. For more information on Idea Statuses, please read this article: Changes to our Idea Exchange pages