Tracking Items That Come Back: The Need for Accuracy in Service and Returns

To stay competitive, virtually every company needs to process customer returns. As today’s customers demand a more specialized level of service, tracking and resolving these returns can be an increasing challenge. With the SIMMS Service and Returns Module, the RMA (Return Merchandise Authorization) process handles returns and replacements with ease. You can handle every return with one flexible solution.

Does your customer want credit, a replacement, a substitution or a repair? The SIMMS Service and Returns Module feature makes it easy to handle all of this—and when a customer has an urgent replacement need, RMA even lets you easily create a cross-shipment entry. This gives you an accurate record of items shipped before returns are received, and one more opportunity to build complete customer satisfaction. This module creates a new level of integration for maximum efficiency.

With the SIMMS Service and Returns Module, you can easily print receiving documents to alert warehouse personnel of pending returns. After the goods are received and inspected, they can be returned to inventory, identified as items for repair, or scrapped. Then, SIMMS automatically generates all the appropriate transactions, including replacement orders, purchase orders, and vendor returns. This complete end-to-end solution saves many hours of data entry and eliminates the need to search through file drawers for supporting historical documents.

The RMA inquiry feature makes it easy to determine the status of a return whether or not it has been received. And the Return Reason Report shows you which items have been returned, who is returning them, and the reason why so that you can quickly identify possible problems.

Master your service and returns with the SIMMS Service and Returns Module.

Start Your Setup Right with Company Details

SIMMS Inventory Management software, through its Company Manager feature, allows users to get their company information entered into the system quickly and easily. The contact address and phone information becomes the header data on all the built-in reports for the user’s company. Additionally, if the company has a logo, it can be placed in the center of the SIMMS main screen; in either bitmap (BMP) or Joint Photographic Experts Group (JPEG) format, the image contents become embedded directly into the company database along with other recurring data.

Owing to the importance of the database that supports SIMMS, regularly-scheduled backups of the database is advised — one a day if many transactions are processed, once a week if a slow but steady stream of orders, transfers, purchases and/or sales. If one uses the version of SQL Express that comes with the SIMMS program, then manual backups should be performed by users’ IT department but also may be conducted by those statused with administrator logins within SIMMS. If a full version of SQL Server (versions 2000, 2005 or 2008) is installed on the user’s system, automatic backups of the database(s) can be scheduled to take place.

The SIMMS Company Manager screen (found under the Administration dropdown menu) is the interface used for all databases to be manually performed, or, if necessary, where backups can be restored should any problems have occurred (such as the failure of the system’s harddrive). Current backups permit the restoration process to be done with little loss of new entries. Backups older than a month, however, can restore only the most recent data and transactions performed up to the moment the backup was performed. SIMMS Company Manager is a stable and reliable feature that keeps you both up-to-date and secure.

Reorder Points Save You Money

The accurate calculation of reorder points is often what keeps one business’ effectiveness ahead of its competitors, and SIMMS Inventory Management software can help them do it. As previously mentioned, many firms choose to only apply an 80% Service Level in-house because of higher ratings already in place at their suppliers. Service Levels, when reduced by formula to a z-value, can be more easily factored into the formula that calculates reorder points.

The standard formula for arriving at reorder points is as follows:

Reorder Point = (Average Lead Time x Average Demand) + Optimal Safety Stock Level

The previously mentioned z-value (if the 80% Service Level was chosen) is 0.84, and is directly featured in the calculation of Optimal Safety Stock Level. The formula for this is as follows:

Optimal Safety Stock Level = z * ?(ALT * SDD² + AD² * SDLT²)

where ALT is Average Lead Time, SDD is Standard Deviation of Demand, AD is Average Demand and SDLT is Standard Deviation of Lead Time.

Stock Management Versatility — Your Future Needs Answered Today

SIMMS Inventory Management software provides users with a wide open range of possibilities for growing their businesses while maintaining a sound inventory structure and applying industry-imposed accounting practices. The wide array of requirements in many businesses leave little room for standard inventory software to comply, but SIMMS permits a great degree of latitude to its users, and allows for growth and expansion on many fronts.

As the science of electronic data collection has grown to incorporate better interface techniques and newer operating systems, SIMMS has kept pace with this evolving and efficient method of stock keeping. The Internet itself has continued to expand and enhance the immediate delivery of information and services to its patrons, and the methods of communication and mass data storage has required software packages to keep in step with this growing volume of real-time interchange. SIMMS also has enhanced its speed and accuracy to allow not only speedier entry of information but of its rapid retrieval as well.

When new methods of sales and supply come onto the horizon, SIMMS will continue to grow and expand to provide service to its users, and this single focus will remain its primary goal through innovation and practical ease of use. It is through this link to its users that SIMMS will remain the choice for small to medium businesses everywhere for their inventory and accounting needs. Let SIMMS help you gain the lead and stay there.

Contact KCSI today here to learn more.

ToolTip: Printing a Physical Count Worksheet

Our ToolTip today comes from KCSI Technical Writer Will Heigh:

Printing a Physical Count Worksheet

The Physical Count Worksheet is the checklist used to make a comparison with actual physical counts and the stock counts for items currently stored in SIMMS. It allows you to make notes of counts during the actual physical counts and then you make adjustments to the SIMMS counts for the items based upon the notes you have made.

