IFS Solutions

27851 Topics

lmckimDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Query build will not allow to select (First Distinct) value of Part Description

I have created a fairly simple query here selecting all order lines in a “Planned” or “Released” status, where Part No is like “-”, and any value in part description. I then sum the Sales Qty for the Part No that is grouped. Our issue is our Part Description is not unique so I really do not need to separate by part description, but if I do not group with it the field does not return values. As you can see for Part No 100-ST50 we have a description of Diamond 20# and a description of Diamond 20lb, I simply need the first description shown for a reference and need the subtotal for part no to include all entries so the subtotal for part no 100-ST50 should be 950. I do not know how to have SQL simply return the first distinct value for part description.

4 years ago

rramaswaDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Oracle user profile

when creating an IFS user how to select an oracle profile, by default it is selecting the oracle default profile, I have created an oracle profile to use password verification function. when I create a new IFS user I would like to select the oracle profile I have created instead of the default Oracle profile

4 years ago

KristenGastaldoSuperhero (Employee)

published in Upgrades & Updates

Webinar: Upgrades & Path to Evergreen

Community Webinar: Upgrades & Path to Evergreen In this webinar, Tony Johnson, Strategic Programme Director, discussed the benefits of moving from IFS9 to IFS10. He touched on the benefits of upgrading, as well as address common concerns raised during the process. He was joined by Lee Sarginson, Technical Services Director, for Q&A.

6350

4 years ago

shewaDo Gooder

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

IFS Report Desginer - Adding a table

Hi, I am doing some Report Designer changes to a layout and struggling adding a new table. I want to add a table in between existing two tables, but new table always goes to end of the Page Body. How can I move the new table where I want? Appreciate your comments. Thank you.

4 years ago

