Thank you so much, this help me resolve the issue. Basically, I copied the original Purchase Order connected to the Distribution Order and released and then received from the Internal Order Transit location. Thanks again,
Once again, thank you for your response. However, this does not help me with the same person printing documents for different suppliers from different countries. Is there any other way? Dave
PURCHASE_RECEIPT_RETURN_REP
Thank you for your response. What about supplier returns, there is no way of changing the language there? Also, can anything be set up in report rules? Dave
Thanks for the advise but I have already checked this and it is enabled.
Again, Thank you for your response, but I did see this post and did not understand what it was all about if I’m totally honest.
Thank you for your response, see attached screen shoot.
Thank you all for your help. I Found out a much simpler way of doing it. I simply used the ORDER BY ‘week’ in the Data Source Designer and its sorted the x axis perfectly.
I too would be interested in understating all three points above.
Hi Jouni, Perfect, that works. Thank you so much for your help. Dave
Hi Jouni, Thanks again, That did not work, i have screen shot the error message Its a date and time and it is displayed like this, 30/01/2020 10:09:25 Dave
Hi Jouni I must start by thanking you for your response and help. I must now tell you that i am new to SQL but learning quick. I only need to get e week number from one date and this need to be a new created column, may be with the AS command I have a couple of question if i may; First question In my scenario does to_char = ACTUAL_FINISH? Second question are you giving me two different solutions or are they one command? Giving my sequence above how would you insert it? I have tried every way i can think of and it wont work. Thank you in advance
Maybe use something like below in an IAL and use the value of avg_down_time to show up on a counter element? SELECT w.wo_no, MAX(CASE WHEN w.new_value = 'WORKDONE' THEN w.dt_cre END) - MAX(CASE WHEN w.new_value = 'FAULTREPORT' THEN w.dt_cre END) down_time, AVG(MAX(CASE WHEN w.new_value = 'WORKDONE' THEN w.dt_cre END) - MAX(CASE WHEN w.new_value = 'FAULTREPORT' THEN w.dt_cre END)) over() avg_down_time FROM work_order_journal w WHERE w.value_source = 'ActiveSeparate' AND w.new_value IN ('FAULTREPORT', 'WORKDONE') HAVING MAX(CASE WHEN w.new_value = 'FAULTREPORT' THEN w.dt_cre END) >= SYSDATE - 7 AND MAX(CASE WHEN w.new_value = 'WORKDONE' THEN w.dt_cre
Thank you for all the responses, I will look at these shortly and let you know the results.
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.