Solved

 I would like to a quick report on the 12th of the month for the prior month.  So on April 12th it will run for the month of March.  On May 12th it will run for the month of Apr and so on.  This report is also run manually by the users.  Is there a way to dynamically set the From/To date to be the prior month or do I have to create  copy of this report with the dates dynamically set in the select statement?  I obviously don’t want two exact reports because of having to remember to make all changes twice.  Below is the a screen shot of the server task schedule.  

Hello, Is there any coloumn in the inventory_part or sales_part  for the HS Code (Customs Tariff, Harmonized Code,  Harmonized system) ?

Hello IFS Community,We are getting a weird error in IFS Connect server logs (APPS8). The error says “Can’t get file channel”. We are trying to process a dat file (Inboud interface). This file is coverted into XML by Java transformer first and is then processed by BIZAPI.This file works fine sometimes but not always. We have already checked the file/folder permissions but all looks good.I would really appreciate if anyone can help on this topic.Jfyi, we tried to restart the connect server and changed the POLL_TIME as well in FILE_READER but no luck. Thanks & RegardsMohit

Hi, I have an issue with adding a field on a lay-out in Report Designer. I want to add a field on the pdf lay-out of the Customer Invoice, but two tables overlap in Report Designer with as result that I am not able to add the new field. Does someone know how to resolve this issue? Please refer to the screenshots below.    

Hello All, I’m hoping there is somewhere in IFS to track this. It was recently discovered that an Availability Control ID was applied to a large group of parts in an inventory location. I have not found a place in IFS where you can view when and who applied the ID. I’ve checked Inventory Transaction History, but I do not see the transaction there. Any help would be greatly appreciated. 

Hello, could someone please point me in the right direction for webinars or videos that may help with Advanced Planning Board setup and functionality. Thank You

In our project we are working with mWO App Version 10.11.1342.0 (Aurena Native).I have the following questions:For synchronizing data from server to the app do we still need the following Scheduled Database Tasks (were necessary for our previous version of mWO):•    Refresh Mobile Sync Objects•    Refresh All Inventory Parts•    Refresh All Purch Parts•    Transfer Work Assignments to Mobile•    Cleanup Mobile Work OrderPlease also provide an info for what purpose these tasks are needed (customer is asking for info).Thx in advance, BRHarald

Hi,There is a requirement to generate a email with a hyperlink in Apps10. For an example, a user will receive an email with the no of Purchase Orders pending to be authorised by himself. Along with the count, they require the Aurena link to PO as a Hyperlink in the email.Is this possible?Thanks.

Hi, Would it be possible to add charts like below into a lobby? How? 

Trying to refresh a Data Mart Source and receiving the following error: ORA-20110: Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired    How do I debug/resolve this issue?

As we all aware, when there is a Drop-off location defined in one particular warehouse (or below levels) and when we move parts using a Transport Task, once we execute the initial transport task, system creates a new (or add to existing) transport task From Drop-off location to Forward to location. I couldn’t find any link (connection) to identify the newly created (or existing one) transport task from the initial transport task. Is there any way to directly go to the newly created (or connected) transport task, instead of go and search in Transport Task/s widows?

I have a requirement for a Sales Quote that also has a Quote Expiration Date. (yes, it is ovbious that we should just make the field required so thay have to enter a date, but I am required to do it this way.) If the Expriration Date is Blank, take todays date and add 60 days to it and put it in the field. If the Expiration Date is not blank, do nothing. The example I was sent from IFS is the attached SalesQuoteExpirationDate.txt If you notice in the attachement, there is a ‘DECLARE which goes down a few lines and stops at END;’;Then there is is code that does the exact same thing as above in a diffrent way, I was told we had to “fool” the system which is why it was done this way. During testing it was found that you have to save it twice and then refreash the screen. I think it is because of having to “fool” the system and this work around is not working.  Sales does not like this. Is there a bettter way to do this through an Oracle Script? I dont mean easier, I know for a fact to mak

