Solved

I can add substitutes for purchase orders, but cant seem to add for supplier invoices. Normally, when I populate on the purchase order substitutes, the authorisers appear and I can add a valid from/to  - but no functions allowed, even with IFSAPP_ALL - permission sets look good too.   Any ideas what am missing here?    

I have SQL that using multiple views, I therefore created an IAL using the SQL and deployed it.     The IAL appears in the IAL Configuration, however, I am unable to access the IAL within the Data Source Designer OR using Quick Reporter.   Can anyone advise what I am missing?    

We are building flight disruptions, but there are times when the aircraft does not end up taking a mx delay...is there a way to delete those flight disruptions? I hate to see a bunch of meaningless flight disruptions (meaning they have no delay time associated with them) clogging up the system, but I can’t see the simple way of deleting, or removing those Flight Disruptions...any thoughts on that?    Concerns: Does it affect MAA downstream to have a bunch of 0:00 mx delays? Do duplicate Flight Disruptions (with real x:xx delays) cause issues? Thanks! Tim

When using a custom layout of fields (in particular on a Custom Page), is it possible to control the layout (location and field size) in any way either via database or importable/exportable XML code in any way? Having to line up a lot of fields with the little arrow buttons is pretty time consuming to get fields to all line up and space evenly. I’m hoping there’s a way I can just input pixel values for size and location somehow?

Hello, I would like to launch the Print Preview report (accessible from the Resolve page of the Service Order) and the Service Order report (from the "Report" button of the Service Order) to a single pdf containing the two concatenated reports in one action.I have considered several solutions:• Create a single new report using the customizer containing both sub report. Knowing that each report to be concatenated normally has its own structure (header, group, detail with sub report, etc.) : I have not tested how many levels of reporting can accept nested sub reports.• Create an action button in the Service Order UI that will execute java code to run both Pdfs : I don’t know how to group the two Pdfs into one. •Use code in the first report that will launch the second report generation : I do not know which code to use and if it is possible to do so.   Thank you for giving me a solution.

Dear esteemed Members,   Our customer is planning to upgrade OS to Win Server 2016 Std or 2019 Std from 2008 R2 for its IFS App Ver 8 Sp2 instance. Would request IFS recommendation on the OS upgrade with possible impact. Any technical document or whitepaper available to back up the recommendation.   Regards, Sunil Nair

Sometimes we have noticed performance drawbacks due to the value set for the "job queue processes” parameter in the oracle database. What is the correct formula for the set this value correctly and what are the things that need to consider?  

Is there a way in a custom menu to allow a user to be prompted to type in a value that I can subsequently use in the SQL code?

Hi, Can someone shed some light about how to get the server resources downloaded for locally installed Touch apps server (for Demo purposes)? In apps 9 there was an option in the customer portal page to check the “Cloud connection status” and if the system is registered most recent resources could be downloaded  but seems that’s no longer available for Apps10. TIA. Regards, Ruchira

Hi   Wondering, we have a field available to us on screen for ‘Supplier Name’ - but when I look in the search box to configure so users can search by name its not available. Is there anything I can do to make this field searchable?? Is there perhaps an SQL expression I can use that will put the sort by name into order?    

Is there any way to get MRP run date and the user information who run the MRP for a purticular part? Actually i can get these two information from background job but there is no option of part query. please suggest if there is any window or any sql view where i can get these information.

when user create new part revision, i would like to set a CF to “A Value” or “B value” depends on revision number (eng_chgt_level). Actually, i do it by an event and a background job but users have to refresh the screen to see value affected. An another option is to do it by an Oracle Trigger BEFORE INSERT by it is not a IFS “best practice”. What is the best way to set and display default value on screen while you’re typing data of a new record ?

Hello. I am looking into the setup of a Freight Price list for our US customer base. I have setup a Freight Map and Freight Price List for Fedex Priority, with the Zone Defined by Zip Code. This allows for a numeric range of Zip Codes as shown below.   This is working when a 5 digit Zip code is used. The problem i have encountered is when the Customer Address is in the ZIP+4 format (XXXXX-XXXX). In this case the Freight Zone is not found. Is there another way to approach this, or have i missed something in the setup?

Hello, I would like to automatically add the invoice (pdf) as an attachment in the service order as soon as we invoice it. Do you have a solution ? Thanks for your help.

Dear fellow IFS users For our production, we created a lobby which shows the current work orders being done. This is displayed on a big TV. When the PC is turned on, this lobby should be opened automatically and displayed in full screen mode / kiosk mode, as it is only for display purposes and doesnt need any user interaction. Is there any possibility to automatically open IFS in full screen / kiosk mode? The PC has no mouse or keyboard connected so this should be automated as far as possible. Many thanks for your inputs on this issue Best regards N.

