Insights (Business Reporter and Analysis Models, EOI)

 You can ask anything you wonder about IFS 10 Lobby. I can answer any questions you may have about IFS 10 LOBBY. Element design, data design, where patterns, references, page creation, authorization, etc. I would be happy to help.

Hi everybody ,I’m new by using IFS ERP and as Data analyst I need the list of tables/views and also the relationship between tables (Foreign keys ) like the Schema  !Regards 

Hello IFS Community, Can somebody point me to the best path to find solution to the following issue?I am running Crystal Report XI R2  and my  IFS 9.  

Hi,We use IFS Cloud 21.2.11 on Managed Cloud and Power BI desktop connect to Power Bi Cloud.Is it possible to read IFS data from Power BI ?If yes, do you have a documentation ?Regards, Christophe  

How I can schedule quick report on particular day of month and share same to the user in a mail? 

Hi all,I am getting the following error while opening the Business Reporter. Any suggestions to resolve this issue? ************** Exception Text **************System.Runtime.InteropServices.COMException (0x80004004): Operation aborted (Exception from HRESULT: 0x80004004 (E_ABORT))   at Microsoft.Office.Core.COMAddIn.set_Connect(Boolean RetValue)   at Ifs.Application.ExcelReporter.AddInManager.GetConnectionAddInObject()   at Ifs.Application.ExcelReporter.AddInManager.SetConnectionAddInProperty(String name, Object[] values)   at Ifs.Application.ExcelReporter.ReportLoaderOperations.PerformBasicValidationOnLoad()   at Ifs.Application.ExcelReporter.ReportLoaderOperations.LoadReport(IUiCallback uiCallback)   at Ifs.Application.ExcelReporter.MainWorkbook.ThisWorkbook_Startup(Object sender, EventArgs e)   at Microsoft.Office.Tools.Excel.WorkbookImpl.OnStartup()   at Ifs.Application.ExcelReporter.MainWorkbook.FinishInitialization()   at Microsoft.VisualStudio.Tools.Office.Runtime.DomainCreator

Hi, I’m looking for a step by step guide in creating Lobby? Thanks in advance! 

What are some good resources for learning IFS?  I’m not able to attend IFS Academy due to costs.  I’m just wanting to know if anyone has good resources for learning.  I have gone through some of the e-learning available in IFS 8 but I was told it was not available in IFS 10.  Any tips would be appreciated.

My company is wanting to set suppliers inactive and we know how to set the expiration date on the Purchase Tab > Misc Supplier Info sub-tab but the definition of the field says “The date after which details of the supplier are not to be retained. The expiration date only controls the creation of new transactions in the system for the supplier”. The first bit is what’s throwing us through a loop. Does this mean that IFS will purge the historical records of the supplier (e.g. purchase orders, invoices, etc.)?

Does anyone have a suggestion on how we can track who and when lobbies are being used in apps 10? Or course we can create an API with a get-function that updates a history table when called, but I wonder if anyone came up with something more elegant or had a discussion with IFS on this? One of the recent updates enables this for quick reports and this is a great tool which can help us identify which reports are important and which could be phased out (we have 2000 reports build over many years). 

Hello community. It is a way to have a list of transactions IDs and their use ?thanks a lot,Emilia 

Where can one find IFS Business Reporter Development Training Material ?

I want to change the placement and order of shortcuts in IFS10 . Is there a way to do it ?I think it is available in older versions.

Hello All, Can somebody provide a good document/tutorial/work instructions on how to create a Business Report? I don’t seem to find any good manuals that describe the possibilities and ways that we can use business reporter. For example: - If I use a Repeater on a row, can I use this repeater and define this immediatley as a dynamic XLS table? - Can I make a Pivot table of this? - How can I create a bar chart that takes into account the dynamic range of the repeater? - How to add an additional ‘calculated’ column to the table? (Calculated = I just want the difference between 2 source columns). Thanks for your help! Best RegardsRoel

Hi all,When I need information about the content in the attribute strings, I look in the debugger.But where do I find the information, when the call does not show up in the debugger. Like this one?archive_api.New_Client_Report() 

