Insights (Business Reporter and Analysis Models, EOI)

Hi How can I export Ojjects of Fixed asset to excel or csv file? I’ve found the template for FA, but it doesn’t work for output. It may be for only input.   Pls refer the piciture below, check on Output file is rejected. Regards; Yasuda    

I have following SQL statement which gives me the right result:   SELECT CASE WHEN PART_NO LIKE '1%' THEN 'A' WHEN PART_NO LIKE '2%' THEN 'B' WHEN PART_NO LIKE '3%' THEN 'C' END PART_TYPE,  MAX(PART_NO) PART_NO FROM PART_CATALOG WHERE (PART_NO LIKE '1%' OR PART_NO LIKE '2%' OR PART_NO LIKE '3%') GROUP BY CASE WHEN PART_NO LIKE '1%' THEN 'A' WHEN PART_NO LIKE '2%' THEN 'B' WHEN PART_NO LIKE '3%' THEN 'C' END   How would this convert to definition of a Lobby Data Source (with view Part_Catalog) regarding Condition and Group By?

I would like to get in contact with other companies that needs to follow the new EU directive WASTE. Have questions regarding if you are using ECO or other system. 

How do I learn your ERP Construction?

Can I know if we are able to sort data in a BR report by a measure item? If it is possible, how do we do that?   Thank you in advance!

We heard that it’s possible to notify our users with rolling text inside of IFS. Does anyone knows how this is enabled and can be used? I think the rolling text will be visible in the address field in Enterprise Explorer. (is this possible in Aurena as well?) Wants to notify users with info about upcoming updates, important actions, etc.

We have created a custom Sales Quotation Report and added it to the menu in IFS Enterprise. We have added the option to run the report by adding an option to the rmb list.   We now need the same custom quotation to be access from our Eurena application.  Please help

I was amazed this could still be a thing!https://nypost.com/2020/01/03/city-parking-meters-wont-read-credit-cards-due-to-software-glitch/   The Y2K bug has struck Big Apple drivers — two decades later. Credit cards are being declined at city parking meters across the five boroughs after a software bug took the payment option offline in the New Year, according to the city’s Department of Transportation.

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). 

We are currently on version 9 and are starting to create lobbies for user review.  I was able to grant access to the lobby that I created to a permission set, however, the it appears that the user(s) now have access to all of the IFS standard lobbies as well.  I don’t see a way to deactivate these or restrict access to them.  I tried to explicitly revoke access in the permission set to specific lobbies but they are still showing up in the lobby overview, although the data isn’t pulling through.  The issue is that the lobby overview is messy with all of the IFS standard lobbies and I’d like to make that a little cleaner.

Just want to say merry Christmas to everyone and thanks for the support and good discussions in the community. :)    

I would like to know which application (form) is actual started by a user. Security is all arranged by permission set, but it doesn't necessarily means that the program's in the permission sets are actually used Is there a way to activate/facilitate logging somewhere in IFS or via PLSQL? This will help me analysing which application is used by which user and in which frequency.    

Why not IFS gives popup message that account has been locked. In IFS8, 9 we get the pop up that account has been locked after a set up incorrect credtional was input by user but in IFS V10 we never receive such messages that account has been locked instead it will give incorrect credentials but the user accounts is locked when we check in oracle profile. Why not IFS provide to view the password input by user.... Alot of time we end up entering wrong password due keyboard issue but don't know what we have inputed. 

In BA System Parameters there are only three options for the BA_EXECUTION_SERVER_AVAILABLE: NO/FOR_ALL_INFO_SERVICES_REPORTS/ONLY_FOR_SCHEDULED_REPORTS However this doesn’t really suit our needs as we want to run some through BAES and others direct. For example Report A: Lets say Finance have a report they wish to run on demand (no schedule) and this should open up in their Excel using the BA Addin. Report B: Now we have a wide range of “Cost Centre” reports which breaks down all of the invoices to various managers and they should be able to run these reports on demand also (no schedule) - we don’t want to have to install the BA addin to everyone's machines so want the BAES to handle this functionality and store the report back in the report archive as a standard Excel file.     Can anyone think of a way aroun

We are currently in an upgrade project to IFS10 and considering which updates to install and when. Please let me know, where can I find the release schedule from IFS R&D? Regarding UPD7, is the planned content published somewhere? For previous updates I have found “What’s new” presentations by Bob Corrigan by Open IFS, but as a decision basis we would need information about the planned content of a coming update as well. 

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() 

code:One of my customer is trying to save BA reports in Sharepoint. Previously it didnt allow users to run BA reports from Sharepoint. Howevercustomer has now mentioned that it is possible to run report from Sharepoint. Can you please confirmwhether if BA now support sharepoint? If not, any possible reason how this could work?

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.

Hi, This is related to EOI.I'm using a Category as Context on my Cockpit Page, but I still see Indicators that have no category modeled on my Cockpit Page. What is wrong?

 Hi,My inbound SOAP service is responding with a 503 after an app pool recycle. How can I fix this issue?  

Dear IFS academy members, Is it possible to get Training calendars for V10 in below countries. Netherlands, France etc. Asia Region - India ,Thailand, Srilanka, . Thanks Samiksha Rajput

When I attempt to open a SSRS report, I get the following error: "No authentication cookie has been found for the report server"

One of the customers has faced an issue in BAES. The BAES is hanged due to an error in excel. Background jobs are in Externally executing state since the reports are not getting processed by BAES. There is a huge queue of ordered reports and BAES now can not handle that much of a load even the excel issue is sorted. This is in Apps8 Environment.

When executing a BA report, I get the following error. “Maximum number of rows to retrieve during statement execution”

In App 10 what are the information sources that support Transactional Level Writeback ?