2072276 - KBA_33989...
 
Notifications
Clear all

2072276 - KBA_3398921 Purpose of two fields for each dimension (height, width, length, and weight) in OITM table

1 Posts
1 Users
0 Likes
39 Views
admin
Posts: 309
Admin
Topic starter
(@admin)
Prominent Member
Joined: 2 years ago

Symptom

When you query the OITM table, you notice that, for the sales and purchase UoM, there are two fields for the same dimension of Length, Width, Height and Weight:

SHeight1, SHeight2, SWidth1, SWidth2, SLength1, Slength2, SWeight1, SWeight2 (sales units)

BHeight1, BHeight2, BWidth1, BWidth2, BLength1, Blength2, BWeight1, BWeight2 (purchase units)

 

Solution

On the Item Master Data, in the Sales Data and Purchasing Data tabs, you have the option to input one or two units for the same UoM dimension for length, width, height and weight.

For example, for an item whose weight is 1.5 kilograms, the user can record the item's weight as either 1.5 kg (one unit) or 1 kg 500 g (two units).

If you input 2 units, (see next 2 screenshots) the information in the OITM table will be recorded in fields 1 and 2 for the relevant UoM dimension.

If you input only one unit, (see next 2 screenshots) the information in the OITM table will be recorded in field 1 only. Field 2 will display a zero value.

As of SAP Business One version 9.0 the information is displayed in the same format in table ITM12.

You can notice similar fields in tables holding row data for various documents.

Reply
Share:
x Logo: Shield Security
This Site Is Protected By
Shield Security