Purpose of this document
Year end is always a crush of time sensitive activities. We’ve learned from past years that there are a few steps that are often overlooked and should be scheduled in order to make your close smoother and less drama filled. They break down into a couple of categories: Physical Inventory/ Inventory Value Related and Financials/ GL. This is not a comprehensive list of all necessary tasks to close the year end At the end of this document is a list of the base procedure documents that can provide overall guidelines for Inventory Counts for Year End and Year End Close Processes for Finance.
Table of Contents
Physical Inventory/Inventory Value Related Tasks
Make sure to read through the entire recommendation list prior to proceeding with any of the tasks in your production database.
1. Identify and correct bad records (Should be completed prior to the count):
- Negative Item Qty on Hand
- Negative Lot Qty on Hand
- Missing UNC/ FBC Codes from positive adjustments (and all Lot Cards)
- Missing required Dimensions (On existing ledger history)
- Blocked Items with Qty on Hand
2. Review and run Inventory Adjust Cost routines and Post Cost to GL. This can take many hours if you don’t
run this on a regular basis. If you don’t run this often, you may have large cost variances for Purchased Items
in your GL before and after running these routines. This work will calculate the actual Inventory Cost and
post it to your GL prior to year-end.
3. Define a cut off day and time for inventory transactions (including all inbound and outbound product).
4. Plan your Posting Date lock outs for Inventory/ Orders. Designate a select group of users that can post in
the year end date range after the cutoff date.
5. All Picks must be picked/ posted or deleted as of the cutoff day/time. For most versions of Ceres, you
cannot count a Location with open Picks. Open Agency Orders are acceptable.
6. Plan your count – if you count some product/ locations before the full cut off, make sure that these areas or
products are not “available” for ongoing Order activity until after the full count and reconciliation. Make
sure to follow the count guidelines for your particular organizations they vary.
7. As of your cut off day/ time – run a baseline report of your Inventory on Hand and Inventory Valuation
before you start your count. If your auditors need Bin information as well as count, make sure to validate
that ahead of time and run a baseline with that information.
- G/L Inventory Reconciliation
- Inventory Valuation Report – Gives you the option to run with an As of Date. Run before and after Adjust Cost.
- Receipts & Distribution Report (filterable by date/ optional)
- Distribution Pounds By County (filterable by date/ optional)
- Items on Hand Report (not filterable by date)
- Items on Hand by Date
- Bin Contents by Location (not filterable by date)
- Bin Contents w/ Pallets (not filterable by date)
8. After your counts are validated and the count and location adjustments posted, run the exact same reports.
Keep both copies for your records.
9. If you use Agency Express, you should notify your agencies and turn off shopping during the actual counts/
count validation/ adjustment posting. Don’t forget to turn it back on after you are done with your count. It
is a good idea to re-synch Items and Availability manually after the count is complete.
10. After your process is complete for the year, go back and review your procedures and update with any new
tasks or learning from this year.
Financials/GL Related Tasks
Make sure to read through the entire recommendation list prior to proceeding with any of the tasks in your production database. There is overlap in this list with the Inventory/ Inventory Value list.
1. Identify and correct bad records (Should be completed prior to the count):
- Missing required Dimensions (On existing ledger history)
- Blocked Items with Qty on Hand
2. Review and run Inventory Adjust Cost routines and Post Cost to GL. This can take many hours if you don’t
run this on a regular basis. If you don’t run this often, you may have large cost variances for Purchased Items
in your GL before and after running these routines. This work will calculate the actual Inventory Cost and
post it to your GL prior to Year end. You will want to determine if you want these adjustments to post to
your GL before or after the count results. This same task is recommended below as a post count task as
well.
3. Define a cut off day and time for the different data sets (A/P, A/R, Inventory).
4. Plan your Posting Date lock outs for Inventory/ Orders. Designate a select group of users that can post in
the year end date range after the cutoff date.
5. Dates, dates, dates – Make sure you lock out anyone you need to from:
- Posting forward into the new year until you are ready
- Once you start the new year, prevent users from posting back into the prior year
- Check all the Posting dates on Open AO’s, DO’s and PO’s after your Cut Off date and update to an appropriate date if needed. Document date = external date. Posting date = internal date for your GL.
- Verify the Adjust Cost and Post Cost to GL dates and their impact on your open year.
6. Identify and complete and receiving and distributions that must be completed prior to cutoff. For example,
all Cash Receipts for the year posted/ all Payables paid.
7. As of your cut off day/ time – run a baseline report of your Inventory on Hand and Inventory Valuation
before you start your count. If your auditors need Bin information as well as count, make sure to validate
that ahead of time and run a baseline with that information.
- G/L Inventory Reconciliation
- Inventory Valuation Report – Gives you the option to run with an As of Date. Run before and after Adjust Cost.
- Items on Hand Report (not filterable by date)
- Items on Hand by Date
8. If you are planning any major structural changes such as new accounts, new dimensions, new posting
routines etc., define a plan and a specific roll out window. You don’t want to have anyone post to the new
year until the new framework is in place.
9. After the count is posted run or re-run the Cost Post routines if needed. This may take hours. Then run a
“post count” Inventory Valuation report. This may or may not be needed, depending on your setup. You’ll
want to coordinate this with the pre and post reporting defined in step 4 above.
After your process is complete for the year, go back and review your procedures and update with any new
tasks or learning from this year.
Related Topics
- Physical Inventory Journal (Inventory Journal and Warehouse Journal)
- Year End Close Procedure (Ceres Specific)
- Microsoft D365 Business Central General Year End Procedure
- Microsoft D365 Business Central Information on Inventory Costing/ Adjust Cost
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article