phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

VBA Developer Needed to Reconcile Inventory

  • Posted:
  • Proposals: 45
  • Remote
  • #4504639
  • OPPORTUNITY
  • Expired
Oluwaseyi O.Ejaz A.Muhammad B.Andrii I.Peter F. + 40 others have already sent a proposal.
  • 5

Description

Experience Level: Expert
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

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Naresh S.

    Hi Isla, could you please let me know whether the inventory system is built entirely in Excel/VBA with local tables, or does it also interact with Access, SQL Server, or another database? Also, do you have a copy of the pre–go-live dataset available for comparison and rollback validation before the reconciliation is applied?

    Thanks
    Naresh

  • Mark R.

    What backend is the database residing on. ? SQL / MSAccess / Other

  • Sudhanshu K.

    Before applying the opening-balance fix, do you have a recent backup or staging copy of the database available for testing, and can you confirm whether the negative stock figures are affecting all ingredients or only specific batches/products?

  • Mahmood U.

    Can you provide the current database format being used (Access, Excel VBA, SQL backend, or another structure)?