Insights (Business Reporter and Analysis Models, EOI)

HiI have created an accounting structure and wants to use that when loading income statement through business reporter.May I know how can we set that as the ‘default’ to be used when loading income statement through business reporter.

Is there a way to get a list of saved queries (with the query string) from Apps10?How could it be achieved?

Does anyone know why the following SQL doesn't work in IFS? I only seems to work without the last LEFT JOIN and the associated column that I want to bring in at the bottom of my SELECT statement. I’ve verified the column names exist, but unfortunately the errors in IFS point me nowhere. Thanks! WITH FilteredAccount AS (    SELECT *     FROM ACCOUNT     WHERE Company = '4400')SELECT    GEN_LED_VOUCHER_ROW_QRY.Company,    GEN_LED_VOUCHER_ROW_QRY.Voucher_Type,    GEN_LED_VOUCHER_ROW_QRY.Voucher_No,    GEN_LED_VOUCHER_ROW_QRY.Accounting_Year,    GEN_LED_VOUCHER_ROW_QRY.Accounting_Period,    GEN_LED_VOUCHER_ROW_QRY.Voucher_Date,    GEN_LED_VOUCHER_ROW_QRY.Year_Period,    GEN_LED_VOUCHER_ROW_QRY.Account,    GEN_LED_VOUCHER_ROW_QRY.Account_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_B,    GEN_LED_VOUCHER_ROW_QRY.Code_B_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_C,    GEN_LED_VOUCHER_ROW_QRY.Code_C_Desc,    GEN_LED_VOUCHER_ROW_QRY.Code_D,    GEN_LED_VOUCHER_ROW_QRY.Code_D_Desc,    GEN_LED_VOUCHER_ROW_QRY

Hi everybody!Is there some way to set Crystal Report to use OData interface to get data to use in its reports? In other words to use REST API as Crystal Report data source…Thanks in advance   

Hello All,I have a requirement to create a CSV file with the data from a quickreport(select) in IFS9 and write it to a folder everyday. I created a database task and was unable to create the process that creates the CSV file.Regards,Henrique

Hello. My IFS version is IFS Apps 10 Update 16.I’m trying to use the “Send Email” action in a report rule to change the default email that IFS sends when you share a Customer Order Confirmation. I can change the Subject and the Body, but renaming the attachment and changing who the email is from is not working. The attachment retains the default name “CUST_ORD_CONF_REP_#####.pdf” and the From on the email is the default “noreply@blahblahblah.com”. Is there something special you have to do to make those change?Apologies if this is under the wrong sub forum. Wasn’t sure where exactly this fits.

Hi ,IFS recommended to use Access views to export data from IFS Cloud environment hosted by IFS.  The recommended user account is IFSINFO. Now the question is, since most data sources have row level security (Company/site/ HR access) some data are not visible to IFSINFO schema user by default. What is the recommendation here ? Q1.  Should IFSINFO be registered as an employee with supervisor access to fetch all  employee data from access view ? Thanks,Rohana         

How do we see the records in the invoice_attachment table?  I am getting “Query returning data types BLOB/CLOB is not supported.”  I just want to see the company and invoice_id for a specific company.  A previous post mentioned excluding the BLOB/CLOB fields, but not how do to that.  Can someone give me a specific example for excluding those types of fields?

I’ve inserted a chart in a Business Reporter report.  I added the chart as a separate tab.  When I do this, the report doesn’t seem to work.  Are charts only able to be embedded in the same worksheet, not a separate worksheet from the source information?

Hello,how is it possible to change the design time to “NO”? Otherwise the layout cannot be deleted.Thanks in advance,Golo

Hi, is there a course available for Report Designer, Apps10 that anyone is aware of?I’ve looked on the IFS Academy and there is only a training opportunity for Report Designer - IFS Cloud.  ThanksStacy

In my report where I have issues with images I have the standard logotype in the report. It has been added via the Aurena Interface under the tab LOGOS. Furthermore I have added another image to the report. This has been added “IMAGES” with another name.When running the report with the standard logotype in the database the image for the standard logotype is displayed both in the area of the standard logo and in the area of the other image.If I remove the standard logo from the database the other image will be displayed as expected, but I also want to have the standard logo in place, but the standard logo seems to replace other images when it’s stored in the database.Has anybody experienced this issue. Is it a bug?  

