CFA Testing Partitioning - Inventory activity report data discrepancies

CFA Testing Partitioning - Inventory activity report data discrepancies

CFA Testing

Restaurant: 02693 - George Washington FSU

Inventory Activity Report

Inventory Activity Report (IAR) data captured before partitioning doesn't match IAR after partitioning. Attached IAR before and after along with specific items (Chicken, Nuggets and Potato, Waffle Fries) analysis.

It appears that 3 columns do not match: Purchase, Used and UsedCost. Please let me know if there are any additional questions.

Before Partitioning:
InventoryActivity-stacy.privalova 02693.pdf

After Partitioning:
InventoryActivity-stacy.privalova 02693 11122020.pdf

Excel sheet used for data validation:
Partitioning validation.xlsx

Report run between:

• Monthly Count 1/31/2020 10:15 PM
• Monthly Count 2/29/2020 10:15 PM
  
• These dates were selected to that no new data was introduced during the partitioning process

Differences between Before and After:

Purchases are different, this likely feeds in to other columns in the report