Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Item unit of measure t...
Small and medium business | Business Central, N...
Suggested answer

Item unit of measure table & item card

(0) ShareShare
ReportReport
Posted on by Freddie P 12

Hello.

Today we have an old NAV version, 2011 and we are now changing to Business Central.

In NAV when we import an item with the configuration packages (rapid start) in the item table 27, the base unit of measure automatically is set up in the Item unit of measure table 5404, and also the Sales unit of measure & Purchase unit of measure on the item card is automatically filled in based on the Base unit of measure on the item card.

This works also in Business Central when I set up an item manually, but when I try to import one with the configuration packages (rapid start), it doesnt work. I get no line in the Item unit of measure table 5404 and the fileds Sales unit of measure & Purchase unit of measure on the item card remains blank.

I think that there might be something that we missed in the setup that fixes this issue?

Any ideas?

Unfortunatelly our BC consultants doesn't have a clue ablut this even though they alsop set up our NAV originally.

Best regards Fredrik Söderholm Pettersson (not a developer, only super user)

  • Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    RE: Item unit of measure table & item card

    1/ from the additional information, you are missing the put away uom definitely. so you need to figure out a way to resolve this.

    2/ in addition, take a look at the bin policy on the location setup. Check if it's set for default or fixed bin, then make sure the bin content is set up correctly for that problematic item

    3/ also, your put away template doesn't seem right, normally you need system to search fixed bin, same uom etc, but in your case it shows floating bin, which normally is set as a low priority on template.

    4/check the take and putway bins suggested on the putaway. If the bins are not correct, you'll get nothing to handle error as well even you got inventory.

    If you couldn't fix the issue, you could use reclassification journal to move the items to the desired bins as a workaround.

    hope the information helps.

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    RE: Item unit of measure table & item card

    Freddie,

    Did you try using a Data Template that defines the Base Unit of Measure?  This will 100% resolve your issue.

  • Suggested answer
    Freddie P Profile Picture
    Freddie P 12 on at
    RE: Item unit of measure table & item card

    Hi, I actually dont know how to check this. Sorry. Quite new to BC.

  • Freddie P Profile Picture
    Freddie P 12 on at
    RE: Item unit of measure table & item card

    I have tried this, exported a few items from then item card that I know are good and one not working to see if anything is missing, but everthing seems to look the same.

    Except the fields "Sales unit of measure" & "Purchase unit of measure" that are blank because I can't import them Rapid start sauys there is an error so I have to remove the data from these 2 fields to be able to import the item.

  • Freddie P Profile Picture
    Freddie P 12 on at
    RE: Item unit of measure table & item card

    I have tried this, exported a few items from then item card that I know are good and one not working to see if anything is missing, but everthing seems to look the same.

    Except the fields "Sales unit of measure" & "Purchase unit of measure" that are blank because I can't import them Rapid start sauys there is an error so I have to remove the data from these 2 fields to be able to import the item.

  • Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    RE: Item unit of measure table & item card

    it will be easier to check if import and export using excel. you could manually set up an item card with all required information and create a config package to export to excel. then compare with your problematic import to find if anything is missing.

    this seems to be you are missing something from the database where the package is exported from or you missed something when creating the package.

    play with a small set of data and it will be easier to find the issue

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,748 Super User 2024 Season 1 on at
    RE: Item unit of measure table & item card

    Have you checked that validation is enabled in your configuration package both on field and record level ?

  • Suggested answer
    TabrezAjaz Profile Picture
    TabrezAjaz 190 on at
    RE: Item unit of measure table & item card

    I suggest please import all the UOM in the "Unit of Measure" table.

    Later use a Configuration Package that contains your Items, including its UOM corresponding to each item record.

    Please, LIKE & VERIFY. (if you got some idea)

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 4,915 Super User 2024 Season 2 on at
    RE: Item unit of measure table & item card

    If you setup a Data Template (and assign it on your Config Package) which includes the Base Unit of Measure, you'll be able to import the data.  If you have a lot of different Base Units of Measure, you can either import by UOM or import everything with EA, then remove the data template and import with the actual Unit of Measure, this should hopefully correct the issue.

    Another option is to include the Item Unit of Measure table in your Config Package and when you apply the package make sure both tables are part of the application.  This isn't a guarantee, but it is supposed to work.

    Hope this helps!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans