Solved

Trying to use the following statement inside an event IF  EXPENSE_RULE_VALUE in ('STD') and  #USER_ID# not in ('7889','013588') THEN  Raise_application_error(-20199,'Select the expense t  : ' ||   EXPENSE_RULE_VALUE  || ' can not be used any more' );END IF; But we encounter the below error [ORA-06550]: line 27, column 74:PLS-00201: identifier 'IFSAPP' must be declaredORA-06550: line 27, column 2: any way to use the #USER_ID#  properly ? 

Hi all,  I am new to creating custom events and a novice when it comes to PL/SQL. I am trying to achieve when a Purchase Requisition is turned into a Request for Order Quotation that the Supplier on the Purchase Requisition Line is transferred to the Supplier tab in the Request for Order Quotation LU. My code isn’t erroring out but I feel I am missing something as the supplier is not transferring over. As always, thank you for your help and time.  -EliCode: DECLAREINQUIRY_NO_ VARCHAR2(32000) := '&NEW:INQUIRY_NO';VENDOR_NO_ VARCHAR2(32000);attr_ VARCHAR2(32000);CURSOR get_vendor_no ISSELECT VENDOR_NOFROM PURCHASE_REQ_LINE_PARTWHERE vendor_no = vendor_no_; BEGINOPEN get_vendor_no;FETCH get_vendor_no INTO vendor_no_;CLOSE get_vendor_no;Client_SYS.clear_attr(attr_);Client_SYS.add_to_attr('VENDOR_NO', vendor_no_, attr_);END;

My customer has created a new company in their database and by mistake made it a Template Company. The tick-box Template Company is ticked and it is not possible to untick it, at least not for IFSAPP, the application owner. Is there any risk if we untick the tick-box using PL SQL Developer?Switching the Template_Company flag from TRUE to FALSE?  

Hi,Is it possible to configure the work assignment header through the page designer?Next to Work Details header, WO number- Work Task number is displayed. However, is it possible to configure it like below through page designer.“WO number 36 - Work Task number 42”Thank you!Best Regards,

Hi team,Is there a way to create a project from another by copying, including the creation of work orders equivalent to those of the original project?When I say equivalent, I mean with the same job template.Any ideas?

Dear All,When user try to open Business Activities page, he/she always needs to choose time zone. We have one time zone added, but he needs to click it whenever he/she visits this page. Is there any way to set this global or permanently for user.    

How can i write an expression/query so it’s possible to search on multiple suppliers? Right now my Quick Report only works when one supplier is searched on. See image:Quick Reportselect sig.supplier_id          , sig.name AS "Supplier Account Name"          , sia.address_id          , sia.name AS "Supplier Name"          , sia.country          , sia.address          , sia.address1           , sia.address2          , sia.address3          , sia.zip_code          , sia.city          , se.buyer_code          , PURCHASE_BUYER_API.GET_NAME(se.BUYER_CODE) AS "Buyer Name"          , PURCHASE_CODE_API.Get_Description(se.PURCHASE_CODE) AS "Supplier Category"          , cm.name          , cm.description          , cm.method_id          , cm.value          , cm.method_default          , cm.address_default          , cm.valid_from          , cm.valid_tofrom supplier_info_general sig        left outer join supplier_info_address sia on sig.supplier_id = sia.supplier_id        left outer join supplie

According to the IFS documentation, there are two types of initialization defined as follows:Initialization - sends pending transactions to the mobile app,; deleted local database on mobile app; re-syncs all data. Force Initialization (which only becomes available after selecting an initialization) - immediately deletes the local database on the mobile app including any pending transactions; re-syncs all data. Following are the only ways I am aware of when an initialization occurs.The first time a new user logs into the mobile app. When the user logs in from the Activate box after Deactivating.Clicking on the Initialize button in the mobile app.Clicking on the Force Initialize button in the mobile app. QuestionsWe’d like to avoid having a user Force Initialize so no transactions are lost. So here are my questions:Besides the Force Initialize button, are any of the examples above considered a Force Initialization? Are there any other says to perform a Force Initialization? Are there any

Hello IFS community,Is there a table that hold all the messages sent via IFS notification?Or any particular place where I could see all the messages sent? IFS9 Thanks,JL

