Mindfire has deep experience developing Progress databases and Progress-driven applications. We describe some of these Progress database project experiences below, and will be glad to share our expertise in detail with you.
Distributions and Supply Chain Management
Progress 10.0B, Progress Database
Client's Distribution system is a complete solution for all distribution needs from Inventory Purchases to Sales to Accounting. It has been designed to fulfill almost every industry, but it did not have some features to support all the needs of the food industry, where the frequency of one complete cycle is not a month or quarter or year instead it's a WEEK or even less and where the items are stored in Lots Quantity/ Container and are sold by pieces or weight.
Meaning whatever comes into the inventory comes in huge quantities, but at the time of selling it is not being sold as a whole lot.
For example: a Fish supplier receives a 10 Lots of prawns weighing 100 pounds each, that is total of 1000 pounds, into his inventory.
Suppose a customer requires 25.5 pounds of prawns, the sales representative goes to the inventory and takes out a Lot of 1 (100 pounds) and start picking prawns from it. He then weighs it as per requirement but comes to the conclusion that he can sell either 25 pounds or 30 pounds to customer but cannot sell 25.5 pounds.
That is where we needed to modify and add a complete module to the system which hooks up the logic with standard logic of taking inventory by lot and also saving the weight of each individual piece in that lot in the system.
By doing so we are always in sync of what has come into inventory and what is going out of it. That is called 'Catch Weight' of the lot product(s).
We have designed the 'Catch Weight' system by modifying / adding more tables to the database and changing the standard business logic by adding hooks to it and changing the standard code with due permission, wherever necessary.
This is applicable to any distribution industry in which the Inventory Purchases are being made in terms of Lots / Quantity and Sales are made according to the Weight of the item, for example Food Industry.
All this has been achieved with the extensive usage of HOOK's created in Progress 10.0B.
Distribution and Supply Chain Industry
Progress 10.0B, Progress Database
The client's standard distribution system had the facility to view sales, cash, purchase, accounting and inventory value. These features were restricted to one company and separate accounts individually. Customer wanted to have an inquiry where they can easily access these dashboard details for any company (with proper user security) but for all the cash accounts based on Daily, Weekly, Quarterly, Month-to-Date and Year-to-Date status.
To have the above modification on Standard Logic we needed to create a whole new set of inquiry screens for Dash Board which in turn shows up the data for all the cash accounts, sales, purchases and inventory values along with the accounting screens based on the different criteria such as Company, Year, Divisions, Accounts and Warehouses.
The Dashboard provides managers with quick access to key information of the status of the company. The data for all the cash accounts, sales, purchases and inventory values along with the accounting screens are readily accessible without running multiple reports or going to several inquiry screens. The data in the inquiry is provided real-time based on the current data in the system, and it provides the summary information at a glance.
1. The Dashboard is accessible from within standard application – there is no delay time in downloading data from the SXe database to an outside product. You are looking at totals based on up-to-the-minute data.
2. The information is provided clearly with one screen for each module. It takes just a few seconds to see key information for each area.
3. The information is provided first in overview format, and the user can drill down for more detail.
4. Navigation follows the standard model – and is intuitive.
5. Data can be exported to Excel for flexible presentation.
6. The dashboard details can be displayed for any company (with proper user security,) for all the cash accounts. The inquiry can be done based on Daily, Weekly, Quarterly, Month-to-Date, Year-to-Date, One Year Ago Today, This Week Last Year, MTD Last Year, QTD Last Year, YTD Last Year status.
The Dashboard has multiple Views to provide inquiry for the status of different areas of your business. The Dashboard provides for the following Views:
3. SO Comparison
6. Inventory Value
The Dashboard displays data based on calendar year or fiscal year depending on your setting in Administrative Options of the Standard Application.
There are also controls on the banner to allow you to limit the data that is included in each View. The data can be limited by Company, Year, Display, Division, Cash Accounts, and Warehouse.
Drill Down Data
In general, when using the Dashboard you can right-click on any numeric field. A menu is display which allows you to "drill down" to detail level. The browser shows the supporting data that was used to obtain the total number in the field.
Whenever you drill down to the detail level, a browser displays with the supporting data that makes up the total amount displayed. As with all browsers in the Dashboard module, you can right click and get the following menu using which columns can be adjusted, moved, resized, and the data can be sorted. You can also export the data to Excel for ease of presentation and manipulation. Select the desired transactions. You can use the mouse to Select All option in the right-click menu. Then select Load Excel from the right-click menu. Excel will automatically display with the data imported.
Below are the 6 different main sections of dashboard:
1. Cash View:
The Cash view displays all activity for Cash Accounts. An account is defined as Cash based on its report group. This view displays Cash Accounts' balances, receipts, disbursements and Other charges along with the calculated Current Cash Balance.
2. Sales Comparison View
The Sales Order Comparison View compares sales for the last 12 periods from the current year to the previous year.
3. Sales View
The Sales View shows both the Booked Sales and Invoiced Sales made for the Display Period Selected. It also shows the totals for Cash Receipts and Backlog Value.
4. Purchase Screen
The Purchase View shows both the entered and invoiced purchase orders.
5. Accounting Screen
The Accounting View shows overviews of Accounts Receivable and Accounts Payable status.
6. Inventory Screen
The Inventory Value View shows the total inventory value of each warehouse selected. It totals the quantity on hand, multiplied by the cost of each product based on the selection. The cost used is be based on the Administrative Options settings.
In general every view listed above has all the related / minute details which helps managers to see up-to-date data along with the drill down details of each piece of information displayed on the screens.