RutJWhalenSuperhero (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Custom RMB to open SINGLE_MANUAL_ISSUE_SO

I would like to create a custom menu RMB to issue material passing the PART_NO and WORK_CENTER display the related detail from the SINGLE_MANUAL_ISSUE_SO view. AND on displaying the detail prompt the user for the enter the LOT_BATCH_NO. Is this possible? Normally, I would use the frame but

4 years ago

hwilkieDo Gooder (Customer)

asked in Service (Touch Apps, MWO, MRO)

Print Preview - Purchase Order Change Order

A user wishes to print preview a purchase order change order, before the change order is authorised and the purchase order is updated. The reason for this is the person wishes to review what the updated PO would look like before they commit to authorising. However whilst on the ‘Purchase Order Change Order’ screen, there is no option to print preview. My initial thoughts are a custom RMB click to a purchase order quick report. However I would want this to reflect our current PO layout which is designs using report designer.

4 years ago

filiep.vwDo Gooder (Customer)

posted in Service (Touch Apps, MWO, MRO)

Call center demo

Hi, we’re on a quest to find out if call center can make a difference in our company. I can ask IFS and the anwser will be “sure it can” and i believe them, however .. talking to someone using it already would give me the real experience. So, if somebody using Call Center feels like shedding a light over the matter in a call or skype session that would be amazing, otherwise we’ll go for the IFS option. We’re located in belgium, be we’ll adapt to any timezone if that would be helpful. BR Filiep

4 years ago

SAFIDESidekick (Employee)

asked in Service (Touch Apps, MWO, MRO)

Document Management - Object Transformation

Between application 7.5 (or 8?! I am not sure...) and 9 I have seen a difference regarding object transformation. In the old release of IFS application an entry was made in the object connection list if a document was passed on from a source LU to a taget LU. Now it seems to be only displayed online. Can someone explain the benefit?

4 years ago

RamadassSidekick (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Translation issue in operational Report

I tried a function ‘Amounts to words’ in report designer and I used like below ‘vldtmath:amountToWords(tns:NET_CURR_AMOUNT,'ar',tns:CURRENCY)’. When I used for german language code or other language codes its translating and showing in mentioned languages but when I tried in Arabic or Korean languages its is not translating in the report. if currency is 1000 means output for ar/ko : One thousands. Please suggest any solution or give me reason why its not coming in report.

4 years ago

sholmesHero (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Doc Management Custom Field - how to view in the 'attachment' view on connected objects?

Hi All I’ve created a Custom Field in Document Management and ideally want it visible in the attachment view on the connected objects. Is this the view the ‘DOCUMENT_VIEW_ACCESS’? If yes how can a OBJKEY be made available as I can’t get this view approved. Or is this just not possible? If I expand to the ‘more’ option on the view the custom field is available. Thanks for reading

4 years ago

dabeleDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Document Management User Settings

Is it possible to administrate the User Settings in Document Management Basic Data for all users rather than manage them individually from the user? I am not able to find these in profiles or user settings.

4 years ago

ManxmanoSidekick (Customer)

asked in Products (Manufacturing, Products, Engineering)

Accessing help on a chromebook

Hi, this may be a really simple question but I am accessing the Apps 10 Aurena PPE environment on a chromebook. It works really nice but I can't find an obvious way of accessing the help. Of course, on a chromebook there is no F1 button and I can't see a link to the help. Please help! Thanks everyone.

4 years ago

RMaassenDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Simultaneous Sessions_Per_user

Hi I was trying some troubleshooting, and changed a setting I obviously shouldn’t have. Due to most users having the “Oracle Profile” of “Default”, I thought it would be fairly safe to change this setting in our test environment: Short after, our test environment crashed. Trying the MWS scripts, I get: A small snippet of the logs: <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <The server 'MainServer1' with process id 12596 is no longer alive; waiting for the process to die.> <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <Server failed during startup. It may be retried according to the auto restart configuration.> <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <Server failed so attempting to restart (restart count = 1)> <Feb 28, 2020 8:06:17 AM CST> <INFO> <EXPMIGR> <MainServer1> <Starting WebLogic server with comm

4 years ago

cjohnsonSuperhero (Customer)

asked in Distribution (CRM, Commerce)

Update connected objects Sales Quote from Business Opportunity

Hello, I’m having an issue understanding the workflow in IFS as it relates to Sales Quote generation. Currently, we are starting the process at Business Opportunity. An opportunity line would be entered for a top line part, which would be saved as a Non-Existing Part. From there an Estimate is created for the part. The calculation is made and the Business Opportunity is updated via the connected object from the Estimate to the Opportunity. In order to create a quote, we have to register the part using Register Non-Existing Part in Business Opportunity. When that is done, you can then RMB the opportunity line and create a Sales Quote. The issue becomes when you need to change the quote for any reason, the Business Opportunity is not also updated to reflect the change. If you adjust Contribution Margin on the Sales Quote, that does not update the Business Opportunity. Additionally, if you need to modify the Estimate, when you update the connected object to the Business Opportunity, you

4 years ago

ProRafalDDo Gooder (Partner)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Modification of a Custom Package (CFP)

Hi! When a custom LU and fields are added, IFS automatically creates a package to insert, modify and delete custom data. Is there a way to safely modify e.g. CF_NEW__ procedure in the custom package to add extra validations? I assume the CFP package will be overwritten when e.g. a new custom field is added or reinstalled and all changes will be lost, so it is probably not straightforwad. Any ideas? Thanks! Regards, Rafal

4 years ago

RutJWhalenSuperhero (Partner)

asked in HCM (Human Capital Management, Payroll)

Time Clock functionality

I would be very grateful if someone could advise on the following: When we select In and then carry out the swipe, the employee id/name is not being displayed in the Welcome message and no records are being updated to Time Card. Is there a way to debug Time Clock?

4 years ago

JBergSidekick (Customer)

asked in Warehouse Data Collection (WaDaCo)

wadaco - configuration feedback

Hi, In our picking configuration the first thing the operator should see is the work information, feedback of the picking. But the feedback will always be blank, any suggestions to why this is happening? Manufacturing part desc / part no are custom feedback fields from shop order part / part description. //Jonas

4 years ago

HarshaK

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

How to Create a New RMB and Link particular report ?

Hello Guys, Does anybody have a doc/PDF or know any external link regarding creating a new RMB and link a report or window ? Or If you can explain step by step also appreciated

4 years ago

ALDMACINTYREDo Gooder (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Fields are blacking out

Hi, when I scroll my mouse over a field in IFS, the field turns black. I can get the information back when I click on it again. Is anyone else having this issue? I am using IFS Version 8.

4 years ago

Praveen WijetungeSidekick (Former Employee)

asked in Products (Manufacturing, Products, Engineering)

Project Gantt Performance Issues

The customers that am working with raised the following question. Would like to request your feedback and advice to assist the customer. Description: Project Gantt Performance Issues To move one activity without saving or scheduling takes 1 minutes and 9 seconds a time. 3 minutes to save saving before scheduling; 1 minute to schedule on only 4 activity changes and a further 3 minutes 17 seconds to save the scheduled changes. Effectively looking at up to 9-10 minutes per overall change and the business currently makes daily changes due to various reasons. If I had to move 120 linked activities that would be 2 hours work?! Test Scenarios: Open a Project in Gantt view Move Activity and Save Schedule Project and Save

4 years ago

todscottaDo Gooder (Customer)

asked in Data Migration

Migrating Data into a Custom Page

I have created a custom logical unit / custom page to add to the Supplier screen as a custom tab. Is there an easy way to use the data migration tool (DMT) to populate the underlying custom table? I’ve seen instructions on setting up the DMT to handle custom fields on a standard IFS screen, but this situation is a little different, in my mind, because it isn’t and extension of a standard method.

4 years ago

jbernardoHero (Partner)

asked in Service (Touch Apps, MWO, MRO)

Adding new fields in UI Designer

Under our part usage, i am trying to also add the description of the part which is unfortunately located in the part table. Since there is nothing connecting these two it cannot determine the path. i manually add it via the item path in the UI designer but it doesn't return any values. there are a lot of screens that i want to do this one. What would be the best way to go about this?

4 years ago

DevBobSidekick (Customer)

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Quick Report SQL Date Question

In my quick report I'd like to select a date range going back to the first of last year, so for today, 2/26/2020 it would select 1/1/2019 - today. date_entered between sub_months(trunc(sysdate, 'YEAR'), 12) and trunc(sysdate, 'YEAR')-1/24/60/60 I tried a sub_month but that didn’t work. I’m already using this format for going forward one year: OP_START_DATE between trunc(sysdate, 'YEAR') and add_months(trunc(sysdate, 'YEAR'), 12)-1/24/60/60

4 years ago

imharshit003

asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

Profile import export in Aurena

Dear All, Can we do the profile import/export of Aurena. If yes then how can we do the same. Thanks in advance! BR, HA

4 years ago

HOOJEWINLSidekick (Customer)

asked in HCM (Human Capital Management, Payroll)

cancel sales quotation line error wrong number or types of arguments

Hi all, Since update 16 we have had an issue that when we cancel a sales quotation line we get the error message: wrong number or types of arguments in call to CANCEL_ORDER_LINE At first we thought this was an access rights issue, but we doubt this. Anyone have an idea?

4 years ago

Page 1090 / 1115

Badges

Sign up

Login to the community

Scanning file for viruses.

This file cannot be downloaded