Hi tryied flags also but no change, still is adding extra ‘ or directly like You wroted “ no data found”
Sure, here You are, this is oryginal one. select listagg(zp,', ') within group (order by kod) ZP, kooperant, kod, opis, sum(suma_do_wydania) suma_do_wydaniafrom (select sma.order_no zp, so.cf$_nfm_id_dostawcy kooperant, sma.part_no kod, INVENTORY_PART_API.Get_Description(sma.CONTRACT, sma.PART_NO) opis, (sma.qty_required) - (sma.qty_assigned) - (sma.qty_issued) suma_do_wydaniafrom SHOP_MATERIAL_ALLOC sma, SHOP_ORD_cfv sowhere sma.order_no = so.order_noand sma.release_no = so.release_noand sma.sequence_no = so.sequence_noand sma.order_no in (&WPISZ_ZP)and (sma.qty_required) - (sma.qty_assigned) - (sma.qty_issued) > 0) group by kooperant, kod, opisorder by 1
Treid it like that but without result. Option with apostrophe and comma result below:option with semicolon Regardig to use semicolon insted of apostrophe and comma, IFS Apps EE by default is putting data for parameter “devided” by apostrophe and comma. There is option to change it to semicolon?
Hi all, Got same error on Windows 11. On another Windows 11 machnes working fine. Any ideas how to solve issue?Best regards
Hi, did you manage to resolve this? We’ve just had Update 17 deployed, and now have an issue with a custom menu and quick report using expandable parameters, which was previously working fine. Hi. It was marked as bug to IFS. WE got update for that.
Hi All, Can we rename the part number which is only lot-tracked enabled? (Assuming the entire lot is in inventory). I am asking the similar scenario which is available for serial parts under ‘Part Serial’ window, RMB option ‘Rename...’ ? Hi Thieuban.You can use counting report for it. Make countout transtaction to remove stock from old part and make counin transaction to put stock on new part. Best regards.
hi @nmmjacek - Have you any infomation on the bug fix ID for this. We are currently testing UPD 17-20 and have this issue. I don’t fancy re-writing all our quick reports! Hi @Matthew sorry no. We got fix from our partner. Bug was releted to some update for sql injection possibilities. Best regards.
Hi @nmmjacek , We need to have rename history in system. Ideal goal is not to remove the stock. Even if we remove, I do not see any option to rename the part number. This is mainly for modification compliance. @Thieuban counting report is tracked in inventory part history. Also You can make a comments on it.
hi @nmmjacek - Have you any infomation on the bug fix ID for this. We are currently testing UPD 17-20 and have this issue. I don’t fancy re-writing all our quick reports! Hi @Matthew sorry no. We got fix from our partner. Bug was releted to some update for sql injection possibilities. Best regards. Found the answer to out issue - In System Paramaters - Reporting ‘Enable bind variables for SQL Quick Reports in IFS EE’ is new. It is set to True by default. Setting to False made the reports work for us. I have same setting.
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.
