111 Snead Dr. · N. Fort Myers, FL 33903

(727) 642-4677

www.mfgsysgroup.com

6/11/17

Off- the-shelf Crystal Reports

Copyright Ó 1999 - 2017

All rights reserved

The following optional off-the-shelf Crystal Report programs represent a wide variety of functions to assist in managing the day-to-day operation of your company. The programs are listed by category with a brief description of capability. One general theme is maintained throughout:

Detailed output is the complete listing of all items. (Every item on every order or part selected)

Summary output is one line per order or part number. (Sum all items on each order or part selected)

Total output is one line only containing the sum of all items. (Sum all lines on all orders or parts selected)

The cost for an individual report is $50. The cost for all reports in a group is specified with the group heading. If the complete lot of over 225 reports is purchased at one time the cost is $2,000 or about $8.88 each. All prices are in US dollars. All MAX 5.0 reports are designed in Crystal 11 format.

Sales Order Entry ($500)

  1. Booking detail Orders booked between user specified dates
  1. Booking summary Bookings summary by order number
  2. Customer list by name Customer data with sales rep assignment
  3. Customer list by sales rep
  4. Customer list by state
  5. Customer list by customer type
  6. Customer list by zip code
  7. Customers on credit hold
  8. Due to ship detail Due to ship prior to user specified date
  9. Due to ship summary Summary by order number
  10. Due to ship total
  11. Executive level price list Executive level pricing with gross margins
  12. Open order detail by customer Open orders by customer with subtotal
  13. Open order summary in weekly buckets Open orders in weekly buckets
  14. Open orders by category Open orders by category with subtotal
  15. Open orders by month Open orders in monthly buckets
  16. Open orders by part Open orders sorted by part number
  17. Open orders summary Open order summary by order number
  18. Open order total
  19. Past due customer order detail Past due customer orders detail
  20. Sales by rep detail Sorted by sales rep
  21. Sales by rep summary Summary by order number by rep
  22. Sales-issues MTD-YTD Includes last year issues and sales

Manufacturing Systems Group, LLC - Results you can depend on.

Shipped Items ($200)
  1. Cost of goods detail Cost of good sold detail from transaction history
  2. Cost of goods summary Summary by order number
  3. Late customer shipments Orders that were late in shipment
  4. Late-early customer shipments Number of days early or late
  1. Shipments by customer summary Includes freight and margins
  2. Shipments by month Shipments in monthly buckets between dates
  3. Shipments by order # detail Shipped information w/freight between dates
  4. Shipments by state summary
  5. Shipments summary Summary by order number
  6. Shipments total Single value of total shipments
  7. Shipped and not invoiced Items shipped and not yet invoiced

Inventory ($500)

  1. A B C Code Analysis Analysis of on hand, cost and ABC value
  2. Bin labels Rack bin labels
  3. Check stock vrs primary stock ID Inventory not in primary stock ID
  4. Check stock vrs primary stock ID by quantity
  5. Component part availability for parent Displays part requirements & on-hand inventory
  6. Cycle count average error summary Averages cycle count errors between dates
  7. Cycle count error detail Cycle count error list between user selected dates
  1. Cycle count worksheet Cycle count worksheet
  2. Estimated inventory turns Compute estimated inventory turns from issues
  3. Hi volume parts Usage times cost in descending order
  4. Inventory for past 3 months Inventory value for past 3 months.

(Assumes stock in only 1 stockroom)

  1. Inventory value by ABC code Computes inventory value by abc value
  2. Inventory value by GL Acct # Inventory value sorted by GL account number
  3. Inventory value by stock ID Inventory quantity, mat’l, labor and overhead by stockroom
  4. Issue by month Issues in monthly time buckets
  5. Issues in descending order Issues on descending value order (qty x cost)
  6. Loan parts from cage Temporarily loan parts worksheet
  7. Obsolete parts with on-hand stock Status 5 parts with on-hand quantities
  8. Obsolete parts Inventory with engineering status of 5 with transaction date older than user supplied date
  9. Receiving Inspection to Main Report of QC stock ready to transfer to cage
  10. Row number labels
  11. Receiving label for PN Label for existing on-hand inventory
  12. Receiving label for PO Receiving dept receiving label
  13. Safety stock and excess inventory Safety stock quantities, usage per month and excess
  14. Safety stock by buyer ID Safety stock cost by buyer ID
  15. Safety stock by planner ID
  16. Slow moving active parts Active on-hand parts older than user supplied date
  17. Stock ID by commodity code Stock room assignments by commodity code
  18. Stock ID equals NODELSTK Print new parts without stockrooms assigned


