web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Season of Giving Solutions is Here!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Business Central forum / Imported Items using S...
Business Central forum

Imported Items using SQL not appearing

(0) ShareShare
ReportReport
Posted on by dstove 35

Hi,

I've imported my Items table from my NAV 2017 database into my Dynamics NAV Business Central (On-Premise) database using a SQL Query and although the data is in the table, the items page shows no data. I have used this method to move data between versions 2009->2013 and 2013->2017 without any issues, and I have imported various other tables such as Customers, Vendors etc. and the data shows up fine. Is there anything different with the items table?

Categories:
Other
Data Migrations
I have the same question (0)
  • JamesCairath Profile Picture
    JamesCairath 30 on at

    I found solution by myself.

    Its becouse standard Extension, that extend table Item. On background is table Item JOIN ItemExtension it means you must fill both table or uninstall extension

  • JamesCairath Profile Picture
    JamesCairath 30 on at

    Hi Dominic,

    did you solved that problem and how?

  • dstove Profile Picture
    dstove 35 on at

    Yes, I can see the data if I select it in SQL management studio. I've even tried making a new page based on the table and have the same result. If I create a new item in the standard form, it shows up.

    Obviously the id field isn't populated, so I've tried it with a blank guid and I've also tried generating a guid while importing the data. Neither way worked.

  • Stefano Demiliani Profile Picture
    Stefano Demiliani 37,166 Most Valuable Professional on at

    No difference, this works.

    Can you see the data via SQL Server?

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

News and Announcements

Season of Giving Solutions is Here!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Business Central

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans