| | How to Rebuild Sort Files |
| Resolution | Before you begin - It's important to back up your company data files before proceeding with the Rebuild. If the rebuild doesn't complete, you'll need to restore the backup
- The system automatically maintains Sort files when you add or delete records from the master files
- Use the Rebuild Application Sort Files utility for the following reasons
- You have damaged sort files; resulting in a missing record (Error 11) or missing information in a report
- You've rebuilt or reinitialized data files
- You recalculated balances to resolve a specific issue
- ON PO, ON SO, ON WO, ON WT quantities aren’t correct in Item Maintenance
- Review full instructions on How to Rebuild Key Files in Sage 100
Run the Rebuild Sort Files application - Expand Modules, Library Master, Utilities, Rebuild Sort Files.
- For Sage MAS 90 version 3.71 and earlier
- Expand Modules, Library Master, Repair, and double-click Rebuild Application Sort Files
- Review the warning, and click OK.
- On the Rebuild Sort Files window, select an application from the Module field.
- Add company code from the Company field.
- Click Proceed, and select responses to the questions pertaining to certain modules (see below).
- Close the Rebuild Sort Files window.
▼ Accounts Payable To recalculate balance due in the Vendor Masterfile, select YES when asked "Do you want to recalculate vendor balances in the Vendor Masterfile?" ▼ Accounts Receivable - Select the Recalculate Aging in Customer Master check box to recalculate the following:
- Dollar amounts of open invoices that belong in the aging fields for each customer in the Customer Masterfile
- These aging fields display near the bottom of the Invoices tab in Customer Maintenance
- Select an aging date from the Aging Date field. This is the date that Upi are calculating aging
- Aging recalculates by invoice or due date, based on the Age Invoices By setting in AR Options
- Aging uses the invoice date or due date, depending on the Age Invoices By setting in AR Options
- Age Invoices By selections include the following:
- Include Paid Invoices. This determines whether paid invoices show in the aging
- Age Credit Memos. This setting includes credit memos in the aging recalculation
- Exclude Future Transactions. This setting includes future transactions beyond the aging date in the recalculation
- Select the Recalculate Open Order amount in Customer check box
- This recalculates Open Order Amount for each customer in the Customer Masterfile
- Select this if the open order amount exceeds the customer’s credit limit and blocks new sales orders
▼ Inventory Management To search for lot or serial item records, click Yes when asked to recalculate committed quantities for the following items. - S/O Invoice Data Entry (Tier Distribution Detail)
- I/M Transaction Entry
- P/O Return of Goods/Invoice Entry
- P/O Material Requisition Issue Entry
- P/O Receipt of Goods/Invoice Entry
- B/M Production Entry
- B/M Disassembly Entry
If the rebuild finds no lot or serial records, committed quantities in the Cost Detail File will clear. ▼ Job Cost To recalculate the Unbilled Costs field in the Job Masterfile, select YES when asked if you want to recalculate unbilled costs also. ▼ Production Management When asked, Recalculate Open Work Ticket Quantities in Inventory Masterfile also? click Yes. This recalculates the following: - On WT quantity in Inventory Maintenance
- Inventory based on the open orders in the Work Ticket entry files
▼ Purchase Order When asked if you want to recalculate open purchase order quantities in the inventory masterfile also, click Yes to recalculate the following: - On PO quantity in Inventory Maintenance,
- Inquiry based on the open orders in the Purchase Order entry files
▼ Sales Order When asked, Do you want to recalculate open sales order quantities in the Inventory masterfile also? click Yes to recalculate the following: - The On SO quantity in Inventory Maintenance
- Inquiry based on the open orders in the Sales Order entry files
▼ Work Order When asked, Do you want to recalculate Open Work Order Quantities in the Inventory Masterfile also? click Yes to recalculate the following: - The On WO quantity in Inventory Maintenance
- Inquiry based on the open orders in the Work Order entry files
[BCB:155:Chat 100 US:ECB]
|
|