Options

Configuration Package

MBClarkeMBClarke Member Posts: 71
I need to import my Item master table using the configuration table, and would then like to include the 'Item unit of measure' table as well, so that I do not get validation errors.

Is there a way I can import my Item master and at the same time have that import load into the "item unit of measure' table at the same time?

Thanks

Answers

  • Options
    rfajdigarfajdiga Member Posts: 40
    Hi,

    I usually create one config.package for table 27 and 5404 and export them in one excel (with two worksheets).

    After filling this excel worksheet I save and import both tables to config.package and first apply table 27, and after that table 5404 to don't raise validation errors that one of items are missing.

    Br,
    Renato.
  • Options
    MBClarkeMBClarke Member Posts: 71
    Hi Renato,

    That is what I am trying to avoid, having to populate two separate tables in a package, as I feel if the Item table already knows that the Item unit of measure is related, it should then have the ability to populate that table with data. I do understand that it is not as simple, as the Item unit of measure table could have more than one unit of measure for the same item, and I would assume this is why, but at the same time, it is difficult to have to populate to worksheets for the same info in essence.

    Regards,
    Malcolm
  • Options
    rfajdigarfajdiga Member Posts: 40
    If you enter base unit of measure on Item table it will automatically fill Item unit of measure with value Code = Base unit of measure, Qty per Unit of Measure = 1.

    After that, all other units of measures must be filled into Item Units of Measure table because it is somehow controlled that you don't enter Sales or Purchase Unit of Measure on Item which does not exist in Item units of measure table.

    If you have the same value in sales, purchase and base unit of measure then it is enough to fill only Item table in other cases you should fill Item Units of Measure table.

    Br,
    Renato.
Sign In or Register to comment.