Does JDE Leadtime Rollup work? (R30822A)

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:

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:
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.
 
Hello, I have tested it and JDE Leadtime Roll-up works correctly as expected. Please use the formula (sample file loaded in this chat).
Thanks,
Vinay
 

Attachments

  • Leadtime calculation.pdf
    733 KB · Views: 8
Back
Top