Wrong Gross Weight in Delivery

[Former Member]

Dear SAP Gurus

When I make delivery against the order for a product, the batch determination does batch split correctly, picks batches on FEFO basis and populates the Delivery Qty as per availability. But it doesnt calculate the Gross weight for Delivery Quantities correctly. This happens randomly for all or some of the subitems. A scenario is below:

An SO has an Product "A" of 100 cartons. Whe delivery is made, the batch determination does batch split. Say 5 batches are availbel of 20 cartons each. 20 cartons are picked from each batch. Now , the Gross wieght/Unit in Material master for "A" is 1.081 Kg, volume 0.863 CCM  and conversion is as below :

240	EA	each	<=>	48	L
10	CAR	Carton	<=>	48	L

The gross weight that is calculted by the system for each sub item should be 20*1.081*4.8=103.776 KG, but it always misses out the Gross wieght/Unit and gives the wrong Gross wieight 96 Kg.

This happens randonly for all subitems, for few (last 2 subitms).It happens for some SKUs and not for all.

The checklist I have checked is :

1. Delivery qty picked automatically

2. The Conversions that are picked in SO.

3. Deleted the automatic Batch split and did the batch split manually. Still the weights comes wrong.

Please help me resolve this issue

[Former Member]

Hello Akber,

I have seen the snap you attached and as you told, you produce the finished Goods in Cartons and you sale it in carton then why are you keeping Base UOM as Liters.

In my opinion, maintaining BUOM for this product as Carton will solve your problem.

Regards,

MR

[JL23]

IS-OIL is a special industry solution from SAP to cover the needs of Oil and Gas industry.

Many OSS notes with bug fixes especially in the area of gross weight calculation in delivery notes are related to this relatively new Industry solution.

Catch weight is an industry-specific function for the food industry to carry out processes with independent units. this is another big area which has a lot OSS notes with bug fixes.

As you already see, I think it is caused by a bug.

From personal experience I would rather suspect the error in own coding in user exits than in SAP coding.

[Former Member]

Thanks ,

We are an FMCG, with dairy business. As im not accustomed to the OSS notes area, can you please guide me to some OSS notes relevant to my issue here.

Also about the catch weight function , i need some link where i can get information.

Can you please elaborate your last point "the error in own coding in user exits".

Waiting for your reply.

Regards

Akber

[JL23]

for OSS access and note search I suggest you approach your Basis team. It does not make much sense to post OSS numbers if you cannot access them, and posting of the entire note is forbidden.

I will not help you anyway, as bug fixes have to implemented in SAP, and for this you need to have access to download the notes anyway.

And finding information for catch weight management is very easy by using Google.

Just type: catch weight management site:help.sap.com

[Former Member]

Jurgen

CAn you please suggest a solution from your area of expertise as to why system is doing this . Ill be grateful

[JL23]

I think you missed some data in your material master maintenance.

You did not say what your base unit is.

If you go into the alternative units then you can maintain a gross weight for each alternative unit. if you never saw the gross weight field there, then you should scroll to the right, there are much more fields than the few fields that are shown directly.

if do not maintain a gross weight to all alternative units. then gross weight from the base unit is used to calculate the gross weight for the alternative. (using the rule of proportion)

you said it calculates to 96, this is telling me that you do not have the tare weight included to your gross weight.

Further, keep in mind, that a change in material master does not affect existing sales orders and deliveries. Those existing orders have to be changed manually

[Former Member]

Hi Jurgen,

The Base Unit is Literes while Order Unit is Cartons. In the material master, in additional data Unit of Measure tab, the conversions are below

1	L	l	<=>	1	L
2,400	EA	each	<=>	480	L
100	CAR	Carton	<=>	480	L

For the 1st line above, when i scroll to the right,  the volume and gross weight is given 0.863 CCM and 1.081 KG (this is copied from the Main data Gross weight/EANs  I guess). No Gross weigh is there for 2nd or 3rd line.

