? in the item master Variable Lead Time field
Solution ID = KB-711
Goal : ? in the item master Variable Lead Time field
Version = Syteline6.XX.XX
Module : SLMFG
Fact : INV
Symptom : Lead time is invalid.
Database : Progress
Fix
If an item has a ? variable lead time, it has typically been put
there by the Lead Time Processor utility which calculates the fixed and
variable lead times. The ? variable lead can be caused by the following
reasons:
1) Having a crew size of zero in an operation that uses a work center that is crew scheduled only (not both machine and crew).
For
an operation that uses a crew scheduled work center, the lead time
processor divides the operation's labor hours by crew size to arrive at
the actual duration of the operation so a crew of zero results in ?.
Progress returns a ? when you divide by zero. If you do not use the
Lead Time Processor utility, the ? was probably either manually entered
or the result of data importation.
To find the problem
operations, open the current operation window and browse though the
operations looking for those that have a crew size of zero and which
have "Schedule Driver" of Labor (indicating it is crew scheduled only)
Since you cannot enter a crew size of zero for a crew scheduled
operation, the zero was probably a result of a custom data importation.
2)
Having an operation use a work center that uses a shop calendar that
has zero hours in each day and you answer Yes to "Use WC Calendars"
when you run the Lead Time Processor. When you use that option, the
utility divides various times by the average number of hours per day in
the work center's calendar so having hours of zero will result in
dividing by zero which causes the ? lead times.
3) You are
using a version that contains bug 32070 and are electing to "Use WC
Calendars" when you run the lead time processor. The
bug was that when an operation in an item's current routing uses a work
center that uses a shop calendar in which there are no days with hours
that are greater than or equal to the value in the "Minimum Hrs in a
Workday" on the Planning Parameters screen. The
system only considers days with hours equal to or greater than the
minimum hours parameter when calculating the average hours per day for
a calendar. If all of the days are lower, it returns zero. The lead
time processor was then dividing by that figure at one point when you
elect to "use WC calendars" which results in the ?.
The
fix to 32070 will prevent the ? fixed lead. However, the fix is that
the utility uses zero hours for the operation if no days have more
hours than the minimum. So, if you want the time in the operation in
question to be considered, the best solution would be to lower the "min
hrs" parameter to be equal to or lower than the hours in the shop
calendar in question.
To determine how many items have this problem, the following program can be run from the Progress editor:
for each symix.item no-lock where item.var-lead = ?:
display item.item.
end.
