IFS Solutions

Suddenly, a last week, users began encountering the following error message when trying to access Power BI reports connected to IFS APPS 9 data sources which are hosted in IFS Managed Cloud."Data source error: {"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"Oracle: ORA-12170: TNS:Connect timeout occurred"}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourceKind","detail":{"type":1,"value":"Oracle"}},{"code":"Microsoft.Data.Mashup.ValueError.DataSourcePath","detail":{"type":1,"value":"ifs_prd"}},{"code":"Microsoft.Data.Mashup.ValueError.ErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"M

Hello - We have a process where some of our suppliers are paid via credit card, which we want to process the true invoice through the system, but then will receive an invoice from the credit card company which will reduce cash.  We want the payment of the supplier invoice to hit a liability account, not the cash account, but we do not know how to set it up to work that way. We have a different payment method for this type of transaction, but how do we get it to DR AP, CR Liability account at PAYMENT of these invoices. 

We have on-boarded a large application wherein the application takes a pathway back through an Integration/Coordination process, through to the Server/data endpoint.ie,Application → Integration/Coordination → Server/DB ServerWe have relations setup between each node to show data flow from the App to the Integration and the DB to the Integration point.  This is the flow of data.  However, when our Service desk receives an issue with the application by an end-user, it will only show connection to the Integration point and not through to the server/db infrastructure.Question:   Using relations, how would you represent that the Application is connected to the Server/DB Server as well as the Integration/Coordination point?

I get the following error when I create an invoice from an Application for Payments (AFP).  Notes:I have a Person connected to my user. I do not see any report rules connected to this (as per what I have noticed). How to get this solved ?Thank you !

Hello, my company has been using a shared repository for docman since they went live on IFS.  I am in the process of transferring the doc repositories to database storage to prepare for the Cloud upgrade. The business would like to block users from creating new docs in certain doc classes.  They would still like the ability to view them. I tried removing Admin and Edit access from the access group in this doc class TEST but a user who is not a docman administrator was still able to create a new doc, I think because by default the doc creator is an admin. Is there a way to block new doc creation by class? or do we have to use custom events to do that?Mary

One of our Customer would like to implement an interface with Docusign. Seems that we have some available API like CDocusignSignerEntity. Is this standard and if yes, do we have some use case and example ?

Hi Docman fans!This post is an experiment to see if we could keep one thread where we collect the most common questions asked about IFS Document Management (aka “Docman”).We could either add links to this entry itself, to other discussions here, or we could add each link in its own reply below. We’ll see what works best.

We are experiencing approximately 5,656 SFTP connection attempts daily from IFS application to an external sftp server (AccessPay). The SFTP connection is always enabled and configured for bank reconciliations.Is this level of connection frequency typical for IFS Cloud environments? Is it normal for IFS Connect Reader to continuously connect to an external SFTP server to read files?

Hi All, We can create a BACS file (BACS.DAT) from ‘Supplier Payment Proposals’ screen.My question is, how to configure the application where BACS.DAT file is copied to a ftp location.Is there any specific screen in IFS where we can configure this?  

 How to revert a Confirmed PO to Released state ? 

Hi, Im using ifs.application.reportingservices.impl.extendedformatter.xslplugin.XSLPlugin plugin in cloud to change the formatting of an existing report using a rpl. But Im not sure what is the xml should be feed into this rpl. I tried the example rpl file given in the documentation as well but didnt work.​@ChanakaAmarasekara any idea?Im referring https://docs.ifs.com/techdocs/24r2/060_development/025_operational_reporting/190_using_report_plugins/020_xsl_plugin/#exampleThanksRoshanga

Hi,I’m planning to import App10 saved searches of the users into IFS cloud instance. As the formats are different in two versions, I want to de serialize the saved search conditions saved in the fndrr_client_profile_value of the app 10 database. They are currently serialized in to the xml tag <SERIALIZED_CONDITION>.Is there a way to de serialize and view these saved searches? I tried few options but nothing worked.ThanksRoshanga

I have a Global Code that has the code value and description. I want to be able to display both the code value and description. I understand I can have 2 initiative ID fields, 1 display the code value while the other displays the description, but how would the initiative description be written to the database?Is there a way to have a field populated based on a drop down in UI Designer? 

