Hello @Marcel.Ausan When I posted my message, I didn’t refresh the page, so I couldn’t see your response.I had a look at the querry to create the form, and we don’t use C_PAYMENT_AMOUNT, but UNIFORM_PAYMENT_ADVICE_REP + SUPPLIER_INFO_GENERAL + LEDGER_TRANSACTION_SU_QRY + MAN_SUPP_INVOICE + PAYMENT_PER_CURRENCY_SU_QRYSo, about the request that I posted, should that be fine? as I use the RESULT_KEY to find the total amount of the payment
I think I found it :Expression 1 :select NVL(sum(payment_amount), 0)from UNIFORM_PAYMENT_ADVICE_REPwhere result_key=[#ResultKey]Operator: <>Expression 2 : 0
Hello @EntShehaM I didn’t know this synthax and sounds interesting, but I still have a question : in the case in which I need to get the value of P_SHIPMENT_ID in a direct call, is that possible to get it?
thanks @gumabs but the link isn’t helpful, I’m not seeking how to automatically send a payment advice on IFS, but to edit the condition that I shared on my screenshot to prevent to send an empty mail to a supplier, but I’m not familiar with the report rule screen.For that, I either need to calculate the right total amount or to know the number of payments.
Hello.FND_LICENSE for the 1st tab, FNDRPL_COMPONENTS for the 4th one.Not sure that there are any views for the 2nd and 3rd tabs
I think I found the screen :Why does the condition doesn’t work? or maybe it doesn’t work when PAYMENT_AMOUNT = NULL ?Thanks
Hello @mwilson It was an issue related to the cache to refresh, now the 2 other custom functions are listed.Thanks
Neat, that works, I didn’t know this screen, thanks for your help
Hello @lisa.gilesAB I don’t use expressions in my case but only SELECT.“Rental Start Date is a Custom Field within the LU”, I understand you are talking about a custom LU, therefore, a custom page. Every custom field in a custom LU / page starts with “CF$_” in their name, if you can use SQL Developer, you can easily notice that.In the arguments field, you can type t.cf$_ALLOCATED_SERIAL In your SQL Query, you need to replaceWHERE ALLOCATED_SERIAL = :ALLOCATED_SERIALbyWHERE CF$_ALLOCATED_SERIAL = :cf$_ALLOCATED_SERIAL
Hello.I don’t fully understand your message. You mention a “custom field”, is that on an IFS data table or on a custom page? From what I understand, if you want to make that kind of custom field, you would need to create a read*only type, and you would need to define parameters, but I can’t know which ones you need in your case… And your custom field needs to return a text.It would be better to use a SELECT CASE in your case, so it would be like this :SELECT CASE WHEN CF$_rental_start_date = CF$_on_demand_date THEN ‘pass’when CF$_rental_start_date-1/24 = CF$_on_demand_date THEN ‘pass’ELSE ‘fail’ENDFROM XXXXXXXWHERE XXXXX
I already made a case and that’s why we are awaiting a delivery to fix this issue.
Hello @Link I got a feedback from the support, it’s indeed a bug, it’s corrected in UPD 8.We are now awaiting a delivery for this issue.
Alright, I made an IFS case.I made a new lobby, but this time, a list type, and the checkbox popep-up : @Link can you confirm that the screenshot that you shared with me was made from a list type?
@Link APP 10 UPD 5
it’s a counter type.Now I’m thinking, when I compare both screenshots, I noticed that the page combobox is filled in my case, not in yours. Can that explain the behaviours that we have?
Hello @Link Unfortunately, I don’t have this checkbox
Hello.Things are going well on our side, the device is now working in offline mode.We discovered that the IFS user used to request on IFS didn't have granted roles, and with full granted roles, the device is autonomous.We are trying to find the appropriated roles to grant on this user, so it can request on necessary views, but we can't find this list...
Hello @Link Thanks for your feedback, my workmate just managed to fix the weird issue : he unpublished the different CF before publishing them again, and now, it’s working fine
@Marcel.Ausan the v_order_no_BP_ is not empty, I left a comment saying that it contains a total of 287 charactersI got a screenshot of the error message but it’s in french, but it’s the ORA-06502 error code
The path is set to C:\TimeclockThe Time clock user is administrator, so no prob about windows privileges
My workmate reported to me that the company id alias was empty : We put a 2 digit number, but we have seen no new behaviour. What’s the next step?
Hello,The EmpCardData file contains only the header line, socompany_id, emp_no, wage_class, emp_card, company_aliasDo we have to fill this file or is there a way to fill it via ifs? like an ifs process or an extraction?The off line path is already set. The badge reader creates the file but remains empty.
@paul harland this is a custom page that I’m working on, this page is filled with the following sql query :select EMP_NOfrom COMPANY_PERSON_ACTIVEOn my custom page, I added a CF$_QUALIFICATION field to select a qualification from the selected employee (selection made by a left click on the line). My issue was to display a list of qualification according to that selected employee.@Telha I made a test but nothing is working fine for me, I think something is missing : how can I save the selected qualification according to the employee? In my case, the pop up doesn’t open, I got a discussion, and we will work differently, the qualification field would refer to a custom list
Hello @paul harland As explained in my first post :I need to display a list of qualifications, according to the selected employee.
it’s a custom method, exactly.Have you added the custom package and method according to IFS standards?I can see my other custom procedures which requiere parameters, so, what’s the method to add to IFS standards for a method with no parameter?Make sure you refreshed the dictionary cache.I did it but still, no success :/
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.
