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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Remove all costing data

Status
Not open for further replies.

Omnicef

MIS
Feb 10, 2003
78
We want to quickly remove all costing data for all inventory items and start fresh for 2004. Can I reinitialze a particular data file for this? Any other way to start over on costing?

Thnks in advance to all users out there who continually answer all of our questions. Although I try to answer some questions, I usually am asking.
 
For anyone who may have ran acroos this same scenario, this is how you do it...

Note: Caution should be taken whenever Repair Utilities are used. Always make a backup first. Assistance by a qualified MAS90 Technician may be necessary.
1) Make a backup of the data files first (VERY IMPORTANT). Have everybody in the live company code exit.
2) Library Master||Utilities|Company Maintenance -> Create a test/temporary holding company code. Activate the Inventory Module only. Next run the (File|Run| SVDATA copy utility and copy JUST THE FORMS (not the IM data) from the live company to the test company.
3) When in the temporary company (from step #2 above) -> File|Run -> SVTRNA which loads the copy masterfile utility program.
4) The "from" company is the live company. The application is "Inventory". For the options screen, DESELECT "Copy Warehouse Detail" (this is the IM2 file). All of the other file options are related to pricing and item setup so leave those selected as needed.
5) Library Master -> Reinitialize data files -> Choose ALL files for the live company for the Inventory module only. Again, MAKE SURE A GOOD BACKUP OF THE LIVE COMPANY DATA EXISTS BEFORE PROCEEDING (step #1 above).
6) Once the IM files in the live company have been reinitialized then File|Run -> SVDATA the "from" company is the holding company from step #2 above and the "to" company is the live company. The only application to copy over is the Inventory Module. Copy the forms from the test company back to the live company as well.
7) Library Master -> Rebuild Application Sort Files for Sales Order, Purchase Order, Inventory and Work Order (in the live company). Only run the Rebuild Sort File utility for Work Order if Work Order module is being used. Answer "Yes" to recalculate the "ON SO", "ON PO" and "ON WO" quantities in the Inventory Masterfile.
8) Library Master -> Company Maintenance -> Delete the temporary holding company.
9) At this point the Inventory module should have items and setup (warehouses, product lines, pricing etc) with no quantities or transaction history.
10) Create a General Ledger journal entry to balance the Inventory G/L account (zero it out)


Thnks in advance to all users out there who continually answer all of our questions. Although I try to answer some questions, I usually am asking.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top