As per the subject, could someone help me with the query to find the Quantity Received since a particular date for a particular SKU ?
If an order is placed for 10 of SKU(ABC)
we receive 1 on date X, I'm assuming TODATEQTY would be 1.
we receive 1 on date Y, I'm assuming TODATEQTY would become 2.
But where do you see the date each was received?
As per documentation:
//###PURCHASE HISTORY HEADER###
PURCHASE_HISTORY_HDR.PH_DATE (purchase order date)
PURCHASE_HISTORY_HDR.RECV_DATE (The date that the items detailed on the purchase order are actually received)
//### PURCHASE HISTORY DETAIL###
PURCHASE_HISTORY_DTL.BVORDQTY (The quantity ordered in buy unit of measure)
PURCHASE_HISTORY_DTL.BVTODATEQTY (The quantity received in buy unit of measure)