To print a Physical Count Worksheet:

1. On the Inventory menu, point to Physical Count, and then click Physical Count Worksheet.

NOTE: If you want to produce a Physical Count Worksheet that includes items’ Manufacturer’s Lots, on the Inventory menu, point to Physical Count, and then click Physical Count Worksheet w/ Manufacturer Lot. This version of the report also permits filtering results by category, as well as offering the ability to include the items’ serial numbers on the report.

The Physical Count Worksheet options window opens.

Figure 1: Physical Count Worksheet options window

The options and filters for the worksheet inc lude:

– Select all inventory locations or pinpoint only one by selecting it from the Warehouse option box and also selecting a single warehouse Bin Code (or leaving the check box selected to include them all).

– Select all categories of items in the system, or pinpoint only one by selecting it from the Category options box, and selecting any subcategories of your choice.

– Group the worksheet by category (if desired).

– Print options include on-hand counts, inclusion of Zero Stock items (those with no current on-hand counts), item reorder points (set in each separate location), items currently reserved (manually set aside), items on hold (items set aside by virtue of being on open sales orders), item costs, item prices, items’ default vendors, as well as printing the worksheet with blank space added on the final page (for manual entry of notes or totals) and including a blank line after each separate item (throughout the report).

2. Click Generate.

The Physical Count Worksheet appears.

Stock Tracking with Manufacturer Lots

SIMMS’ Manufacturer Lot Tracking allows for the smooth assignment of lot numbers to goods received into stock, and the same ease in generating lot numbers for items created through the SIMMS Work Order and/or Kitting (BOM) process.

Lot numbers can reflect the date and project information for their usage. Lot costs and weights can also be assigned, permitting accurate shipping data when the time comes to supply your customers. Details required for requirements for governmental and client standards. Tracking is easy from the levels of raw materials through finished products, as each stage can display which lots have been used in each step, whether for quality compliance or historical reference.

When used in combination with SIMMS’ customizable serialization features, you will always know where every piece is and its resultant use and location, down to any user-assigned attributes the pieces may possess. The ease of item issue of multiple lots or one single lot has never been easier, and receipts using the same criteria is simple and comprehensive. Combined with robust reporting capabilities, the details you need to be able to find makes SIMMS’ Manufacturer Lot Tracking the best choice on the market.

KCSI Releases SIMMS version 7.3.9

November 19, 2010 – Kornyk Computer Solutions International (K CSI) today released version 7.3.9 of its flagship software suite, SIMMS Inventory Management software. With expanded processes and enhanced features, SIMMS remains one of the best and most comprehensive inventory management packages on the market today.

To begin to take advantage of the features of SIMMS today, contact KCSI by clicking here.

SIMMS’ Command Center: The Item Manager

SIMMS’ Item Manager features represent the leading edge of inventory management on the market today. From the use of item numbers or SKU number assignment to tracking of weights, valuation, warranties, depreciation, specific customers and vendors and their costs and prices and much more, SIMMS is the software you need. Whether tracking stock counts in unlimited locations and/or their assignment of default values with extensive details, stock management has never been so comprehensive yet so simple at the same time.

Categories of items and their respective sub-categories make for easy reporting and analysis of which stock sells and which stock does not. The assignment of images to each item enables SIMMS users to produce catalogs of their stock for ready use of their customers. Items can be entered into SIMMS with their weights and multiple units of measure, streamlining the immediate details pertaining to shipping data, storage capacities as well as sales and purchase information.

Purchase and sales records and reports allow for the analysis of best- and worst-selling items, how much stock is sitting still in warehouses and not being sold. Note tabs permit an item-by-item information flow so that both purchasing and sales departments can know precisely how much is being spent — and received — at both the vendor and customer level. All this data and much more is created and subsequently mananged by SIMMS’ comprehensive Item Manager features.

SIMMS’ SQL Assistant Is a Prime Tool for Efficiency

SIMMS Inventory Management software features a useful tool for administrators to access the SQL (Structured Query Language) database that holds the company’s data — The SQL Assistant.
Whether running up-to-date fixes provided by the SIMMS support department (service packs) or perhaps only to display the content and structure of the various tables in the database — most often done to provide the information to display data onto customized reports — the SQL Assistant is a valued aspect of a SIMMS administrator’s understanding and mastery of the overall software solution.

Administrators can, with the help of the SIMMS  Support Department, be given command lines in SQL that can be entered and run within the SQL Assistant screen to either access data or to make improvements or to reset features within the system. Complete and specific instructions are provided, and often times, a self-contained SQL format file is sent so that it only need be run to apply its changes.

In the SQL Assistant, users can run lines to check which users are currently logged into the system in case a system backup is pending, thus letting the administrator the names of those who will need to exit the system for this valuable security process.

Additionally, Administrators can make global changes to the status of stock within the system, such as changing items’ current location and move them to another just by running a couple of lines of SQL code. Changing items’ categories or subcategories can be just as easy, saving the administrator — or some other authorized user — a lot of manual data entry time. When run safely and wisely, the SQL Assistant makes quick and easy work of the job of managing the contents and accuracy of company data within SIMMS Inventory Management system.