Home
Debtors
Creditors
Company
Jobcards
Operators
Cash Book
Quotations
Departments 
Transactions 
Bill of Materials 
Purchase Orders 
Control, Security 
Price list, Support
How do I ?
Reports
Options
Hardware
 
 

Very comprehensive inventory system
with multi warehouse facility,
to keep good control of parts.

Product pricing linked to customer.
Special price per item, link to customer.
Maximum discount level per product.

Unlimited Alternative part numbers

Movement per month over 36 months.
Reset Reorder Points, Order quantity,
according to factors, lead time, value.

Ability to duplicate record,
Integral Bill of Material, linked in
to product list. Bill of materials can
also be a stock item for sale.
Costing, average, current, list cost.
 

View outstanding orders against item.

Print product label, barcode, bin number.

Full stocktaking system, also update
pricing, re order point, on warehouses.

Memo pad for extended description.
Use integral markup system for
price setting, against different costs.

Gross profit per product visble throughout.
Price adjustment system,
based on supplier, category.

Copy record to other company.


Screen shot. [Colors, fonts, text and Icons, User configurable].
 

List options The product list. Go to top of page
Use F5 To add a product or stock card.
Use F6 to access the product record, and edit items like description, prices, etc.
Use F8 To delete an unwanted product. You will only be able to delete a code which has no stock. If you re-use a deleted code, all the history will be returned to this code, as transaction records are never deleted. It is actually better not to delete a product.

Stock card

Go to top of page

The inventory or product list can contain as many items as you want, and they do not have to be "stock" items. We use this list to prevent repetitive typing of commonly used items, and "items normally kept in stock" are identified by having a Reorder Point set. Labour items, linked to the internal labour code, can also be in this list, and are shown as such by the & sign.
Code or part number 14 digit alpha-numeric code. Fast search inventory for this item.
Alternative code, 2 direct link to alternative part number. Fast search inventory for this item.
Alternative code, 3 direct link to alternative part number .Fast search inventory for this item.
Description 40 digit description. Fast search inventory for this description.
Unit Multi-pack designation. Leave blank or 1 if sold as single units, but "24" for instance, will let you use multiple quantity, while use basic pack value for costs.
Supplier Link to supplier code, for selective ordering, reporting or pricing.
Department Category for this item. Fast search inventory for this department. Also used for selective reporting and pricing.
Bin number Warehouse shelf location.
Stock quantity Quantity on hand, and will, optionally, allow negative stock values. This happens when you sell the item before it is put in stock. Reporting option to filter on negatives.
Stock quantity, 2, / Factor / available Used as weight factor in FMCG mode, to bring unit quantities to kg basis.
Tax type Tax to be added, exempted or inclusive of tax.
Tax level Up to 8 different tax levels.
Average cost This is a weighted average cost of the stock on hand, which is the true cost. Calculation is done on bringing new stock in. Calculated as ((old_qty*old_av.cost)+(buy_qty*new_cost)) / (old_qty+new_qty)
Current cost This is the latest cost that you paid, put in at purchase automatically.
Date The date of the last purchase.
List cost List cost is a reference cost, usually used in the steel industry, but can be a general supplier price list cost.
Sales price, 1 The normal standard sales price, and, if linked to customer record, will be used for sales pr.1
Date The date when this price was entered, either by you, or by a purchase that has option set to update sales price.
Sales price, 2 The second sales price, and, if linked to customer record, will be used for sales pr.2.
Sales price, 3 The third sales price, and, if linked to customer record, will be used for sales pr.3.
Markup Sales prices can be marked up from each cost price. The standard markup is entered on Internal, Company Deatails. Use Ctrl+F6 to change selection.
Maximum discount A zero here will allow unlimited discount, but any other figure will prevent higher discounts going unnoticed at point of sale. If you want to give no discount, enter 0.01 here.
Order below The quantity (less 1) at which you wish a new order to be generated, when asking for goods to be ordered from the system. If there are already outstanding orders, which together with stock on hand, are more than this figure, a new order will not be generated.
Order How many to order when an order is generated.
On order Goods already ordered, but not received, if the option "put on backorder" is used while generating the order.
Sales, latest The latest date on which this item was sold.
Alt If "1", this item is linked to multiple alternative part numbers.
Sales quantity, year to date Sales quantity, year to date
Sales quantity, last year Sales quantity, last year
Sales value, year to date Sales value, year to date
Sales value, last year Sales value, last year
Purchases quantity, year to date Purchases quantity, year to date
Purchases quantity, last year Purchases quantity, last year
Purchases value, year to date Purchases value, year to date
Purchases value, last year. Purchases value, last year.

Screen shot.....
 

Alternative items

Go to top of page

