Unable to enter demands for current year within Maintain Projected Demands in Sage 100

Cause

MRP Maintain Projected demands will display a 2 year window (weekly or monthly detail). The years displayed are based on the Master Scheduler Year in the MP0xxx file. The window will display the previous and current year (Master Scheduler Year).

Maintain Projected Demands only allows entry of projections in the Qty Projected Next Year field. If you need to enter the current year projections you should scroll up to the corresponding month/week of the previous year and enter the projected demands in the Qty Projected Next Year field.

If the current year is the first of the 2 years displayed, the Master Scheduler Year in MP0xxx is one year ahead. For example:

Current year = 2000

Maintain Projected Demands = 01/01/2000 through 12/01/2001

Master Scheduler Year = 2001

The Master Scheduler Year field is also used to determine the Current and Last Year Quantity Sold Numbers. The Information displayed in these fields is not stored in MRP but read from Inventory files. The Inventory Sales History Files are stored by year. The numbers being displayed in the Quantity Sold This Year and Last year are dependent on the year in the Master Scheduler Year field in the MP0xxx.soa file. For example:

MS Year = 2003

Qty Sold This Year = 2003 Data displayed from Inventory Sales History Files for year 2003

Qty Sold Last Year = 2002 Data displayed from Inventory Sales History Files for year 2002

Resolution

CAUTION: Sage Customer Support does not assist with issues related to third-party products or enhancements, hardware, report customizations, state or federal tax-related questions, or specific accounting questions. Please get in touch with your Sage business partner, network administrator, or accountant for assistance. Please refer to our Scope of Support document for details.

1. Expand Modules, Library Master, Utilities, Data File Display and Maintenance
2. File Name field type, MP0xxx (where xxx = company code)
3. Hit Enter key
4. Click the Key Scan button
5. Select the M/Pxxx record (where xxx = company code)
6. Click, Edit
7. Enter Field Number, 2 and hit Enter key
8. Enter Change Data, enter the current calendar year (example: 2004)
9. Click OK and close the window