Differences in MRP from SyteLine (PROGRESS) to SyteLine (SQL)

SyteLine 7.04 service pack 11 added a new Material Requirements Planning (MRP) function that is based on the MRP function included with SyteLine (PROGRESS). In general, MRP in SyteLine (SQL) is much the same as SyteLine (PROGRESS) MRP. However, some changes were necessary due to the functional differences between the two. This topic lists the differences.

MRP Algorithm in SyteLine (SQL)

The planning algorithm used by MRP in SyteLine (SQL) is almost identical to the algorithm used in SyteLine (PROGRESS). SyteLine (SQL) MRP plans requirements in order by the lowest level in which the item appears in all current, job, and production schedule bills of material. That is, it plans all end items first, then all items at the next level, and so on, backward planning each requirement from the requirement's needed date to the item's lead time, batching together requirements needed at the same period of time. SyteLine (SQL) MRP generates planned orders and exception messages to help you implement an accurate plan.

MRP Business Process

Your process for using MRP should not change significantly in SyteLine (SQL). As in SyteLine (PROGRESS) MRP, you must still run the Current Bill of Material Processor and Job and PS Bill of Material Processor before running an MRP generation to ensure the low-level codes are correct.

SyteLine (SQL) MRP also offers these features found in SyteLine (PROGRESS):

You can run MRP in Net Change or Regeneration mode. As in SyteLine (PROGRESS), Net Change mode plans only those items for which on-hand, supply, or requirements information has changed since the last MRP run (as tracked via the Net Change field on the item record). When you make a change to an item's on-hand, supply, or requirements information, the Net Change field on that item record is selected automatically and that item will be included in the next Net Change MRP run, just as in SyteLine (PROGRESS). Running MRP in Regeneration mode plans all items in the database.

The remaining sections in this topic list the differences in specific forms, fields, and other assorted differences. In some cases, there is not a direct mapping from a SyteLine 6 form or field to an equivalent SyteLine (SQL) concept; however, in most cases, there is some replacement concept.

The tables below list only those screens/forms/parameters that are titled differently in SyteLine (SQL) or are handled through some other function. If the form still exists in SyteLine (SQL) under the same name as in SyteLine (PROGRESS) (such as the Material Planner Workbench), it is not listed.

Form/Screen Differences

SL (PROGRESS) Screen SL (SQL) Equivalent
Planning Detail Display Planning Detail form
MRP Generation MRP Planning form
MRP Order Action Report Order Action Report
Rough Cut Capacity Planning screen (RCCP not brought forward to SL7)
Resource Master (user-defined resources not brought forward to SL (SQL) )
Items with Net Change Flag Set Report Filter on Net Change field on Items form to get list of items with Net Change field set.
Load Planned Orders utility Use the Schedule Planned Orders parameter on the Shop Floor Control Parameters form

Parameter Differences

SL (PROGRESS) Parameter SL (PROGRESS) Screen SL (SQL) Parameter SL (SQL) Form
Mfg and PO Online Planning Parameters Planning Parameters (not brought forward to SL (SQL) ) n/a
CO and Forecast Online Planning Parameters (not brought forward, but this function is supported through the SQL database structure inherently) n/a
Transfers Online Planning Parameters (not brought forward, but this function is supported through the SQL replication functionality) n/a
Whse Considered For Planning Parameters Dedicated Inventory (see About Warehouses for detailed information about how this field is used in MRP planning) Warehouses
Post Planned TOs Planning Parameters (not brought forward, but this function is supported through the SQL replication functionality) n/a
Use JIT Scheduling Planning Parameters Plan Materials at Operation Start Planning Parameters
Use Dynamic Lead Time Planning Parameters Use Scheduled Times in Planning Planning Parameters
Multi-site Group ID Planning Parameters (not brought forward, but this function is supported through the SQL replication functionality) n/a
MRP End Date Job Orders The closest equivalent is the job's Projected date. See help topic titled "About Job Dates" for detailed information about how this field is used in MRP planning. Job Orders

Exception Message Differences

SL (PROGRESS) Exception Message SL (SQL) Exception Message
Reschedule Receipt Move In Receipt

Move Out Receipt
Sched. Receipt Not Needed Receipt Not Needed
Sched. Receipt Past Due Rcpt Projected Late
Sched. Reqmt Past Due Rqmt Projected Late

Related Topics

MRP Overview

MRP Steps

APS Overview