Shop Floor Control ($500)

  1. % setup cost summary Setup cost and recommend qty’s for desired % setup
  2. Defect codes Established defect codes
  3. Generic routing notes
  4. Late MF and MS orders Late shop orders > specified grace days
  5. Part Routing Notes Part routing notes for all parts
  6. Pick list by stock ID Pick list in stock ID sequence (primary only)
  7. Routings by operation description Detailed listing of routings sorted by op description
  8. Routings by OPID Detailed listing of routings sorted by OPID
  9. Routings by part number Routings sorted by part number
  10. Setup summary for SFC Setup times summary for 3 different quantities
  11. Shop order history by work center Shop order history by work center
  12. Shop order history by order number
  13. Shop order pick status Indicates picking status of open shop orders
  14. Shop orders by planner ID Manufacturing and MS orders sorted by planner ID
  15. Shop orders de-expedited Shop orders de-expedited by MRP explosion
  16. Tooling in routing Routing tooling reference list
  17. WIP by order number detail Value for each shop order with issued material
  18. Work Center Data Work Center data
  19. Work Center Schedule Sorted by work center

Purchasing ($500)

  1. Below Reorder Point Inventory below reorder point
  1. Expected receipts(NI & PO) Expected PO receipts prior to user selected date
  2. Expected PO receipts with notes
  3. Hot list List of purchased parts due before user supplied date
  4. Open PO’s by vendor name Detail list of open PO’s sorted by supplier name
  5. Part # activity Issues (last 6 months), requirements and open PO’s
  6. Part vendor data by buyer ID
  7. Part vendor data by part # List of vendor part data sorted by part number
  8. Part vendor data by vendor ID List of vendor part data sorted by vendor ID
  9. Past due non-inventory PO’s3.5 Detailed list of past due non-inventory PO’s for 3.5
  10. Past due non-inventory PO’s3.7 Detailed list of past due non-inventory PO’s for 3.7
  11. Past due PO’s Detailed list of past due PO’s sorted by supplier
  12. PO Notes3.5 PO and Part notes for version 3.5
  13. PO Notes3.7 PO and Part notes for version 3.7
  14. PO receipts PO receipts from PO receipts file
  15. Purchase price variance vrs standard Purchase price difference than standard
  16. Purchasing planned orders MRP generated planned orders for purchased items
  17. Purchasing planner action report Purchasing planner action items
  18. Requirement and supply for part Requirement and supply orders for part
  19. Unconfirmed PO’s PO’s with blank confirm field
  20. Unused PO numbers Indicates “holes” in PO numbers
  21. Vendor list by vendor ID Detail address list of suppliers
  22. Vendor performance Summary of supplier performance in time buckets
  23. Vendor update sheet Document faxed to suppliers with data for review
  24. Vendor update log Log used to track response from vendors

Alert Manager ($300)

1.  Check parts in stock ID other than primary stock ID (excludes QC & MRB)

2.  Manufactured parts without BOM after 3 days

3.  Manufactured parts without lead time after 3 days

4.  Past due manufactured shop orders after 1 day

5.  Purchase parts without cost after 3 days

6.  Purchase parts without lead time after 3 days

7.  Past due PO’s after 1 day

8.  Order delstk not equal to part delstk

9.  Order planner ID not equal to part planner ID

10.  Zero cost with on-hand quantities

Repetitive Receipts ($50)

  1. Repetitive receipts Repetitive receipts to stock between dates

Transaction History ($200)

  1. Purchase price history Summary of past purchases w/prices
  2. Ship history by month Monthly buckets sorted by sales category
  3. Transactions by part number List of transactions
  4. Transaction receipts detail Detail of all items received
  5. Transaction receipts summary


MRP ($200)

  1. Load plan hours Past due and month due quantities
  2. Manufacturing planned orders Manufacturing planned orders sorted by planner ID
  1. Order availability of components Order requirements and availability of parts
  2. Part availability of components Requirements and availability of parts for parent part
  3. Net availability and PO supply 0-15 days Net available parts and PO supply orders
  4. Part requirements and supply by week Requirements and supply order quantities

Master Scheduling ($200)

  1. Customer vrs MS orders Weekly buckets of CU and MS orders
  2. Duplicate Mfg orders for same day Identifies duplicate Mfg orders for the same day
  3. Forecast orders past due Forecast orders prior to user supplied date
  1. MS shipments by month Monthly buckets of MS shipments between dates
  2. Open MS orders detail Sorted by planner ID
  3. Open MS/FC orders summary Summary of MS orders vs. Forecast by date

