The Product - Reporting and Access to Information
Access to Information
JIWA provides the required information when and where you want it
through customisable, flexible pop-ups and a comprehensive drill-down
capability. Some real-life
reporting examples include:
- Customer Sales History
Some JIWA users have this information automatically "pop-up" when certain
groups of customers purchase an item that they have never purchased before. Others
have this information pop-up by clicking a button.
 |
| Example: Customer Sales History pop-up |
Please note: Information within these pop-ups is fully flexible and each
column may be individually sorted.
Also, the number of days history can be overwritten on-the-fly.”
- Product Sales History
Here is another pop-up that a customer uses when sales orders are entered. It details the instances of a particular
company purchasing a particular item. Some JIWA customers have this "pop-up" in the bottom
right of their screen as they enter sales orders just so that they can quickly
check the price that they previously gave a customer.
 |
| Example: Product Sales History pop-up |
Like all areas of JIWA, double-clicking allows users to drill-down to more information,
even from within these "pop-ups".
Furthermore, JIWA has been designed so questions like:
- When will I get my order?
- When will you get stock of that item?
- What should I order?
- What stock do we have in other warehouses?
... are answered quickly and completely.
Powerful Searching
Whether you have
thousands of inventory items, customers or suppliers, JIWA's powerful searching
facilities make it easy to find
the information you need. JIWA enables you to search upon as many fields within
the system as required, at the same time, using "starting with", "starting
from" and / or "containing" capabilities. You are also able to
make one entry in a search screen and JIWA can search on multiple or all fields
in a particular area at the same time.
Reporting - Microsoft Excel
JIWA offers the ability to use Microsoft Excel Pivot Tables to analyse data
contained in JIWA without being constrained by Microsoft Excel's limitations.
These limitations include Excel's slow processing speed, especially on large amounts
of data, and data capacity, there are only 65536 rows and 215 columns in an Excel
spreadsheet.
JIWA overcomes these by utilising Microsoft SQL Server. This powerful facility is extremely easy to use, especially for ad-hoc
reporting. Information in areas such as: debtor balances; general ledger; sales;
stock on hand; may be quickly and easily dragged-and-dropped in order to obtain
the required information.
Information within these Microsoft Excel Pivot tables may be viewed by day, by
month, by quarter, by year or over a number of periods.
Information may also be easily presented colourfully and graphically.
Reporting - Crystal
All standard reports and stationary layouts (such as invoice layouts, etc.) have
been built using the worldwide standard in business reporting, Crystal Reports. This provides JIWA with huge amounts of flexibility. If one
of the 300 standard reports does not suit a JIWA user, an existing report may
be tailored to suit or a new report may be designed from scratch.
As Crystal Reports is also used for stationary layouts, customers and suppliers
need not notice any difference when you change to JIWA.
JIWA Financials is supplied with a Crystal Reports runtime licence, so users do not need to
buy Crystal Reports to run JIWA reports.
Open Database Compliant (ODBC)
Due to the JIWA database being Microsoft SQL Server and therefore ODBC, as well
as using the standard facilities detailed above (Crystal Reports, Microsoft Excel,
and JIWA forms/screen) to access information, a plethora of other tools may the
used such as: Microsoft Word for performing direct mail merges; Microsoft Access
for performing ad hoc database queries; or the range of other report writers in
the market.
Next page: Read
about Inventory Control...
