Is there Cost history details for Shop Orders? Can I export all cost bucket detail for shop orders from the last 2 years? Where is the data stored? I need the cost data for all shop orders.
Solved
Is there Cost history details for Shop Orders?
+14Best answer by Abdul
Hi
Please check following screens,
- Shop Order Actual Cost Details
- Shop Orders Costs - Run Aggregate Shop Order Costs per Shop Order process to populate data.
- Additionally, you can create a simple quick for Shop Order Cost » Overview Unit Cost tab. You can use below sql statement
SELECT T.* FROM SHOP_ORDER_COST_DETAIL T
WHERE SHOP_ORD_API.Get_Close_Date(T.ORDER_NO,T.RELEASE_NO,T.SEQUENCE_NO) BETWEEN TO_DATE('&FROM_DATE','DD/MM/YYYY') AND TO_DATE('&TO_DATE','DD/MM/YYYY')
Hope this will help.
+20Hi
Please check following screens,
- Shop Order Actual Cost Details
- Shop Orders Costs - Run Aggregate Shop Order Costs per Shop Order process to populate data.
- Additionally, you can create a simple quick for Shop Order Cost » Overview Unit Cost tab. You can use below sql statement
SELECT T.* FROM SHOP_ORDER_COST_DETAIL T
WHERE SHOP_ORD_API.Get_Close_Date(T.ORDER_NO,T.RELEASE_NO,T.SEQUENCE_NO) BETWEEN TO_DATE('&FROM_DATE','DD/MM/YYYY') AND TO_DATE('&TO_DATE','DD/MM/YYYY')
Hope this will help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.