cancel
Showing results for 
Search instead for 
Did you mean: 

Import Items with UoM Group from Excel

Jacqueline
Contributor
0 Kudos

Hi Experts,

does anybody know how to set the UoM Group for an item through SAP internal excel import functionality?

Thanks,

Jacqueline

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Jacqueline,

I don't see any field in OITM as UoM Group. Could you show where you get it?

Thanks,

Gordon

Jacqueline
Contributor
0 Kudos

Hi,

UoM Group is a new feature/field of SAP Business One Release 9.0.

It is stored in OITM Table, Field Name UgpEntry,

Jacqueline

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Did you checked my reply?

Thanks & Regards,

Nagarajan

Jacqueline
Contributor
0 Kudos

Hi Naga Rajan,

yes, I have checked your reply but that don't answer my question.

I try to find out how to set UoM GROUP.

Thats not discribed in the online help of business one, which you have posted here.

Thanks and regards,

Jacqueline

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Yes. You are correct, this is the new field in OITM and it can be linked with OUGP Uom Group table.

I have verified 9.0 online help, there is no field for UoM Group in the excel.

Also this field is not added in DTW template. (Refer SAP note 1874004)

Better check with SAP support

Thanks & Regards,

Nagarajan

KennedyT21
Active Contributor
0 Kudos

Hi Jacqueline Wutke

Use the Below field for UOM

Unit of Measure for Purchasing - 5 - Alphanumeric

Unit of Measure for Sales - 5 -Alphanumeric

Hope helpful

Regards

Kennedy

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi,

Please refer complete information:

Preparing a Microsoft Excel Import File for
Items


The following fields for items can be imported into
SAP Business One and can therefore be contained in the Microsoft Excel file:


Field Name

Max.
Length

Data
Type

Item No.

20

Alphanumeric

Item Description

100

Alphanumeric

Description in Foreign Lang.

100

Alphanumeric

Group (1)

20

Alphanumeric

Bar Code

16

Alphanumeric

Tax Definition

1

Y – Liable to pay tax

N – Not liable to pay tax

Entries must be upper case.

Price List Code (3)

6

Numeric

Price in the Price List

17

Numeric

Currency of the Price List

3

Alpha (in accordance with the defined currencies in
SAP Business One)

Sales Account

15

Alphanumeric

Expense Account

15

Alphanumeric

Regular Vendor (4)

20

Alphanumeric

Vendor Catalog Number

17

Alphanumeric

Unit of Measure for Purchasing

5

Alphanumeric

Quantity per Purchase Unit

20

Numeric

Unit of Measure for Sales

5

Alphanumeric

Quantity per Sales Unit

20

Numeric

Target Warehouse Inventory in Purchasing
Unit

20

Numeric

Minimum Warehouse Inventory

20

Numeric

Purchasing Item (5)

1

Y – Yes

N – No

Entries must be upper case.

Sales Item (5)

1

Y – Yes

N – No

Entries must be upper case.

Warehouse Item (5)

1

Y – Yes

N – No

Entries must be upper case.

Fixed Assets

1

Y – Yes

N – No

Entries must be upper case.

Brand (6)

30

Alphanumeric

Customs Group (7)

20

Alphanumeric

Sales Factor 1

20

Numeric

Sales Factor 2

20

Numeric

Sales Factor 3

20

Numeric

Sales Factor 4

20

Numeric

Purchasing Factor 1

20

Numeric

Purchasing Factor 2

20

Numeric

Purchasing Factor 3

20

Numeric

Purchasing Factor 4

20

Numeric

Additional fields are available for importing
information on length, width, height, weight and volume. You can also import the
packaging unit and the quantity per packaging unit for an item.

Re (1)

If the imported group has not been defined in the
system yet, the system automatically creates a new group.

Re (2)

If items that are liable for tax are involved, the
default tax groups for the items defined under G/L account determination are
used.

Re (3)

The price list with this number must already exist
in the system. Therefore, you may have to define the corresponding price list
before the import.

Re (4)

If no master record for the imported regular vendor
exists yet in the system, the system will automatically add it during the
import.

Re (5)

If these fields do not contain entries during the
import, the system automatically adds the master records as purchasing, sales,
and warehouse items.

Re (6)

If the imported brand has not been defined in the
system yet, the system automatically creates a new brand.

Re (7)

The customs groups specified for the import must be
defined in SAP Business One before the import. If one of the customs groups in
the Microsoft Excel table has not been defined in the system, you will not be
able to import the data.
Hope helpful.
Thanks & Regards,
Nagarajan
former_member186605
Active Contributor
0 Kudos

Dear Naga Rajan,

first of all, it is more than good style to specify the real source of your information.
Here you directly copied from SAP online help http://help.sap.com/saphelp_sbo900/helpdata/en/45/0708c7f61941dee10000000a1553f6/frameset.htm. Please check.

Second, it's essential to consider the concrete version where the issue is reported for, and so to mark for which version 'your' solution is valid for.

This helps maximizing the value and credibility of your response and increases reusability.

Thank you that you have picked out the information.

Regards, Peter

kothandaraman_nagarajan
Active Contributor
0 Kudos

Hi Peter,

Same thing, just I was focus on the subject and this provides direct information to the member.

Thanks & Regards,

Nagarajan