Skip to content
+1-888-319-3663

COMMUNITY FORUM

SmartList showing corrupted data in field

AXEL E. asked 4 years ago
Hi,
I have this SmartList under Sales – Receivable Transactions where the field “Posted User ID” is showing funny characters instead of the UserID value. This is happening for this field and all reports below the asterisk. 
I checked through SQL the table RM20101 and it shows the value correctly for the same transaction.
How can I correct this?
Thanks,
Erwin
Answers
Patrick Roth Staff answered 4 years ago
I think there was a bug on this that was fixed in more recent builds of SLB.  SO you might try updating your version of SLB to the newest version to match the GP version you are running.
however the underlying issue is that the query generated by SLB (or in a view if it Receivables Transactions) is creating NULLS for this data.
Dexterity itself doesn’t work with NULLS well and sometimes will then display odd characters if it encounters them in smartlist.
So the solution would be to make sure that the query generated by SLB doesn’t return nulls.
you can check this by turning on the dexsql.log and capturing that query and running in SSMS.
if you see a string field in the query such as Posted User ID and it returns NULLL in SSMS, then I can see that you’d get issues like this.
Resolution depends on whether or not this is something you can control or else the app controls and so if you can change the query or results to no longer return NULL values.
patrick
AXEL E. replied 4 years ago

Good morning Patrick,

Thanks for your response! I will check on this with our VAR and will post the results. We’re running GP 2015. I’m not sure if our SLB version is the latest but it worth a try.

The lists that I’m having a problems are the packed one from Dynamics. Not one created from scratch by us. I checked through SQL the data stored in this field for the same records shown with the error in SmarftList and they do have the UserID correctly (we don’t use special characters in our user id’s). Now, I noticed some records with no data at all for this field. Could it be that once it read one of these records with the empty field, the rest of the records are displayed incorrectly?

Regards,

Erwin

Patrick Roth Staff replied 4 years ago

Verify that your SLB 2015 is the latest – it probably isn’t the latest as we just released a new version last week for GP 2015 R2.
Hopefully you are on R2.
Once you load the new versions, run the “Create Views” process in SLB and it’ll drop & recreate your SQL slb views and should fix the issue.

AXEL E. replied 4 years ago

You’re right. We have the previous version 14.00.0223. We will do the upgrade right away. As soon as I have the results I will post back. Thanks!!

AXEL E. replied 3 years ago

Hi Patrick,

The problem returned under the same SmartList (Sales >> Receivables Transactions). I’m getting garbage data under Customer Name and Country.

I upgraded SmartList Builder to the latest version according to my Dynamics Gp version (GP-2015 R2). I ran all maintenance options including “Create Views” but the problem remains.

Is there anything else that I can check?

Thanks!

AXEL E. answered 4 years ago
Hi Patrick,
The upgrade did the magic!! I didn’t have to run the Create Views. Once I installed the upgrade I went into SmartList and the data showed up correctly.
Thanks for your help!
Regards,
Erwin
AXEL Erwin answered 3 years ago
Hi Patrick,

The problem returned under the same SmartList (Sales >> Receivables Transactions). I’m getting garbage data under Customer Name and Country.

I upgraded SmartList Builder to the latest version according to my Dynamics Gp version (GP-2015 R2). I ran all maintenance options including “Create Views” but the problem remains.

Is there anything else that I can check?

Thanks!
Gerry Weiler replied 3 years ago

We just ran into the same issue on a Purchasing SL. We’re on GP 2015 R2 SLB v. 14.00.0223
The native GP SL Receivings Line Items is returning garbage characters for Vendor ID and Vendor name. the underlying SQL view (ReceivingsLineItems) returns correct data for the same transactions.
Need some suggestions ASAP please.


If you would like to submit an answer or comment, please sign in to the eOne portal.