Community, would like you to share how you are handling below scenarios, Product A Rev 2 currently is on shop orders, which are started, whereas engineering department issue a new revision of Rev 3. and shop floor are requested to build Rev 3.question is, what is the best practice to handle this scenario? what if the components are installed already?

The above code modification compiles and is technically correct but my IFS Connect flow doesn’t run thereafter.Commenting out this inclusion will make it work again.

Hello,One of our customers have reported that their ifsdump.cmd does not work correctly as it does not pick the needed log files when creating the .zip. I have compared the .cmd file with a file in a core environment and both look identical. Any idea on what could be the reason behind this? 

Hi,I have installed the IFS Developer Studio 10.82.0, once we right click on any entity file generate code and deploy getting this error.java.lang.ClassCastException: [Ljava.lang.Object; cannot be cast to [Ljava.lang.String;Please provide solution to overcome this error. 

Hi We using IFS 10 upd 6, installed 2013 Visual studio, installed Toolkit also, while opening IFS form getting this dll error.  

Could someone explain how the tolerance is calculated on a Posting Proposal and how it is being finally posted? Does it consider both % and Amount defined in the company/supplier level? Reason for the clarification: A customer requested a lobby to reflect the number of PO matched invoices that have the PPV within tolerance and the PO matched invoices that have the PPV outside tolerance.

Hi Community,When we use Output> Excel option is IFS, the dates after 2029 appear as 19## is excel.For example is date is 03-Jun-30 This is exported as 03-06-1930 in excel.If I change my Regional Setting in PC to DD/MM/YYYY, this issue does not occur.This is very strange - Why it only occurs for dates 2029?Is this something to be reported to IFS?ThanksGayan

Hi,When i m sending a customer order e-invoice, i m receiving the following error. May i know what could be the reasonBest regardsZuha

HelloWe have a problem with printing labels from the printer Citizen cl-s521. When the print is started via the print agent, the label is physically printed on the printer without any problem. The printer is mapped to the server and the process takes place over the network (the printer has an IP address). When we print via USB on the same printer, the printout appears in the print queue locally on the workstation, but the printer does not actually print it. Any ideas? 

Hello all,  Is it possible to add a custom button to the Shop Floor Workbench? I have IFS Developer and some developing experience in Java, .Net and the like. I am just curious if this can be done as I was not able to find anything in the technical documentation on whether or not this was possible.  As always, thanks for the help! Eli  

Hi Everyone, is it possible to add a LOV to standard free entry field ?I suppose the answer is no and that we need to use a custom field instead but just need to make sure that I am not missing something . Much appreciate.

Hello, Since March 10, 2022 our IFS 8 Prod environment has been crashing about every hour.We have not been able to identify any changes to our database, firewalls, servers, scheduled tasks, integrations, IFS front end configurations, hostingTo get it back up, we log onto middleware server > instance > bin > stop all services then start all services. It stays online for a bit, then crashes again.Best guess is that it seems to be connected to the # of users that login.  Relevant details:The Database does not go down during the crash During/after a crash before we start all servers again, the ‘check server status’ script shows severs are up even though no one can access It stays up over the weekend or during night shifts significantly fewer users doing less types of tasks during these times only confirming production, moving inventory, and quality control plans Integrations & major functionality Radley EDI, Radley data collection, TrueCommerce EDI CBS, demand planner  What

We had 2 users that were accidentally making changes to the same screen (installed items).  We are now stuck where neither user can publish or delete their customization.  As we have 3 other pilot environments without this issue, is there a way to copy over existing files that are customizer related and replace the problematic ones?

Hi! We implemented IFS apps 10 in my company just over a year ago. We still have many problems but one of the biggest is the system is constantly asking us to buy things we know we don’t need. (Garbage in garbage out of course!) My specific question is, ‘What is MRP Planned demand’. In the I P A P screen, it’s easy to understand why something is needed when the demand object is a shop order, or a customer order… But it’s baffling to continually see MRP planned demand. Especially when we know it’s not real demand. What does this mean?    

Hi Community, Is there a possibility to monitor/track who has exported which data via IFS Client?  Thanks in Advance!Best regards,Thakshila