Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Resetting the Average Cost

Resetting the Average Cost

Resetting the Average Cost

An Average Cost on one of our items is causing one of our Access Databases to error out. I've tried entering adjustments to try to reset it, but it's still erroring out.

Any ideas on how to reset the Average Cost? The # for the average cost is 879,977,427,676,107.00, and we've never had an order for more than $59.00 per unit...

I'm using MAS90 4.4, by the way.

- Zy
(Sage MAS90 4.4 User)

RE: Resetting the Average Cost

Never mind, I wound up going through Data File and Display Maintenance to change it to the values it should be.

Anyone else know where these values are besides

CI_Item &
IM_Item_Warehouse ?

I'm starting to look now.

- Zy
(Sage MAS90 4.4 User)

RE: Resetting the Average Cost

This is why I don't like average cost. It my guess that at some point the item went negative and then positive and they system tried to guess at what it should be. Just before month end adjust out all the quantity for this item and then do month end and then bring it back in at the correct cost.


RE: Resetting the Average Cost

Zy, you may be getting hit with a product issue that we are currently working on.  

Check the CostCalcQtyCommitted and CostCalcCostCommitted in the IM_ItemWarehouse to see if there is data in any of those fields.

There should only be data in those fields if someone is actively previewing or printing a transaction report or if there is an update occurring.  If data is "stuck" in those fields it can cause issues with reporting in and outside of MAS.  

If you have data in those fields call support and create a case or create one online.  It will be no charge because it is a product issue.  

Mention that the MAS 90 / 200 CSAM requested you create a no charge case and that i should be notified.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close