Hello @Aneta Kuzora , Thanks for your answer; 1- MSF voucher selected.2-Voucher Rows have lines but voucher postings tab is empty.3-I am logged in with IFSAPP, but I checked all authorizations and IFSAPP belongs to AC group. But still I am not able to create a new line with ‘+’ sign, it is inactivated. Kind Regards
Hello @Aneta Kuzora , Thanks for your answer, I think your answer is correct but I can’t test it on my enviroment because “+” sign is not active in any account. Any idea about it? Thanks in advence,Best Regards
Here is an example of how you can change a part of your sub-select: FROM &AO.TRREP_SATIS_ANALIZ b WHERE b.PERIOD2 <= TRREP_SATIS_ANALIZ.PERIOD2 Or you could try to replace the sub-select with: SUM(amount) OVER(ORDER BY period2 RANGE BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) Hello @Tomas Ruderfelt ,Thanks for your help!First option solved my problem.It helped a lot and I learnt something, thanks for that. Kind RegardsOzgun BAL
Hello Servet, thanks for reply. My aim is to calculate running total value of SUM(AMOUNT) cloumn.So I added a new column with using subquery which sums running total values. Please inspect following screenshots;And If I remove alias result is like that; Maybe someone can help me about other ways to calculate the running total value?My logic to calculate running value of SUM(AMOUNT) may be wrong but query results seems correct. What I only need is to save this data source design but IFS doesen’t allow. Kind RegardsOzgun BAL
Hi @Ozgun BAL , I believe if you remove the b from the field where you’ve entered the view name and change your inline query to include the b after the view name you’ll be able to successful save your data source. Regards, William Klotz Hello @william.klotz , Thanks for your answer, If I remove the alias names from the query, result will be incorrect.I actually need to give a name to the view table. If i dont give an alias, query result won’t be correct. Isn’t there any way to give an alias name to view table in this situtation? The query preview works fine but IFS doesen’t let me save my lobby data source element. Thanks in advence. Regards Ozgun BAL
Hello,Actually my aim is just to see If I created purchase requisition for a specific shop order.I dont’t want to reserve anyting, I just want to realize if I created purchase requisition for the shop order or not.So I solved my problem in this way.
Hello,I think pegging requisition and order is imposible. >>>I solved my problem in this way, so it may help somebody.>>>1- I created a costum field in Purchase Requisition header called Des. 2-Then I added new tab called purchase requisitions in manuel pegging of shop order material lineAnd Tab is matching the Custom field “Des” in the purchase requisition and Shop order no.So when I click manuel pegging in the Shop order, I just can see If I should create purchase order for a specific shop order or not. Kind RegardsOzgun BAL
Thanks for help!
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.