Solved

Hello,I have 2 columns of data I would like to represent in a pie chart. one value for quotations won% and the other quotations lost%. (SELECT COUNT (quotation_no) FROM order_quotation_line WHERE objstate IN ('CO Created' , 'Won') ) /(SELECT COUNT (quotation_no) FROM order_quotation_line WHERE objstate  IN ('CO Created' , 'Won', 'Cancelled', 'Lost', 'Planned', 'Released', 'Revised'))*100(SELECT COUNT (quotation_no) FROM order_quotation_line WHERE objstate IN ('CO Created' , 'Won') ) /(SELECT COUNT (quotation_no) FROM order_quotation_line WHERE objstate  IN ('CO Created' , 'Won', 'Cancelled', 'Lost', 'Planned', 'Released', 'Revised'))*-100+100 When creating the Pie chart element. I am only able to see the Won% column represented in the pie chart. How do I configure both of these columns to show up on the pie chart? 

Hi, We have an ADExport.csv file which overnight imports users into Assyst via ETM. Sometimes, a user fails to import so we manually have to import that user via ETM. I’ve written a basic PowerShell script which prompts us to enter in the Email address of the user that has failed to import. Once the email address has been entered, the script then searches for that user in the ADExport.csv file. Once the user is found in the file, it copies the following file headers into a new .csv file: "sAMAccountName","userPrincipalName","SID","GivenName","Description","sn","physicalDeliveryOfficeName","Department","mail","telephoneNumber","userAccountControl","MobilePhone","Manager","ManagerName","ManagersAMAccountName","extensionAttribute11","DistinguishedName" The script then copies the users info found in the ADExport.csv file then pastes it into the new .csv file created above. I’ve confirmed each header has the correct info assigned.When I import the new .csv into ETM, it shows the following e

Dear all,One of my client receives supplier invoices (related to goods purchasing) with freight cost included.The freight cost does not appear in the order (because the purchasing team is not able to anticipate this amount).The accounting team deals with the discrepancy, when entering the invoice in the books, by reallocating the cost in the right account or directly in the purchasing account.They would like to know if it is possible to breakdown the cost of freight directly on the related invoice on each line/article taking the full amount of each line as the ratio of breakdown.Their final objective is to impact the cost of freight in the total cost of stock for valuation purpose.Thanks for your help 

Hello,We are on IFS 10 with a MWS running WebLogic Server 12.2.1.3.0. Has anyone imported into the MWS a SSL certificate, whose key has been generated using ECC 256 instead of RSA? I’m afraid of potential incompatibility issues. IFS officially only recommmends RSA:https://docs.ifs.com/techdocs/foundation1/020_installation/020_installing_fresh_system/010_planning_installation/020_security_considerations/010_Certificates/  

 Hi all, I have a question about a specific window behavior which is Background jobs.Can background jobs be deleted from Aurena? It is possible to delete background jobs from IEE, but there is no such option in Aurena. I would like to know whether this behavior is correct or not and the reason.Background Jobs (ifs.com)  Thanks!

Hi Guys  How to clear below errors   Posting type M201 is missing in Posting Control for company SASL and code part Account. Posting type M258 is missing in Posting Control for company SASL and code part Account. Posting type M257 is missing in Posting Control for company SASL and code part Account.

Hi, Are there any hidden options available for adding new tiles to IFS MWO Service Eng App? I can see all the other options from page designer (Adding groups, lists and cards) except tiles.  

I created a AST as below for a quick report in IFSAPPS 9 After executing the schedule, following message has been created. How can I use the report result to save in to a file? Message Response is transferred to  BizAPI: ExcelQuickReport: RenderExcelQuickReport. How can I use this?  

Hi All!Is it possible to make all WO of MP visible in the tile of portal maintenance engineer as non affected?Thank you All  

When using the Activity Tracking module, selecting the Order link will error on Invoiced Orders.It works fine from Order Locator.It looks like Activity Tracking is calling maint, where Order Locator is calling history_maint. Activity Tracking: <a class="qbe-link-field" onclick="Astea.Grid.NavigateGridCell('form_asp/service_request_maint.shtml?action=retrieve&where_cond=SV2304300160@@1',10,false,10)">SV2304300160</a>Order Locator: <a class="qbe-link-field" onclick="Astea.Grid.NavigateGridCell('form_asp/service_request_history_maint.shtml?action=retrieve&where_cond=SV2304300160@@1&WebVar_goback=order_locator',0,false,0)">SV2304300160</a>Is this a bug, or intended behaviour?

Can someone confirm that running the report “Aggregate Shop Order Costs per Shop Order” has no general ledger impact?  As I understand it, this just recalculates shop order costs that can be queried for analysis.  Thx

Community,User reported that there are 4 purchase receipts cannot be found in supplier invoice receipt window. in window Receipts, they do have status Received. In Invoiced Purchase Orders, we cannot find the 4 receipt references are receipt matched.wondering why?these 4 receipts are received last year. you can see they are connected to activity sequence. in below activity sequence, it is still in Released status. 

