IFS Applications version: App9 UPD14
Found out the cause of issue, the “SELECT” was not on position 1 of QR’s query-box. (There were 3 empty spaces before the “SELECT” word).
It might not be the solution. But, try to trace first: Have you tried activating the debug console, and check the query statement when the navigated window is populated? (check whether those 2 fields are in the where condition).
Hi @DevBob, in the data-source colums, instead of giving SUM(...) you can define the alias field name which has been defined in the IAL.Your IAL might need a little change, you will need field-name without space bar, and start the field name with alphabet. Oracle cannot support field-name started with number. ex. select state as Status, count(*) as All_Orders, -- instead of “All Orders” ... sum(case when TRUNC(wanted_delivery_date) between TRUNC(sysdate - INTERVAL '5' DAY) and TRUNC(sysdate - INTERVAL '3' DAY) then 1 else 0 end) as Days_Past_Due_3_5 , -- instead of “3 - 5 Days Past Due”...Data source definition:
Hi @DevBobyou can check the technical documentation for detailed info on how to do migration data into custom fields: Location: see the breadcrumb path Hope it helps. Cheers,~Juni
Hi Marcin, to enable “E-mail Order...” context menu, the purchase order’s “Supplier Contact” must have email setup in communication method. If you haven’t setup the event to email the report, you can check this thread Hope it helps. Cheers,~Juni
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.
