Hi Community,I’m having trouble with creating a Lobby Data Source based in SQL in IFS 10 and I feel that I have tried everything without being able to figure out why this fails. To get the data I wanted for the data source I have created this IAL:SELECT SL.SHIPMENT_ID, SL.SHIPMENT_LINE_NO, SL.INVENTORY_PART_NO, SL.OBJKEY, SL.OBJVERSION, SL.OBJID, SL.CF$_MAN_PICK_STEPS_DB, SL.CF$_MAN_PICK_STEPS, SL.CF$_MAN_PICK_STEPS_PICKED_DB, S.CONTRACT, S.PLANNED_SHIP_DATE, S.OBJSTATEFROM &AO..SHIPMENT_LINE_CFV SLINNER JOIN &AO..SHIPMENT S ON S.SHIPMENT_ID = SL.shipment_idWHERE 1=1AND S.Contract = '70'AND S.OBJSTATE = 'Preliminary'AND SL.CF$_MAN_PICK_STEPS_DB in ('1', '2')When using this IAL view in the Data Source Designer I am successful in getting the data i want by using the “preview” button:Image shows the preview is successful if no columns is added However as soon as I add the column names I want, the preview is un
Hi community!I have recently received a need from the business where we are looking into if it is possible to require our timeclock users to provide a reason if there is a deviation to their timestamp vs their work schedule. Since I have worked very little with the “Time Management” in IFS Apps 10 I wanted your initial feedback if this is even possible out of the box in IFS?To elaborate here is and example of what we are trying to achieve:Employee-1 is on a schedule where he is working Mon-Fri 08.00 to 16.00.On Tuesday he goes to the dentist and is not able to clock in before 09.00 which means that he is working 1 hour less that day than what his schedule says.We would like a solution where he is prompted to insert a reason (hopefully predefined list of values) for his 1-hour delay.The reason for us wanting this is that according to the Norwegian work regulations some absence is with pay, and some is not. Best regardsJoakim
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.
