Solved

Hello,I am wondering what is the procedure for adding package procedures to Crystal Report Quick Reports in IFS? For example I would like to add  Delivery_Route_API.Get_Description(ROUTE_ID).Is there any way to add this without joining the Delivery Route table or it’s just not supported? Thank you.

We recently realised that when PO had change processed due to price increase and PO was updated to new price; receipts that were created prior to this change but not matched to an Invoice are updated to new price as well.Is there a setting anywhere so I can turn that off, we have issues where we order in bulk but the price changes and sometimes there is a lag between the goods arriving so we would need to receipt them at the old priice  

Hi, I am trying to extract the weeknumber from a date. But both my SQL statements return the wrong weeknumber. Here is my first statement: SELECT to_char(to_date(cf$_co_date_order, 'dd-mm-yyyy'), 'ww') FROM customer_order_cfvStatement returns: 22-3-2021 0:00 12 23-3-2021 0:00 12 24-3-2021 0:00 12 24-3-2021 0:00 12 25-3-2021 0:00 12 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13  My second statement: SELECT to_char(to_date(cf$_co_date_order, 'dd-mm-yyyy'), 'iw') FROM customer_order_cfvStatement returns: 22-3-2021 0:00 12 23-3-2021 0:00 12 24-3-2021 0:00 13 24-3-2021 0:00 13 25-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13 26-3-2021 0:00 13  So both are wrong. I expect every date to return weeknumber 12, because that is the correct weeknumber. Does someone know how to achieve this? 

Hi all,I have an RMB that navigate to a custom page: The problem is that the custom page does not jet have any rows to navigate to.Is it possible to fetch the parameter values and add a row to the custom page?  

Missing RELEASE_NO field from CUSTOMER_ORDER_IVC_REP.  How can I add RELEASE_NO  I haven’t found an API call where I can grab this information. Thanks John

When you use the Quick Expense Reporter in Aurena, we are unable to attach documents/media.When we try to attach an image we get the following error:We also get the same message when we try to attach PDF’s, ideally we want to be able to attach media as most people will be filling out expenses on there phone.Are we missing some set-up in  document management?Thank you.Nikki

Hi Team,Is there a .jsp we cannot find for editing panel descriptions?There is a security privilege that suggests there is one Category1 Parm Name2 Description Enabled   Assembly - Panels ACTION_EDIT_PANEL_DETAILS Permission to edit panel.  We’d like to update the panel descriptions, ie  EQP_TASK_PANEL.DESC_SDESCUnderstand for adding new Panels we need to use configurator. Thanks in Advance

It is allowed to match SUPIA for supplier invoice where in ‘Posted’ status. Normally IFS application allows to do payments or offset only for authorized supplier invoices. However it is different in this scenario.Any idea on restricting matching SUPIA for supplier invoice where in ‘Posted’ status. Steps followed is noted below for easier reference.Create Advance Supplier Invoice Authorize Advance Supplier Invoice Made payment to Advance Supplier Invoice Create Supplier Invoice, RMB on the invoice header & select Advance invoice Then select the paid advance invoice & save. Invoice status changed as ‘PartlyPaidPosted’ Our customer required validation on authorization on supplier invoice before perform step no 5.

How do I change the Company Name on a printed Quick Report? [img]https://uploads-eu-west-1.insided.com/ifs-en/attachment/45c6809f-b46b-4808-82f9-4158c5766795.png[/img]

Hi, I am unable to get columns from a View created using sub-query.Anyone knows if this is supported or if I am doing anything wrong?  Thanks in advance!

I’m attempting to set up Crystal Reports 2016 so I can connect to the IFS Oracle database (Apps 9). I’m using Oracle Client 12. Firstly, I have not seen anyplace where it is specified the normal tnsnames.org file location for Oracle Client 12. Everything says “ORACLE_HOME” (which I understand means whatever the home  directory is not a directory literally named “ORACLE_HOME”) /network/admin. There is no network OR admin folder in the Oracle directory. To use SQL Developer, I don’t need that anyway, because I can just directly load a tnsnames.ora file. But then Crystal reports… I have googled seven ways from Sunday and cannot figure out how the heck to associate the TNS file with Crystal Reports. When I go to “Database Expert”, I have an option for “Oracle Server”, but no matter what values I use (and I know they’re the correct values b/c I can connect with them in SQL Developer), I can’t connect.   No one here is very savvy at this so there is no one I can ask. Help! Thank you! 

