Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Inventory Transactions...
Microsoft Dynamics GP (Archived)

Inventory Transactions SmartList - Source Reference Number

(0) ShareShare
ReportReport
Posted on by Jim Lines 2

Greetings,

I have a couple corrupt record fields that are preventing me from exporting my Inventory Transactions SmartList.  In the attached screen shot, you can see there are 2 records that have random characters in the Source Reference Number field.  I've run into the issue in the past where Excel throws an error trying to export records that contain random symbols/characters.  My problem is that I cannot find the table/field that contains that data to attempt to correct.  

The only place I found anything similar is the SRCRFRNCNMBR field in IV30200, but that wasn't helpful. 

Does anyone know where I can find the field?

Thanks.

Jim

2016_2D00_06_2D00_15_5F00_15_2D00_16_2D00_10.jpg

*This post is locked for comments

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: Inventory Transactions SmartList - Source Reference Number

    Jen - Thanks!  I'd never heard of that dex.ini switch (probably b/c I never needed it!).  We're going to give it a try as we have another SL with a problem too.  Our developer is working to find a fix for the corrupt data.  

    Regarding your other question, this is the out of the box Inventory Transaction - the title bar was showing the favorite.  But I did investigate that one too.  

    Thanks for your time!

    Jim

  • Jen Kuntz Profile Picture
    Jen Kuntz 3,220 on at
    RE: Inventory Transactions SmartList - Source Reference Number

    One thought - to see if you can get around the export issue might be to add a dex.ini switch "enhancedsmartlistexport=true" which may allow it to export. It more or less doesn't try to format anything in excel so sometimes things export that don't without the switch enabled. That doesn't resolve the data issue of course but may get you moving forward for now.

    Second thought. I can't tell from your screen shot exactly but is this a custom smartlist or the out of the box Inventory Transactions smartlist? The title on the screenshot looks different and I can't tell if it's the favourite name or a smartlist object name.

    If it's custom (in smartlist builder or something), perhaps look at that in smartlist builder (or whatever tool it's built with), to verify the table and field it comes from. I've seen people change column names in smartlists so what you see displayed isn't the actual field name in the table and that often throws you off when looking for the underlying data.

  • Jim Lines Profile Picture
    Jim Lines 2 on at
    RE: Inventory Transactions SmartList - Source Reference Number

    Thanks Leslie!  I'm not having any luck.  The transaction originated in SOP and has been posted.  I've checked the SRCRFRNCNMBR  in IV30200 and and in SEE30303 and it just shows blank.  Any ideas how to troubleshoot this one?

    Thanks!

    Jim

  • Verified answer
    L Vail Profile Picture
    L Vail 65,271 on at
    RE: Inventory Transactions SmartList - Source Reference Number

    Hi,

    It also appears in the IV10000 (unposted transactions) and the SEE30303 (for the HITB report)

    Kind regards,

    Leslie

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