Skip to Content
0

UoM Calculation

Feb 27, 2017 at 12:21 PM

219

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

11 Answers

Gaurav Bali Feb 28, 2017 at 04:41 AM
0
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


new-picture.jpg (40.7 kB)
Share
10 |10000 characters needed characters left characters exceeded
Rizki Wicaksana Feb 28, 2017 at 11:16 AM
0

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


uom.png (138.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
J Srinivas Feb 28, 2017 at 01:20 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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

0
J Srinivas Mar 01, 2017 at 10:39 AM
0

Thanks Rizki,

Please have a look below screen.

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


uom.jpg (245.4 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

Yes, the scenario is the same but result i am getting different as you see in the above screen.

0

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

0
J Srinivas Mar 01, 2017 at 01:37 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Gaurav Bali Mar 01, 2017 at 01:42 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
J Srinivas Mar 01, 2017 at 02:36 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left 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

0
Gaurav Bali Mar 03, 2017 at 12:27 PM
0

Hi

Here is the screen shots

uom-group.jpg


uom-group.jpg (175.4 kB)
Share
10 |10000 characters needed characters left characters exceeded
J Srinivas Mar 06, 2017 at 10:42 AM
0

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?

Share
10 |10000 characters needed characters left characters exceeded
J Srinivas Mar 08, 2017 at 08:55 AM
0

Hi Experts,

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

Thanks in advance.

Share
10 |10000 characters needed characters left characters exceeded