Skip to main content
Microsoft Dynamics NAV forum
Answered

Should I Insert Records into the [Item Attribute Value Mapping] table that don't have a corresponding record in the [Item] table

editSubscribe (0) ShareShare
ReportReport
Posted on by 30

Hello,

We transitioned to Dynamics NAV 2018 from another ERP and we have a lot of old items that we didn't want to import to Nav because they were no longer being sold but we still need them for historical reporting. We could import and block them but we want as little clutter as possible on the items list page.

Effectively, I wanted to add item attributes for these items in Nav without setting up an item card and I noticed that Nav will let me import records into the [Item Attribute Value Mapping] table even though the item does not exist as a separate item card. Even though I'm able to do it I wanted to know if it is a good idea or if I am playing with fire.

The only downside to my method that I have seen thus far is that I cannot use the Filter by Attributes button on the items page when trying to filter by an attribute that is assigned to at least 1 non-existent item.

I get the message "The Item does not exist. Identification fields and values: No.=xxx"

Maybe it is better to create a separate table within Nav to hold these items and attributes? Seems like it would require a lot of customization to union the secondary item attributes table with the original for all reports, queries, pages, etc.

Appreciate any advice.

  • Verified answer
    rmccarty Profile Picture
    rmccarty 30 on at
    RE: Should I Insert Records into the [Item Attribute Value Mapping] table that don't have a corresponding record in the [Item] table

    Thanks for the info. If anyone is curious I got an answer in the dynamic users forum thread here.

    dynamicsuser.net/.../should-i-insert-records-into-the-item-attribute-value-mapping-table-that-don-t-have-a-corresponding-record-in-the-item-table

  • Verified answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: Should I Insert Records into the [Item Attribute Value Mapping] table that don't have a corresponding record in the [Item] table

    Hello  - We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist.  If you need assistance with debugging or coding I would recommend discussing this on one of our communities.

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    I will open this up to the community in case they have something to add.

Helpful resources

Quick Links

What Motivates a Super User?

We know many of you visit the Dynamics 365 Community and Power Platform…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,045 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,570 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Product updates

Dynamics 365 release plans