×

Reports Menu

 
The majority of ShopPAK reports are located on the  Reports  menu:
 
Reports Menu
 
Many ShopPAK reports have already been covered in previous chapters.  For example, Job specific reports are explained in "Jobs Form".  This chapter focuses on reports that are not covered elsewhere in the User’s Guide. 
 
Many job costing and tracking reports require a specific security access privilege before a user is allowed to generate the report.  Others will simply omit privileged information if the user has inadequate security access privileges.  See "Security" for information on defining Employee security profiles.
 
1

Jobs Reports

 
ShopPAK produces a number of job cost and tracking reports.  These reports alert you to potential problems and bottlenecks, and give you the necessary information to keep jobs on target and within budget.  The jobs listed on a report depend on how broad or narrow you set your report filter criteria when generating the report.
 
As more and more jobs are run through ShopPAK, you build up a repository of historical data that can be invaluable for analyzing profitability and productivity, as well as, spotting trends.  Armed with this intelligence, you’ll make informed decisions regarding new equipment investment, process improvements, and work center efficiency.
 
1. Jobs Reports
Reports Menu
1

Margin Summary

1. Margin Summary
2

Dept Percent of Price Summary

2. Dept Percent of Price Summary
3

Production Schedule

3. Production Schedule
The job production schedule reports allow you to sequence the report by a number of dates including Scheduled Start, Scheduled Finish, Target Finish, Ship and Request By.  The report calculates ‘Days Left’ so you can easily see if you are on target or slipping.
 
4

Job WIP / Billing Analysis

4. Job WIP / Billing Analysis
5

Job Cost Analysis

5. Job Cost Analysis
6

Labor Hours

6. Labor Hours
7

Total Job Costs

7. Total Job Costs
There are 5 report menu options within Total Job Costs:
 
 
These reports give total costs, as of the date you run the report.
 
8

Periodic Jobs Costs

8. Periodic Jobs Costs
There are 3 report menu options within Periodic Job Costs:
 
 
These reports give you a subset of job costs based on the report selection.
 
9

Open Job Analysis

9. Open Job Analysis
There are 6 report menu options within Open Job Analysis:
 
 
These reports give you total costs and tracking information as of the date you run the report.
 
10

Materials Past Due

10. Materials Past Due
11

Transmittals

11. Transmittals
12

RFIs

12. RFIs
2

Job Items Reports

2. Job Items Reports
Reports Menu
1

Orders

1. Orders
2

Job Item Listing

2. Job Item Listing
3

Costs

3. Costs
Generates an extract file that can be opened in Excel for further analysis and printing.
3

Work Order Reports

3. Work Order Reports
Reports Menu
1

Work Order Reference List

1. Work Order Reference List
2

Rework

2. Rework
3

Production Schedule

3. Production Schedule
The work order production schedule reports allow you to sequence the report by a number of dates including Scheduled Start or Finish, Target Start or Finish, Ship, Material Due and Request By.  The report calculates ‘Days Left’ so you can easily see if you are on target or slipping.
 
4

Zero Percent Billed Work Orders

4. Zero Percent Billed Work Orders
5

Change Order

5. Change Order
4

Products Reports

4. Products Reports
Reports Menu
1

Product Status

1. Product Status
2

Product Job Costs

2. Product Job Costs
5

Department/Operations Reports

5. Department/Operations Reports
ShopPAK lets you gather job cost information at the departmental level, and if you wish, down to the operation level.  Gathering department and operation data helps you pinpoint production bottlenecks, inefficiencies, and hidden costs. 
 
Collecting at the department and/or operation level is particularly helpful in tuning your ProjectPAK assemblies and estimates so they more accurately predict actual engineering, fabrication and installation costs.
 
Reports Menu
1

Department / Operation Code List

1. Department / Operation Code List
2

Operation Code List

2. Operation Code List
3

Actuals

3. Actuals
4

Operation Status

4. Operation Status
5

Operation Exceptions

5. Operation Exceptions
6

Department Production Schedule

6. Department Production Schedule
6

Employees Reports

