Solved

Community,I have a SQL column RECEIPT_INFO_CFV.ARRIVAL_DATE which is showing like below, 8/15/2022 5:14:12 PMwhich function I can use in SQL to retrieve Month in a column, and Year in a column, for above sample,  SQL result should return like below,Month       Year8                 2022 Thank you.

Is it possible to automate the printing process of a Purchase Requisition? Or at least the creation of the pdf? I can capture the output in the debug window when I select RMB-”Print Requisition”  on the Requisition screen but there is too much code in the output, I can’t find the block that creates the pdf. I can do it for a Purchase Order but I want to do it for the requisition.

Dear Community,  We have a process related question / issue which belongs to IFS Apps8 and IFS Apps10. I tried to find answer in different places but unfortunately we are stuck, so I hope you have any idea. We had the following process in IFS Apps8 and we continue to doing this in Apps10, but it looks - currently it is not working neither in Apps8 nor in Apps10:  We transfer the subsidiary’s opening balances to e.g.: 2024 period 0 from COMP1(subsidiary) company to GROUP (parent) company.During the transfer, it looks the balances are transferring, but there is no amounts for year 2024 period 0 (opening balances)  in GROUP company in GL Balance Analysis window.Process:Create the Subsidiary Consolidation in company: COMP1 for year-per: 2024-0 in Financials - Consolidation\Consolidated Accounts\Subsidiary Consolidations window switch company to GROUP.  Check the new line Financials - Consolidation\Consolidated Accounts\Parent Consolidations in company GROUP on the new line (Company: COMP1,

Hi,do you know how does posting rule TX7 for control type AC2 - Pre posting work ?Where should pre posting be entered to be retrieved to this posting rule ? Best regards,Małgorzata

Hello, does anyone know, if there is a way to increase the time for automatic logoff time? (backend and/or mobile edge)We are using Alliance 15.3.0.7 Thanks in advanceRegardsTorsten 

I’ve run into a unique issue where a Case is not visible to a user unless they are added to a Case Access Group with restrictions defined as “None’.Why is it necessary for a Case Access Group to be defined for the user to see the case?A little background:23R2 SU 2Case Type: GlobalAssignee has access to the Support Organization and the Queue 

" How can we get the user logged in Company session in PLSQL? "Product Version: UPD18

Hi there, actually we are not using the Checkbox “Priority SLA” in Customer Contracts by any reason, but as always there is an idea to have a marker on Contract Level showing this contract is more important than others. This should not have an effect on Priority oder Service Level calculations.So I need to know if there is a out-of-the-box functionality behind this checkbox or if I can use it for my purpose without braking anything else.  To give you more inside on my question. We do have some customer with a lot of Orders so the single order is not that important in the view of the contracts SLA. But there are also Customers with a very limited amount of Orders on some contracts where missing a single Ticket can have an enormous effect on its SLA. To mark these Contracts somehow I have the Idea to use this “Priority SLA” Checkbox.If this is not an option, I will just create a new Checkbox Field in customizer. Thanks in advance.

In Mixed Payment, showing an information message to tick ‘New Item’ and not allowing to save. How to solve the issue ? 

We are using V10 IEE. Our business wants to schedule PM work orders out several years, to 2027. The Maintenance Plan for every PM Action we create will only plan work out to the end of next calendar year, Dec. 2025 in this case. This is observed across multiple sites and calendars used, even when the calendars are generated well past 2027.How do we get the Maintenance Plan to push planned work out multiple years ahead?  

Hi All,I have created the below reference look up   However it is not appearing in pop up Search box as a concatenated display reference, please help ? 

Hi All,Could you please advise me what is the best approach to connect same invoice number sequence for CO invoices and Instant invoices. Regards,MalinG.

When users tries to approve shop order in shop floor workbench an error pop up.“The date applied of the transaction cannot be a future date” Note- The error then resolves itself, occur generally in month-end

The customer is trying to add the code field Reference No from Entity JT Task into a mobile screen. Currently the customer has already add multiple custom fields from JtTask into the target mobile screen, but for some reason the core field ReferenceNo is just not available in the drop down. - Open Solution Manager / Mobile Apps / Configuration / Apps for Page Designer.- Find page Service Engineer / My Work.- Click on a work task and button "..." / My Work Detail Page to take it to the Work Details Page.- Click on Page Designer to start changing that page.- Click on Contents / Task Information.- Scroll down to "Task Information Group".- Click on Contents + button to try to add Reference No.- Observe that Reference No is not in the drop down as it should. The entity is JTTask and it seems that all JtTask fields are available in the drop down except for Reference No.

Hi all, We are testing with Cloud 23R2 having an on-prem database. Just wanted to know if it is possible to configure the access such that mWO (Service Engineer) can access IFS directly from Android phones (i.e. without a vpn), but all other users accessing the wider IFS Cloud pages via PCs, tablets should use a vpn to connect? My idea is to make the access to IFS is secure enough, but not too rigid for the mWO users, and at the same time they don’t have to depend on reliability of the vpn.TIA.

Hi Experts:We have resource A where he is normally working for two types of jobs, Active and Passive. We have one dataset for ACTIVE and other one for PASSIVE.Question is How we can allocate the same resource into two datasets but job allocations should not conflicts?EX:If the resource A is allocated to a Task in dataset ACTIVE, at the same time he should not be allocated for any job in Dataset PASSIVE. Jobs should not conflics. Thank you,KM  

  Hi, Does anyone know if recent versions of Cloud support the multi drag and drop of operations in the manufacturing Visualizer?  In DOP and/or project manufacturing, all shop orders connected often need to be rescheduled as a whole. In APB, you can simply drag and drop the DOP or project and everything moves along. Is a similar option available in the Visualizer?   

Hi,For a forecast Part I have entered data in ‘Manual Historical Demand Planning Data’ page. I did run the jobs ‘Aggregate Daily’ and ‘Create Forecast’ which were okay without errors.However when I check for the Forecast part → Historical data tab, I cannot see any of this data and historical values are shown as 0 even in the Demand Planner Client (Forecast tables values are all 0) This is my sql I have used Combination of Historical data + External issues, I guess this is correct.Version I am working on - 23R2What am I missing? Appreciate if someone can guide me in the right direction Kind RegardsYashodha

Hi everyone,Can I please know if there’s a way to Cancel/Delete an I voucher type? Voucher is not yet updated to GL. Thank you in advance 

Hello BR experts,I have created a business reporter based on structure where I am trying to compare GL and IL Balances. Column HFM Balance is using source Internal Ledger Balance and Statutory Balance is using GL balance.When I defined a filter for Ledger ID on HFM Balance column, report gives me error shown on the screen shot.The only way to apply a filter is on cell level. But I am afraid it will reduce report generation time if I apply filter for each cell in the report.Basically my question is how to enter the filter that will bypass this error?   ThanksFurkan

Hi,My Logistic team would like some price displays with 3 (or more) digits after decimal point.We can input value with 5 decimal digits, and IFS manage it.But to control data, we have to open item one by one, it’s not confort.They manage gasoline price so it will be useful.Is there a way to manage displaying by page conception or by Contexte ?  Regards

Hi community,I’m trying to add an enumeration in the operational report parameter.In my RDF file, I added two procedures to get the qvalue and enumerate : Result in IFS :I can’t see the list of ‘NO’ and ‘AVO’.Any ideas please?Thanks in advance.

In App9 we could search for a set of SalesParts and then attach one Existing Document to all selected/found objects in one operation. We use it to attach the same document to several SalesPartsThis functionality was changed in Cloud and is deeply missing. We have e.g. 20 sales parts that shall be connected to the same document – and this not done by one/or to click.Today (cloud 23R1 SU6) we do following steps to attach one ExistingDocument to several SalesParts:Find all SalesParts that shall be connected to an existing document (1) (in Sales Parts window) Click on «Stample/Attachmens» «Attach existing» In the side panel you can select an existing document – by default you can search by TITLE (and not a Doc_no!)Step 2-4 must be done for each SalesPart, one by one(!) Do anybody know how to do it more efficient?It could help if we could write doc_no in «Attcha Existing Document» drop down list, instead of seraching by titles or use «search panel» for each time we attach the same document.

When trying to create an IAL that is not “Create IAL for live data only” it still creates the IAL as Live data only.  IFS Cloud 22R2.9.Has anyone else seen this or have any ideas?I need to create some scheduled IALs for large views to use in queries, and using live data is far too slow.Example: Creating a new IAL with the option for live data only disabled: The IAL is created without any error but it is only for Live data and cannot be scheduled: And no option to Update Now or Schedule the refresh from the IAL details screen either: But I can see in the database that the table needed to store the data has been created in the IAL_OWNER schema: 

Is it possible to run IFS Cloud in a database other than Oracle?