Many part numbers are supplied by different suppliers with alternative part numbers. This program allows you to have unlimited alternatives, which are doubly linked, where you do not need to keep the alternative number in your inventory, but if you type it in, it will be cross referred to where you can choose the number that YOU use. The alternative table will show whether the number is an inventory item, or not, and, if so, will show you supplier, price and stock quantity. You can directly return to the chosen item in inventory. Any new item that you link to any other item, will immediately give you a list of all possible alternatives, which you can amend as you wish.
Item code. This code does NOT have to be in the product list.
Other number The alternative number, which also does not have to be in the product list.
Description.  
Supplier  
Date  
Cost from this supplier.
Discount given by this supplier.

Stocktaking.

Go to top of page

To check inventory against a physical count, or use this system to update other inventory information.
Load the stocktake file Press ctrl+F7 while in the product file. The stocktake file is a temporary file that is made from the inventory records, and we work on this temporary file until satisfied, when the inventory file can be updated automatically from this stocktake file. The loading options screen has three lists, for suppliers, departments, and bin numbers.These all default to "All", but in options, below, you can select for each. You can have a cross selection of items.
Options in the loading
  • You can choose to load all items, or only items with quantities, both plus and minus.
  • You can choose to load only items from certain suppliers. Tab to select the supplier section, press F5 to add suppliers.
  • You can choose to load items for only certain departments. Tab to select the deapartment section, press F5 to add departments.
  • You can choose to load items from only certain bin locations. Tab to select the bin number section, press F5 to add bin numbers.

The default "All" will act on all items. If the file has already been loaded and you are back in this section, you can ask the program to search for all suppliers, departments, and bin numbers, and itemise these in the respective lists. Right click, and select Search for ? whatever.

Press F4 to either load the stocktake file, or go back to it if already loaded. You can get back to this section from the stocktake file, with the insert key.

Work on the stocktake file This is the list of items you are going to work on. Check the options above, which can help you bring this list to what you want. From here, you can :
  • Print count lists, in three different sort orders.
  • Print a stock valuation, prior to counting,
  • Amend counted figures against inventory quantities, F2. This will allow you to enter a quantity in the "amend" column, press enter, which will move you to the next item, ready for quantity again. You should do all editing with the screen sort order in the same sequence as the count sheets, and you will find it extremely fast to enter the count sheets.
  • Enter new selling prices, F6
  • Enter new current costs from a supplier. F7
  • Enter reorder points, ctrl +F2
  • Enter economic order quantities, ctrl +F3
  • Print descrepancy lists
  • Print a new stock valuation list after updating the quantities in inventory.

You can go in and out of this file at will, as long as you do not act on "Delete All", which will clear the whole file, without updating the inventory records. You can delete records from this file, as well as import others from inventory. See below.

Options in the stocktake file
  • You can choose to hide items with a nil stock quantity, ctrl+E
  • You can import individual line items from the inventory file, F5
  • You can import items for a specific supplier into this temporary file,ctrl+A. Remember that you may not see these imported items if the option on suppliers is not set to "All". Press the insert key to check.
  • You can import items for a specific department into this temporary file, ctrl+B. Remember that you may not see these imported items if the option on departments is not set to "All". Press the insert key to check.
  • You can import items for a specific bin number into this temporary file, ctrl+C. Remember that you may not see these imported items if the option on bin numbers is not set to "All". Press the insert key to check.
  • You can select whether to print one line item per 1,2 or 3 lines on the count sheets, ctrl +L
  • You can select in which of three sort orders to view and print this file. (Tab key). We suggest you set the option for Reports, (Local Options) "View report on screen" to yes. This will prevent printing in a format that is not what you want (you may have forgotten to set the sort order) before you are ready.
  • Print Count sheets, ctrl+P. If the list is in bin number order, the count sheet will show the average cost, otherwise these count sheets are blank except for code, description, and bin number.
  • Print stock valuation, ctrl+Q. This will print off the temporary file, so if you have done any transactions which affect the stock file proper, these will not be reflected here, and will be overwritten when the main file is updated off this temporary one.
  • Print a descrepancy list off this list, once the counting has been done. ctrl +R
Updating the main inventory file. You should only press F4 when you are ready to update the main inventory file, and after printing descrepancy lists if doing a stocktake. The format that you have been working in, i.e. amending quantities, or setting prices, will be the default for update on the next screen. Make sure when going through, that you check this, as it would be counter productive to reset stock quantities (all to zero) if you have been working on sales prices, etc. You will get a final warning, before the program updates the main product file, and at the same time, it will reset the figure in the stocktake file to the amended figures. There will be NO record left of the original situation in the product file, after this step, though for stock quantities that have changed, there will be a record added against each stock item, reflecting the change.
Clearing the temporary file. This can be done at any time, from either the selection screen, or from the stocktaking list, and deleting the file will do just that, clear it. No updating will take place. You must update as described in the section above, first.

Go to top of page