This query provides a list of items that were received into store locations within a specified date range. The query retrieves data from the RPRO VOUCHER and VOU_ITEM tables to determine items received. Other RPRO tables are linked to also retrieve the needed item details.
The date range in blue below can be easily modified in the WHERE clause to output data for a different timeframe:
and v.created_date >= to_date('20170828', 'YYYYMMDD') and v.created_date <= to_date('20171001', 'YYYYMMDD')
Requestors of this report in the past include:
GT Finance - Chloe Park, Diana Zhang, Ben Chen
GT Merchandising - Sarah Kolbuc