Dynamics GP Smartlist Display Issue - Ghost Column?

(4) Share

Report

Posted on by SE-23091431-0

Has anyone here seen an issue like this? We've had other issues with smartlist around SQL issues that were simpler to solve... this has us stumped.

In the application, when viewing results from any custom or ootb smartlist view, there's a first column that is like a composite key or ID (in the example below it's a concatenation of Docno, soptype, soptype prefix, and customer number).

When exporting to Excel, that column isn't there. Users have been doing that as a workaround for awhile now while we've tried to troubleshoot.

Any ideas?

GP 18.6.1728

Categories:

Microsoft Dynamics GP

I have the same question (0)

All responses (4)

Answers (0)

Sort by

BJ-09051414-0 407 on at

Like (0)

Report
Copy link

Link copied!

Hello,

Couple things I would check first is what columns are included in the Smartlist in SQL. As the screenshot provided is not a core GP Smartlist and appears to be a favorite, we would want to check the ASIEXP86 in the Dynamics Database. Below is a script that you can use.

select * from DYNAMICS..ASIEXP86 where ASI_Favorite_Name = 'Uposted Invoices' -- the name is based on the screenshot.

Now, you will want to review the ASI_Field_Number and ASI_Column_Display_Name to review the columns in this Smartlist to attempt to identify the problem column.

If a number is used in these fields, you then need to use the ASITAB20 table for find more about the column based off the value.

select * from DYNAMICS..ASITAB20 -- ASI Field Definition - Use to link Field NUmber to Field Name in the ASIEXP86.

Next, use the data to determine if there is a problem column in the ASITAB20 and/or the ASIEXP86 table that might point to the problem.

With it exporting to Excel correctly, I am hesitant to say the problem is in the Smartlist Tables. I would “Assume” that if there was a problem in the table it would export incorrectly as well.

This leads me to the next thing that might be a problem. A synchronization issue between your GP client and your dictionaries.

I would go through the Recreate and Synchronization of the dictionaries to make sure this is not causing a problem. I have provided the article below to do this.

Please note, all users will need to be out for this if the dictionaries are shared.

If the dictionaries are not shared, this needs to be done on every machine that has GP installed. I would just test one first.

Re-create the Reports.dic file - Dynamics GP | Microsoft Learn
Re-create the Forms.dic file - Dynamics GP | Microsoft Learn
Reports Dictionary must be upgraded - Dynamics GP | Microsoft Learn – only do #2 in this article which is the synchronization process. I would also add to change the INITIAL and SYNCHONIZATION line in the DEX.ini before doing this step.

Hopefully the above helps.

Thank you!

Was this reply helpful? Yes No
SE-23091431-0 10 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the advice here. I recently upgraded to 18.8.1941 in hopes that the upgrade would help resolve the issue.

I've identified more of the behavior now.
If I run GP Utilities and update modified reports -> select "Smartlist" -> Click "Process" (green check), then Select "Synchronize Reports and Forms" and locate the DYNAMICS.SET file and click "Process" then any ootb or custom smartlist looks correct! Problem solved, right? No.

Upon exit and reopening the application, the view reverts back for the sa user and all other users (we have deployed as a single-install, multiple users).

Does this narrow the potential root cause any further? I've tried "Repair" the installation (using physical media), the steps you listed above (removing the FORMS and REPORTS.DIC files, reimporting the modified reports package, and then "synchronizing" using GP Utilities). This is how I've identified the specific behavior.

Any further help or ideas will be GREATLY APPRECIATED!!

Was this reply helpful? Yes No
BJ-09051414-0 407 on at

Like (0)

Report
Copy link

Link copied!

Hello,

That is some strange behavior. I guess what I would try next is to install a new GP install on a different machine and point it to the current SQL instance and see if the same thing happens. If not, might be a corrupt GP install.

If you used a Custom package installer, do not use this and test with a freshly downloaded installer.

I would suggest again to check the tables that I pointed out in the initial response to make sure there is no problems with the columns. Does not sound like it but we should still check.

Do you have Smartlist Builder? Can you disable this in the Customization Status window and then open Smartlist and see if the issue still occurs? You will likely see two folders when Smartlist Builder is disabled. Test with both to see if one has the issue and one does not as one would be Smartlist Builder and one would be Smartlist Designer.

I hope the above helps!

Thank you!

Was this reply helpful? Yes No
BJ-09051414-0 407 on at

Like (0)

Report
Copy link

Link copied!
Hello,

I ran into something similar recently that might be helpful if you are still seeing the issue. The cause for the similar issue was Smartlist Builder.

Give the following a try and see if this makes a difference.

Open the Customization Status window.

Dynamics GP | Tools | Customize | Customization Status.

Locate and Smartlist Builder.

Click Disable.

Close and open Smartlist if it is open.

Expand the module folder for the Smartlist having the problem.

Locate the Smartlist folder for the Smartlist.

Do you see 2 of the same folder now?

If yes, the first one will be eOnes Smartlist and the second one will be GP Smartlist.

Test with the first folder to determine if the issue occurs.

Test with the second folder to determine if the issue occurs.

If the problem only occurs with the first one, then the problem is coming from Smartlist Builder.

This does not tell you why, but it will now identify where the problem is coming from and can dig into it further.

I hope this helps!

Thank you!

Enavate

Was this reply helpful? Yes No