Skip to main content
Version: Ceres 6

Year End Physical Inventory

Feeding America Member Food Banks Resources to Support Year End Physical Inventory

PhaseTaskResource or Link
PlanGet your warehouse and product readySJC - Preparing for Physical Inventory
Clean up your Ceres data (Negative lots, bin/ lot/ pallet mismatch issues, bad Card data)Handling Negative Lots in Ceres;

Data Quality Jet Report (Hungernet)

Plan your cutoff date/ close out open transactionsYear End Checklist
Determine how you will count (Manual, Handhelds, both)MBS Inventory UG May 2019 Recording (Hungernet);

MBS Inventory UG May 2019 Resources (Hungernet)

PracticePractice in your test system or via a cycle count using your planned method; time how long it takes.Cycle count/full count user group demo in Ceres (Hungernet)
If planning to use Handhelds for the first time; validate how the journal(s) will generateMBS Inventory UG May 2018 (Hungernet)
Stop transactionsAll received posted; all shipped posted; turn off AE shopping. Run Ceres Items on Hand by Date report and save
Generate count sheetsExecute the plan you practiced; hand out count sheets and empty bin listPhysical Inventory Count Report; Jet Count Report etc.; Empty Bin Jet report (Hungernet); or export saved view to Excel
CountUpdate count sheets or Journal with first count
Filter and recount any variancesExample Second count guide by Item Jet Report; runs from physical inventory journal
Filter and post adjustmentsSee Cycle count demo
Run Items on Hand by Date report and save