VBA Developer Needed to Reconcile Inventory

We are looking for an experienced VBA / Database Developer to help us resolve a technical misalignment in our inventory management system's go-live data.

The system utilizes a FIFO engine where IngredientBatches controls batch availability, and a movement-led IngredientStock ledger calculates live stock based on receipt/consumption transactions. Currently, a gap in our opening balance setup has caused our live stock dashboard to display negative figures.

The strategy and a core fix module (mod_OpeningStockReceipts.bas) have already been outlined. We need an expert to run diagnostics, align the columns, execute the fix safely, and ensure full system reconciliation without disrupting existing consumption history.

Scope of Work
Module Integration: Import and test a provided VBA module (mod_OpeningStockReceipts.bas) designed to generate missing opening receipt entries in the movement ledger from existing batch data.

Column & Data Alignment: Run data validation checks (via a provided macro) to identify and correct misaligned data columns (specifically Status and RemainingQty in the IngredientBatches table).

Data Reconciliation: Ensure that:

IngredientStock reconciles perfectly with positive opening balances.

FIFO batches remain completely unchanged.

Existing ConsumptionLedger records stay intact.

No duplicate stock movements are created.

System Validation: Rebuild and validate the live stock dashboard formulas to ensure future "End of Day" automated runs function reliably.

Thank you