SQL SE XRL CONVERSION

We have moved a customer from VFP to SQL SE.

I have been informed by Pegasus that any XRL reports will need to be rewritten for Opera 3 SQL SE.

Does anyone have any quick ways of doing without re-writing the reports as its very time- consuming and they have a large quantity of XRL Reports.

Regards

Darpal

03 Infor Gen Conversational Assistant for PLM Item Impact Analysis.mp4

Find more posts tagged with

Pegasus - Partner General Discussions

Accepted answers

All comments

tcyprys

Hi Darpal - as far as I know, you need to re-write. The table names are listed differently in XRL SE to the VFP version, and some of the filters work slightly differently/have different options available.

I found lining them up side by side and copying the fields and filters etc the easiest way and then amending filters as necessary the best option. Not sure if formatting can be copied across i.e. save as Internal or External Definition on the old report and load them on the new - not tried that as the reports I dealt with didn't have formatting as such.

Tony

unknown

hi im afraid, tont is correct. The table names are different. Even if you save as internal & extrenal definition ect, it filps over to the VFp version

So Ive done exatcly what Tonys done & had both open, as in the VFP verion & made a note/screenshot ofthe XRL formula, then created it in the SQL

Would have been good if there was a conversion!!!

jason-warner

Hi Darpal

We have some fieldnames are different and some fields don't exist , so its not truly like for like!

Regards

Jason

fzw

The only advise I can add is make sure that you are on the latest version. I have logged a lot of calls regarding missing links between tables and missing filters and Pegasus have made a lot of changes which is ongoing.

Hopefully it will get better !

Felicity

unknown

yes I would agree with Felicity!!! XRL doesnt appear to be like for like, eg unit price in the purchase orders is not there!!!

darpal-thiarha

Thank you all for your help , its appreciated.

I also had the following FROM PEGASUS in case this question comes up in the future

We have also been asked about DataSends in XRL and these are not available for SE and, there are no plans to add these.

Regards

Darpal

andy-parker

It is also worth noting that you cannot access any bespoke fields in SE with XRL as you cannot write custom Serducts with SE

alex

I've created a bespoke serduct for a customer on SQL SE.......

alex

That's frustrating as we have a fair few customers using the Data Send to update Special Prices.

dEPM-625-Using dEPM in ION Workflows.mp4

darpal-thiarha

We are struggling with simple reports for example using IT1 ( Itran transactions table ) creating a Summary report we keep crashing as soon as we enter the Line Quantity.

Product=Opera 3 SQL SE Platform=MS-SQL Table=IT1
Error -2147217911 The EXECUTE permission was denied on the object 'pgfnFormatVal', database 'Opera3SECompany00A', schema 'dbo'.

Seems to be the same with other reports where we pick the Quantity fields.

darpal-thiarha

Also, does anyone know how we add a sum to a field ?

kerryh

Hi Darpel

Did you find a solution to the 'EXECUTE permission was denied error on the object 'pgfnFormatVal ...' error you were getting when creating a report on IT Transactions

We are getting the exact same issue when creating a detail report on IT Transactions when we add the line quantity or the goods value field. This happens in 3 companies we have written the report for (migrated from VFP) and also on the Z company (not migrated accross) on customer site but doesn't happen on our own SQL installation

Kerry

alan-bourke

FWIW pgfnFormatVal is a user defined function on the SQL Server database. So it's a permissions issue with EXECUTE on that.

0911060553270289.pdf

kerryh

Hi Alan

Many Thanks for the response, much appreciated.

Hope you don't mind me asking, would you be able to give us any more information to point us in the right direction

Kerry

darpal-thiarha

Hi Kerry

Please could you try and check in SAM > Reporting , Users , Edit the user and check if the role have been assigned, so for example I have the Invoicing SOP processor ticked.

Also, in SQL , Security , Logins , User , Login Properties > User Mapping > I have Opera_SE_Role_Salesprocessor ticked as well.

Hope this helps

Kind Regards

Darpal

kerryh

Hi Darpel

The SAM side was all okay

Have followed your settings within SQL and reports are now working

Many thanks for the information

Kind Regards

Kerry

Copyright © 2025 Infor. All rights reserved.