Thanks @ridvanyazici , this solved it!!
I have access to every site and company that I query, so I don’t think that’s the problem.
Thanks. I will do that then.
select a.part_no, a.description, a.contract, a.planner_buyer, a.part_status, h.planning_method, h.order_point_qty, h.lot_size, Inventory_Part_In_Stock_API.Get_Inventory_Qty_Onhand(a.contract,a.part_no,NULL), case when d.qty_past_month is null then 0 else d.qty_past_month end as QTY_LAST_MONTH, case when e.qty_2_months_ago is null then 0 else e.qty_2_months_ago end as QTY_2_MONTHS_AGO, case when f.qty_3_months_ago is null then 0 else f.qty_3_months_ago end as QTY_3_MONTHS_AGO, case when g.qty_last_6_months is null then 0 else g.qty_last_6_months end as QTY_LAST_6_MONTHS from inventory_part a left join ( select sum(a.qty_shipped - a.qty_returned) as QTY_PAST_MONTH, a.part_no, a.contract from customer_order_line a inner join inventory_part b on a.part_no = b.part_no and a.contract = b.contract where a.real_ship_date >= sysdate - 30 group by a.part_no, a.contract) d on a.part_no = d.part_no and a.contract = d.contract left join ( select sum(a.qty_shipped - a.qty_returned) as QTY_2_MONTH
No, I only use standard views from IFS, like customer order lines, inventory part and inventory part planning.
I’ve already verified the permission sets, but they are the same for every quick report, and since the others work, this should work as well if that were the problem.
First of all, thanks for the reply! You are correct, I am using IFS EE, not Aurena. In fact, every other SQL quick reports work just fine, I am able to see the information in IFS if I do “View Report” and if I use “Export to Excel”, the same information appears. For this specific quick report, unfortunately this doesn’t happen. My query starts with “SELECT” clause and I have a few “LEFT JOIN” inside it, but it should work just fine. I am not sure if there exists any kind of limitation with the type of data that I am exporting, in terms of conversion to excel, but it’s basically just sums inside my “LEFT JOIN” clauses, between certain periods of time. I’ve taken a different approach to this and instead of using “Export To Excel”, I use “View Report” and then use the output channels to export this information to CSV and it works perfectly. Still, it’s not as efficient doing this when you could simply export it to excel directly.
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.