ERP Consulting, Software & Services for Small & Midsized Businesses | Blog

Mastering the Art of Reporting - Part Three

Written by Vision33 | Mon, Mar 11, 2013 @ 04:47 PM

 

For our final post of our three part summary of the Mastering the Art of Reporting webinar, hosted by Small to midsized enterprise (SME) expert Carl Lewis, we focused on reports beneficial to a Controller in a company, in this case, looking specifically at inventory and parameters surrounding it depending on the level of information required.

Reporting for Controllers

Accessed from the Finance cockpit, you can launch several different types of reports within SAP Business One that are beneficial to a controller and go beyond a standard accounting software system.

The first is an Inventory Analysis Report that enables you to select different parameters, and then narrow it down by parameters such as by warehouse. In an Inventory Analysis Report, all of the items are listed along with their descriptions, and it is possible to see what’s committed on sales orders, committed to production orders, and equivocally what’s been ordered on Purchase Orders, and Production Orders, and what’s available.

From here, SAP Business One enables you to drill into an item directly. By selecting an item, you can take a look at the available and promised inventory. It can also give you a running total of what’s available each day, based on production orders that are posting to the system, and other documents, like deliveries, and receipts for a deeper level of analysis.

To take the data a step further, by delving into an Inventory Status report and viewing it by warehouse results in higher level of detail, which provides additional information on last receipt data, the last date it was issued, the item price, and the total value of that item in inventory.

The most detailed report in the entire system however, that captures every transaction including; what the item was, where it went, and how much it cost, and much more is the Inventory Audit Report. By selecting the entire year, you can see all of the transactions including things like AP invoice, an AR invoice, and receipts. Every single transaction is visible, and because the document that created it was captured, you can expand the document itself. You can go directly to the journal entry that was created from the transaction, so you can access all of that detail very quickly with the Inventory Audit report and find out exactly what happened, and when it occurred.

If you would like to see more examples of how standard reports appear within the context of SAP Business One, for any of the three scenarios we have discusssed including; a Controller,  Purchasing agent, or Sales manager, then watch the full  pre-recorded webinar below. Out-of-the box, SAP Business One provides managers and other decision makers in your organization with valuable reporting that provides insight into your business with accurate data that you can use to inform better decision making and provide greater transparency across your business.