Inventory Control Reports

This function works similar to a dashboard and will save you hours upon hours of time compiling data. You can look at your “Business Condition” for General Ledger, Accounts Receivable, Accounts Payable, Sales (Point of Sale and Order Entry) and Inventory with the click of a few buttons.

Each module provides different information along with charts and graphs, giving you options to select the specific information you are looking for. It will save your settings from the last time you entered so you don’t have to set it up every time. Unless, of course, you are looking for different data.

There is no doubt that this feature will save you time and provide you with information critical to your organization. Here’s a list of highlights of the information you can find on these reports and useful for taking to the bank.

Print the financial data based on a period or date range along with a graph of the total net income/loss per period for the current fiscal year.

shows a complete list of all stock items in inventory. It displays the following information: stock number, item description, product type, and stock location. You can also choose to print last cost and quantity on hand.

Choose the information you want included on your labels and print them for a single stock number, a range of stock numbers, or all stock numbers.

We have added more reports and enhancements to the custom reports menu that we started with the Version 11 release. With Version 12 you no longer have to worry about overwriting your custom reports during upgrades etc. You can now easily separate the custom reports from the originals by saving them elsewhere on your computer. In addition you now have the ability to create multiple custom reports, save them, and still keep the original. The Dated Invoice/Payment, GL Expense Distribution and History reports are now accessible from the custom reports menu.

Found in: AP, AR, GL, IN, and PO
What a timesaver! This is a continuation of a feature we started in version 11 by providing you with a "Search For" option on many reports. Well, now with Version 12 we have created additional queries and improved functionality for the Dated Invoice/Payment and History reports.

This system-wide report allows you to see what effect the posting will have on your General Ledger accounts prior to the actual posting. This provides you with real-time information you need so that you actually see what your balances will be once you've posted and what you can expect - income, expenses, overall cashflow.

If any errors are found during posting, then this report will print the validation errors instead of the account impact which is very helpful if you have a large number of transactions to post.

shows all information from the Master file for the selected stock items. It has variable sorting ability and can be printed for a single stock item, a range of stock items, all stock items, and for one or all Inventory Codes.

Generate this report prior to performing an inventory count. Space is provided on the report to write in the actual physical inventory and for noting any discrepancies between physical and computer counts for later adjustments. For each stock item selected, this report lists the following information: inventory code, stock number, item description, product type, stock location, and unit package. You can also choose to print last cost and quantity on hand.

shows both the quantity on hand and the various pricing breaks for each inventory item. This report shows only retail pricing breaks and is often provided to customers as a pricing reference. The report includes: stock number, item description, vendor, product type, location (only available if multi-location inventory installed), and pricing type.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

This report provides cost and quantity information about all inventory on hand. If this report is run with detail, each purchase of inventory and the associated cost is presented. This report is useful when adjusting inventory levels after taking a physical inventory. It is also useful for reconciling your General Ledger. The On Hand detail report shows the following for each item selected: stock number, item description, stock location, last order date, quantity on order, quantity on hand, detail serial number, date, cost, and quantity. You can also choose to print detail, last cost, and skip zero quantity.

The Stock Value Report reads the cost and quantity for each stock item and gives a total dollar amount of inventory for a particular period. The Condensed report shows the totals for each item, while the Detailed report contains a separate line for each purchase of each item, detailing how many of each item are on hand at each cost. The Stock Value Report shows the following for each selected item: stock number, item description, product type, location, date, on hand quantity, unit package, method, weighted/average cost, and value. You can also choose to print: last cost, and skip zero quantity.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

shows minimum acceptable levels of inventory and the required quantities needed to return inventory to the predetermined levels. This report is considered an exceptions report to management, indicating inventory items that are not being replenished often enough. The Understock Report includes the following detail for each stock item: stock number, item description, understock quantity, stock location, vendor, vendor's stock number, product type, alternate stock number, interchangeable stock number, quantity on order, and minimum quantity. You can also choose to print: last cost, quantity on hand, quantity committed, and vendor's stock number.