6. Employees Reports
ShopPAK captures Time and Attendance and Job Cost information as employees log time against jobs.  Reports allow you to gauge individual productivity, spot trends, and capture payroll information.
 
Reports Menu
1

Labor Actuals - Daily

1. Labor Actuals - Daily
2

Time and Attendance - Daily

2. Time and Attendance - Daily
3

Labor Variance - Daily

3. Labor Variance - Daily
4

Labor Detail

4. Labor Detail
5

Employee Action Items

5. Employee Action Items
6

Milestones & Submittals

6. Milestones & Submittals
7

Employee ID List

7. Employee ID List
8

Time Card Labor Actuals

8. Time Card Labor Actuals
9

Employee Labels

9. Employee Labels
<TODO>: Insert description text here...
7

Purchase Orders Reports

7. Purchase Orders Reports
ShopPAK totally integrates Purchasing, Inventory, Job Costing, Receiving and Invoice Reconciliation.  It produces a number of reports that help you manage this critical function. 
 
Reports Menu
1

PO Summary Reports

1. PO Summary Reports
Six summary reports are available with these specific sorts:
 
    
 
     An example of the ‘by Job’ summary report is shown below….
2

Open PO by Vendor

2. Open PO by Vendor
3

Open PO Detail by Vendor

3. Open PO Detail by Vendor
4

Active PO by Vendor

4. Active PO by Vendor
5

Back Ordered Items

5. Back Ordered Items
6

PO by Vendor

6. PO by Vendor
7

PO Items Past Due

7. PO Items Past Due
8

Vendor Due Date Performance

8. Vendor Due Date Performance
9

PO Receiver Details

9. PO Receiver Details
8

Billing Reports

8. Billing Reports
ShopPAK offers seamless integration between Shipping and Invoicing.  It produces a number of documents and reports that help manage these critical functions. 
 
Note, under the Jobs report menu item, there are two very useful job oriented billing analysis reports:
 
  • Job WIP / Billing Analysis
  • Job Cost Analysis
 
See Jobs Reports in this chapter for details on the above reports.
 
          Reports Menu
1

Billing Summary

1. Billing Summary
The first report is shown with no details.  The second report is shown with details.
 
 
2

Sales Tax

2. Sales Tax
 
3

Job Billing Status

3. Job Billing Status
 
9

Shipping Reports

9. Shipping Reports
The first report is shown with no details.  The second report is shown with details.
 
 
10

Inventory Reports

10. Inventory Reports
ShopPAK’s inventory system is entirely transaction driven, which gives you the ability to analyze any aspect of it.  For example, you can see when and who purchased, reserved, received, used, and returned inventory, and how many units were involved.  You can easily determine inventory on-order and on-hand counts for your entire inventory, or any sub-group or individual item of inventory.  Moreover, you can generate reports that tally asset valuation based on how you’ve defined your inventory valuation method à Weighted Average, FIFO, LIFO, or by individual unit.
 
Reports Menu
1

Item List

1. Item List
2

Reorder Point List

2. Reorder Point List
3

Inventory Code List

3. Inventory Code List
4

Inventory Transaction Report

4. Inventory Transaction Report
5

Inventory Reservation Report

5. Inventory Reservation Report
6

Material Card Actuals

6. Material Card Actuals
7

Inventory Purchases

7. Inventory Purchases
 
11

Accounting Reports

11. Accounting Reports
Reports Menu
1

General Ledger Reports

1. General Ledger Reports
ShopPAK generates a number of accounting GL oriented reports.  These reports break out Work in Progress (WIP), Cost of Goods Sold (COGS), and Use Tax.  Because these reports need to read and process low level transactions, and there can be tens of thousands of them, a report can take several minutes to generate.  So we don’t tie up ShopPAK’s main window while generating reports, we launch a separate program that actually handles report generation.
 
 
Accounting reports are driven by Job Item or Work Order COGS Code settings. Please see WIP and COGS Reporting for further details.
 
You can generate several reports at the same time.  All reports are written as PDF files and placed in the target folder you choose.  While the reports are being processed, the GL Accounting Reports program logs status messages:
 
 
 
