Skip to Content
avatar image
Former Member

Import Items with UoM Group from Excel

Hi Experts,

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

Thanks,

Jacqueline

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jun 25, 2013 at 11:25 AM

    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
    Add comment
    10|10000 characters needed characters exceeded

  • Jun 25, 2013 at 05:40 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 25, 2013 at 09:10 PM

    Hi Jacqueline,

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

    Thanks,

    Gordon

    Add comment
    10|10000 characters needed characters exceeded

    • 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