Is there an easy way to add all components from a manufacturing product structure to the produced parts of a disassembly one (same FG)? We are trying to disassemble a finish good completely into its components. The problem is that its has 80 components. Manually creating each disassembly component is pretty tedious. I tried to copy the rows over to the produced parts table from components; the items filled in but not the quantities and it wouldn’t let me save. 

Hi, Can you guys tell me, where the attached files are physically stored in the IFS. I want access the attached file location.   Thanks.

Problem:When you make a API GET, you might want to filter on a nested entity. When you do this with the camunda engine, you are just unable to. In my opinion it seems only logical to be able to use the filter, but it stays empty. Solution:Make it available. Doesn't seem like an out of the box enhancement, more of a design flaw honestly.

Hi IFS Community,I am exploring a way to automate procurement of component parts linked to a parent part when Order Point Planning (OPP) triggers a Purchase Requisition (PR) for the parent.Example Scenario:A parent part "Wheel" has a BOM with components like "Tire", "Rim", etc.When OPP triggers a PR for the "Wheel" (due to reaching its order point), I need the system to automatically generate PRs for its components (Tires, Rims) as well.Thanks in advance.

Hi AllI am trying to test the emailing of RFQ to share with suppliers. First I tried to email it myself.  However in the application messages, the following error appears and sending fails.   

Hi,we have one page word files. When we approve this document, we are taking a mistake “something went wrong in the call the application server when trying to get the file size” how can I fix it ?    

Hi,On Apps10 Enterprise Edition is it possible to auto-populate a custom field based upon what is inputted to another custom field?In the same way that when a customer ID is selected in the Project screen, the Customer Name is then auto-filled immediately (see below).I have a custom field that is a lookup; when it is clicked into by the user it brings up a lookup that searches for part numbers. When a part number is selected I want a second custom field to be populated with the default location of that part.Is this possible? I don’t think it is, only built-in IFS fields can do this but I want to confirm.Thanks you,  

is it possible to create a lobby to show missing timesheets, based on work hours and timesheets raised in period in IFS Cloud?

I am currently in the midst of testing the IFS Cloud IFS Connect Reader using SFTP. While I have conducted several successful tests with the known host file, I have encountered an issue when using the private key-public key pair. I am unsure whether this is a bug in the application or if someone has successfully used the private key to read an SFTP location via the IFSCloud Connect Reader. I would greatly appreciate any insights or comments on this matter.

Hi, I am currently having trouble with shortage handling in IFS Cloud. I’m trying to get the shortage notification to appear when I place a Customer Order in the scenario where there is no stock available to fulfill the order. I have enabled the Shortage Notification toggle on the Inventory Part and the Shortage Handling toggle on the Parameters for Supply Chain and Manufacturing page. I have checked to make sure there was no quantity on hand and also see the orders with shortages on the Handle Customer Order Shortages page. Is there anything I’m missing for this message to appear? Any help is appreciated!

Hello All, I have a question regarding the Supply Chain/Invoicing system in IFS that I cannot seem to find a solution for. A customer of ours has setup an online market place that they want us to start using to “shop” for better prices on component parts we buy for their products. Right now, we’re using IFS to generate PORs → POs → Arrival → Invoicing to satisfy demand and stock the components. However, they want us to be generation POs and invoices on their market place. I don’t see a way in IFS that this solution could be accomplished, as we would still have to generate a PO in our system and receive the stock in. We still need MRP to keep track of when we need parts. I had thought about putting in a $0 purchase order, but that would create a financial variance then that would need reconciled. I don’t believe this is something that could be addressed using VMI either. Not sure if anyone has come across this scenario before, but wanted to ask the community. Tha

Hello For the last 3 years we have issues when closing the IL. We are receiving the error message that parallel currency is not in balance and we are not able to create vouchers that are needed for audit. We can transfer the balance just not the create voucher function - We did have a fix that was to create a Q voucher posting to an SBAL account but we should not have to do this ?? We are on APPS 10 UPD 19 - All help gratefully received ! Many thanks in advance Paula