Select Advanced Understock for the report type to monitor which stock items need to be replenished along with the total sold of each item in 5-, 30-, and 60-day increments. The Inventory Advanced Understock Report includes the following detail for each stock item: stock number, item description, understock quantity, stock location, vendor, product type, quantity on order, minimum quantity, last cost, quantity on hand, quantity committed, and quantity sold in the last 15, 30, and 60 days.

shows maximum acceptable levels of inventory and the quantity by which an inventory item exceeds this level. This report is considered an exceptions report, indicating inventory items that are moving slower than expected. The report includes: stock number, item description, overstock quantity, vendor, product type, stock location, alternate stock number, interchangeable stock number, quantity on order, and maximum quantity.

includes those items that have quantities in the On Order box of the item Master Record. The On Order Report shows the following information for each included stock item: stock number, item description, vendor, product type, location, quantity on order, and date of last order.

The Back Order Report includes those items that have quantities in the Back Order box of the stock item master record. The Back Order Report can be sorted by stock number, description, or product type. It includes the following: stock number, item description, product type, vendor, stock location, quantity on order, and quantity on back order. You can also choose to print last cost, and quantity on hand.

shows a brief history of each stock item you carry. This report includes the following: stock number, item description (includes transaction description, serial number, and ending serial number), product type, quantity on hand (includes quantity, cost, and price), and multi-pack (if Specialty Shop is installed).

provides an indication of how fast inventory items are selling. The movement is presented as a percentage, calculated as the number of items sold over the sum of inventory on hand and purchased during the period. It is sorted by percentage. The Movement Report shows the following for each item: stock number, item description, product type, location, beginning quantity, quantity bought, quantity sold, quantity on hand, and movement percent.

When you run a promotion, it's important to know if it was successful. You need to know what was sold at regular prices, what was discounted, and how many were sold at different prices. The Promotional Sales Report is the tool you need to evaluate your special sales promotions. The report tracks promotional sales data that is posted according to the Promotional Codes you set up. The Promotional Sales Report shows the following for a selected promotion code or range of promotion codes, or for a range of stock items, departments, salespersons, inventory codes, or product types over a promotion date range: promotion code, sale dates, stock items sold and quantity, promotion price and extended price, gross sales, free/discounted items, and net sales. You can run this report in either a detailed or condensed format depending on what you want to see.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

This report is important in that it will show errors with your data files. You may want to run this report whenever you find a discrepancy in your on-hand quantities; whether the quantities vary between reports, lookups and reports, or between any two places in the system where the numbers do not match. The Control Report shows the following for a selected inventory code or for all inventory codes: total number of items on hand, or the book value of each of those items. Report totals are calculated for both values and are shown at the bottom of the report. You can specify which vendors to include in the report by selecting a range of vendors.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

Kits allow you to group inventory items - and the ability to create kits allows you to streamline your inventory management process. The ability to quickly view your kits and closely monitor them is an added benefit. With the Master Kit Report in Inventory, you can quickly view the current cost and quantity requirements for any or all kits set up in the system.

Click the Report Window Thumbnail to see the options available for tailoring the report for your needs.		Click the Sample Report Thumbnail to see an example of a report that you can run.

You can now Reindex all files from the main menu. What a time saver! You no longer have to go into each module and reindex them individually. To make this feature even better you can tie it into the Automatic Backup feature. You can set the system backup to reindex prior to doing the backup. If you use the advanced options you can even stop the backup if errors are found in the reindex. A full Run Log is provided so you will know exactly where the problem is.

Have you ever accidentally posted a check for the right day but the wrong year? In previous versions we allowed you to block postings to prior periods by setting this block. In Version 12 we have enhanced this feature to also block future periods from posting.

This allows you the option of blocking all postings in all modules for a specific period(s) within the fiscal calendar. You will receive an error message if you attempt to post a transaction that is outside of the date block range, i.e. posting to 2008 instead of 2007.

Found in: IN, OE, and POS
AP Check Register Report now includes the posting reference numbers for easier tracking.

Now after you post tranasctions to Accounts Payable, you can track the module, reference number, transaction number, and batch number for every transaction. This might be beneficial, for example, if there is an error in a transaction and you want to track it back to the individual who posted it.