Insights (Business Reporter and Analysis Models, EOI)

HousseinySidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

how to filter on multiple items in message box (SQL)

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

340

1 year ago

maurycy.gawlikSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to associate an invoice with the inventory transaction history table

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.

1304

1 year ago

Chamaka WimalarathneHero (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Using multiple page Contexts for a user

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 ?

912

1 year ago

PennyBSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

BA Report switches date format when scheduled or run from IFS application

We’ve had this issue for years now, with no solution. BA Report displays dates in correction Australian format when run via BA Excel Add-In. However, when report is schedule or run from IFS application any date references on the report revert to US Format. E.g. if there is a header in the report referencing the date the report is run or the date entered in a parameter it will show 9th June 2023 as 6/9/23 instead of Australian format of 9/6/23. Just wondering if anyone has resolved this?

1193

1 year ago

HananeSidekick

asked in Insights (Business Reporter and Analysis Models, EOI)

Custom event on customer order

Hello everyone , I need to create a custom event that triggers when the status of the customer order is closed .My problem is that I can’t find state column ( sql column for status ) in the list of column available in customer_order_tab .PS : I can find it in the view but not in the table Does anyone have an idea how to get it ? Thank you in advance.Hanane

1635

1 year ago

ParsaHZMSidekick

asked in Insights (Business Reporter and Analysis Models, EOI)

Customized field in Business opportunity

Hello, FriendsI have a problem in Relationship management module, I’ll describe it in the below:We have some Customized field in Business opportunity page (follow the attached file) that prepared by our ERP developer team, How can we achieve to these fields in Business opportunities page (we want to bring them in Business opportunities columns) for preparing some analysis report and excel output. Thanks guyswish the best

20812

1 year ago

HananeSidekick

asked in Insights (Business Reporter and Analysis Models, EOI)

changing's a person email

Hello ,I changed my email in communication method in the person screen .But since i’m sending a scheduled report , i still receive it with the old email .Is there is further step that I need to apply or a job that I need to execute to take account of the new email saved . Thank you in advance Hanane

864

1 year ago

NMALKIHero (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Is it possible to have a schedule event that trigger BR

Hi Everyone,We were able to schedule BR and send it to users by mail directly, but our request now is to schedule a BR to be send to PMs of active projects (we have around 100 projects).If I do it via Scheduled Reports, I will have to create 100 schedule reports and keep updating them every time PM change, new project created or another one closed...Project_ID is a parameter for the business Report.Not sure if there is a way to schedule a database task that lunch a custom event and in the event to trigger/ call a Business report (which function to call?)… then maybe send a link to the report archive or attach it to the PM mail ideally. Any idea would be much appreciated.We are using APP10 , Upd 15Thanks

1250

1 year ago

techniceDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Cloud - Inside Powerpoint or other presentation viewer

IFS Cloud - Is there an inside Powerpoint or other presentation viewer to use directly in lobbies?

1861

1 year ago

sherryDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

ask for sql query tool training document

Does someone has any document for the sql query tool, i’m new for this area, want to get started.

732

1 year ago

JacJLSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Error using Custom Dimension LoV

Hello, I am currently trying to set up a ‘Custom Dimension LoV’ from a Dimension I have created. When I go to publish I am presented with the following error: I am unable to find anything on why this is happening, any help is appreciated!

1442

1 year ago

TimSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

How to delete entries from XLR_REPORT_RESULTS_TAB

APPS9We have been advised that XLR_REPORT_RESULT_TAB is consuming a large amount of disk space on our database.It looks like this is added to when a BA report is scheduled or manually run.How can we flush out/delete records from this table? We can see records going back to 2020 which we don’t need. Thanks

991

1 year ago

durasrbDo Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Report Designer for IFS Apps 8.0 (SP-0)

Hello all, i would like to start using IFS Report deisgner, version of IFS which i using is IFS Apps 8.0 (SP-0) , i could not find any exe file to download, could anybody help about this issue and send me instalation file with report designer.Thank you in advance

400

1 year ago

Manish VermaDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Event Builder - Data Corruption

We have existing Event Builders at Product Level. Everything looks good in Database, but on Support Portal it is showing wrong information.Instead of Product Level, it is showing Item Level and next field is blank: We are having this issue with a large number of Event Builders. Is there is a quick fix? Updating these manually is very time consuming.

110

1 year ago

HousseinySidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Avoiding duplicate values when combining two views SQL

Hi, I have the below two tables with the mentioned fields and sample rows. Table GL_Ledger X has got a lot of actual details down to GL rows while table Budget Y has got budget amounts by Activity_Seq. I need to come up with one report where I have all fields of table X and one additional field for “AMT” coming from budget using the common filed Activity_seq. Two issues in my result:Duplication of budget amounts (in A1 rows). Missing budget for A3 and A5In other words, want to keep all details and rows of table X and pick up all records from table Y with no duplicates.Any clues on how to solve this issue? Also if I will use union all, is there an easy way to copy all table X columns properties to table Y and how to do it if that is the only solution.

1364

1 year ago

SKA123Do Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

Modify RDF PLSQL in IFS Cloud 22R2

Hello community,Please I want to modify RDF PLSQL in IFS Developer Studio, but I can’t find in Cloud 22R2 any report files for *.RDF and *.Report: Thank you for your help.Best Regards.

1781

1 year ago

jzouaouiSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

disabling Report printed automatically by the sys

Hello ,i have a report that is automatically printed by the system. and I want to disable automatic printing but I don't know where I should go in the set up .Report name : inventory order report Report ID : INV_PART_ORDER_PNT_REP_REPI think the report is printed when the Mrp is started by a scheduled task . but im not sure Report archive : Thank you in advance .

1558

1 year ago

HousseinySidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

what is SQL View of posting proposal history

HiWhat is the view of posting proposal history? need to retrieve some columns in SQL query. Any clues??RegardsHousseiny

632

1 year ago

SKA123Do Gooder

asked in Insights (Business Reporter and Analysis Models, EOI)

Text translation in IFS cloud

Hello everyone,I’m trying to change translation for customer order report fields, but I can’t find it:I think it’s a problem of permission sets, do you know please what permission I need to work on reports ?Thank you,Regards.

1252

1 year ago

lemantDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Support of SQL 2022

Do we know when IFS will support SQL 2022? Thank you!

110

1 year ago

nahidDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

IFS Report Crystal error

The problem is described in the attached doc file.Please find the problem description in that doc file.

1293

1 year ago

JacJLSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

New line not being created in Business Reporter

Hello, I am working on creating the ability to insert a new row in Business Reporter and have it wrote back to IFS.I am given the normal pop up to insert a new row, I enter the information and press ‘OK’ and occasionally the new line will not be created. There is no error message that is given and nothing happens.Insert New Values ScreenAny advice on why this may happen or how to trouble shoot would be appreciated.

643

1 year ago

JacJLSidekick (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

Business Reporter Writeback 'Existing state of has been invalidated'

Hello, I am currently trying to use the writeback functionality in Business Reporter.When I am working on creating the Procedure for the the writeback, if I update the API package and try to use the writeback functionality again, I am returned with this error: ‘Existing state of has been invalidated’. I have refreshed my cache, logged out and back in, and nothing changes it. The API works normally from inside SQL Developer. I am unsure of how to solve this error, any advice is appreciated.

742

1 year ago

Sadeepa GamlathDo Gooder (Partner)

asked in Insights (Business Reporter and Analysis Models, EOI)

Send Business reporter files via schedule job

Hi, I have a customer who wants to schedule job to send customer statement of account (New report created using BR). Is it possible to send BR reports via schedule batch job? Sadeepa

822

1 year ago

bpamlinDo Gooder (Customer)

asked in Insights (Business Reporter and Analysis Models, EOI)

how to handle multiple data sources in the lobby data source designer

How do you implement 2 data sources (views) into the lobby data source designer. I want the following code to return the count in the data source.select distinct(sp.catalog_no)from lora1app.sales_part sp, lora1app.sales_price_part_join splp where splp.catalog_no = sp.catalog_no and splp.SALES_PRICE_TYPE_DB = 'SALES PRICES'and sp.activeind_db = 'Y' and (splp.part_valid_to_date >= (sysdate) or splp.part_valid_to_date is null)and splp.valid_to_date >= (sysdate) --currently I have gone about it the following way seeing that the data source cannot handle two views:select distinct SALES_PART.Catalog_NO from SALES_PART where SALES_PART.activeind_db = 'Y' and SALES_PART.Catalog_NO in (select catalog_no from sales_price_part_join where sales_price_part_join.catalog_no = SALES_PART.CATALOG_NO AND sales_price_part_join.SALES_PRICE_TYPE_DB = 'SALES PRICES' and (sales_price_part_join.part_valid_to_date >= sysdate or sales_price_part_join.part_valid_to_date is null) and sales_p

5553

1 year ago

Page 8 / 25

Insights (Business Reporter and Analysis Models, EOI)

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded