Solved

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;    

Where can you set what you want your purchase order number to look like?  During implementation? 

We are running Apps10 UPD8 Our Finance department would like to start emailing Customer Statement Of Account reports directly from IFS.  We are testing the setup in our test environment.  We already use report rules to email other reports out of IFS, so I know IFS can send emails.Where we are atSetup the AR Customer Contact information under the Payment tab in Customer.  Output Media is E-Mail. When we run the report - I can see it in Report Archive with Notes = “Output Media: E-Mail, Language: en”  The Printed checkbox is not selected (correct) But - the email is not being sent.Based on the documentation, it sounds like it should just email, but I’m not sure if I need to setup something else.If this should work - any suggestions on where to look to figure out why the email is not being sent? Or do I need to setup a Report Rule to actually send the email? Thanks 

When I try to post imported object transactions, I receive the following error. Does anyone have an idea of what might be causing this? Would appreciate any help. Thank you.   

Hello. I am testing an upload template to upload Depreciation Data that, if done manually, would have been entered into the Import Object window of an object. I am getting an error that says that an FA_OBJECT_TRANS_VALUE_TYPE is required. Could someone advise on what this is or what field in the IFS window it refers to? Any assistance would be much appreciated. Thank you.    

Trying to refresh FACT_CONSOL_BALANCE and receiving the following error: Null value not allowed:  (ORA-01400: cannot insert NULL into (“IFSAPP”.”CONSOL_BALANCE_MVT”.”BALANCE”)  Any ideas how to resolve this issue. Thank you.

While importing External Supplier Invoices we receive an error message the invoice already exists when in fact the invoice doesn’t exist.  We use FastAP to process our supplier invoices.  The error is intermittent.  I believe it is timing related and how busy the server is.  Any suggestions? Thanks      

We have an issue with the Payroll Postings. Quite a few entries are now missing the Account, there were no issues with previous payrolls and there have been no changes to the payroll. Last month and previous months posted correctly:  Any ideas what would cause this issue or why this would happen?Thank you.

Hi, I have just joined a manufacturing/defence company that has chosen IFS apps 10 as their erp of choice. I have supported users in the past but never been part of an implementation. They are asking me to put together a list of information we need to gather from the users that will help the implementation and config. Does anyone have any pointers/document?The only info I have is that IFS has listed these modules as within the scope: Distribution, Engineering, Finance, Project, Human Resources, Health & Safety, Maintenance, Program Management, Production (work orders etc.)

Hello- I am looking for help creating a positive pay file from a supplier payment proposal/pay order for checks from a US bank. I have found the template but am unable to trigger the output (in Apps10). Best-Christy

Hi,We experience an issue when we try to complete a project. We want to complete a project for 100%.When I run the ‘Generate Unfinished Work Activity Items' event in the Project Deliverables Navigator, I get the following result: I cannot set the status of the project to Completed because there are some supplier invoices which we have not received. So when I try to complete the project in the finance module, I cannot complete it for 100% because the status of the project is not Completed (and this is blocked by the supplier invoices which we have not received yet). The screenshot below shows the error in the finance module.  Is there a way to work around this issue? We want to complete the project for 100% and we do not want to wait on our suppliers for sending the invoices.We are on APPS10 Update 7.

Many sync jobs returned the same error.I ran the function manually, a different error returned. 

Hi,In IFS any way to execute mrp for only safety stock?

Hi All, Issue:Customization option for default menu items isn’t working.Path:Go to “prepare work order” screen. RMB à Properties à Advanced Uncheck not required menu items from checklist and click OK. Again, click OK to apply changes.Expected result:Hide unchecked items.Actual result:All default items visible. 

Hello Guys, my Crystal Report always ask for server login when I execute it under Quick Report.Can anyone show me how to skip this login dialogue and directly generate the report?Regards,Kim Siang

To simplify for Manufacturing operators using Shop Floor Work Bench, we are trying to set a default Work Center when the manufacturing user logs on and is taken to his homepage (Work Bench). We have tried setting a filter then saving the user profile but it did not work. Can this be done? Thanks

Hi Everyone,I’m new to the IFS Community so apologies if I’ve posted a question that has already been addressed.My company is currently running IFS9 update 16 and I’m just exploring a customer request which a lobby would be suitable for. I noticed, however, that when adding a line graph as a new element that the SQL statement when running the debugger is only fetching 100 rows -  (FETCH NEXT 100 ROWS ONLY). This is therefore not showing all the data we need.I took a look at the options within the element designer and data source designer but wasn’t able to find anything. Essentially we are looking for a line graph to show daily results. Is there anything I can do to overcome this or is this standard within IFS?Many Thanks,Dan 

If External Invoice should be loaded with PDF file saved in local computer. Where and how that location could be given in XML file and what are the pre-requites to be fulfilled ?

Hi, I found that there is a RMB option “Add/Remove Invoice Fee” in Customer Invoice (Maybe this GET functionality ). It is really appreciated if someone could explain the functionality behind it? BR Champika 

When I print the Consolidated Picklist from the Shipment for one customer only, this issue occurs on the printout on the place usually the delivery Address is displayed.   However when I check the Customer record, ‘Delivery’ has been ticked for one address ID only. How come I get this error?

 HiFor example customer wants to remove IFS EE and Add-ons links and change icon/picture.  

Hi All, Any suggestions would be appreciated, I have taken a copy of TEST to put on to a new virtual machine. The IFS home builds if I use a new RTM build or a clone of the existing TEST onto the new box. I keep however receiving this error in the node manager logs. It implies it can’t find this file that I can physically see here -  <23-Apr-2021 09:21:39 o'clock BST> <INFO> <Loading domains file: D:\IFS\IFSExt\IFST\wls_domain\NEW_IFST_PA\nodemanager\nodemanager.domains><23-Apr-2021 09:21:39 o'clock BST> <INFO> <Upgrade> <Setting NodeManager properties version to 12.2.1.3.0><23-Apr-2021 09:21:39 o'clock BST> <INFO> <Upgrade> <Encrypting NodeManager property: CustomIdentityKeyStorePassPhrase><23-Apr-2021 09:21:39 o'clock BST> <INFO> <Upgrade> <Encrypting NodeManager property: CustomIdentityPrivateKeyPassPhrase><23-Apr-2021 09:21:39 o'clock BST> <INFO> <Upgrade> <Saving upgraded