You won’t get your desired outcome with a PLSQL method either if I am understanding the use case correctly.This would be better delivered using a lobby or multiple lobbies. You could navigate from the page passing the parameters through to a lobby page, then have a lobby element that filters the data further by status.
Hi @robynalexkiraWould you mind confirming which version of IFS you are using?It may be that a Quick Report would suit your needs over an existing screen but I’ll check for you.Cheers,Pete
Hi @Hanane You need to reduce the number of columns/attributes in the “only when these attributes are changed” section. I don’t know your exact use case here but you could try to always trigger the event and then move the logic to the event action instead.Or you could split this up into multiple events.Cheers,Pete
Hi, Slide-outs (known as Dialogs in IFS, thanks to old IFS clients) can be modified. You will find them in your Page designer in All Pages, section. Step 1: User Drop down/Page designerStep 2: Page Designer/ All Pages/ Dialogs/Add Customer Contact DialogStep 3: Content/Add Element If what you are looking for is not there as an element available to be added, you might have to start with amending projections too. Hope this helps Hi Asanka, @AsankaGaru Thank you for your answer, if I narrowed down the result we are looking for could you provide further guidance as to whether it is possible without customisation (i.e. using IFS Developer Studio/Build Place)?When creating this contact manually from the Account Contact page, there is a field available called ‘Campaign Interest’. Is it possible to add this to the AddCustomerContactDialog?See the screenshot below:Image 1On the right you can see the Account Contact page that shows the Campaign Interest field available, on the left you can s
Did you try to use the Android or Windows App on the same environments and what happens then? No access to an android device so cannot check that.Windows App from MS store:This just crashes when trying to login...eek!
Hi, Can you send me a screenshot of error appear in the client? Also the ios version you’re using. Im also getting exception errors when completing process as well as in between. But not exactly the one you’ve mentioned here. iOS version = 14.8.1
Hi @robert_g,The CONNJOB isn’t an available rule for Excel Migration jobs.This can be achieved by adding a row to the start of the Source Mapping which calls a custom function that performs the following steps:Check if date of new entry will overlap with existing entries. If overlap then call autonomous procedure to amend VALID_UNTIL date on existing entries. the DM job will then execute with no errors.Cheers,Pete
Hi @matt.morge,When reconfiguring IFS there are a number of check boxes on the installer assistant screen that should be UNCHECKED to stop this from happening.Import IFS Connect items - Connect ConfigurationIf you setup new connector senders and leave the IFS standard ones alone this should also stop this from occurring again.Cheers,Pete
@Oshada Samarasinghe, the below is now the error I get, any other ideas? As @Eugene Wager states I’m using Apps9 and therefore I do not have the condition option of IS NULL. Any more ideas you wonderful people? Hi @sholmes,If this is going to run a PL/SQL block then you can leave the ‘Conditions for performing this action’ empty and move the logic into the PL/SQL code?This will cause the Event Action to evaluate for all records but this does not typically effect performance.Can you outline the complete business requirement?Cheers,Pete
Hi @BLLBrucemo So you have supplier invoices with Document Attachments, you want to output a spreadsheet containing the supplier invoice data PLUS a column with a URL/hyperlink to the Document Management record(s) connected… If I have understood correctly then I would propose a compromise:Rather than a link to the document(s) include a link to the Manual Supplier Invoice - you could create a custom field to display this on screen and then using Output Channels would work. I think Apps 10/Aurena/Excel you may be able to use OData feeds to do this but I am not sure if this provides native links back to application. Does this help?Pete
Hi @mfrejik,I wont be able to assist much here but very interested if you get this working.Like CR itself you would need to have correct Oracle Client installed?This link has more detail:Do you get any error messages? Can you post more detail?Cheers,Pete
Hi @ZTC ZTC JGOTA This is a common issue, have a read through this - it should help:Cheers,Pete
Custom Fields is a workaround but the answer is no, not without a customisation (mod) from IFS.
Try removing the:?COMPANY=$COMPANY$From the URL Address.If that doesn’t work then it may not be possible as I don’t t think you can pass column values to the URL address...
Hi @brantmb Would need a bit more detail to be sure but here are a couple of ideas:Check the report definition records and ensure the Prevent Overwrite checkbox is checked on records you have made changes to: When you deploy releases to IFS using the IFS installer you will see the following screen:You could try unticking the Report Schemas box to skip this part of the patching process, IFS will overwrite the schemas in the system with the ones within the delivery. You may however miss out on the latest changes/fixes to the report from IFS. Finally you could manually export the XSD files pre update and manually redeploy them as part of your post patch process. Cheers,Pete
Thank you for the responses! I guess my question was worded poorly. I know about the ways of scheduling the task, I would like the frequency to be based on a dynamic date in the database. Essentially I need this task to run at the end of every accounting period quarter, however, these periods are not static dates and change year to year. Hi @NSRJMITCHELL,To do this you could create a Function in the Database (within a custom Package) that returns the next date you want the Scheduled Task to execute, then when scheduling the task enter the Function into the ‘Custom’ option shown below:Function must return Date type.Cheers,Pete
Hi Bobby ( @BBAGDJA ) First create a list element ( I am assuming you have created a data source with relevant data).Then add all the columns you wish to display (including the column the icon will be based on, the KPI measure, even if you don’t wish to display it).When you open columns dialog you will see a black button to add your icon.Once added go to Formatting section and select the icon column, add rows to format the icon as required, for RAG KPI you will need three rows.When you add rows select the column holding the KPI measure data and apply operator, symbol and full colour as required.If you don’t want to display the KPI measure column in the list element set the percentage width to zero for that column.I will add some screenshots next week.Cheers,Pete
You should Group By the full column name as @paul harland has highlighted.
Thank you for the in depth response @ShawnBerk - I appreciate that this only scratches the surface of the solution you have in place at Instron.If we had a few more questions relating to your experiences in this area and about this solution would you be open to a call in the new year?
Hi Mick,Have you gone through standard Crystal troubleshooting steps?Does the report run in Crystal Developer when logged in as IFSPRINT?If not then maybe permissions need granting to IFSPRINT.Can you preview the report from the IFS client (Report Archive), if not what error message pops up? Cheers,Pete
Hey Anne-Sophie!Routing Rules and Addresses process Application Messages IN/OUT.Assuming this is an OUT message you will need to generate an Application Message that contains the message body (in the right format) that IFS CONNECT can process and route using your setup above.Depending on your objective there are a number of ways to create the Application Message:Create a Procedure (PLSQL) and call using RMB or Event Connectivity Setup Report Rule Setup an Event/Event Action Replication Migration Job etc.Will need more info to narrow down these options.Cheers,Pete
Hi Frances ( @BABFRANCESW ),I assume you are referring to Primavera P6?We are on Apps9 UPD17 and some of the files in the following folder/sub folders have been updated:\\%IFSHOME%\instance\IFSL\client\officeaddins\prjmspofficeaddinThis isn’t very scientific but if you are planning on deploying an update then ensure you test all business critical functionality, including peripherals.If you are looking to see if any features have been added since UPD11 I would raise a case with IFS asking that question.All the best,Pete
Hi, At a customer they use it to load opportunities in CRM. It builds the heading and the part lines. This is due to the fact that header and line info are in the same Excel row. Not only is it used to import new information, also updating the data is done in the same way. In this situation, the responsible key user of an opportunity uses Excel Migration Tool only for their own opportunities. Another situation is to load supplier for purchase part price lists. One Excel is used to retrieve the open lines (using search icon), the lines get a valid until date and are updating the data in IFS. The second Excel migration job is used to generate new price list lines. Works great and highly efficient. There is also a situation that sales prices are loaded. The downside is that there is no audit trail when someone has used this tool. Using a standard migration job, the last usages is reported in the information of the migration job and there is the history when several times the same job was
Hi Miguel ( @Miguel )In order to mitigate the risk of reporting from this dataset- you could create an IAL (Information Access Layer) either Live or Replicated to report from ( it would depend on how real-time the report needs to be).This way if you didn’t want the rows with zero you could filter them out.Cheers,Pete
Hi Shaun ( @ShawnBerk ),I have a sledgehammer suggestion for you - could you raise a (zero value) Purchase Order from Chinese to UK company (they would be the supplier) and transfer the serial items inter-company like this?Cheers,Pete
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
