helpmewithjdeplease
Member
Hi everyone,
I am trying to figure out how JDE Leadtime Rollup (https://docs.oracle.com/cd/E26228_01/doc.93/e21780/appendix_a.htm#WEASP552) runs.
I have ran the program with a sample set of parts, however I am not able to recreate the programs calculations manually therefore I'm not sure if the program is running correctly.
Formula is in that first link (sorry not sure how to put an image)
Here are the inputs I am using and where they are pulling from:
Link showing where they should pull from(https://support.oracle.com/epmos/fa..._afrWindowMode=0&_adf.ctrl-state=xpycgxlw9_53)
M or L - Either the machine or labor based on the Prime Load code of the work center - pulling from F30006
SUM - Sum of all operations
TIMB - Time basis code from the routing - pulling from F3003
MLQ - Manufactured Leadtime Quantity from Branch/Plant – pulling from F4102
E or M - Number of employees or machines in the work center - pulling from F30006
Setup - From Routing - pulling from F3003 which is the routing file
Queue - Queue plus Move time from routing or work center – pulling from F3003
EF or UT - Efficiency or Utilization from work center – pulling from the F30006
CUM Yield% - From routing – pulling from F3003
Here is the data for one item:
So with the formula column added up I calculate a LT Lvl of 6 when the program calculates a Lvl LT of 15. Does anyone know why?
I know this is a lot so thank you in advance!
I am trying to figure out how JDE Leadtime Rollup (https://docs.oracle.com/cd/E26228_01/doc.93/e21780/appendix_a.htm#WEASP552) runs.
I have ran the program with a sample set of parts, however I am not able to recreate the programs calculations manually therefore I'm not sure if the program is running correctly.
Formula is in that first link (sorry not sure how to put an image)
Here are the inputs I am using and where they are pulling from:
Link showing where they should pull from(https://support.oracle.com/epmos/fa..._afrWindowMode=0&_adf.ctrl-state=xpycgxlw9_53)
M or L - Either the machine or labor based on the Prime Load code of the work center - pulling from F30006
SUM - Sum of all operations
TIMB - Time basis code from the routing - pulling from F3003
MLQ - Manufactured Leadtime Quantity from Branch/Plant – pulling from F4102
E or M - Number of employees or machines in the work center - pulling from F30006
Setup - From Routing - pulling from F3003 which is the routing file
Queue - Queue plus Move time from routing or work center – pulling from F3003
EF or UT - Efficiency or Utilization from work center – pulling from the F30006
CUM Yield% - From routing – pulling from F3003
Here is the data for one item:
| Op | MLQ | M or L | TIMB | E or M | Setup | Move | Queue | EF | UT | CUM Yield% | LT Lvl Formula |
| 1 | 1 | M | 1000 | 10 | 0 | 0 | 0 | 90% | 85% | 100% | 0 |
| 2 | 1 | M | 1000 | 4 | 0 | 0 | 48 | 150% | 85% | 100% | 2 |
| 3 | 1 | M | 1000 | 4 | 0 | 0 | 0 | 150% | 85% | 100% | 0 |
| 4 | 1 | M | 1000 | 1 | 0 | 0 | 0 | 100% | 100% | 100% | 0 |
| 5 | 1 | M | 1000 | 0 | 0 | 0 | 48 | 100% | 100% | 100% | 2 |
| 6 | 1 | M | 1000 | 2 | 0 | 0 | 8 | 150% | 80% | 100% | .33 |
| 7 | 1 | M | 1000 | 1 | 0 | 0 | 0 | 100% | 100% | 100% | 0 |
| 8 | 1 | M | 1000 | 0 | 0 | 0 | 40 | 100% | 100% | 100% | 1.67 |
| 9 | 1 | M | 1000 | 10 | 0 | 0 | 0 | 90% | 85% | 100% | 0 |
| 10 | 1 | M | 1000 | 1 | 0 | 0 | 0 | 100% | 100% | 100% | 0 |
So with the formula column added up I calculate a LT Lvl of 6 when the program calculates a Lvl LT of 15. Does anyone know why?
I know this is a lot so thank you in advance!
Last edited:
