• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • 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!

Does JDE Leadtime Rollup work? (R30822A)

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:

OpMLQM or LTIMBE or M SetupMoveQueueEFUTCUM Yield%LT Lvl Formula
11M10001000090%85%100%0
21M100040048150%85%100%2
31M10004000150%85%100%0
41M10001000100%100%100%0
51M100000048100%100%100%2
61M10002008150%80%100%.33
71M10001000100%100%100%0
81M100000040100%100%100%1.67
91M10001000090%85%100%0
101M10001000100%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:

Larry_Jones

Member
Try simplifying it first by setting Efficiency and Utilization to 100%.
Then turn them on 1 at a time to see if that identifies your discrepancy.
 
Top