• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Has anyone ever used JDE Leadtime Rollup?

[FONT=&quot]Hi everyone,[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Version: JDE Enterprise One[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I am looking into rolling out JDE Leadtime Rollup Program that is found within the Plant Manufacturing Data program (https://docs.oracle.com/cd/E26228_01/doc.93/e21780/appendix_a.htm#WEASP554). Specifically I am looking to calculate Level Lead Time which is shown as using the formula/inputs as seen below (also linked).[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]I pulled all of these variables out and tried to manually recreate what the Leadtime Rollup program calculated but my values aren't even close to what the program calculates. I am confident I have recreated the formula as seen below correctly so I believe this may be a problem of using the wrong inputs.[/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]My question is does anyone know which tables/where each of these variables are being pulled from? For example for the Time Basis Code, does it pull from the Routing Master (F3003) or Branch Master?[/FONT]
[FONT=&quot] [/FONT]
SUMSum of all operations
M or LEither machine or labor hours based on the prime load code
E or MNumber of employees or machines in the work center
EF or UTEfficiency or Utilization from the work center
Cum Yield %From the Routing Master (F3003)
MLQManufacturing lead time quantity
TIMBTime basis
SetupSetup time from the Routing Master (F3003)
Total Queue & MoveQueue plus Move time from routing master or work center
[FONT=&quot] [/FONT]
[FONT=&quot][/FONT]
[FONT=&quot] [/FONT]
[FONT=&quot]Thanks in advance![/FONT]
 

Devo

Well Known Member
Time Basis Code comes from the Routing.

You may want to review Doc ID 1381278.1 - E1: 30: R30822A Understanding Leadtime Rollup
 
Thanks!

Time Basis Code comes from the Routing.

You may want to review Doc ID 1381278.1 - E1: 30: R30822A Understanding Leadtime Rollup
The document answered it thanks!

Below is the answer for anyone else wondering.

M or L - Either the machine or labor based on the Prime Load code of the work center
SUM - Sum of all operations
TIMB - Time basis code from the routing
MLQ - Manufactured Leadtime Quantity from Branch/Plant
E or M - Number of employees or machines in the work center
Setup - From Routing
Queue - Queue plus Move time from routing or work center
EF or UT - Efficiency or Utilization from work center
CUM Yield% - From routing

 
Top