dear all,i want to create new field in ifs10. how can i revised below query for read only select expression, SELECT ipis.QTY_ONHAND - ipis.QTY_RESERVED eldeki_miktar fROM PURCHASE_ORDER_LINE_ALL pola RIGHT JOIN INVENTORY_PART_IN_STOCK_UIV ipis ON ipis.project_id = pola.:project_id AND ipis.part_no = pola.:part_no and ipis.activity_seq=pola.:ACTIVITY_SEQ and ipis.CONTRACT=pola.:CONTRACT ps: Below is the screen where I will make this development.
dear all,In the first image I added, a window is visible in the test environment. In the second image, in the prod system, this area is not visible when logging in with the 'ifsapp' user. The result remains unchanged. What could be the reason for this situation?
dear all, We want to create an event if the quantities of materials in the purchase order exceed the quantities specified in the order during the delivery processThe code snippet for the event is provided below, but we're not receiving any emails from the event. Does anyone have any comments on this? BEGIN DECLARE v_emails VARCHAR2(200); v_subject VARCHAR2(100); v_message VARCHAR2(4000); v_buy_qty_due NUMBER; v_total_qty_arrived NUMBER; BEGIN SELECT pola.BUY_QTY_DUE, SUM(ria.SOURCE_QTY_TO_RECEIVE) INTO v_buy_qty_due, v_total_qty_arrived FROM PURCHASE_ORDER_LINE_ALL pola LEFT JOIN RECEIPT_INFO_ALT ria ON ria.SOURCE_REF1 = pola.ORDER_NO AND pola.LINE_NO = ria.SOURCE_REF2 AND pola.RELEASE_NO = ria.SOURCE_REF3 AND pola.PART_NO = ria.PART_NO AND pola.CONTRACT = ria.CONTRACT; IF v_total_qty_arrived > v_
Dear All, i have created below test report via BR,when i want to take an output, it shows below message, and then i click the “ok” button, then system do nothing. so, how can i take output in ifs10?
Dear all,Can we use database querries in ifs business reporter?How can we use our custom queries in the Business Reporter using this tool? I ‘m currently seeking know-how regarding this matter.
Dear All,How can I access information about who created the supplier in ifs10 enterprise explorer? I can access the 'created_date' information, but I cannot access information about which user created it.
dear all, we want to create an event below.I need a SQL query and steps to create this. I would be very happy if you could explain it step by step as I am a beginner.When a purchase request is created for purchasing materials with a standard package size larger than 1, we want the user to receive a warning on the screen: 'You can only enter the quantity in x (standard package size) or its multiples of the purchased material.
Dear All,we have created, below event action for purchase requestioners.Problem 1: Approval emails are being sent on a line-by-line basis, leading to unnecessary email traffic for the approver.Problem 2: Emails are not being sent to the next approver based on the approval hierarchy. That is, after the first approver gives approval, the email should be sent to the second approver. What is your advice regarding these issues?
Sayın Arkadaşlar,Hızlı raporda oluşturulan özel alanı nasıl kullanabiliriz?
dear all,how to use ial object in business reporter? could you explain step by step? or any documentation?
Hello, we placed a purchase order from the maintenance order. However, we want to cancel this order. But we cannot cancel the purchase order because it exists in the maintenance order. We also cannot cancel the maintenance order as it is being used in there. What would be the appropriate course of action regarding this matter
dear all, i can not run this querry for read only custom object. can anyone edit below query.“select IFSAPP.Inventory_Location_API.Get_Warehouse(ria.CONTRACT,IFSAPP.Receipt_Info_Manager_API.Get_Default_Location_No(ria.SOURCE_REF1,ria.SOURCE_REF2,ria.SOURCE_REF3, ria.SOURCE_REF4, ria.SOURCE_REF_TYPE_DB)) FROM RECEIPT_INFO_ALT ria”
Dear All,I have created a custom tab in IFS. How can we automatically filter it when the representative in the title is selected and if the salesman code on this list screen is the same.
Dear All, We have created the lobby element below for our company's C-level users.We want to visually enhance readability by separating currency digits with a dot every three digits. Since the TO_CHAR function won't suffice for our purpose, do you have any alternative suggestions?
Dear All, Is there anyone who has previously implemented saving meeting minutes for meetings held in our company in a specific format (for example, Word, Excel) in IFS10 IEE? What is the best way to do this?
Already have an account? Login
No account yet? Create an account
Enter your 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.