Dear all, Is there a way to simply mark invoices so that they won't be involved in a Reminder propoal?I've seen that you can set the Reminder Blocked unitil in the window Reminder/Interest Info per Customer Invoice. Unitl the date set ismn't passed invoice will be excluded from a Reminder proposal.Is there a posibility to set this field in an other way?Or is there an other way to mark invpoices that they won't be involved  in a Reminder Proposal?I know that I can Exclude them when I've made the proposal but then I've to do that every time I've made a proposal. That's not what i want. 

Hi All, It was my understanding that all reserved materials can now be moved in Apps10. But, when component parts are reserved for supplier materials, the system does not allow this reserved stock to be moved.Is this the standard functionality and what is the reason behind this? Or am i missing something? Thanks in advance. Regards,Arunalu 

Hi, I have following requirement, please advise If a supplier is 45 End of Month (45 EOM Payment Term) – they would be paid 45 days from the end of the month the invoice is received (i.e. 45 days from the end of April). So if an invoice was received today (2021-04-08), we would pay them on 14th June at the earliest (31 days in May + 14 days in June = 45 Days) .Please note that this payment term has been granted to us by the supplier  In IFS, if we check “End of Month” in payment term and set 45 Days as “Days to Due Date”, system give priority to “Days to Due Date” and then apply the “End of Month” as a result due date becomes 30th of May . BR Champika     

Hi,     In IFS Aurena or IEE , by which menu I can attache parts into Handling Unit?    eg: in there are 10 parts-A  in stock, I would like to put 5 in Box-1 and other 5 in Box-5.    ※in WaDaco, I know we have “ATTACH_PART_TO_HANDLING_UNIT” procss ,   　 but in Aurena or IEE , I Cannot find similiar menu.

CAn You please point me to the release notes for IFS application 10 update 10 & update 11 . Thank You. Martin  . 

I now have user pictures associated with the Person info.The picture size is 844 x 1055 pixels and by default the user picture looks zoomed out (see below)I will have to manually right click on the image and Scale - Size to fit  , to see the full picture. My question is, is there an way to set the Size to fit option by default ? or is there any option to edit the user pictures in bulk (i.e. modify the picture size in bulk)   

Does anyone know if can I fix a two line M voucher with a missing transaction code on one of the lines?  Line 2 shows ‘MANUAL’ which I would expect, not sure what has caused line 1 to come through as blank.  Any advice on what may have caused it or how to fix would be appreciated.  Thanks

 What DB table or view contains the data for Activated and Terminated employees, and what are the default Company and Site and Permission Sets?    

Is there a way to move multiple serialized parts to a common inventory location in apps 9 or do they need be moved one by one?

Hi could someone please help, i am looking for a way to migrate our users baseprofiles from IFST environment to IFSD environment is there an easier of doing this?  Thank you in advance   

Has anyone successfully implemented IFS Applications 10 to use the default SSL port 443 instead of the standard port numbers?One of my client wants to implement this configuration for couple of reasons:Suppress the port number inside the IFS URL Most firewalls are tolerant to 443 compared to other portsPlease advise, thanks!

Hi Customer is using Azure AD authentication and want to use CRM Panel Outlook Add-In (IFS CRM Panel v10.4.0.0). But Login from Outlook is not working is Azure AD authentication is used. When you press “Log In” in CRM Panel, Azure AD authentication page pops up and after entering e-mail address and password, it just show “Log In” page of CRM panel again. (when using Database authentication, it works fine). We configured Azure AD App registration as described in IFS help files . Customer is using IFS Applications 10 UPD5. Anyone that got CRM Panel working with Azure AD? Is there any patch that needs to be installed? Neno Solaja, Novacura

Hi, Im trying to give a non HR person access to training records without exposing the rest so went about creating an IAL for it with live data and then granted permission to the IAL against the users permission set. However when the user runs the quick report it only returns the data that the user has access to i.e under his position access.Previously i have done this and it has worked fine. The only thing i can think of at the moment is that because it it looking at live data and not copied/scheduled then IFS is still checking the position/data access of the user.The IAL is a union on these two views;ifsapp.pers_license_emp_profile_Ovifsapp.emp_training_history_ov Any ideas?