I create report in crystal reports, after I insert in IFS through “Create new Quick Report” window.In crystal reports I enter multiple parameters. But in IFS how I pass multiple values in single parameter.

Hello,I have a report that returns data results by entering parameters.In other words, the report result is displayed when you enter a parameter.If no value has been entered for the parameter, the report should still be displayed.When the parameter is used as a condition in the query sentence where the report draws data, the rows that do not contain data in the column will not appear in the report.I couldn't find how to display them.How should I write the condition in the query sentence? Can anyone help with this please?Sincerely..

We use Aurena only, Apps10 Upd13 (soon to be 14) and on a regular basis one or more or all of our SQL order reports start giving errors to all users. But only sql reports, crystals and operational reports are fineThe report in EE works fine, even when in Aurena failsapart from a server restart, this seems to continue for a few hours, then resolves itselfIt feels like were running out of some cache or disk but no one has been able to adviseRunning a refresh server cache sometimes fixes the issue, but not alwayserror:An internal server error occurred. Contact administrator.Url: https://----/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_844567()?$skip=0&$top=25Request Id = 46e2c0fe-2ce6-4e79-8e0b-09cdeb2b7c37Date = 2022-01-13T12:15:14.661ZClient version = 10.14.123.0

We are just beginning to use Business Reporter and some of our users are getting this error when attempting to open BR reports to edit:Microsoft Office Document Customization“This document contains custom code that cannot be loaded because the location is not in your trusted locations list:_____________________.  If you trust this document you can save and open it from a location on your computer.  For more information, see ‘http:\\go.microsoft.com/fwlink/?LinkId=99104.Others users can open any of the reports just fine.I know we can add a location to trusted locations, but to share reports for maintenance this isn’t practical for our purposes, and we would like to understand why this is happening for some users and not others.Has anyone else seen this and found a solution?  We are on Apps10 UPD6, although the same issue occurred on Apps 10 UPD4. 

Hi, When will the new vision(IFS APP 11) come? And will EE still be available then, or only Aurena?

Hello Dear Community Users, I have a question regarding the following topic.I need to add the current operation state and the state of the operation before the current operation as parameters. When the parameter popup window is opened, 2 pieces of operation status (Oper Status Code) field are displayed. Which one is present and which previous operation parameter is not understood. SELECT * FROM shop_order_operation o LEFT JOIN shop_order_operation prev_op ON prev_op.order_no = o.order_no AND prev_op.release_no = o.release_no AND prev_op.sequence_no = o.sequence_no AND prev_op.operation_no = shop_order_operation_api.get_previous_operation(o.order_no, o.release_no, o.sequence_no, o.operation_no) WHERE o.work_center_no = '&[MCS-L]Work_Center_No' ANDo.oper_status_code = '&[MCS-L]shop_order_operation.oper_status_code' ANDprev_op.oper_status_code = '&[MCS-L]operation_history.oper_status_code';How do we make special prompt when we use view column which is enumeration? B

Can you program Lobby Parameters have dropdown selections?  Our Managers would like the ability to select the Sales team instead of typing the name. 

Hi, I need some help with a SQL statement for a Quick Report I try to create. I want to show the total amount of a Purchase Order including charges (when a charge or multiple charges are applied on an order) and excluding tax. I created the statement below, but did not get the desired result. The statement is working fine, except the bold part. The statement returns only a value in ‘Total Amount’ when there are charges applied on the Purchase Order. And also, when there are multiple charges applied on the PO, the statement returns multiple lines. See the example below. Purchase Order Wanted Receipt Date Receipt Week Status Total Amount P101306 12-01-2021 02 Closed 726,6 P101306 12-01-2021 02 Closed 701,6  My desired result is: When there are no charges applied on the Purchase Order, the report should show the total amount of the Purchase Order. And when there are charge(s) applied, the report should show the total amount of the PO plus the amount of the charg

In Apps 10 there was an option to export data, including the output of quick reports, in various different formats. By default this included .xlsx, .xml and .txt (which would be formatted as a CSV) as well as there being a setting to enable more possibilities. Is there similar functionality available in IFS cloud? When pressing the export button it does not give a choice and always exports as a .xlsx.