Hello.On an sql treatment, I had to update a custom procedure to return a value, for that, I added a new parameter with the “out” key, so the new signature is :PROCEDURE SFD_EV_SC_053(p_order_no_ varchar2,p_line_no_ varchar2,p_rel_no_ varchar2,p_line_item_no_ varchar2,p_shipment_id out float) On an old event, this same procedure is called but in a deferred way, so the code is : Client_SYS.Clear_Attr(attr_); Client_SYS.Add_To_Attr('P_ORDER_NO_', '&NEW:ORDER_NO' , attr_); Client_SYS.Add_To_Attr('P_LINE_NO_', '&NEW:LINE_NO' , attr_); Client_SYS.Add_To_Attr('P_REL_NO_', '&NEW:REL_NO' , attr_); Client_SYS.Add_To_Attr('P_LINE_ITEM_NO_', '&NEW:LINE_ITEM_NO' , attr_); Client_SYS.Add_To_Attr('P_SHIPMENT_ID', v_shipment_id , attr_); transaction_sys.deferred_call('MYPACKAGE_API.SFD_EV_SC_053','PARAMETER',attr_ ,'#SQL Treatment'); But it seems that PL/SQL doesn’t support the call of such a procedure in a deferred way, or maybe the call must be different. The error code that I
Hello.I would need your help as I don’t know what IFS screen I have to reach.We have a custom report that we defined on :ifswin:Ifs.Application.ManageReportDefinitions.ReportDefinitionDetail?action=get&key1=UNIFORM_PAYMENT_ADVICE_REPThis report is generated to send an email to suppliers with the report sent at attachment file, but I can’t find how the send is done. We have an error in which we send an email with a total amount of 0, and we need to prevent that.Thanks
Hello.I made a new custom package to make a custom lobby as it’s way too complex to make it on IFS.I made custum functions in this new package to return results, but they are not available for users. What’s the way to grant access to these custom functions? I went to this screen :ifswin:Ifs.Application.SecurityAdministration.PermissionSetDetail?action=get&key1=XXXXXXXXI selected the database objects tab, I ran a research to my new package name and IFS listed it, but I cannot find every custom function inside, 1 custom function is listed out of 3.Am I doing something wrong?
Hello.I was asked to add an approval process on the work center screen (link : ifsapf:frmWorkCenter ) but I don’t know well how IFS works on that. Is that possible to make an approval process on such a screen? By clicking on attachments, I can only see “media”
Hello.I have a very important question to ask about custom pages.Today, we have a high number of custom pages on IFS APP10, and this number of pages will continue to grow up with time, we even have a scheduled task to fill these different pages, and we have custom menus as well. When we will migrate to IFS cloud, would this whole stuff still be compatible? Or would we have to re-create everything?
Hello.On a lobby, I updated the data source to sort data from the CUSTOMER_ORDER_LINE view, the sort is now done on WANTED_DELIVERY_DATE.On the desginer, I have a link to navigate to ifsapf:tbwOverviewCustOrdLine_Ext, but strangely, records are not sorted on the destination page.What’s the way to sort data when I navigate to ifsapf:tbwOverviewCustOrdLine_Ext through the lobby?
Hello.We are using APP 10 UPD 5 and we have harsh issues with the IFS badge reader.While the badge reader is in online mode, employees can badge and it works very well.While the badge reader is in offline mode, nothing works, the reader can’t read any badge.I asked what’s written on the badge to someone who installed these readers, he told me there is the ID badge on it.What’s the way to make this badge reader work? is that a configuration issue or badges need to be updated?
Hello.We have a weird IFS behaviour : on this screen ifsapf:tbwReceiptInfoWe already added a couple of custom fields, they are already available and displayed on ifsapf:frmReceiptInfoAbout ifsapf:tbwReceiptInfo , by realizint a right click → column chooser, even if we add every CF on the right side, and then, by clicking on the OK button, these CF are not displayed.If we return to column chooser, they still appear in the left side.What can we do to display these CF? all of them are persistants and they are not shared with no other view.
Hello.We have an issue on a custom menu we made to generate a pick list from a list of shop order operations.In our developement, we have this :IF (p_user_language_ = 'FR') THEN v_consolidate_ := 'Entrepôt';ELSIF (p_user_language_ = 'EN') THEN v_consolidate_ := 'Warehouse';ELSIF (p_user_language_ = 'PT') THEN v_consolidate_ := 'Warehouse';END IF; --v_order_no_BP_ contains a list of ORDER_NO with ; as separated value, the length of v_order_no_BP_ is 287 charactersmessage_ :='!$ACTIVITY_SEQ=0$COM_PART=%$CONSOLIDATE='||v_consolidate_||'$CONTRACT=ABCDE$DEPARTMENT=%$FROM_REQ_DATE=$INCLUDE_MATERIAL=TRUE$INVENTORY_PART=%$ISSUE_FROM_LOC=%$LOCATION_GROUP=%$MAX_ORD_PER_PICK_LIST=0$ONLY_COMPLETE_LINES=FALSE$ONLY_COMPLETE_ORDERS=FALSE$OPERATION_NO=0$ORDER_NO='||v_order_no_BP_||'$ORDER_TYPE=%$PHANTOM_PART_NO=$PRINT_PICK_LIST=0$PRODUCTION_LINE=%$PROJECT_ID=%$RELEASE_NO=%$SEQUENCE_NO=%$SHOP_ORDERS_KEY_LIST=%$START_DATE_FROM=$START_DATE_TO=$TO_REQ_DATE=$WAREHOUSE_PICK_LIST=FALSE$WORK_CENTER=%
Hello.In a custom page, table type, is that technically possible to make a custom list which depends a specific field?I need to display a list of qualifications, according to the selected employee.
Hello.I made a new custom page, I did set the grant access to this page.I then created a link to access to this page, but the users can’t see this link. They can still access to the page via the URL.What do I have to do? I already refreshed the reference cache server.
Hello.I need to create a new background task, but strangely, procedures with no parameter are not listed.Is that a bug or is that tricky to select such a procedure?
Hello.On the customer order screen, I made a new event, so, when a new line is created in the detail, I have to check the freeze price field, but nothing happens.On the event action, I put the condition “NEW:PRICE_FREEZE = FREE”, in the code, I put this :DECLAREattr_ VARCHAR2(32000);BEGIN Client_SYS.Clear_Attr(attr_); Client_SYS.Add_To_Attr('P_ROWKEY','&NEW:ROWKEY' , attr_); transaction_sys.deferred_call('CustomPackage_API.CheckPriceFreeze','PARAMETER',attr_ ,'#Check the “price freeze” field');END; I defined the function like this : PROCEDURE CheckPriceFreeze(P_ROWKEY VARCHAR2)ISv_attr varchar2(32000);v_objid varchar2(200);v_objversion varchar2(200);v_result varchar2(32000);BEGIN SELECT OBJID, OBJVERSION into v_objid, v_objversion FROM CUSTOMER_ORDER_LINE WHERE OBJKEY=P_ROWKEY; Client_SYS.Clear_Attr(v_attr); Client_SYS.Add_To_Attr('PRICE_FREEZE_DB','FROZEN' , v_attr); IFSAPP.CUSTOMER_ORDER_LINE_API.MODIFY__(v_result ,v_objid ,v_objversion , v_attr, 'DO' ); COMMIT;END CheckPric
Hello.Today, we only have 1 contract we use for any shop order / selling documents / purchase documents and such.In our developements (events / CF read only type / schedule tasks / lobbys ), the most of the time, SQL queries don’t use the contract to filter data, but generally we only use the ORDER_NO field for selling and purchase documents, and ORDER_NO + RELEASE_NO + SEQUENCE_NO fields for shop orders.We have planed to create a new contract : what would be the consequences on our developements ? Would they need to be re-worked?
Hello.On a CF, read only type, how can I get the user language?I have to display a message, the message is returned by a custom function.I thought to send the value of #USER_LANGUAGE# as a parameter, the variable can’t get the value, just the label.
Hello.In this screen : ifsapf:tbwOverviewCustomerInvoiceItem_Ext We added a persistant CF, formatted as text.The user would like to enter a datum to this specific field, without editing any standard field : But an error occurs, preventing to fill the field :
Hello.Can IFS catch a custom exception from a custom report?I’m working on a custom report for the shop order screen, and I don’t manage to make IFS catch any custom exception.
Hello.We created a new CF (persistant type) on :LU = PurchaseOrderLineView = PURCHASE_ORDER_LINE_ALLURL = ifsapf:tbwPurchaseOrderLine_Ext And now, we would like to make this same CF visible on :LU = PurchaseOrderLinePartView = PURCHASE_ORDER_LINE_PARTURL = ifsapf:frmPurchaseOrder_Ext and on LU = PurchaseOrderLineNopartView = PURCHASE_ORDER_LINE_NOPARTURL = ifsapf:frmPurchaseOrder_Ext Is there a way to share this same CF among these screens? or do we have to create new CF and make events to “share” the datum?
Hello.On the shop floor workbench screen (URL = ifsapf:frmDispatchList), we would like to understand how privileges work to manage the access to this menu :Material Review board → create Thanks
Hello.We made a custom Field on the SHOP_ORD table, a checkbox type to know if the SO got printed or not. The custom event which is supposed to check the CF is nowadays randomly working, when it doesn’t work, it doesn’t do the stuff, no error is showed. Here is the custom event we made :LU = ArchiveDistributionTable = ARCHIVE_DISTRIBUTION_TABFire when : new object + objects changedAttributes changed on PRINTED Custom action :Condition for performing this action : NEW:PRITED = 1 Code (in a deffered call) :SELECT REPORT_ID INTO v_report_id_ FROM ARCHIVE WHERE RESULT_KEY = &NEW:RESULT_KEY;IF v_report_id_ = 'SHOP_ORD_WI_REP' THEN SELECT PARAMETER_VALUE into v_order_no_ FROM ARCHIVE_PARAMETER WHERE RESULT_KEY = &NEW:RESULT_KEY AND PARAMETER_NAME = 'ORDER_NO'; SELECT PARAMETER_VALUE into v_sequence_no_ FROM ARCHIVE_PARAMETER WHERE RESULT_KEY = &NEW:RESULT_KEY
Hello.By logging in on IFS IEE, a lobby page is displayed as their homepage.How can administrators update this homepage to define another lobby page for specific users?
Hello.On a custom page, is that possible to open in a dynamic way another custom page?I meant, I would like to realize something like this :if CF$_MyField = “a”, then open PageA if CF$_MyField = “b”, then open PageB ectEither via a zoom or via a custom menu.Thanks
Hello.Is there a way to enter an expiration date in the count per inventory part screen?For certain articles, the expiration date is mandatory.Thanks
Hello.I created a new custom field, a combobox type (not a column), and I have some issues to make it visible for all users by defaut.If they do a right click → properties, the new custom field is still listed.What’s the way to make it visible by default?Thanks
Hello.Is that possible to duplicate a whole custom LU?So far, I have 3 identical custom LU and I know that I will have to make more, all of them have the exact same model?
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.
