I am trying to create a query in datasource desinger where the view I am using includes CREATED_DATE in a datetime format. I have no problem creating a new field in the query to translate this to date or month, but I am struggling to use the same statements in ‘Group by’.Whenever I try to use any type of calculated value (such as to_char) in Group by, to get the results on a daily or monthly level, I get an error message. Is there any way to resolve this?
We have a pricing structure that consists of four different parts.A general price list where we set a cost and a price for each article Customer specific prices for the most common articles Regional prices for some customers i.e., a customer may pay different prices for the same service in different parts of a country, essentially multiple prices for one customer Project specific prices (for large projects)We are trying to understand how to best use the concepts in IFS Cloud to set this up incl. Sales Price Lists (Part based), Customer Agreements, Campaigns, Base price lists, Service contracts and more.What would be the recommend mix of these for an easy maintenance for our pricing structure?
I am trying to create a data source in datasource designer based on a query that I am designing in query designer. The end result should be a list of all Work Orders with a Work Leader that is missing a specific competence.In Query designer, I am able to retrieve a list of ongoing Work Orders with Work Leaders and I am also able to retrieve a list of competence per Work Leader but I fail to remove the Work Orders for those with a Work Leader that has the specific competence.The filter in Query Designer seems to be applied as a final step which makes it hard to just get a list of the specific competence at hand, and eliminates the possibility to use left outer join and search for null values.Is there anyone that knows a good way to solve this challenge?
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.
