JERE V. HORWITZ & ASSOCIATES, INC.
Distribution/400
Custom Manufacturing/400



Distribution/400 is specifically designed for the IBM AS/400 and is written in RPG/400 utilizing the advanced features of that language and the native database structure of the OS/400 operating system. The application is a straight forward, menu driven approach to order entry, basic inventory control, invoicing, sales analysis, and accounts receivable for finished goods distribution.

The system includes basic on-line help screens and menus that are easy to follow and keep track of the last step used by the operator. Automatic crucial database backups and journalizing is incorporated in the CL as necessary. The system is designed to be user driven, and the source code is straight forward for easy maintenance.

The Distribution System includes:

The Order Entry Module includes these features:

  1. Master order processing to allow consolidated picking and/or invoicing.
  2. Kit processing to allow an item to relieve component items from inventory.
  3. Copy features to allow easy duplication of the same order to multiple ship-to locations.
  4. Matrix pricing at list less discount or net.
  5. Automatic sales tax assessment and calculation.
  6. Back order processing.
  7. Automatic credit checking.
  8. Fast "product code - quantity" entry.
  9. Miscellaneous charges and order comment support.
  10. Special charges and C.O.D. tracking.
  11. Pick list generation by user controlled sequence.
  12. Simple invoice release processing.
  13. Complete order status, customer search, item status inquiries and reporting.
  14. Business day cut-off so that order processing may be continuous during posting.


The Inventory Control Module includes:

  1. Detailed audit trail of all transactions affecting movement by day.
  2. Complete physical count sub-system.
  3. Multiple warehouse and location abilities.
  4. Easy interface to scanning systems because of simple transaction record oriented design.
  5. Movement analysis and projection of future requirements.
  6. Multiple units of measure.
  7. Minimum, maximum tracking.
  8. Average costing and standard costing.
  9. Complete stock status reports and screen inquiries.

The Invoicing Module includes:

  1. Invoice consolidation for multiple orders.
  2. Presentation of prices in two ways -net or discounted.
  3. Easily customized print program.
  4. Automatic interface to A/R, inventory, and sales analysis.
  5. Gross profit and sales promotion tracking.
  6. Automatic inclusion of handling charges.

The Sales Analysis Module includes:

  1. Different detail levels based on customer.
  2. Analysis of orders/invoices based on type, value, customer class, profit, state, territory, region, and sales representative for three years by quarter.
  3. Analysis of items based on quantities, sales value, profit, and number of orders for three years by quarter.
  4. Customer analysis by purchases, credits, and number of orders for two years.
  5. Detail kept on-line for user specified time period.

The Accounts Receivable Module includes:

  1. True open-item receivable.
  2. Full screen payment entry by customer.
  3. Cash discount and freight discount handling.
  4. Easily handles unapplied cash.
  5. True cash receipts system.
  6. Accurate handling of returned checks.
  7. Automatic finance charges.
  8. Average days to pay display.
  9. Cycle statements.


The Custom Manufacturing System includes:

The Job Costing Module includes:

  1. Up to 99 sub-assembly jobs can be linked to a single designated job.
  2. The cost of finished goods will reflect all sub-level costs.
  3. Nine sub-component jobs can be linked to the 99 sub-assembly jobs.
  4. Listings show the linkage of jobs in production.
  5. Users can review jobs prior to closing and all linked sub-assembly jobs must be closed prior to closing the designated job for the end product.


The Bill of Materials Module includes:

  1. Supports materials, labor, and outside services.
  2. Listings can be printed by selected bill of material cost to standard inventory cost.
  3. Cost variance reporting compares the actual bill of material cost to standard inventory cost.
  4. As jobs are released into production, a Quantity-in-Process report, operations routing, and control sheets are automatically generated.
  5. Duplicate routing sheets can be reprinted if lost.
  6. A jobs bill of material can be copied or adjusted prior to release.
  7. Jobs currently in production can be changed with the addition or deletion of materials or operations.


The Material Requisitions Module includes:

  1. Requisitions can be released in their entirety or line by line.
  2. The Outstanding Requisitions report identifies potential problems in a timely manner.
  3. The Material Requisitions Status report assists in tracking the quantities required, released, and backordered, including costs.
  4. Backorders and cancellation of materials is supported.

Return