Dear Clients,

We recently completed an interesting project for a client whose company has more than doubled sales in the last year as they’ve expanded their product lines and integrated online sales.

The accounting system and core business processes scaled great—but even though they started with some excess warehouse capacity, that and the picking process became bottlenecks to meeting customer demand. So we commenced a comprehensive inventory analysis to optimize the warehouse.

Slotting is the industry term for warehouse optimization and there’s several factors to consider…

First is, naturally, sales velocity—how fast each item sells—to place the items which sell more often in prime “picking locations” near the front of the warehouse, and dropping items which aren’t moving.

The second consideration is product affinity—to place items which often sell together close to each other (such as peanut butter and jelly)—and also to place hot selling items which don’t typically sell together (like coffee and tea) near the front but specifically NOT near each other to improve the picking flow.

Of course the pick lists include not only the bin location of the goods, but the system automatically lists them in the “recommended pick order” to optimize travel through the warehouse.

Often system improvements are made that we all agree are improvements, without the analysis to capture an exact measure of such—but not in this case. We were able to calculate “feet traveled per order picked” both before and after re-organizing the warehouse, and the measure is almost exactly HALF what it used to be.

While this was a best-case scenario of optimization, since “wherever stuff got put first” over the years had became the default locations before the optimization, the results were striking. And THAT is how they doubled sales with no increase in warehouse personnel.

So, have you considered optimizing your warehouse? We’re always standing by in the cornfields!

Kevin E. Stroud

Upcoming Online Product Trainings for AccountMate/SQL

June: We’ve been promoting the June 7-21 online Core Product Training here—that’s next week and if you’re interested, reach out to us and we’ll confirm there are open seats! At 3-5 hours per day for 10 days (attend the whole thing or just the sessions of interest to you), it covers the SM, GL, PO, AP, IC, AR, SO, AR and BR modules and more good stuff to round out your AccountMate skills and knowledge.

Q3: We expect future dates to be announced by AccountMate after the June class—but if it goes as it has in recent years, there will be another core training this fall, plus a deep-dive online class for the Payroll module.

And if you’re on Lifecycle Maintenance, your training could be free!  

If your company has a current Lifecycle Maintenance Plan, and you have 1-10 registered AccountMate users, you can send 1 person per year to a core training (all or part) for free. 11-20 users gets you 2 free people, 21-30 users is 3 free people, 31-40 users is 4 free people, 41-50 users is 5 free people, and at 50+ users it’s open to all your registered users. Additional people added to the AccountMate SQL core training get a 50% discount. Note: The Payroll class doesn’t qualify as a free Lifecycle Maintenance class.

Click here for Course OverviewCourse Outline, and Course Schedule—then reach out to us if you don’t see your favorite module listed, or if you’d like training personalized to your business processes and modifications.

AccountMate Tech Note: Understanding the Inventory As Of Report (New!)

The Inventory Control module has a new report which provides an overview of the company’s inventory stock status and related costs. The Inventory As Of Report includes information such as inventory item on-hand quantities, average cost, and total cost as of a certain date at the warehouse and bin level. You can generate this report to facilitate the monitoring and reconciling of inventory balances as of a specific date.

Full details are in our Article #1299: Understanding the Inventory As Of Report. This technical note provides information about the available report criteria and report fields used in the Inventory As Of Report.

AccountMate Tech Note: How to Record Transactions Using Multiple Bins

AccountMate provides the capability to record inventory transactions using multiple bins. Article # 1313: How to Record Transactions Using Multiple Bins discusses the procedure to do so.

This document also discusses the reports that show the assigned bin in each particular inventory transaction.

AccountMate Tech Note: Understanding Finished Job Cost Calculation Methods and Their Effect on Production Variances

AccountMate’s Manufacturing or Manufacturer’s Inventory module provides three different options by which to calculate finished job cost in manufacturing inventory items. Article #1164: Understanding Finished Job Cost Calculation Methods and Their Effect on Production Variances discusses how the system calculates finished job costs using these three methods including the calculation of production variances. It also shows the appropriate GL entries for the different methods used to calculate finished job costs.

AccountMate Technical Tips

 Versions: AM12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL, Express and LAN
AM9 for SQL, Express and LAN
AM8 for LAN

Modules: AR, BR

Q: I discovered that I posted a payment to the wrong customer. The payment has been deposited to the bank and it has been reconciled. How can I correct our records?

A: You must void the incorrect payment. When you void the payment, AccountMate will ask you whether the payment has been recorded as a deposit. Click Yes to confirm. Selecting Yes will trigger AccountMate to create a reversing record (showing a negative amount) for which you must record a deposit. Once the deposit has been recorded, the negative amount will be displayed in bank reconciliation to offset the previous reconciliation. You must also post the correct payment; then, record a deposit for the payment.

■ ■ ■

Versions: AM 12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL and Express
AM9 for SQL and Express

Module: SM

TIP: You can bookmark Online Help topics by adding them to the Favorites tab. To do this, perform the following:

  1. Access the Online Help topic that you want to bookmark (e.g., AccountMate Function/Hot Keys).
  2. Go to the Favorites tab.
  3. Click Add. You should see the section listed under Topics.

■ ■ ■

Versions: AM 12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL, Express, and LAN
AM9 for SQL, Express, and LAN
AM8 for LAN

Module: PO

Q: How can I configure the Receive Goods function to allow receipts of units more than the purchase order quantity?

A: The Received Goods function allows you to receive more units than the purchase order quantity with no setup required.

The message, “Receive Quantity > Order Quantity” is displayed when you enter a Rec Qty that is more than the B.O. Qty in the Receive Goods function. To continue, click the OK button in the message dialog box; then, click Save.

■ ■ ■

Versions: AM 12 for SQL and Express
AM11 for SQL and Express
AM10 for SQL, Express, and LAN
AM9 for SQL, Express, and LAN
AM8 for LAN

Module: IC

Q: I know that you can assign serial numbers on items using the Specific ID or Avg with S/N cost method. What is the difference between these two cost methods?

A: Specific ID: Serial numbers must be pre-assigned before you can ship or invoice an item. Each unit has an assigned cost.

Avg with S/N: Serial numbers are not pre-assigned. The serial numbers are entered at the time of shipment or when creating the invoice. All units are assigned with either the average cost or standard cost.

Subscription Information

If you or someone else in your office would like to automatically receive our NewsLine in your inbox each month, please email