Skip to Content
avatar image
Former Member

UoM Calculation

Hi Experts,

Kindly help me in UoM calculations (refer attachment).

I want the amount to be calculated based on my UoM.

for example, if i type 1024 qty, it should be treated and calculated as 1. Please let me know how can i achieve this.

Why UoM Code & UoM Name are different.?

why can't i remove the Manual UoM.?

How can i set up UoM in my case?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

11 Answers

  • Feb 28, 2017 at 04:41 AM
    new-picture.jpg

    Hi

    When you say 1024 qty treated as 1 you means in report or in system?

    Why UoM Code & UoM Name are different.?

    It is a matter of defining the codes. Though you can define UOM Codes same as UOM Name and vice versa.

    why can't i remove the Manual UoM.?

    It is a system definition. Though you can stop any one from selecting manual uom via transaction notification.

    How can i set up UoM in my case?

    The best way according to me would be to define a new UOM Group with Kbps as base UOM and define 1 Mbps = 1024 Kbps there.

    Then assign the Kbps group to your Item with Mbps as default UOM.

    This way you can add sales order with 1mbps as sales UOM and items per unit will be 1024 kbps.

    NOTE: It is a good practice to use Unit with lowest possible value as base Unit in a UOM Group

    Add comment
    10|10000 characters needed characters exceeded

  • Feb 28, 2017 at 11:16 AM

    Hi

    This is the best practice for you. see the image.

    Note : Make sure that base UOM = inventory UOM or lowest value as base UOM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 28, 2017 at 01:20 PM

    Thanks for reply Gaurav & Rizki,

    When you say 1024 qty treated as 1 you means in report or in system?

    Yes, i mean in the system not in the report while posting AP/AR transactions.

    for example:

    A 1,024 100 = 100 because 1,024 kb is equal to 1mb.

    Please let me know how can i do this.

    I kept the kb as lowest value and assign in the sale uom as mb, but it is multiplying in the AR/AP transactions.

    A 1,024 100 = 102,400

    How can i make it as 100?

    **selling uom is kb & purchase as mb.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sap B1,

      According to your picture, your setting is still wrong. That's why I gave you my screenshot.

      The point is in your UOM code in sales order. If your UOM code is still manual, it's mean your UOM(Mbps) group hasn't been assigned into your item. Please see my picture carefully.

      Select UOM Code, To distinguish kbps or mbps in marketing document. Not in UOM Name.

      So the scenario for your case :

      1. A/P Invoice

      Item Code | Quantity | Uom Code | Price | Total

      A 1 Mbps 100 = 100

      2. A/R Invoice

      Item Code | Quantity | Uom Code | Price | Total

      A 1024 Kbps (100/1024=0.097) = 100

      Good luck Sap B1 !!!

      Regards,

      Rizki

  • avatar image
    Former Member
    Mar 01, 2017 at 10:39 AM

    Thanks Rizki,

    Please have a look below screen.

    but still the same result i am getting. please suggest me.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sap B1,

      - For UOM Code Mbps use price = USD 100

      - For UOM Code Kbps use price = USD 0.0976 and perform the rounding method.

      Because 1 Mbps and 1 Kbps have different price right?

      Sorry, I just understood what you mean,

      "for example, if i type 1024 qty, it should be treated and calculated as 1. Please let me know how can i achieve this."

      You can only achieve it with different prices.

      Regards,

      Rizki

  • avatar image
    Former Member
    Mar 01, 2017 at 01:37 PM

    Hi, very thanks,

    - For UOM Code Mbps use price = USD 100

    - For UOM Code Kbps use price = USD 0.0976 and perform the rounding method.

    But here there is a point If user enter the price by dividing with respective conversion then what is the need of unit of measure and it's conversion/group in SAP B1.

    In my case, price will be only for mbps, then system should calculate based on uom selection in the transactions.

    Item Code | Quantity | Uom Code | Price | Total

    A | 1024 | Kbps | 100 | = 100

    Please let me know can i solve this.

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 01, 2017 at 01:42 PM

    Hi

    In that case you only need to select Mbps as purchase UOM and Kbps as sales UOM. Unit price will be for 1 Kbps.

    This way when you purchase say 1 Mbps then your inventory will have 1 Mbps*1024 = 1024 Kbps and amount will be calculated as 1*100 = 100

    and when you do sale, the inventory transaction will be like 1024 Kbps = 1024 Kbps and amount will be (100/1024)*1024 = 100

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 01, 2017 at 02:36 PM

    Thanks Gaurav,

    "when you do sale, the inventory transaction will be like 1024 Kbps = 1024 Kbps and amount will be (100/1024)*1024 = 100"

    (100/1024) will be calculated by user or system. if it will be calculated by the system then please send me the screen to refer to solve this.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Sap B1,

      (100/1024) will be calculated by system automatically. You only need to set price in price list of item master data.

      Because of SAP B1 limitation, this gonna a little complicated.

      You can choose among two this option :

      The First Option

      • Set Inventory UOM = kbps
      • Set In price list of item master data = USD 0.0976 / kbps (Depends on your decimal place in general setting)
      • Your inventory report will be displayed with kbps as UOM Code

      The Second Option

      • Set Inventory UOM = mbps
      • Set In price list of item master data = USD 100 / mbps and also kbps with auto tick mark.
      • Your inventory report will be displayed with mbps as UOM Code
      • You only can use this option if your selling quantity is 1024 kbps or its multiplication. such as : 2048, 4096. Because this is sap b1 limitation based on your UOM group conversion. Try by yourself, if you have stock 2 Mbps and then you sell 1200 kbps or 1400 kbps or 1700kbps. What happened? It can't be divided in precision.

      Hope this helps,

      Regards,

      Rizki

  • Mar 03, 2017 at 12:27 PM

    Hi

    Here is the screen shots

    uom-group.jpg

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 06, 2017 at 10:42 AM

    Hi Gaurav,

    Thanks for sharing the screen but the unit price should not be in decimal. Why should user calculate and put the price in decimal it should be calculated by system?

    For Ex: User enter the unit price 100 for 1024 kilobyte (because 1mb=1024kb), so It should calculated (100/1024)*1024 = 100 in the line total.

    How can i achieve this?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 08, 2017 at 08:55 AM

    Hi Experts,

    I am still searching for the solution? Can anyone help me?

    Thanks in advance.

    Add comment
    10|10000 characters needed characters exceeded