|
| |
INVENTORY CONTROL SYSTEM
Our Inventory Control System (ICS) was one of the first products
that we developed beginning in 1984-5. In the early days was very basic but then, so were
all the other packages of the day. Over the years, it has evolved to what it is today.
Currently it consists of over 400 master and subroutine programs.
In keeping with our philosophy of "simple and fast", the main menu of the
package is made up of 4 items.
Our master inventory menu has evolved
from one that simply points to other menus to being a full blown menu of all processes
that are handled by inventory control staff from buying to receiving etc. It
combines all the standard main file control as well as daily transaction, reporting and
links to other pertinent routines as might be used by this department. We suggest
that you take a look at our HELP files to get a feel for the enormity of this module.
Some of the options on this menu include:
- Add a new item (SKU, PART NUMBER, ITEM.ID...however you want to refer
to it.
- Edit an item... Allows full or restricted editing of any item depending
on user password.
- Delete and item.... Access to this one is usually given to your most
- Change ID...If you happen to enter some product information with the
wrong SKU, you can change it easily using this.
- Merge items.... Have you ever ended up with two part numbers for the
same item and wished they were one ? Well this is for you. It merges all stock movement
history, sales figures etc.
This menu allows you to do all your daily routines mostly for batch mode processing.
- Daily Sales.. no longer used, because this is done through POS
- Daily Returns.. no longer used, because this is done through POS
- Receive Goods.. Update your stock with items coming in.
- Transfer Stock.. From one warehouse to another, or one location to
another.
- Stock Adjust IN... Once in a while you have to add an item back to
stock if it shows up in your warehouse.
- Stock Adjust OUT... Sometimes and item will disappear and you have to
adjust your stock
- Batch Enter Goods on Order... Lets you manually track goods on order if
you don't have a Purchase Order System in place.
- Out for Repair... You send items back to manufacturer for repair. This
tracks those items
- Back from Repair... You get them back.
- Batch Goods in Reserve... Lets you manually track Back Ordered goods to
your customers. This is the invoice that is written against incoming normal stock.
Choosing this item presents you with a menu for preparing various reports:
- Daily Sales Report
- Goods Received Report
- Daily Customer Returns (or can be combined to be included as negative sales in your
daily sales report.
- Transfer Goods Report
- Repairs Movement Report.
- Goods Ordered Report
- Stock Adjust Report
You can also add a number of customized reports to this menu. There is usually room for
about 18 reports on one menu. Any more and it becomes cluttered.
These are the reports that you request to built specifically for your business. Most of
them can be produced very reasonably. Once you have found that you are using a custom
report on a regular basis, it can be moved to the Standard Report Menu.
This menu contains various routines that will change parameters to modify the way your
program presents itself to your operators. A few of these utilities are outlined below.
- Enter Master Company Information
This routine is common to all
Modules. This is the one that lets you enter your company name, address, phone numbers
etc. It is this information that will appear at the head of all reports, customer
statements etc. You only have to do this once per system.
- Update Legitimate Whse
This one lets you add new warehouse (store)
designations to your system. A two character code is required here. Although is is nice to
code your stores with something meaningful, you actually have 1296 possible combinations
if you use standard alpha characters and the 10 numeric digits (36 X 36).
- Update Product Codes
All items can be categorized by a product code,
a 6 digit (numbers or alpha) code. This utility lets you enter legitimate codes along with
descriptions of the code etc. Information produced by this utility prevents operators from
entering wrong product code information.
- Update Vendor Codes
All items have a vendor code (12 character) associated with them to designate who they
are purchased from. This utility allows you to specify proper code, name, address, phone
numbers etc of vendor to prevent wrong vendor codes from being entered by operators.
- Update Factors
This one is still evolving, but to date, the key into
the file is a combination of the product code and vendor code. Information includes
factors for landed cost, msl, your selling price, sale prices and others. By utilizing
this information, you need only enter the "invoice" price of an inventory item
as a base price and all other calculated amount fields are automatically completed.
- Update Pricing by Factors
There is a routine that allows you to
update certain fields in your inventory files in a batch mode. For example, if you wanted
to increase your selling price of a complete product line by 2%, you would simply use the
"Update Factors" routine to change the factor for retail of "product code *
Vendor Code" by 2%. You would then run this routine, again specifying the product
line, and all pricing would be changed.
- Many others.....
Many other programs are resident in the utilities
menu, and the list keeps growing from customer requests. Again, please see our Help
files.
KEY BENEFITS:
- EASE OF USE....Our current clients do not use an operating manual. The
program is very intuitive to use. When the program is first used, you will receive
preliminary instructions and once you begin using it, you will wonder how anything so
simple can do so much. We find that a new installation generates about 4 or 5 phone calls
of inquiry to us in the first month of use, a couple the second month, and then hardly
ever a call after this period.
|
Grendata Computer Systems