Madics - Product News

Tracking and Paying Customer Rebates

If your business has requirements to offer customers rebates based on achieving turnover objectives, then look no further then our latest development.

This package is designed to help you track and pay any customer rebates you refund back based on the customers turnover.

For further details please download the "CUSTOMER REBATE" PDF in the documents section of this website.

Support Team

17/02/2010

Data Grids - How they can Assist In MADICS

For the past few months Madics has been busy developing and integrating DATA GRIDS into our standard software.

What are Data Grids?
Well the easiest way to think of them is like having your data displayed in a spreadsheet.

We all know the convenience of being able to Sort or to Move columns around the screen to change the screen layout in a spreadsheet. Column widths can also be stretched or squeezed and colour can also used to highlight specific items that match certain criteria.

Depending on the individual Grid, options to print the grid or export it to a CSV file are a mouse click away, and right click brings up a list of options, including an option to re-set the columns back to the default layout.

Where can I find some of the Data Grids in MADICS?

Bill of Materials
We introduced Data Grids earlier this year in the BOM suite, allowing you to display an exploded BOM assembly and offering sub-component detail expansion by simply clicking on a sub-assembly.

Right Mouse Click offers a variety of options, from displaying all occurrences of where the component or sub-assembly is used through to checking physical stock, or displaying stock documentation of the item, and print option.
We also provided a quick and visual way of marking items within the assembly as “Discontinued” by simply clicking on a check box with the mouse, once checked the line turns pale red indicating it has been marked on the Stock Master File as a discontinued item.

This is an example of a Data Grid display as used in Bill of Materials

Dart Example 1

Columns may be moved or in some instances sorted to present your data in different ways, the use of colours helps to quickly identify key points of the data being displayed.

Sales Order Management
Manual Stock Allocations has a Data Grid option. The grid can be sorted by any of the final column names to present your data in different ways, perhaps by customer, or allocation priority flag etc.

Projected Stock is also available in a Grid, although because of the nature of projected stock, it is not practical to sort by columns in this grid. Columns however can be moved if desired, and again a print option is available with a right click of the mouse.

Purchase Order Management
Supplier Returns has been greatly enhanced through the use of a number of Data Grids, this package has incorporated a lot of new features to enhance the user view of their data.
Colour is used to identify the status of the return, with returns showing in RED where action is still needed. The Grid Columns in this module can either be sorted or moved to meet your own requirements.

Future Enhancements
Madics will continue to develop the use of Data Grids as we review each package, however if you feel you have a specific requirement for your company, please call us to discuss your needs.

Data Grids require the ATE emulator on your PC.

Support Team

16/02/2010

Data Analysis and Reporting Tool (DART for MADICS)

MADICS DART (Data Analysis Reporting Tool) is used to provide you with detailed analysis of your Madics Data either in a graphical chart format or in a table format.

Sample Pie Chart of Sales by Area

Dart Example 1

Order / Credit Details in Table Format

Dart Example 2

Dart allows you quickly highlight important trends in your data and then to be able to “Drill Down” into those areas for further investigation.

Dart is a multi-user tool, that can be used by employees and management alike due to a comprehensive security level that restricts access and manipulation down to your own requirements.

For more information please download the DART Brochure.

Dominic Fitzpatrick

30/10/2008

Does your system cope with stock supplied to order?

David Carter, a highly respected industry consultant in the area of ERP software has commented on accountingweb.co.uk that “packages like Opera II, Exchequer, Sage MMS simply give a lump figure for Free Stock which can be very misleading” and goes on to explain how many software packages do not go far enough in the area of Stock Control.

The issue is one of providing the user with stock figures that reflect not just whether there is a problem today, but also whether there may be a problem in the future. When supplying from stock for immediate delivery, most systems that actually allocated the stock will be able to show you the current stock availability position. It should be noted however that many of the smaller systems don’t even do the allocation, so the stock can be “stolen” by other orders.

The issue that David Carter highlighted is that many larger systems cannot cope when the stock is bought to order and will simply show a misleading negative stock position, e.g. Sales Order demand for 10, Purchase Order placed for 10 (receipt due in time to satisfy the Sales Order Required Date, but not yet received), thus available stock is shown as minus 10.

With MADICS the Projected Stock position will show the user all future stock movements in chronological order with a clear indication of what the real position is. The user is also shown all the items that can be changed, that is they are beyond the lead time for that product/supplier combination and those that can’t, because they occur before the lead time of the product.

In the example above the real position is that there is NOT a problem, because the confirmed delivery date on the Purchase Order is before the despatch date required on the Sales Order to achieve the Required Delivery Date for the customer. The Projected Stock is thus zero, not minus 10. Here the required delivery date is THE key field, not the available stock today.

Michael

15/10/2008

How often do you update your stock buying levels?

We have noticed that with the excitement of getting a new software system (!), most organisations update all of their stock buying levels (maximum, minimum, target, safety, economic order quantity etc) so that the automated purchasing reports work perfectly for them. However it seems that for many organisations this is either a one-off exercise or something that is reviewed at best once a year. MADICS Inventory Management is a tool that does this hard work for you, or if it can’t it will tell you why.

Based upon the highly acclaimed Distribution Inventory Management by Gordon Graham the software takes the hard work out of reviewing and if necessary recalculating and updating your stock levels. Where the pattern of stock usage, whether for sales or incorporation into another product, is outside the set parameters (for example dominant customer or exceptionally high or low usage in a period), the levels will not be updated until you have reviewed the exceptions and chosen to amend, accept or monitor the situation.

Michael

15/10/2008

Subscribe to feed