It will be very useful to have specific information/documentation about IFS securities. We are in the middle of a project, updating IFS 9 from UDP6 to UDP17 and having a data dictionary about new database objects added by the updates will be very useful. A database model is another piece of documentation that could be very useful for reporting purposes. Many thanks Miguel
sorry I should have shown the last part of that screenshot
Hi, No it is not an “own process”, please see screenshot below. kind regards Miguel
Hi, Thank you for your reply. I have imported your custom menu. Did you see the menu available on a RMB in the race database, please let me know which company in the race database. Unfortunately the RMB>Menu is still not available for me, please see screenshot below. The custom menu is connected and I have ticked the appropriate box in the Properties windows, screenshots below. I have reload the configuration and also logout and login again, however the menu still doesn’t show. Kind regards Miguel
Hi Kevin, the RowKey has activated ?? I don’t understand, however at least now I can attempt to add custom fields to a related IFS window. I will have to investigate further the size of this table/view. Many thanks for your help
Hi Kevin Thank you for your suggestion. I have run the Direct option to activate the Key and the “eternity bar” is doing its thinking . It might take a while. I will revert back with my findings. Regards Miguel
Hi, Our DBA is checking on this number now. I think this might be related to projects having a long life and the view holding data at week level. I wonder how this view could cope if you are dealing with 100 of projects and trying to use the Resource Forecasting module and multi-company level. We are on UPD6. This amount of records is available in our TEST environment only were I have been testing the Resource Forecasting functionality. Kind regards Miguel
Hi Piotr. Thank you for your reply to my question. Yes IFS 9. I had count records in PROJECT_RESOURCE_SPREAD_WEEK and the records are 44,058,054 . No we don’t have any configured search domain options on ProjectResourceSpread . Kind regards, Miguel
Hi, We have implemented a RMB>custom menu “Expense Sheet Details” from the Project Transactions screen that show the details of the expense sheet (an IFS Quick Report). Best regards Miguel
Hi Steve, Many thanks, the deployment went through without errors. I don’t think I understand the rationale of the change though. Please see the main part of my SQL code with the IAL deployed successfully now. I only inserted the &AO.. in the nested API call, not everywhere. Miguel ifsapp.work_sched_assign_api.Get_Day_Sched_Code(COMPANY_ID,EMP_NO,ACCOUNT_DATE) SCHEDULE, NVL(IFSAPP.WORK_SCHED_ASSIGN_API.GET_SCHED_HOURS_DB(COMPANY_ID,EMP_NO,ACCOUNT_DATE,ACCOUNT_DATE),0) SCHED_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_ABSENCE_HOURS(COMPANY_ID,EMP_NO,ACCOUNT_DATE,ACCOUNT_DATE),0) ABSENCE_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS(COMPANY_ID,EMP_NO,&AO..Wage_Group_API.Decode('Absemce'),'HOL',null,ACCOUNT_DATE,ACCOUNT_DATE),0) HOL_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_HOURS(COMPANY_ID,EMP_NO,&AO..Wage_Group_API.Decode('Absemce'),'SICK',null,ACCOUNT_DATE,ACCOUNT_DATE),0) SICK_HOURS, NVL(IFSAPP.TIME_PERS_DIARY_RESULT_API.GET_WAGE_
Hi, If your projects are connected to the Sales contract Window, then you could create a shortcut using this advanced save search. The user has to enter the Project ID in the pop up window and then the sales contract connected will be retrieved by the shortcut CONTRACT_NO in ( select contract_no from ifsapp.contract_project where project_id = '&Project_Id')
Hi,We have SSO implemented and we run IFS 9 in premises. We upgraded from IFD 7.5 to 9 in November 2017. The IFS team dealing with the upgrade configured IFS for SSO. I don’t think it was a major challenge for them. If you want I can find the name of the person that was in charge of configuring SSO for us in IFS.Mig
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.