Does anyone know of any IFS Documentation on how to map IAL columns to the Designer ? Here’s what we’re trying and we get an error: IAL: select col.COMPANY as Company, col.CONTRACT as Site, col.customer_no || ' - ' || max(rega1app.CUST_ORD_CUSTOMER_API.Get_Name(col.CUSTOMER_NO)) as Customer_Name, pm.Part_Main_Group "Trademark", ROUND(SUM( col.revised_qty_due * col.sale_unit_price), 2) "Total_Revenue", ROUND(SUM( col.revised_qty_due * col.cost ), 2) "Total_Sales_Cost", ROUND( SUM( ((col.revised_qty_due * col.sale_unit_price) - (col. revised_qty_due * col.cost))), 2) "Margin", ROUND(AVG( case when col.sale_unit_price <> 0 then (((col.revised_qty_due * col.sale_unit_price) - (col.revised_qty_due * col.cost)) / (col.revised_qty_due * col.sale_unit_price)) * 100 else 0 end ) , 2) "Margin_%" from REGA1APP.CUSTOMER_ORDER_LINE col left join REGA1APP.CUSTOMER_ORDER co on col.ORDER_NO = co.ORDER_NO left join REGA1APP.PART_CATALOG pm on col.part_no = pm.part_no left j
I am using Apps 9 and am creating a permissions set for people to be able to report shop order operations. The permission set currently allows the user to go to the “Report Shop Order Operation” screen (Manufacturing → Shop Order → Report Operation → Report Shop Order Operation) and do everything they need to do, but for some reason the RMB menu option for “Report Operations...” is not enabled in the “Shop Order” screen (Manufacturing → Shop Order → Order → Shop Order). What permissions do I need to enable to enable this RMB option? Is there a good way in general of identifying which permissions need to be set to enable RMB menus?
Morning, I know we can stop different parts being stored in the same location by ticking ‘Mix of Part Numbers Blocked’ on the Warehouse Navigator, but is there a way in Standard Apps 9, to prevent a part being stored in more than one location? i.e Limiting every part in a warehouse / bay to only 1 Pick Location. Thanks, Chris.
if there was a way to only choose certain part categories to copy - Copy Part - from user: Just to clarify. I was.wondering if there can be a default where to ones that never get used can be unlocked when I open copy part, or even removed/hidden. I know they can be clicked off. I'd love to just open one and adjust the two or three changes needed depending on if it's a purchased part or a manufactured part.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.