Solved

 I am trying to connect an IAL definition to a Data Source Designer Element, but when I click the preview button I get an “SQL command not properly ended”.  Here is a screen shot of my IAL Object Developer, below that is a screen shot of my report designer and below that is a screen shot of the error I am getting.IAL Object DeveloperData Source Designer 

Hi, I've got a question with regard to IFS Aurena. In the time registration UI, in the side bar of the list of employees, the employee's name is not visible on each list item. However, an icon is visible denoting the initials of the employee. Is the is the default behaviour? How can I make the names visible? I also noticed the same behaviour in other UIs such as expenses to manage. That's why I'm uncertain if I have set up the system correctly. Can you give some hints to fix this?

Help please, We bring in the field VENDOR_NO on the DEMAND_LINES, SCHEDULE LINES,However when I look at the incoming customer schedule I can not see this field or the data. Does anyone know where is kept? I am asking as we need to put this detail on our out going ASN message.Thanks in advance for your help, Sarah

We have a customer in Germany that requires .xml reporting for invoices.  We tried using a .rdl report from IFS to generate the .xml successfully.  However, the report shows our Parent US company name on it and not our subsidiary from Europe.  Even though the invoice is for the other Company (FR200)in IFS.  How do we update/fix the .rdl to have the Europe company name on the report instead of US? 

Hello,We are using IFS 7.5, I know it’s a little old.  Anyways, I have a couple questions. Sometimes I need to enter/voucher invoices without a PO so I enter everything manually such as the account and cost center.  I have noticed that sometimes when we pass the plan pay date the payment does not go out.  It kind of seems like it gets stuck in the middle between me vouchering an invoice and payment being made.  Can anyone answer why this happens?  When I pull up the entry and I want to cancel the entry and re-enter it I get an error saying that the “invoice is used in payment order” which leads to my second question.   Is there an option on the payments side that can push the invoice payments through.  As of right now the only way I can try and fix this is by someone on the payments side going into the system and searching for the supplier ID that didn’t pay out and cancel the payment.  Then on the invoice entry side I can cancel the invoice and re-enter it and hope that payment goes

Have made changes to a data source, then the applicable element, cleared server cache and lobby cache (URL) with no luck.I know I must be missing something simple, but I do not know what it is. Sincerely,VK

What step of the Supplier Agreement flow that we enter a Project ID? In the planned state or after in the Agreement, IFS won’t let me enter a Project ID either from the LOV or manually. I was wondering if a Supplier Agreement can be used for a Project based purchase at all? The business requirement is, the project needs to release a PO through an active agreement.   

Hi, we would like to be able to enter time cards on behalf of other employees.We know already how to do it if we are in the same project team. But how to do the same if we are NOT in the same project team? We systematically get this error message: “You are not allowed to enter Project Time/Cost Reporting for this Employee of company XXX.I guess there could be a way via Access Attribute, but i can’t figure out what should be changed to grant this right.Thanks to help if you have any clue ...