Cost of Goods Sold
 
 
Cost of Goods Sold
 
 
Work In Process – Detail
 
Use Tax Analysis
2

Applied Overhead

2. Applied Overhead
The Applied Overhead report shows applied overhead costs by cost type for a particular date range.  Use it to better understand what your overhead costs are when analyzing future overhead burden absorption percentages and rates.
 
    
 
12

Where-Used

12. Where-Used
The Where Used Report is a powerful utility to find where an item (using either description or code) is being referenced throughout ShopPAK………. and even ProjectPAK.
 
 
Filter By
Choose ‘Description’ or ‘Code’.  Tells ShopPAK to either search on corresponding code or description fields.  Enter either the entire character string, or partial character string, you want to search by.
Sort By
Tells ShopPAK to either order generated report on code or description.
Library
Tells ShopPAK to search the ProjectPAK Library for a match on the input description or code string.
Assembly/Estimate Detail Rows
Tells ShopPAK to search ProjectPAK Assembly and Estimate grid items for a match on the input description or code string.
Assemblies
Tells ShopPAK to search ProjectPAK Assemblies for a match on the input description or code string.
Projects
Tells ShopPAK to search ProjectPAK Projects for a match on the input description or code string.
Products
Tells ShopPAK to search ShopPAK Products for a match on the input description or code string.
Inventory
Tells ShopPAK to search Inventory for a match on the input description or code string.
Purchasing
Tells ShopPAK to search Purchase Order Items for a match on the input description or code string.
Shipping
Tells ShopPAK to search Ship Ticket Items for a match on the input description or code string.
Billing
Tells ShopPAK to search Regular Billing Items for a match on the input description or code string.
 
13

Material Labels

13. Material Labels
Printing material labels is a two step process.  First, labels are generated from either PO Builder, Purchasing, Receiving, or Inventory tabs.  Second, they are printed via the  Reports | Materials Labels  menu item.  Selecting the menu item displays a dialog box that you use to find the labels you wish to print.  The reason we separate label generation from printing is because it allows you to batch labels together to print at one time.  This is often more convenient and allows you to use label media more efficiently than immediately printing labels upon generation.
 
Filter
Several filters are available to pinpoint the labels you wish to print:
 
 
Select the filter, provide filtering target value(s), and then click the ‘Run Filter’ button.  ShopPAK fills the print grid with generated labels that match your filtering selection.
 
 
Un-check print flag after printing
Tells ShopPAK to un-check print flag after printing.
Grid Print Label CheckBox
Tells ShopPAK which labels you want printed when you click the OK Button.
Delete Rows Button
The dialog not only controls material label printing.  It also controls deleting generated labels.  It is a good ideas to delete generated labels after you print them so you don’t have printed labels in your material label print queue.
 
Material Label Size and Format
You have several options for label size and formatting.  See "Setup and Options" for details on setting up material label defaults.  Your defaults flow into the print setup dialog box.  If you wish, you can override label size and format.
 
 
 
 
After you print the labels, ShopPAK displays a message box asking if the labels printed OK.
 
 
If they did, click Yes,  ShopPAK automatically un-checks the rows you marked to be printed.  If they didn’t print OK, say ‘No’.  ShopPAK will not un-check the rows you requested for printing so you can fix the printer problem and then try printing again.
 
Deleting Labels
 
If you want to delete generated labels from you material label queue, refer to "ShopPAK Tools".
14

Inventory Labels

14. Inventory Labels
ShopPAK prints Inventory labels if you want to bar code actual materials or bin locations.  Since we give users the option of scanning barcodes when doing ‘picks’ and ‘returns’ against inventory, ShopPAK gives you an easy way of generating inventory item bar coded labels.  (Note, ShopPAK also produces bar coded inventory ‘pick lists’ via the Jobs tab reporting function).
 
When you select the menu item to print inventory labels, ShopPAK first displays the label dialog box:
 
    
 
Tell ShopPAK which label media you want to use.  Next, ShopPAK displays a dialog so you can pinpoint which inventory labels you want to produce.  Use the filter and sort controls to generate only the labels you want to print.