Hi, How do we set the status “Scrapped” on Design Objects? When we try to do that, we get the message “This state change is not allowed when the operational status is In Operation”.And the Operational Status seems to be read-only. Thanks in advance!

Hello,Hoping someone can point me in the right direction.I have created a Workflow and would like to deploy to screen so it launches on a button click.How do you do that?I can see in the FSM Reference Documentation the following: Button. You can create a button to execute a workflow using the UI Designer. You add a workflow button to a screen customization and then attach one or more workflows using the edit workflow group feature. You can run a new instance of a workflow or complete a workflow instance that is preserved.  I cannot see in the UI Designer, or other screens anything referring to an ‘edit workflow group feature’. Any pointers on this would be greatly appreciated. RegardsAdy

I am getting the error below when creating a Project Invoice off of an Invoicing Plan.  It doesn’t happen on all customers in this company, and the ones it’s not working on are being invoiced through the regular Customer Invoice process in Production.   Any ideas what to check?  

Hi all,I am trying to set up the Onboarding Assignment Configuration and have assigned one Onboarding Program Template to be triggered on only Employee Category. I have placed it in the top of the list which should meen that this template should be choosen first if there is a match (In this case it should be triggered if Employee Category is equal to Konsult).But in New Employment assistant IFS pick the second one in the list. Does anyone know if this is a Bug or am I missing anything in the configuration-page?Best regards, Josefin

Hello all, I am currently looking into a way to create an Event Action to notify a user via Streams that a Routing is approaching a Phase Out Date. I’m not quite sure how to do this, as there does not appear to be a way to trigger the the Event. The Phase Out Date would already have the date and it would not be updating, simply lapsing. In the screen shot below, Ideally a Streams notice could be triggered to send 7 days prior to 3/31/2021. Any guidance would be greatly appreciated!

Hi! Can anyone help me with this?A customer have developed a custom inside Business Opportunities form that points to a Aurena survey page (example: https://XXXX.com.br:56090/main/ifsapplications/web/assistant/EmpSurvey/Survey;$id=SurveyId:LAF_COM_DIAGNOSTICO_,CompanyId:01...)When they open this URL ‘internally (using IEE) we get the error below. when  we try to open it ‘externally’ using our own browser, it opens without any problem.Is it possible to open Aurena pages inside IEE? We’re running IFS V10 UPD9 and I’ve set Edge and Chrome as default browser (and Aurena is supported by them) and could not solve this problem.OBS.: Internet Support Center page opens normally inside IEE.Thanks!

Hello, We’re running the IFS Change Document Repository process in IFS Apps 9. In the ‘Move from Repository’ dropdown, it shows only those repositories that have status set to Usable. Similarly, in the ‘Move to Repository’ dropdown,  it shows only those repositories that have status set to Generating. What is the meaning of a Usable vs a Generating repository? 

Not sure what triggered this but all the lights in the monitor schedule screen have turned red. If i click Run Now they will run and generate the appropriate results. However we need these to run automatically as scheduled.Made sure all appropriate services were running on the server.The “Next Run” shows as yesterday Appreciate the help!   

Can we add drawings (e.g. specification) in Parts so that we check them while raising Purchase Order and also send them along with Purchase Order to Supplier? 

Hi,Can we make use of the response from foreign system captured in integration run log without storing in FSM server?A quick answer is really appreciated.Thanks & RegardsDeepak Kumar

When we search on screen  the result data can be changes and saved there only.Is this possible ?

I want to copy a file that’s in Aurena (actually it’s in THOR) to a local directory.  But, I  am not seeing “Copy File” functionality.  Did it go somewhere?  I’m also not seeing this in a standard version that’s in a customer’s database.

Hi All,I am recently involved to setup some 21R1 configuration in various environments. When setting up I encountered various issues such as not knowing which projections to be granted in order to external clients to work, most of them are IAM clients. Which projections to be granted, information was passed by the Product Development teams which helped us. But is there a way to exactly know which projection should be granted so that the external clients would work. e.g. AdvancedPlanningBoard, MaintenancePlanningBoardIntegration I think in Aurena client we can search by Projections by Navigator so inside the client if something isn’t working, we probably can grant these projections to a specific permission set so the purpose is achieved. 

is there a way of only showing certain document classes for certain views? For example when creating an expense and you attach a document it only shows the document class you have set-up for expense receipts? Thank you.Nikki