Solved

hello every one,in some users the Attachment does not appear, but in some other appear for the same logic unit , the problem maybe in Permission Set.can anybody help.thank you.     

Hi All, Can anyone please show an example of using NVL2 function parameter in a BR report?  I tried to use NVL but could not get what I wanted. And trying to use NVL2 function parameter, but  not sure what should I enter for the first argument (ValueIfNull). please see the image.&CodeB is a standard parameter for DIM_CODE_B.CODEThe requirement is to get all CodeB values including NULL when the &CodeB leaves blank and the selected CodeB values when &CodeB has a value.Example:when &CodeB = say '45' , the report will only show the records with code_b = 45when &CodeB leaves blank (NULL) then the report will show the records where the code_b of any value plus the code_b IS NULL  Thank you!

Hi All, I’m struggeling to create a list via a Mobile Client Script.I succesfully recieve a Object with data via getDBValues, but I only need one item from that object. So I created a for loop, to go trough the object and store the value in a String, Array or Object (doesn’t matter). Creating a new Array or a Object seems not to work for mobile Als simply extending a var via the += method also not working.Example:var data = getDBValues(stringFormat("SELECT id FROM database_table WHERE type = 'placeholder'"));var arr = new Array();var list = ‘’;for(var i=0; i < data.length; i++) {       arr.push(data[i]['ID']);   list+= data[i]['ID'];} 

We are using IFS 10 UPD7 wherein the Inherit Measurement functionality is not available.Since there are some serial objects which are being moved between equipment's and running hours of the serial object is tracked for maintenance, repair and replacement, it is needed to auto update the measurement readings from the parent object. Would like to know is there any patch available to get this functionality in IFS 10 UPD7 version. Thanks in advance,Siva Ganesh M  

I have problems with an advance invoice that is bigger than the connected Customer Order Invoice. This happened when Customer order was created, Advanced invoice was created and sent to the customer.Thereafter the price for an item on that order was decreased. Order released, shipped. When the invoice is to be created, a posting error is displayed:“ORA-20105: Invoice.ACCERROR1: Error (Sum of offset amounts 10000 cannot exceed gross amount of customer invoice 9500!) occurred while booking Invoice CD 220000074.” According to help text, “Advance invoices can only be prepared for up to one hundred percent of the total value of the order”, in this case the advance invoice is about 105%.I cannot post invoice. Any option to get these posted are of interest, preferably with the difference as POA.Best RegardsDenny

Hi  I am trying to setup an employee schedule for our casual staff where they are scheduled to work a Total 40hrs per week, (5days a week for 10hrs per day), with any additional hrs works they receive as overtimeI.e. if an employee works 43hours, they should receive 3hrs as overtime  Mon Tue Wed Thur Fri Wk Total Normal 9 12 12 7 - Overtime - - - 3 - Total 9 12 12 10 - 43  When trying to set this up as a Day type schedule, I can’t seem to get the overtime to calculate correctly, as it is calculating based on the 10hr per day not the total 40hrs per weekI.e. with the above it is calculating 4hrs as overtime I can’t seem to get the Flexible schedule to achieve this either Any help would be hugely appreciatedCheers 

 Dear All,would you help ? I’ve an issued when tried to create shop order the message was shown “Supply for shop order part not allowed”, would you kindly suggest ? Thank you.

hi sirIn app10 upd15 and upd16 aurena.in the supplier address window,  there is no address detail is it a bug ？ 

Hi All, I’m raising this IFS community post on behalf of a customer. The customer has raised an issue regarding the unavailability of the RMB option, “Electronic Payment Addresses” for the payment method CHK. Customer was already informed the following explanations through the case. CHK payment method doesn’t have an electronic payment address in the IFS application.  This is the reason why this option is not available with the CHK payment method.  For payment methods such as, SEPA, BACS, ISO22000, or ACH, this option is available.Customer needs to know the reason why some of the payment methods like CHK are not enabled for “Electronic Payment Addresses” option.  Thank you! Best Regards,Geeth 

IFS Cloud 22.1.4, Case CS0087287ObjectProperty property_value cannot be longer then 24-67 characters in Aurena. Because ETAG exceed 100 characters. etag_ VARCHAR2(100) := 'W/"'||objid_||':'||objversion_||'"';objid length = 18other characters = 5100chars is exceeded whenvalue length > 67 charswhen validation is enabled => max. value length = 67 – (length of validation method aprox. 43 ch) = 24 charactersSELECT avg(length(validation_method)) FROM object_property where validation_method is not null; = validatation avg length = 43chI want to use 250 characters long string, column is defined as 2000 chars long.This BUG is system wide, etag creation or long objversions must be redesigned at least for specific logical units. rtrim(rpad(property_value||chr(31)||validation_enabled||chr(31)||validation_method,2000)) objversion,  

