Skip to main content

Posts

Showing posts from July, 2020

Query to Get Item Onhand Quantity as on date

Item On-Hand Quantity For A Specific Date  SELECT   qslt.organization_id, qslt.inventory_item_id, as_of_date_on_hand   FROM   (  SELECT   organization_id,                      inventory_item_id,                      SUM (qty) AS as_of_date_on_hand               FROM   (  SELECT   organization_id,                                  inventory_item_id,                                  SUM (transaction_quantity) qty                           FROM   mtl_onhand_quantities_detail                   ...