Inventory Turnover Report Query: Difference between revisions
Jump to navigation
Jump to search
Intra>User m (1 revision imported) |
m (1 revision imported) |
(No difference)
| |
Latest revision as of 12:58, 14 July 2023
SELECT (select qty_on_hand from arPprtrx_qty_on_hand(P.PRODUCT_CODE, :BEG,0, NULL)) beg_qty, (select qty_on_hand from arPprtrx_qty_on_hand(P.PRODUCT_CODE, :END,0, NULL)) end_qty, (select sum(qty_sold) from artslsdt sd where sd.product_code=p.product_code) qty_sold, P.product_code,p.description_1,p.product_class FROM ARTPROD p WHERE P.STOCKED='Y'