Product Menu
Product Menu
Home
MAS 90
MAS 90 Small Business
MAS 200
MAS 200 SQL
MAS Enhancements
EDI
Crystal Reports
FRx
Citrix
Receive Our Demo CD
Viewable Demos
About Us
Price Lists
Contact Us


Manually adjust item costs PDF Print E-mail

 

What is the Proper Way to Manually Adjust Your Item Costs in MAS 90 and MAS 200?

 

There are occasions when it may be necessary to adjust the cost of an

inventory item already recorded into inventory. For example, a cost may

have been initially entered, or calculated, incorrectly.

At one time, users with Supervisory rights could use the ?Fix? button in

Inventory Maintenance to adjust an item?s costs. However, it was

determined that using the 'Fix' button to make these changes caused outof-

balances in Inventory, and was not updating General Ledger, when

used incorrectly. Therefore the ?Fix? button was removed for version 4.05.

There is still a means of properly adjusting the costs associated with an

inventory item, outlined in the sections below for each Valua tion method:

Standard Cost:

Use an adjustment to bring the total quantity (for all warehouses) to 0 at

the current (incorrect) standard cost. This adjustment will bring the total

quantity and total value in inventory to 0. At that time, you can manually

change the standard cost within the Inventory Masterfile and adjust the

total quantity back in at the new standard cost. This transaction will

update General Ledger with the new inventory value.

Average Cost:

To change average cost, the total quantity in a ll warehouses must be

adjusted out at the current (incorrect) average cost. This adjustment will

reduce the inventory quantity and value to 0. Once the inventory has a $0

value, the same quantity can be adjusted back in at the correct average

cost. This transaction will update General Ledger with the new inventory

value.

LIFO, FIFO, Lot, and Serial

The negative and positive adjustments must be made to the same cost

tier (i.e. the receipt date and reference for LIFO/FIFO or lot/serial number

for lot/serial items) by clicking the distribute (?Distrib?) button on the

Transaction Entry Lines tab and distributing the quantities to the correct

cost tier. In other words, for a FIFO item, if the cost was incorrect on a

particular FIFO tier, the negative adjustment would be entered for the

quantity in that tier at the current (incorrect) cost and then distributed

back to that tier with the correct cost.

 

 

   Home arrow Tips & Tricks arrow Manually adjust item costs