You’re offline. This is a read only version of the page.
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)
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.
Freddie,
Did you try using a Data Template that defines the Base Unit of Measure? This will 100% resolve your issue.
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.
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.
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
Have you checked that validation is enabled in your configuration package both on field and record level ?
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)
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!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (