Solved

I want to retrieve data from IFS database into a Word document, e.g. work order number and task number to which the document is connected. Document is stored to IFS docman and data should be fetched when document is opened for viewing.Is it possible to do the procedure with document macros?

Hi experts,There is an requirement as below. In request screen, we can have multiple part needs. Once we create a new row in Part needs tab, we need to add some default values (Ex- Promised Date/Quantity) to the newly added row based on the first part_need row values. As an example, in this screenshot, first part need sequence = 46. So when user adding new row by using New button, the values from sequence - 46 should be fetched and set as default values in the newly created row.  I have already fetched the values from the first part need row by using client script sql. But when I try to use the getDataTableSelectedRows and setValueOnListDataRow, it seems these methods are not triggering the newly added row. Instead this method will trigger the first row since that is the one already selected as the default. Any feedback or work around for this. Thanks,Hasara

Hello community experts, I have a custom block on frmObject_Ext that works when I am running manually on PL/SQL developer, however is not working in the IFS Apps. I am receiving below error. &COMPANY is not fetched from user window.   This is my custom blockDECLARE company_ VARCHAR2(32000) := &COMPANY; object_ VARCHAR2(32000) := &OBJECT_ID; code_a_ VARCHAR2(32000) := &ACCOUNT; invoice_no_ VARCHAR2(32000) := NULL; amount_ NUMBER := NULL; old_info_ VARCHAR2(32000) := NULL; old_objid_ VARCHAR2(32000) := NULL; old_objversion_ VARCHAR2(32000) := NULL; new_info_ VARCHAR2(32000) := NULL; new_objid_ VARCHAR2(32000) := NULL; new_objversion_ VARCHAR2(32000) := NULL; attr_ VARCHAR2(32000) := NULL; action_ VARCHAR2(32000) := 'DO'; CURSOR c1 IS select p.invoice_no, sum(p.dom_amount) from ifsapp.MAN_SUPP_INVOICE_POSTINGS p where company = company_ and code_i = object_

Hi,in a datatable in the UI designer a field gets truncated (web-client).I didn´t find a solution. I tried with length an control-type but it has no effect.Custom Metadata for the field:Max Chars 1024Column Type STRING (also tried LONGSTRING) The text is completely visible in the datatbase!Does anybody know how to slove this? Thanks 

Hi Is there in IEE a way that a user might grant document access to multiple documents without having to open every single document individually?We would like to avoid PLSQL scripting, as the user who would give access do not have access to the database, but are only admins in the document management area.Is there a screen we cant find, or a IFS standard RMB or assistant which does this? We are on IFS10 upd.8Best Regards

Hi,Is it possible to enable the import button in Sales Order module?version 15.3.0.5 Regards,Robin

Hello,we are new in iFS world so we would like to ask for help here. For Supplier Invoices we plan to use posting control M93 and control type C31 for automatic account number assignment. Everything is set-up and working properly but there not possibile to override assigned account if neccesary during Manual Invoice processing. "Override” selection doesn’t seems to allow that. Any sugestions how to achieve this except reopening and edditing of line of the PO? Thank you

Hi folks,  if we could have desired process to upgrade Assyst 11.5.2 from 11.3 on prime , regards  

Hello.  I think this is a simple question.We are testing implementing EDI Customer orders.  For an inbound customer order (EDI850)  how is the ship-to location for a customer that has many ship to locations specified in the XML? Today, in our current system, our ship- to locations are coded by an alphanumeric designation  Specifically where in the XML should we specify the customers ship to code so that in IFS the correct shipping address is on the order?  I hope this makes sense.Thank you.  Any help would be appreciated.

HiWe are using the quick order flow as the way for users to progress orders but when an order has a line which is subject to an export licence the next step is not being shown in the quick order flow. All the orders in the snip above are of the same type for the same customer, but MLM061 and MLM063 both have a controlled part, MLM061 the licence shows as ‘connected’ and for MLM063 the licence shows as ‘matched coverage’.The reservation and create pick list next step for these orders was not shown under the three dots.  This means the user has to go to different screens to progress those orders even though they are doing the same process.  The user is able to do the reservation and picking without being blocked by any export licence check.Is there a reason why these orders are not being handled in the usual way under quick order flow once they are released?  Is there an option we can set to make sure they show up the same way?Any assistance much appreciated.  We are using Cloud version

Does anyone have an example of creating a task in Custom Event using PL/SQL? I will be grateful!

Hello,   We are currently moving to IFS Application 10 Update 6 and we read in the documentation the .NET IFS Printer Agents currently do not support the Socket Server which we’d use to print ZPL files.  The java version of the print agent still supports a Socket Server to print ZPL but we’d like to utilize the .NET Print Agents.   Is there any release information on when the .NET Print Agents will implement the Socket Server?   Thank you, William Klotz

A few users are getting this error, when trying to view attachments in Apps 10 the attachment shows that it’s there, but they cannot view it.  “ slow network mode click here to view attachments”

We have a Contact User Lookup field that uses Lookup Expression as below:select usr.id from usr as usr where usr.csg.shortCode ='xxxxxxxxxx' The expression returns only Active Users. We need all Active and Inactive Users.

I am in Resource Navigator in the correct Person group. I found the person and in their Connections > Employee tab I am trying to add their Employee Object. When I click on the add (+) it auto-populates the correct Employee ID but when I try to save it, it says “Employee XXXXX does not exist”… but I’m literally staring at the Employee Object. Screen shot below: 

How to add employee picture in report using IFS developer studio/IFS report designer tool??

We have a series of authorisation rules in place for Project requisitions based on value.  These are along the lines ofup to 10k by Project Manager 10k-20k by Project Manager & Department Head 20k+ Project Manager, Department Head & FD   Is it possible to have an additional rule, where non-project reqs just go to Finance Manager for sign-off?Is it just as straightforward as ticking the Apply for Non Project Connected PR and making sure the Priority is a higher number than our existing rules? Thanks.

Hi Community, mistakenly ran the condition generation command without mentioning the Equipment ID, which leads to generating multiple Work orders so my question here is is it possible to cancel these work orders from inside the PM Action in a way that will not affect the PM sequence.?? Thanks a lot in advance

Want to add Job Description(JD'S) on employee file is there any specific field to keep this in IFS

Scenario:  Work Order goes out and checked but not fixed and it gets marked Finished and moved into Historical Work Order List.  From the Historical List I right Click and select Reopen and it moves it back to the Open Work Order list.Now the Status says WorkDone can that be changed back to Released any way? How will the Maintenance Dept know that WO still needs done?Do we have to rewrite the Fault Report and reference the “Old” one

Hi All,We are facing issue as P3 task which is having 3 days SLA are getting assigned after 10 days, after breaching SLA. Can some one give me the solution. Regards,Shiyaz

I am adding Like operator in business rule input parameters as below, but somehow this is not working as expected. I need the business rule to be triggered for all the Tasks which have Task Template Id’s starting with AR_BS or CO_IP like AR_BS_XYZ, CO_IP_ABC, CO_IP_123 etc

I have accruals that I want to upload instead of manually enter. Can external vouchers auto-reverse? 

HiWe have a number of PM’s which should generate 4 weeks before the planned start date, which has been working fine since 2015 but for some reason no work orders are generating for 2023. The calendars are generated and I even regenerated these yesterday but nothing. We have schedule database tasks that run overnight to generate the work orders and these are running fine with no errors so I am not sure what else could be causing this.Is anyone else experiencing a similar issue or can any advise what else I can check.This is in Apps 8.Kind regards,Hayley

Hello , i create a user shop_lead_1 as time clock user service .The user had the access to the Company .In time clock i can’t see the employee of the concerned Company as you se below : Need help Please