QUICK REPORT NOT WORK
-----NEW ORDER STOCK CHECK 25-03-2025 V2 SELECT INVENTORY_PART_API.Get_Accounting_Group('AQ',X.COMPONENT_PART)ACCOUNT_GROUP, ACCOUNTING_GROUP_API.Get_Description(INVENTORY_PART_API.Get_Accounting_Group('AQ',X.COMPONENT_PART))ACCOUNT_GROUP_DESCRIPTION,INVENTORY_PART_API.Get_Part_Product_Family('AQ',X.COMPONENT_PART)PRODUCT_FAMILY,CODE_C_API.Get_Description('AQ',INVENTORY_PART_API.Get_Part_Product_Family('AQ',X.COMPONENT_PART))PRODUCT_FAMILY_DESCRIPTION,X.COMPONENT_PART,INVENTORY_PART_api.Get_Description('AQ',X.COMPONENT_PART)DESCRIPTION ,X.REQ_TOTAL_QTY,X.AVAL_TOTAL_QTY_,X.TOTAL_PO_QTY_, --((X.AVAL_TOTAL_QTY_ + TOTAL_PO_QTY_)-(REQ_TOTAL_QTY))DIF,CASE WHEN ((X.AVAL_TOTAL_QTY_ + TOTAL_PO_QTY_)-(REQ_TOTAL_QTY))< 0 THEN ((X.AVAL_TOTAL_QTY_ + TOTAL_PO_QTY_)-(REQ_TOTAL_QTY)) when ((X.AVAL_TOTAL_QTY_ + TOTAL_PO_QTY_)-(REQ_TOTAL_QTY))> 0 then 0 end as shortage_qty FROM (SELECT --L.FG_PART,--L.AC_GROUP ACCOUNT_GROUP,--L.AC_GROUP_DESCRIPTION ACCOUNT_GROUP_DESCRIPTION,--L.PF_CODE PRODUCT_FAMILY, -