Hello,I hope someone can help me 😊.This is the scenario :When a CO is for the customer XXX, I would like to create a “Purchase Order Direct” , and when it’s a YYY or ZZZ customer i would like to create an “Invent Order” . ( It’s the same sales part )Can we drive the Sourcing rules automatically du to the customer ?These are the setting I made :Create a sourcing rule : With highest rank as Sourcing Objective.Create a sourcing rules per Customer and Sales Part   And this is the error when I create a line on CO : There is also the set up “Sales Part” Sourcing Option, but i’m not interested because it will always give the same choice for every customer. Did someone  know how to setting this properly ?Regards,Nicolas.

I have created a persistent filed of data type number and would like to limit it to 2 digits.  Does anyone know how to limit the field to 2 digits?

Hello all,I would like to ask for your help to navigate me where to set the background color for gant chart in APB. Unfortunately, it is set to the orange and I would like to reset it back to white/transparent. Can you navigate me to the appropriate register key?With kind regards,Zdenek Baumelt  

Hi Community, does anybody know if it’s possible to customize the .html layout of the service report in Aurena Native Apps (Service Engineer App)? thanks and BR,Sven

Morning All,  I am following the documentation to Configure IFS Database Identity Provider:Configuring the IFS Database Identity Provider Our Apps 10 environment is running on a local server,  is it possible to have Logo URL and the Background Image URL local files stored on the server and not web addresses?  I have attempted to have the URL as \\T:\IMAGES\BACKGROUND.jpg but this does not seem to work, the images are stored on the middleware server and the path is correct. 

To extract data from IFS, Is the use of ETL like Boomi prevent the use of other mode of Extraction( flat files extraction ) ? that is to say, if i use Boomi to extract data from IFS i cannot do so using flat file in the same time ?

Does anyone know how to clear old customer and supplier schedules from the table?  We have added values in the Customer and Supplier Schedule Agreement Part record for ´Old Plans to keep´. In my test example I set the value to 50 but after running the MRP we have 273 record in the overview. I guess there need to be some kind of cleanup task that will clear old customer and supplier schedules but I cannot find any matching database task. Any ideas?  Thank you.Josefin  

 Hi,A Part is having 5 characteristics A,B,C,D,EConfiguration combinations tables are using all characteristics and returning values.But from sales rules, it has been defined to detach a characteristic B when selecting an Option value from A,But There is a Value defined in Configuration combination using characteristic B.Due to detach of characteristic B, There is an error in Interim order header, component defined in Configuration combination table is not returning to the structure….Any known fix for the issue?more example…….As from above example shown in picture 20-AO_QTY is the characteristic that detach when selecting DP from 20-COMP-CONT Characteristic. 1 is the default value for 20-AO QTY.if there is a value in 20-AO QTY, it is not passed the connected component Default value is return, not the connected value.when we empty the value in 20-AO_QTY, then correct value will be returned.

Where would I find schema changes for 11.5? It would appear that tables have been deleted in the wiki.  

Hello,the release of PSO 6.10 is announced by IFS September 2022.Does anyone have the release note available? ThanksMArkus  

Hi, Does someone knows how to create and the connect a Customer Invoice to an advance invoice already created?Here is the step by steps I followed:Have a Customer order in planned status connected to a Projet I RMB and created an advance invoice related to this Customer Order  The advance invoice is created, I print it and paid it: it’s in status Paid/printed I followed the Quick Handle flow for the Customer Order and change it to Deliver status Know I want to have the Final Customer Invoice created to be able to link it to the previous Advance Invoice created. I’m stop at this step because:I do not have the option to create a Manual Customer Invoice,The instant invoice is not relevant for this matter I cannot create the Invoice in the screen “create customer invoice” , my Customer Order doen’t appears.I only have the Advance Invoice for this Customer Order.Does someone has already test that and suceed ?Thanks for your helpCamille

Failed transaction handling is big trouble in practical scenarios. Work order transferred to mobile is accepted by the mobile user but later it is taken back or put up in the prepared status in IFS for reassignment or replaning. IN SUCH SCENARIOS, Group messages will fail and handling of these messages becoming big hurdle. How these can be properally handled. Specially, I  such scenarios where WO no is showing g different WO no like - 50004 etc. 

When a user creates a material requisition for a  particular site, is a transport task automatically created for this material requisition? 

Hi,I am trying new custom API through IFS Developer Studio for IFS Cloud project. Once it is deployed properly, able to see it in API explorer and able to call it in web browser and got proper response, where as if I browse the same API throguh Postman, got 401 Unauthorized error. Request Header what I am passing is, Basic authenticaion with content type. Could anyone had faced same issue and what is the workaround for this? ThanksVenkat

When the Dispose of an object is done using sale of an object which is an income to the Company , we had already raised a Customer order and Customer invoice for thisIs it possible to invoice the sales of an object using Customer invoice without instant invoice process?What is the process here ?Should i first proceed with Customer invoice and once it is transferred, then create manual voucher and post it to asset?Thanks,KMH