Community,We are planning to set up couple flat LCD/LED panels to show the lobby info about inbound/outbound transport tasks and their status. questions:does each panel need a IFS user id?  which lobby out of box will have transport task info? how to set up lobby as the only info on the flat panel? any documentation available?Thank you.

Hi,We have App10m we are getting this error Maytime's and we done most of the recommendations like:Take the initpub backup.Uninstall the crystal services.Re install crystal service from new zip in IFS instance folder (install CWS from IFS Home)Restart the IIS.Retry generating the PDF reportNothing work!!!!We created 8 instances for crystal to make load balance also it’s not working!!!!Also we checked log file and nothing there    

Issue Can not export quick report result to excel if the report have a bind variable and I leave it empty. For example, if I have a where statment like this: where company like nvl('&Company', '%'). If I run the report in IEE and leave it empty it works fine. But if I try to export it to excel I get the error "Stream was not readable".Product Version: Apps10 UPD19  Resolution Identified this as a bug, and this is fixed in APPS10 UPD20.

Issue After upgrade from IFS8 version to IFS Cloud table quick_report_tab has empty rowkey column. With this it is impossible to assign report to ACP package. Resolution Running the below query will solve the issue,UPDATE QUICK_REPORT_TAB SET ROWKEY = sys_guid() WHERE ROWKEY IS NULL; Permanant solution has been implented in 23R1.

Issue When creating a quick report based on query designer and that query does not have parameters, it is not possible to create the quick report.The error message is :11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"8","time":"195915004","category":"CALLSTACK","level":"DEBUG","type":"","text":"__anonymous_block at line 2 QUICK_REPORT_HANDLING_SVC.DO_CHECK_QUERY_DESIGNER_SQL_ACTION at line 939 QUICK_REPORT_HANDLING_SVC.CHECK_QUERY_DESIGNER_SQL_ACTION___ at line 4543 QUICK_REPORT_API.CHECK_QUERY_DESIGNER_SQL__ at line 2807 ERROR_SYS.APPL_GENERAL at line 339 ERROR_SYS.RAISE_APPLICATION_ERROR___ at line 129 ERROR_SYS.RAISE_APPLICATION_ERROR___.FORMAT_CALL_STACK___ at line 123 "}11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"7","time":"195915004","category":"FRAMEWORK","level":"INFORMATION","type":"Framework","text":"Calling method: Server_Log_API.Log_Server_Error_"}11:29:11 TRACE - DATABASE {"origin":"DB","indentation":"8","time":"195915004","category":"FRAMEWORK","level":

Hello! We are having Business Reporter issues where a given report is filtered for one of our “Companies” and the report does not run yet the same report where we have the filter set for two or more of our “Companies” and the report runs… Seems odd to us and we have altered the single filtered company report in a few ways and no go over all. Curious if this could be a software version issue as we are on BR Product Version: 5.0.23 Any thoughts anyone?Thanks

How Can I quickly copy several rows of product codes into sales quotation lines instead of going row by row adding a single product code then waiting for it to populate? I often have 30-60 product codes to fill in.

Hi, I want to create a report which displays the 1. Supplier 2. Invoice Number 3. Amount 4. Cost Element. And it needs to match with the Actual Cost in the Project Navigator, as displayed below. Does anyone know if this is possible and how so?   

Hi, I have added a grouping for repeated column (D Column) in business reporter. It works in design mode but when running the report, it is not working. See the below images for reference.Any idea about how to collapse repeated columns in BR? Before runningAfter Runing 

I am having a hard time figuring out the setup to use elements of a PowerBi report inside a lobby. Is there a guide for this? 

I have the below line in SQL query where the user could write only one company or % for all. Is there a way to enable multiple values like we normally do in any view filter by ;?  I need this to be a parameter variable based on the user input and not fixed in the query itself. COMPANY LIKE NVL('&COMPANY', '%') regardsHousseiny

Hello everyone.Does anyone know? What is the key between the inventory transaction history table and the sales invoice lines. The customer's order_no alone is not enough, because many invoices can be issued to it.

I want to have a Custom context for a user group so I created one . And out of that group I want just one person to have a different lead page than other users .Something like below But when I create it as below . Is there a way to give priority to contexts . To use a logic like this …check the context chamaka is in the page , if not use the context pagero ..cant the context to be page oriented ?