Checked the issue forwarded by Ms. Arelene regarding  Cartier’s per store stock on hand/inventory which includes consigned items?  The file sent before doesn’t include jewelry consignment items.

Open the report in the Report Designer to checked for the script
Review the script if the Cartier Consignment is included in the department parameter
Generate Per Location Inventory and Stock onhand report as of yesterday
Ask Ms. Shirene the date she is trying to generate as per Ms. Shirene May 1, 2020, is ok with her
As per checking in MySQL, there are no data in for May 1, 2020
Run inventory work back for May 1, 2020
Generate the reports and send it to Ms. Shirene and this is now ok as per email confirmation