I have created a custom event for a specific background job if it fails a stream message is sent to user to view the job. I also want user to transfer to background job details page to see the logs for the failures. For this I want to use below address.   ifsapf:frmBackgroundJob?DATA_TRANSFER=%2F%2F4VAEQAZQBmAGUAcgByAGUAZABKAG8AYgAWABYAQwBSAEUAQQBUAEUAXwBXAEkATgBEAE8AVasdasdfasdfsdfadfADABgAasdfsdafdsA3ABYAGQA%3D&COMPANY=XXX   However I am not sure how DATA_TRANSFER string is created by IFS. Below address does not work.   ifsapf:frmBackgroundJob?JOB_ID=1232323&COMPANY=XXX   Any idea how can this be achieved in APPS9?

Hi, I have send out an Application Message from IFS to an external API endpoint using a HTTP connector. I have reaced the endpoint succesfully. The endpoint returned me back a message and IFS is showing it to med in a .txt file. How can I access that response, and have is saved somewhere in the database? Any help is very appreciated. Kresten

Hi,   In a foreign currency supplier account, the invoice was entered at one rate, but was paid at a different rate on later date. The foreign currency amount clears off fine, but in the Supplier account, it is leaving a balance in the home currency. What would be the best way to write off this difference to bring the account down to $0 balance in both foreign currency and home currency?     Thanks in advance, Lawrence  

When a customized form is deployed and if the form has some entries in the base profile, the customized form is not loading instead the standard form is getting loaded for the user. The same user if we remove the base profile, the user is able to see the customized form. The base profile is not getting updated with the Customized form name. It looks like I have do recreate the profile again for all the customized pages. Is there solution available for this. Thanks & Regards, Siva     

Dear All,   Does anyone has any idea about outbox messages which are in Released status. They should be transferred after some time but they are stuck in Released status, when I am checking the message line they are coming in Posted and no error is coming. I checked the connectivity setting in system parameters for outbox and inbox process. Both are On. I checked the setup connectivity, i did the setup for installation site still no luck.  Please advice what else we can do.   Thanks IP

I thought I’d ask the community this question but I am pretty certain I know the answer.     Is there a way in MWO Service 10 to request parts from the main warehouse to replenish truck stock (my stock)? (NOT FOR A JOB)  As far as I know, you can create a transport task to move stock from your my stock to another mobile user or back to the main whse.  Or receive transport tasks from another user or from the main whse.  As far as I know, you cannot create replenishment orders.  Typically I have done Remote WHSE assortments to refill mobile whse’s and run the refill parts but I have never had to replenishment truck whse manually from mobile.  Is this possible?  

Apps 7.5 had a cool enhancement to Operational Reporting called ‘iPrinting’ which was a UK customisation. It allowed additional data to be pulled into a report layout which could then be used by Report Designer. This feature appeared to disappear by the time Apps 9 came along and I wondered whether anyone has come across this? Custom Fields offer some assistance but what they do not provide is ‘sub queries’ of data. e.g. Customer Invoices lines report the Lot/Batch Number of the invoice qty but I want to then show a break down of that quantity across the batches. This would require a sub-query of the inventory transaction history or something to show the separate lot ref and qty. I used to be able to do this using iPrinting but I can’t see way to do it with custom fields. Anyone got any ideas?    

Hi Guys,   I am facing an issue in Apps 10 where an Fixed Asset created through a Project cannot be moved, sell or scrap..etc. It gives error saying the project is completed. The setup was as follows. GP3 Account for Project and Acquisition Account for Object is same Reposted to same account   When Project was completed, the object was moved by removing the Project code part. In here reposting debit entry was created without Project Eg ACC01 - OBJ01   DR  XXX ACC01 - PROJ01-OBJ01   CR  XXX   Is it wrong to use GP3 Account for Project and Acquisition Account for Object as same ? What is the way to get rid of this flowstopper?   Cheers Lahiru  

HI there,   Is there any way we can write back the key values to the Excel sheet once the record is inserted or updated in IFS. For Example: A Excel migration job is configured to create a new Work order with data from the excel. Can the newly created Work order number be returned back to excel sheet and displayed against the data line.   Thanks in Advance.   Siva Ganesh M

I recently added a field to a stock IFS operational report and found it challenging. I'm probably missing something really basic. I've created and modified a lot of operational reports done with Crystal Reports, but this is the first time since Apps 2004 that I've tried to use the IFS tools. Does anyone have any better documentation/training material than what is supplied with the Report Designer? Or tips and tricks on creating/modifying reports with Report Designer?