Hi, I’d like to put a date range for my SQL statement. Could you please advise? SELECT payment_address.Identity,SUPPLIER_INFO_GENERAL.Name,payment_address.Party_Type,payment_address.Way_ID,supplier_info_general.creation_date,payment_address.Description,payment_address.Default_Address,payment_address.Data1,payment_address.AccountFROM payment_addressFULL JOIN SUPPLIER_INFO_GENERALON payment_address.IDENTITY = SUPPLIER_INFO_GENERAL.SUPPLIER_ID
Is there any way I can get data from IFS (Aurena) in Power BI?
where can I find Purchase order number and line number?
I’m trying to use PowerBI to pull data from IFS. Someone mentioned that it’s possible through REST API but I have no idea and there are not many materials I can look. Does anyone have any experience using REST API?
Environment: Aurenais there a way to set up a history log Attributes for permission set change (grant and revoke an object or method)?
For audit trail, I enabled Log Insert/Log Update/Log Delete for the following Payment Tables - PaymentWayPerIdentity / PaymentAddress / PayAddrCompTender (Lu Names).When Payment info modification occurs in Supplier, for example TEST123, the History Log captures updates. but it only shows meta data, not the actual items.How can I get the actual data (before update)?
Does anyone have tutorials/manuals for page designer - custom attributes/entity/enumeration [aurena]
where can i find "matched PO receipts to invoice"?
We can't create a quick report based on tables.However, the view which is based off the history log attribute table is empty. I don't think it should be, do you know why, is this an IFS bug?Table: history_log_attribute_tabView: history_log_attribute
What's the relationship (task number/work order number/order number/ task sequence)?AURENA
[AURENA]I have created a quick report. Does anyone know how to make this report downloadable into a pdf file?
hi,[AURENA] I’m trying to put a dropdown list in the General Info on the Business Opportunity page. The problem is the dropdown info is from Project Definition (different datasource). Anyone knows how? Is there any training material? Thanks in advance,
hi, my goal is to put Project ID dropdown list from Project Definition Page into Business Opportunity.I’ve tried with some manuals from IFS but it’s very hard for me to figure out without step by step tutorial. I’m very new to IFS.My question is,In the Active Page, Datasource Entity Set already exists with BusinessOpportunities, how can I put different data source (Project Definition) here? I’ve created Entity Configuration, Projection Configuration but I don’t know how to plug them in to get Project Definition in the Page Design.
If I delete/update items/records, where are the data archived?
I have created a quick report in IFS. I need to display the updated records as well as the old records of Vendor bank details on the same report. Currently, the History Log only show the meta data but not the actual changed value. And If I run payment table, it only shows changed value. Is there any way I can display the actual changes and the old value?Is there any table/db that holds the original data?
We have created a quick report in IFS Aurena. We need to display the updated records as well as the old records on the same report. How can we accomplish this? Currently, the History Log only show the meta data but not the actual changed value. We need to display the actual changes and the old value.
where can I find work order info (workorder #/routing #/labour/mechanic/dept./hours)
As an admin, what should I change to give a user an access to Active Work Orders? (AURENA)
I have created a quick report in IFS. I need to display the updated records as well as the old records of Vendor bank details on the same report.Currently, the History Log only show the meta data but not the actual changed value. And If I run payment table, it only shows changed value.Is there any way I can display the actual changes and the old value?Is there any table/db that holds the original data?
[AURENA] How can I save a quick report with filters applied?
Could anyone tell me how to give query grants to a user?
Which data table should I use to get General Leger Document Number and Purchase Order Number?
Hi, I’m trying to bring project ID and description from Project Definition Page to Business Opportunities Page.Is there any linkage between the 2 pages? If I edit the page designer on the Business Opportunities Page, is it possible if I put Project data in the Library?
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