Hello,I currently have a workflow that takes the sale amount of a customer order line and places that value in the customsvalue field automatically. We do this because customsvalue is the only field with prices that moves over to shipment proforma invoice. I am fully aware that IFS wants the order taker to define this field manually, but it is a requirement that we handle this automatically. The workflow that we currently have works fine, as it goes off of the event when a customer order line is created, but the only issue is when a sales quotation is converted to a customer order. I get the error message “Error occurred while processing the request: Unknown property used in expression, ${LineItemNo} Cause: Cannot resolve Identifier ‘LineItemNo’”How do I get around this issue so even the customer orders that are created from sales quotations work, and their customsvalue field gets populated? Any and all advise would be greatly appreciatedThanks,Bryan

Hello,  When we use IPR we can check calculation details with simulation file.Into this file there is  a column “Order day”  : States Yes if a order can be placed on that day othervice No.So it look like IPR and or MRP can take it into account to schedule orders, but how or where can we configure this data in IFS?    Regards

Hello.I have a BOM that containsComponent 1 Reserve/Issue Method = Reserve/backflushComponent 2  Reserve/Issue Method = Manual (Qty Per Ass = 1)Both components are allocated to an operation (Qty Per Ass = 1) I have created a shop order / released the shop order and reserved the shop order. The result is that component 2 is fully reserved.When I try to approve the operation for qty of ‘1’ I receive the following error (expected) I manually issue a qty of ‘1’ of this component and try to approve ‘1’ against the operation again - It works as expected.I try to approve an additional ‘1’ to the operation against (total 2) and it allows me, even though there isn't enough components issued to allow the approved qty - I believe this should error???The application will also allow me to receive the goods into stock. It even allows me to receive the full qty and close the shop order, even though all the materials haven't been issued.I have ran debug at the approve operation stage and simplified ma

We’ve recently noticed that everytime we create a new customer address, there will be a GEOCODING application message generated which would end up in Failed state since there’s no routing rule/address configured to intercept that message.I’d like to turn off the generation of that application message, but I’ve no clue if that is even possible.What I’ve done thus far:→ checked event actions → there’s no event action creating this Application Message→ looked up in System Parameters but I couldn’t find anything that would refer to GEOCODING functionality.Any ideas on how to turn this off?I’ve also read the documentation from below, but it doesn’t say how to turn off this functionality.https://docs.ifs.com/techdocs/21r2/050_development/060_ifs_applications_business_components/150_application_services_development/#geocoding

I have a need to modify my mWO pages (via Apps for Page Designer) using several ‘Contexts’ which seems all well and good until I try to add these Page Configurations to an Application Configuration Package. My hope was that I could select only the Page Configurations that are associated with a particular ‘Context’, but it would seem that any Page Configuration that is of the same Projection is added to the ACP as well. I only selected one Page Configuration when choosing “Add to package” and IFS selected the second Page Configuration (associated with a different ‘Context’) and added it to the ACP as well. Is this the default behavior for ACPs that include Page Configurations? Is my assessment correct that it relates to the fact that these Page Configurations come from the same Projection or is there some other link between the Page Configurations? I really want to manage the Page Configurations by each ‘Context’, and not by ‘Projection’. Does anyone have any insight into the matter? BT

IFSv10 upd15Azure SSOOracle 19cGlobal user baseSome of our users have reported that their IFS client session fails to work after they return to their locked Windows PC?Has anyone else seen similar issues? Is it a timeout issue? (Set to 0mins in System Parameters), perhaps a network blip? Are there any logs that may give us some more info?Thanks for any response given.Mike

How to enable FSM over View in Documentaion for users. 

I know that the following will assign 210 to the variable CompanyId (in a script task):execution.setVariable('CompanyId','210');What if I want to prepare a KeyRef for this that would contain in the end: 'CompanyId=210^’I'm looking for something like concatenate. I've tried:execution.setVariable('KeyRef’,'CompanyId=' + '210' + '^’);Ultimately I want something like:execution.setVariable('KeyRef’,'CompanyId=' + ${CompanyId} + '^’);In this case ${CompanyId} is a variable set in an earlier step of the workflow.So, my question is how to perform a concatenation in a system task?

How do you move shop orders within a schedule?  We do not use production schedules, but we may need to move shop orders up and down for start/stop dates. Also, how does a shop floor operator know which shop order he/she should be working on next? Any assistance would be greatly appreciated.  We are using the IFS Cloud.

Hi , As we can not see previous allocation in dispatch console , Is there a way or any other type of calendar available so that we can see the previous allocation of resources . Thanks

hi, is there a way that multiple criteria can be applied in the dispatch console filters like multiple competencies . I think since Match All is on, if I put multiple, it does not show any results. So want to turn it off. 

We use Aurena only, Apps10 Upd13 (soon to be 14) and on a regular basis one or more or all of our SQL order reports start giving errors to all users. But only sql reports, crystals and operational reports are fineThe report in EE works fine, even when in Aurena failsapart from a server restart, this seems to continue for a few hours, then resolves itselfIt feels like were running out of some cache or disk but no one has been able to adviseRunning a refresh server cache sometimes fixes the issue, but not alwayserror:An internal server error occurred. Contact administrator.Url: https://----/main/ifsapplications/projection/v1/QuickReports.svc/QuickReport_844567()?$skip=0&$top=25Request Id = 46e2c0fe-2ce6-4e79-8e0b-09cdeb2b7c37Date = 2022-01-13T12:15:14.661ZClient version = 10.14.123.0

Hi Experts,I have a search type screen, On it I am trying to invoke a client script via a button. But the script does not seem to pick the the rows of the resultnt search. Is this expected, or am I missing something?