Skip to Content
avatar image
Former Member

TLB calculations

Hi,

we are facing following issue in TLB calculation. One product is there having following data: Base Unit of Measure is EA.

1 EA = 5.44 OZ ( gross weight)

1 CS= 12 EA = 4.55 LB (gross weight)

1 PAL= 1848 EA (154 PAL) = 730 LB.(gross weight)

I have a deployment confirmed order for 1540 CS (10 PAL). TLB profile is defined with max limit as 11 PAL and weight is 7300 LB. When i run the TLB, TLB order is created for 10 PAL which is correct. But the weight is showing as 1540X12X5.44/16=6283.2 LB. ( 1 LB= 16 OZ) Here ideally the weight should be 7300LB but system is showing the weight after converting into EA and taking weight from EA.

If we reduce the maximum weight is less than 7300 LB say 6500 LB,but still system is creating order for 10 PAL as the total weight is calculating as above and it is coming to 6283.2 LB.

Any one come across this issue?

Thanks

Akthar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Dec 10, 2009 at 07:52 PM

    Hi Akhtar,

    Little confusion....

    What is your questions?

    1. Why system is not calculating 7300 LB? or

    2. Why system is considering EA?

    As you have defined BUM as "EA" all alternative UoM will get converted to BUM. So when you place order of 1540 CS (10 PAL) System calculates 10 PL = 18480 EA = 6283.2 LB which is still well within the max limit of 6500 LB or 7300 LB which is correct. You have not yet consumed you capacity.

    Now consider you maximum capacity is 7300 LB than create a deployment order with more than 11 PAL and then run TLB system should split this order into two. One with full capacity consumption of 11 PAL or 7300 LB and other partial consumption.

    If you want every thing to be calculated in CS than change BUM to "CS".

    Hope I am able to clear your doubt.

    Regards,

    Harshil Desai

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Aktar,

      I think in this case you need to review the gross weight maintained.

      If 1PAL= 730 LB = 1848 EA then 1 EA = 0.395 LB = 6.32 OZ

      I don't see any reason system is calculating incorrect weight....

      Regards,

      Harshil Desai

  • avatar image
    Former Member
    Dec 11, 2009 at 09:34 AM

    Dear Akhtar ,

    How system calculates

    BUOM is EA

    TLB profile defined in

    Pallet = 11 PAL ( Max)

    Weight = 7300 lbs ( Max)

    Now TLB created for 1540 CS which is equivalent to = 18480 EA

    which is equivalent to = 100531.2 Oz

    which is equivalent to = 100531.2/16= 6283.2 lbs.

    System has calculated correctly as per your definition .

    Now there is a mismatch between your assumtion and the system result .

    You defined 1 EA = 5.44 OZ is correct then the above calculation holds good then your third line is contradicting your line 1.

    i.e. 1848 EA equivalent to 730 lbs

    1 EA equivalent to 730/ 1848 lbs = 0.395 lbs

    1 Ea equivalent to 0.395 * 16 Oz = 6.32 OZ

    Now can you see on one hand you have defined 1 EA = 5.44 OZ in line 1 and on the other hand in line three you have defined 1 EA = 6.32 OZ ( indirectly)

    so kindly make the two lines consistant

    if 1848 EA= 730 lbs is true then in the first line make it 1 EA=6.32 OZ

    or if 1 EA= 5.44 OZ is true then in the third line make it 1848 EA=628.32 lbs

    You need( should ) not mention a conversion factor between EA and lbs in the second line at all if you want to then it should also be consistant with your assumption.

    Hope it helps

    Thanks

    Debsankar Das

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Any one got this issue previously. SAP says that this is system design that TLB converts the quantities into base unit (here EA) and provides the weight. If TLB creates an order for 1000 Cases,weight should be reflected as 1000 X gross weight of each cases. But it is appearing as 1000 X no of EA per case X weight of each. Similarly for pallets also.

      We cannot change the base UOM now as R/3 is already implemented with Base unit as EA.

      Thanks

      Akthar

  • avatar image
    Former Member
    Dec 16, 2009 at 08:16 PM

    issue is resolved.

    Add comment
    10|10000 characters needed characters exceeded