35
Hello all:
I'm having issues with the SOP Document Analysis report in GP2013 SP2 (12.00.1482). Some items won't show if I print the report in "Summary", but if I print the same report and with the same parameters, the values come out correctly. **See screenshots with example.
I looked into the tables (SOP30300 and IV30300) to see the data, and it's there. Already Checked Links on Sales and Inventory modules.
Any ideas?
Thanks!
Carlos.
*This post is locked for comments
Carlos,
I know where to find the report in GP.. when it's installed. The thing is that those reports are part of the module 834 in the Dynamics.set file, a dictionary that is definitely not standard part of GP, at least not in recent builds. I checked 2015 to 2018, and it's not there as a dictionary entry.
Though It is now part of the default GP REPORTS.DIC.. somehow this wasn't the case in GP 2013. On my other customer's site, the GP security reflects that as a separate dictionary called TRXREP.DIC.. those are the entries found in DYNAMICS.SET
:C:Program Files (x86)/Microsoft Dynamics/GP2013/TRXREP.DIC
:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/TREP_FRM.DIC
:C:Program Files (x86)/Microsoft Dynamics/GP2013/Data/TREP_RPT.DIC
Thanks Carlos,
This isn't actually specific to the SOP Document Analysis report :-)
I ran into this issues with SSRS, Excel and SmartLists reports too.
Was hoping you could give me some insights of the origine of the reports.. how it gets installed.
Don't worry if you don't know, I'll find out elsewhere.
B@
Hello:
Actually this particular issue was solved and it was related to special characters inserted on the items description on the import process. We created this script to remove the special characters, and the items start to show up correctly on the report:
--- FIX ON SALES TABLES
update sop30300
SET ITEMDESC = rtrim(REPLACE(REPLACE(ITEMDESC,char(13),' '),char(10),' '))
where ITEMDESC like '%'+char(13)+'%' or ITEMDESC like '%'+char(10)+'%'
and ITEMNMBR = 'XXXXXX'
-- FIX ON ITEM MASTER
update IV00101
SET ITEMDESC = rtrim(REPLACE(REPLACE(ITEMDESC,char(13),' '),char(10),' '))
where ITEMDESC like '%'+char(13)+'%' or ITEMDESC like '%'+char(10)+'%'
and ITEMNMBR = 'XXXXXX'
Hi Cafero
Did you ever got to the ground of this problem ?
I've a customer that is running GP 2013 and on their Citrix server they do have this dictionary installed (834 - Transactions Reports) for SOP Document Analysis, but not on their workstations apparently. I know I could simply copy the .DIC files over and add the entry in the DYNAMICS.SET file, but I was wondering from where this module comes.. it's apparently a Microsoft add-on, but it's not part of the regular GP client setup. Do you know where this can be downloaded ?
I couldn't find anything about this special dictionary on the net or in the community forums..
Thanks in advance for your help.
#1
Almas Mahfooz
3
User Group Leader
Share
Report
All responses (
Answers (