When trying to refresh 3 data mart sources either individually or together  we receive the following message:Error while refreshing Data Mart Source (CONSOL_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expiredError while refreshing Data Mart Source (CONSOL_PER_DET_BAL_MVT) - resource busy and acquire with NOWAIT specified or timeout expiredError while refreshing Data Mart Source (CONSOL_PERIOD_BALANCE_MVT) - resource busy and acquire with NOWAIT specified or timeout expired At the time of refreshing I was the only one logged int. Regards John

Hi,Is it possible to convert normal table row to a table header in Report Designer? Or move existing table to Repeating Header section?Thank you. 

For some reason Search with Keywords does not functioning in APP10 Customer database. Is there any specific setup? 

From Document Class Management > Persons and Groups user NETKLK is enabled to create documents from doc class : PO-S1.But not from doc class PO-S2. Therefore when searching for document class when creating a new document revision with criteria PO-% user will get only the doc class PO-S1.But when user is trying to attach a document he/she will get document revisions created from doc class PO-S2 as well. It is also possible to attach a created documents from doc class PO-S2 . How to restrict attaching documents from document classes that user does to have permission to create new revisions?Thanks In Advance

What is the max size limit for uploading attachments to transactions in IFS10 / Aurena?E.g. Purchase Orders, Requisitions, Projects, Work Orders etc Thank you, 

Hi  Attached is an example of unexpected results in apb.Shop order 903 is the parent shop order 1000 Disc and spindle is the child wanted for operation 10 of 903Both parts are finiteResult from APB puts shop order 903 finish date ahead 1000, This is a physical impossibilityWhat do we need to do to make sure the parent SO uses the child part for its planning?Thanks

Hi, We have installed IFS7.5SP6 on a machine with OS win2008R2. The connect and batch services are coming done with below error in the log:=============================================================================2020-09-24 12:44:22,152 1 ERROR [Integration] StaServer.__AW_init(): Fatal error!ifs.fnd.ifw.sta.UnauthorizedAccessException: POST error #401: Unauthorized accessat ifs.fnd.tc.http.HTTPClient.__AW_doPost(HTTPClient.java:420)at ifs.fnd.tc.http.HTTPClient.doPost(HTTPClient.java)at ifs.fnd.tc.http.HTTPClient.__AW_post(HTTPClient.java:240)at ifs.fnd.tc.http.HTTPClient.post(HTTPClient.java)at ifs.fnd.connectserver.setup.ParameterList.fetchConfig(ParameterList.java:179)at ifs.fnd.connectserver.setup.ParameterList.<init>(ParameterList.java:101)at ifs.fnd.connectserver.setup.ConnectorLoader.<init>(ConnectorLoader.java:128)at ifs.fnd.connectserver.ConnectorServer.initializeServer(ConnectorServer.java:79)at ifs.fnd.ifw.sta.StaServer.__AW_init(StaServer.java:83)at ifs.fnd.

Can anyone help me with what transaction triggers the Posting Controls of GP22 - GP25?  I can’t get these transactions created in the application.  What process creates these?

Hi, I want to use the Information Sources Supplier/Customer Open Balance, but Business Reporter is not showing data when I run the report. I tried adding various data items, but not one is showing data. Has anyone else experienced this problem and/or knows what the issue is and how to solve it?  Kind regards,Simon 

Hi, Has anyone used SAP crystal reports server (not ifs crystal web service) to automate emailing of reports. I’m getting an error when running reports with IFS data. It doesn't seem to be connecting to the database. Any information is greatly appreciated. -Mike

 Hi all,I have my data source based on an IAL. As I learned the where-statement should be made in the data source when I want to navigate form the element to a window: My element looks like this:  But clicking on the element within the lobby does not show the data:   Any tipps and tricks how to solve that? Thanks a lot for your input! Mattis

Hi All, We just went through update 9 in IFS apps 10 and are running into an issue. On commission orders we used to be able to add an unconnected charge line and invoice that on it’s own. Now we have to add a $0 order line, connect it to the charge line, and change the wanted delivery date to today’s date so we can invoice it. It this new functionality or do I need to look for a setting somewhere? Thanks,Mike

Hi,     I have created a Sync Rule with delivery mode as Batch Delta and everything runs fine until the Mobile is initialized ,After initialization no data is there in the table and the data gets pushed the next time the sync rule runs.Is the app not supposed to download data for all tables when it is initialized for the first time.Am i missing something,Any guidance would be appreciated

I’m trying to copy a CLOB field from one table row to another.Is this possible with Data Migrations?

Hello,   I have problem about IFS System Monitoring in IFS Application 10 upd7, and image does not apper in some IFS System Monitoring at menus Database   Memory and CPUDatabase Locks    SGA Info    Scheduled Jobs  Tablespace Details  How to solve about this problem ?   Thank You

Hi, We would like to do the authorization of a purchase on the purchase requisition level, because there we can use the Pre Posting based Authorisation. However, if the request is converted to a PO, you can still change whatever you want on the PO level. Is there a way to restrict is, or is the only way another set of approvals on the PO level? thanks!

I'm trying to create a event or addition, to set the Sales Quotation to state printed.The Sales Quotation is released if the attached document is released, it is triggered with the below custom event. This works great.But it does not trigger the print checkbox, and therefore the revision function is not triggered.If a update is made for the Sales Quotation, the SQ is not revised, because it has to be in state printed.Can someone give me a hint on how to get the state of the Sales Quotation to printed. declare   info_ varchar2(32000):= null;  objid_ varchar2(32000);  objversion_ varchar2(32000);  null_ varchar2(32000):=null;  pragma autonomous_transaction; begin    select q.objid, q.objversion into objid_, objversion_  from order_quotation q where q.quotation_no=doc_title_api.Get_Title('&NEW:DOC_CLASS', '&NEW:DOC_NO');    ORDER_QUOTATION_API.RELEASE__( info_ , objid_ , objversion_ , null_ , 'DO' );   commit;   end;