Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

Smartlist Builder - Matched Tables Error

Posted on by

H5353.SLB_2D00_Error_2D00_2.bmp"/resized-image.ashx/__size/500x0/__key/CommunityServer-Components-UserFiles/00-00-00-54-08-Attached+Files/5466.SLB_2D00_Error_2D00_1.bmp" border="0" />

If you choose the 'more info' button you get the message below. 

Thanks
Jennifer

*This post is locked for comments

  • Re: Smartlist Builder - Matched Tables Error

    Hi Leslie

    I looked at SLB11100 and it was missing the Blank_Field_CB field.  So, I exported the data, recreated the table and then imported the data back in.  Now I was able to use the matched tables.

    Thanks

    Jennifer

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    Re: Smartlist Builder - Matched Tables Error

    Hi Jennifer,

    The table they are referring to is the SLB11100 table and it most certainly has the column Blank_Field_CB. Take a look at your physical table just to make sure the column is there. It is the last column in the table, so it is suspect. If your table is indeed missing that column you can export your data to a new table, recreate the SLB11100 table using SQL Maintenance (File > Maintenance > SQL) in Dynamics and then import your data back in.

    Kind regards,

    Leslie

    I have not encounterd this error either and I do have several Matched Tables lists.

  • Mike Smith Profile Picture
    Mike Smith 6,840 on at
    Re: Smartlist Builder - Matched Tables Error

    Hi Jennifer,

    While I haven't encountered this on my v2010 R2 install, I would try refreshing the SmartLists and possibly the cache as well (if you haven't already tried).

    Both of these are under Microsoft Dynamics GP > Tools > SmartList Builder > Maintenance.

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,235 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans