In Quick Report, how can I use calendar Date picker on invoice date. Sample : SELECT *FROM IFSAPP.INVOICE WHERE INVOICE_DATE >= 'STAR OF YEAR' AND INVOICE_DATE <= 'END OF YEAR'If I use SELECT *FROM IFSAPP.INVOICE WHERE INVOICE_DATE >= ‘&NVOICE_DATE’ then I have to type in date manually. Thank you in advance.
Please see image attached. In IFS Business Reporter, is there a way to convert Invioice From and Invoice To to calendars? These two fields return dates from db table. Not sure why they don’t display calendar automatically.
Please see my attached files. I want to be able to filter >= &invoicefrom from my report. Settlement Period From is invoice date. Sample, 05.02.2024 from db format is date, month, year from value list. In Filter Criteria, when I set invoice =& invoicefrom (like 05.02.2024) is returns data as expected. However, if I set to >=&invoicefrom (like 05.02.2024) it returns the whole data, which I don’t need. How can this issue be corrected? Eventually, I want to set my report like invoice >=& invoicefrom and invoice <=& invoiceto. Thank you in advance.
Is it possible to pass today date to url string page/CustomerOrderLines/List;path=0.995139193.1811xxxxx.6424xxxxxx;usedefaultfilter=true;$filter=DateEntered%20gt%202022-11-01T00:00:00Z >» this one work when hard coded page/CustomerOrderLines/List;path=0.995139193.1811xxxxx.6424xxxxxx;usedefaultfilter=true;$filter=Contract eq '01' and DateEnteredTruncated eq #TODAY# <« does not work
Hi all,I simply want to include additional questions raised by previous user.How can I find out data from different tabs and their queries? How can I find out data from each section of the page? Looks like this page has three different sections.
I am new to Developer Studio. Could you please provide a step by step on how to create View using the tools?
I am trying to create a link in lobby which points to this page with two parameters. However, this would not work. Could you provide some guidance?page/CustomerOrders/List?$filter=OrderId eq 'ERS' and (Objstate eq IfsApp.CustomerOrdersHandling.CustomerOrderState'PartiallyDelivered' & ‘Released’
I am trying to add the link below to Navigation lobby by filtering OrderId = 'ERS' and Objstate = ‘PartiallyDelivered'’. Right now it return all Orderid = ‘ERS’. It does not also filter Objstate. Is the link below accurate? page/CustomerOrders/List?$filter=(OrderId eq 'ERS')&((Objstate eq IfsApp.CustomerOrdersHandling.CustomerOrderState'PartiallyDelivered')
I am trying to pass a value from a column named “PART_NO” from an element. Under Element Preview, there is parameter name “PART_NO”. When I tried to pass it, it displayed “null”. I am not sure what I did wrong. Please advise.
Hello, I am still new to IFS. Please see my attachments. I want to accomplish a couple tasks.create datasource where Created (column) returns only current month. create datasource where Created(column) returns a count of Quantity (column) for each month for current year.Your help is greatly appreciated.
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.