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