Current eMessageSoftware Update > February 2018

Software Update

Best practices for inventory batch processing

By Tim Carlson, Training/Conversion Analyst

If your company uses inventory, we strongly recommend performing your batch posting process at least monthly, if not weekly. By performing this process on a regular basis, it will make it easier to reconcile your inventory. We’ve found that when companies perform this step less frequently, it makes reconciliation more cumbersome.

Before performing inventory batch posting, you can review all inventory transactions that will be posted by running the Inventory Transaction Listing report for the desired date range and filter the Status column to Open. Additionally, you can run the Inventory Balancing Report for the period and this will show a summary of all transactions by item and location.

To complete inventory batch posting, select Batch Posting from the Inventory Suite or Packages – Inventory – Batch Posting. After selecting the company, beginning, and end date that you want to process, select the Pre-Batch Edit Report button. This will provide you with a listing of all transactions that have occurred between the selected dates, along with general ledger account, value, and period information. If satisfied with the transaction information displayed in the report, close it and select the Post Entries button to complete the process. You will then get the Journal Entry Posting Report showing the selected transaction with the Journal Entry Number created.

One common issue we see are Purchase Orders that need to be reconciled and closed for a specific period are not until after batch posting has been completed and the period closed. It is important to review these purchase orders and reconcile them so that any inventory adjustments for freight or taxes be posted correctly.

If you are unsure of any of these steps, we recommend refreshing your understanding of these processes by taking one of our Inventory or Purchase Order web training courses.

MACC Challenge

Article Archive

January 2018
Custom Grid Reports

2017 Articles

December 2017
Year-end AM reminders

November 2017
Fall plant cleanup

October 2017
AM tax form processing options

September 2017
Simplify service agreements

July 2017
PSAP Templates Available in CM 17.1

June 2017
A small settings change can be a real lifesaver

May 2017
Am I forgetting something?

March 2017
eBill processing – Keeping Customer Master up-to-date

February 2017
Tips for implementing the new ‘My Time’ feature in Customer Master

January 2017
Get a great start to 2017!

2016 Articles

December 2016
Year-end AM reminders

October 2016
2016 tax form processing options

September 2016
Customizing Customer Master

June 2016
477 Reporting – how to be prepared

January 2016
Get 2016 off to a great start