Production ($300)

  1. Completed order with material short Status 4-5 order with material issued short
  2. Earned hours actual detail Actual earned hours by work center
  3. Earned hrs sum from routing receipts Earned hours from routing receipts by work center
  4. Earned hours sum from part receipts Earned hours from part receipts by planner ID
  5. Performance summary by sequence # Performance for selected operation sequence #
  6. Production variance Actual quantity completed vrs order quantity
  7. Shop order performance detail Job performance detail against standards
  1. Shop order performance summary Job performance against standard between dates
  2. Shop order traveler Large Julian due date

Costing ($200)

1.  Costed order BOM Cost for items issued to shop order

2.  Default account code assignments List of default account GL assignments

3.  Override account code assignments List of override account GL assignments

4.  Stockroom account code assignments List of stockroom account GL assignments

5.  Work GL file data Work GL file data with selection options

Audit ($500)
  1. Audit BOM structures Invalid LT offset or scrap %
  2. Audit order data All orders in system
  3. Audit part master Part number data audit
  1. Audit purchasing data Purchasing data audit
  2. Audit sales order data SOE part number audit
  3. Audit shop floor control data SFC routing audit
  4. Blank commodity code
  5. Check SOE vs. order master status Checks Sales order vrs order master status
  6. Delete Identifies items to address before deleting part
  7. F part type with on-hand stock
  8. Invalid stock ID in part master Invalid stock ID assigned to part number
  9. No BOM assigned No bill of material assigned to mfg parts
  10. No buyer ID on purchased part Blank buyer ID
  11. No manufacturing lead time Zero days for manufacturing lead time
  12. No part-vendor data No entry in part/vendor file
  13. No planner ID Planner ID blank
  14. No preferred vendor Preferred vendor blank
  15. No primary stock ID assigned Blank deliver-to stock ID
  16. No purchase cost assigned No cost for purchased parts
  17. No purchase lead time Zero days for purchasing lead time
  18. Order master status bad Order master qty = 0 and status not > 3
  19. Order planer ID not equal to part planer ID Shop order planer ID not equal part planer ID
  20. Order stock ID not equal to part stock ID Shop order stock ID not equal part stock ID
  21. Order with invalid current due date Invalid current due date on order
  22. Part type code count Count of different part types
  23. Zero cost with on-hand quantities Engineering 5 parts are not checked

Physical Inventory ($300)

  1. Auditor list of all tags All tags with disposition
  2. Inventory value Quantity and value for inventory
  3. Physical inventory worksheet Min and Max tag # sorted by stockroom
  4. Pre and post physical difference by counter Difference sorted by inventory counter
  5. Pre and post physical difference by part # Difference sorted by part number
  6. Pre and post physical difference by tag # Difference sorted by tag number
  7. Pre and post physical difference by Stock ID Difference sorted by Stock ID
  8. Pre and post physical difference Difference between pre and post inventory
  1. Print physical tags Use crystal to print the tag file in lieu of MAX
  2. Tag count of needed tags Physical inventory tag requirements
  3. Uncounted tags Uncounted (unposted) tags

Material movement ($100) (used where raw inventory is in more than one stockroom)

  1. Material pull request Material pull requirements into primary stockroom

2. Order requirements Order requirements

3.  Pull all list Complete list of items that are set up for pull feature

Configurator ($50)

  1. Configuration data Condensed list of configuration data
  2. Qualifier data Condensed list of qualifier data

Bill of Materials ($100)

  1. Component count on BOM Combined count of component requirements
  2. Single level BOM with detail BOM with detail items
  3. Single level explosion All BOM’s with single level explosion in descending low level code order

Bar Coding (requires bar-code font) ($250)

  1. Check stock vs primary stock ID-bc Check if stock not in primary stock ID
  2. Container availability Display container stock ID’s without any quantity
  3. Container stock ID labels Labels for the container stock floor
  4. Cycle count worksheet bar coded Cycle count work sheet
  5. Expected PO receipts bar coded Bar code format of expected PO receipts
  1. Kanban for manufactured items 4” by 6 label for boxed manufactured material
  2. Main stock ID labels Labels for main stock racks
  3. Pallet sheet for raw material 8’ by 11’ pallet for incoming pallets
  4. Part stock bar coded Bar coded work sheet for counting parts
  5. Rec Insp to Main bar coded Transfer sheet
  6. Receive label for Part number – bc Receive labels for part number bar coded
  7. Receive to container pallet sheet
  8. Receive label for PO – bc Receive label for PO bar coded
  9. Receive label for PO’s bar coded Label for PO receipts
  10. Receive label for part numbers Label for parts already in stock

Labor Tracking ($300)