Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Costing Method 1

Status
Not open for further replies.

hahsia

Programmer
May 15, 2003
88
SG
Hi,

I have a question on how/or what are the steps i should take if my client who has been using FIFO costing method in Accpac now decided to change to Moving Average costing method?

Seeking For Advices.
Thanks In Advance.
 
Accpac maintains all costing methods automatically. All you have to do is run IC dayend processing, then switch the method. Before you do so, however, analyis the current average costs for all your items to ensure they're reasonable. If you allow negative quantities, average cost values can become skewed.

Jay Converse
IT Director
Systemlink, Inc.
 
It is not as difficult as it seems. Make back ups prior to attempting this, just in case.

1- calculate cost average from the ICCOSTxx.dbf file for each item. Use cost and conhand fields or any appropiate field.
2- Insert this calcualted item-cost into ICITEMxx.dbf and field: avgcost for each item.
3- Change Sysdata.dbf
field: SYSID look for ICxx (Inventory control) and field: str3 ,change the first character from F (fifo) to W (weight average).

Good Luck
Edgar
Integrated Bar Code Systems
 
Careful, Hahsia. I was talking about Advantage Series, and Edgar's talking about Pro Series. Make sure you use the right one!

Jay Converse
IT Director
Systemlink, Inc.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top