Resetting the Average Cost
Resetting the Average Cost
(OP)
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.
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
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
http://co mmunity.sa gemas.com/ sagemas/?c ategory.id =SageMAS90 and200Disc
RE: Resetting the Average Cost
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.