What is tare weight ?

Yes i know i have to make new orders for the changes  in material master.

Waiting for your reply

[JL23]

net weight is the weight of the product

tare weight is the weight of the packaging

gross weight is total weight of product and packaging

let us assume you sell beer.

1 L  - would be 1 kg net and 1 kg gross weight, as this unit does not include any packaging

1 BOT - would 1 L beer + the glass bottle, hence 1 KG + 200 gr for the bottle, hence a gross weight of 1.2 kg

1 Box with 20 bottle berr would be 20 * 1 kg for the beer, + 20 * 200 gr for the bottles, + 1 box of 1 kg, so in total 20 + 4 + 1 = 25 kg

if you never never sell beer without bottle and you always sell in boxes and not single bottles, then you could just maintain a gross weight of 1.25 at the 1 L unit

because of the proportion calculation, SAP would always determine the 25 kg if you sell in boxes.

But if you sell bulk, bottles and boxes using the same material number, then you would maintain per unit a different gross weight.

if you sell in bulk you do not have any packaging, so net and gross is just equal with 1 KG

if you sell in bottles, then you have a gross weight of 1.2 kg per bottle

and if you sell boxes, then you enter 25 kg gross weight per box.

As your gross weight was calculated with 96, I assume that the sales order was created before the correct gross weight was entered in the material master. OR someone had manually overwritten the gross weight in the sales order item detail. Please check your change history of material master and sales order and delivery to get the full picture.

[Former Member]

Hi Jurgen,

Thanks for your valuable comments.

Our business sells Milk in cartons. One example is an SKU of 200 Ml below. The Base unit is "L", as the milk is made in Litres and packed in pieces and then in cartons.24 Pieces "EA"of 200 ML are packed in 1 carton "CAR".

Quality team gives us the Avg weight of 1 carton (of 200 Ml SKU) as 5.26 KG.  Below are the conversions (1st snapshot). It shows that 1 litre has a gross weight of 1.081 KG. Then after seeing your remarks I have put the gross weight of 1 "EA" and 1 Carton.

The conversions that i have carefully calculated are also given below  as per L, EA and CAR.

SKU	Average weight/CAr (Kg)	Pieces/CAR(EA)	Gross weight/Piece(KG)	Ltrs/Piece (L)	Tare weight/Piece(KG)	Pieces/L (L)	Gross weight/L(KG)	Tare weight/L(KG)	Pieces/CAR(EA)	Weight/CAR(KG)	Tare weight/CAR(KG)	Liters/Car(L)
200 ml	5.260	24	0.219	0.2	0.019	5	1.096	0.096	24	5.260	0.460	4.8

Now when i make an order after changing material master, i make of 946 cartons and then when i make the delivery, the automatic batch determination calculates the wrong gross weight per carton  for the last subitem(shown below snapshot).It should be 230.335*5.26= 1211.562 KG.

Since we deliver the carton, which are sold in whole numbers and not in decimal, I delete the subitems and do batch split manually and then copy the batches as per availabilty. Now when i see the Gross weight per carton  for subitems it gets worse (snapshot below) and scary. Gross weights gets equal to Volume.

Im Stuck badly!!!

[JL23]

can you please go into your sales order item

go into the detail and there to the shipping tab

what is the gross and net weight there?

[Former Member]

Its 4,975.960 KG and 3,918.332 CCM. The gross weight 4,975.960 KG = 946 CAR * 5.26 KG/CAR. This 5.26KG is the gross weight of 1 car that i put in mat master

Whereas the delivery is calculating different weight initially (after automatic batch det) 4,870.009 KG.

When i delete the auto batch det and split batches manually to get cartons as whole number then the gross weight for 946 cartons becomes 4,540.793 KG

[JL23]

are you in IS-OIL? or do you use catch weight solution?

[Former Member]

Wha tis IS-OIL? CAtch Weight solution?