Open Forum

Expand all | Collapse all

Weights & Dimensions

  • 1.  Weights & Dimensions

    Posted 12 days ago
    I am new to Navision and we are currently using NAV 2013 R2, but are in the process of upgrading to NV 2018.
    I would like to record the Weight and Dimensions of our parts in the item card. Does anyone else store the weight and dimensions in the item card?
    I do  not see where these values can be entered, Do I need to make a custom field?

    ------------------------------
    Stephen Peel
    Alliance Concrete Pumps Inc.
    Aldergrove BC
    ------------------------------


  • 2.  RE: Weights & Dimensions

    TOP CONTRIBUTOR
    Posted 12 days ago
    Item Units of MeasureThere are fields for this information on the Item Units of Measure. You may need to show the columns, they may not be on the list by default. To my knowledge these are for information only and do not transfer to any fields on sales orders, shipments, etc.

    Someone else on this forum may be able to provide you where they are used.

    ------------------------------
    Cynthia Priebe MCP, DCP
    Senior Analyst and Project Manager
    Liberty Grove Software

    Join us at User Group Focus in Houston, March 13-14, 2019.

    Woo-hoo! There is a track for Business Analysts this year.

    Join me and my co-panelists and presenters at the following sessions:
    BAN75 - Ask the Analysts
    CFO90 - Ack! My A/P Person Just Left, What Do I Do Now?

    Not for you, check out the other great content at https://www.ugfocus.com/focus/locations/houston/houston2
    ------------------------------



  • 3.  RE: Weights & Dimensions

    Posted 11 days ago
    There is a net weight and gross weight field under foreign trade on the item card. If you establish the net weight prior to setting up a unit of measure then it will feed that value to the weight field on the item units of measure table.

    Adding multiple units of measure will change the weight listed on the item units of measure field based off what the qty. per unit of measure field is set to times whatever the net weight field is set to.

    If you already have a base unit of measure set for an item and you enter a net weight after the fact then the weight field for the base unit of measure on the item units of measure table will not be updated automatically.

    If you have Lanham E-Ship installed then the net weight and gross weight field under foreign trade will be mirrored to the corresponding fields under the e-ship section of the item card.

    ------------------------------
    Trey Kilgore
    Jack Black, LLC
    Carrollton TX
    ------------------------------



  • 4.  RE: Weights & Dimensions

    Posted 10 days ago
    Hi Stephen

    We started on NAV2009 Classic and added bespoke fields for all of our item details (about 30 extra).  Now we are finding that all these extras might get in the way when it comes to upgrading to BC, so we are looking at putting it all in attributes, which may be the way for you too, as it is a standard NAV function that can be added to reports etc.

    Many thanks.

    ------------------------------
    Adam Jones
    Celebration Paper & Plastics Ltd
    Burton upon Trent
    ------------------------------



  • 5.  RE: Weights & Dimensions

    SILVER CONTRIBUTOR
    Posted 9 days ago
    Adam,
    Custom fields are easily handled by extensions and are very simple to convert from a old style mod to an extension.
    Attributes can be tricky as they are stored similar to dimensions as attribute combination values and are not individual fields like your custom fields are.  This can be challenging for reporting and filtering.

    Putting them on the item unit of measure is the best place to put them.

    Kevin

    ------------------------------
    Kevin Fons
    Senior Application Consultant
    Innovia Consulting
    Windsor WI
    ------------------------------



  • 6.  RE: Weights & Dimensions

    SILVER CONTRIBUTOR
    Posted 10 days ago
    In my company this seemed counter-intuitive.  We set the Net Weight (qty of 1) as that of our product (taps, etc.) without its consumer packaging and the Gross Weight of the tap including the consumer box.  Then for multiple qtys (e.g. CARTON or PALLET) of the product, it did as you state; multiplied the Item Card's Net Weight by the Qty. per Unit of Measure which meant it totally ignored the consumer packaging box weight. I therefore changed our system so it used Gross Weight instead for the calculation before we started trying to use that feature properly.

    ------------------------------
    Paul Simpson
    Business Analyst
    Vado
    Cheddar
    ------------------------------