Report Options

The Report Options screens allows you to customize certain report options before running the selected report.

The Report Options screens can be accessed from the Selection tab by clicking on the Run Reports button.

The reports covered in this section are:

• Labels Report

• Inventory Report

• Inventory by Bin Report

• Availability Report

• OFC Reclass Impact Report

Labels Report

This option produces part labels.

The fields on the Printing Details section on the Report Options - Labels screen are:

Printing Details
Field	Description
Label Type	Select whether to print a Part label or a label for the Bin Location of the part.
Print label for each quantity	Select the print labels for each quantity checkbox to print parts labels for each quantity of part included.

The fields on the Include on Label section on the Report Options - Labels screen are:

Include on Label
Field	Description
Barcode	Whether to include a barcode on the printed label.
Part Number	Whether to include a part number on the printed label.
Description	Whether to include a part description on the printed label.
Price	Whether to include the parts price on the printed label.
Bin Location	Whether to include the parts bin location on the printed label.

The field on the Select Labels section on the Report Options - Labels screen are:

Field	Description
Printer	Select a printer that will print the parts labels.

Use these buttons to complete your work on the Report Options - Labels screens:

Button	Function
Run Report	Runs the parts labels report.
Close	Closes the Report Options screen without running the parts label report and returns to the Selection tab.

Inventory Report

Runs the inventory summary report, which acts as an inventory balancing report. This option produces a report showing the current parts inventory dollar value. The report can be run whenever there is a price increase/decrease in order to determine the impact of the price changes on your inventory values. Since all parts costing is posted to the G/L at average cost, a price change has no impact on the general ledger parts inventory account balances.

The fields on the Report Options section on the Report Options - Inventory Summary screen are:

Field	Description
Select Report Type	Select an inventory report type from on the drop down list. Summary—prints only totals. Detail—prints every part making up each total.
Select Sort Order	Select the sort order for the information on the generated report.
Select on Hand Type	Select inventory on hand type: either net on hand or current on hand quantity which includes any allocated parts. The report should agree with the bin counts at the time the report is printed, regardless of whether a sales order billing run has just been run or not.
Include Negative Quantity	Select the checkbox if you wish to include negative inventory quantities on the generated report.

The fields on the Select Printer section on the Report Options - Inventory Summary screen are:

Field	Description
Printer	Select a printer that will print the selected report or label.
or PDF	Select whether or not you would like to create a PDF file of the report, which can be viewed via the PDF Viewer.

The reports produced when running a Part Inventory report are:

WPSPR02B	Parts Inventory Summary
WPSPR04A	Parts Inventory Details

Use these buttons to complete your work on the Report Options - Inventory Summary screen:

Button	Function
Run Report	Runs the parts inventory report.
Close	Closes the Report Options screen without running the parts inventory report and returns to the Selection tab.

The calculations for the Inventory reports are: 

On Hand Quantity

When the On Hand Type is Use Current On Hand Quantity, then the value of On Hand (PMOH) is used.

When the On Hand Type is Use Net On Hand: 

Equation			Notes
Net On Hand	=		The Parts Profile on hand value.
		On Hand	PMOH which is the same as the Parts Profile inventory.
	-	Quantity Allocated	PMQA
	-	Quantity Reserved	PMQR

Average Cost

When average cost is less then or equal to zero:

Equation			Notes
Average Cost	=
		Cost	PMNET
	÷	Parts Per Package	PMPPK
	*
		On Hand	See On Hand Quantity.

When average cost is greater than zero:

Equation			Notes
New Average Cost	=
		Old Average Cost	PMAVN
	÷	Parts Per Package	PMPPK
	*
		On Hand	See On Hand Quantity.

Current Cost

Equation			Notes
Current Cost	=
	÷	Cost	PMNET
		Parts Per Package	PMPPK
	*
		On Hand	See On Hand Quantity.

Sell Cost

When Price Increase Code is Blank or 'L', then the percentage is applied to the list price:

Sell Cost = ((Price * Price Increase Percentage)/Parts Per Package))* On Hand

Equation			Notes
Sell Cost	=
		Price	PMPRC
	*	Price Increase Percentage	PMPIP
	÷
		Parts per Package	PMPPK
	*
		On Hand	See On Hand Quantity.

When Price Increase Code is 'N', then the percentage is applied to the net price:

Sell Cost = ((Cost*Price Increase Percentage)/Parts Per Package))* On Hand

Equation			Notes
Sell Cost	=
		Cost	PMNET
	*	Price Increase Percentage	PMPIP
	÷
		Parts per Package	PMPPK
	*
		On Hand	See On Hand Quantity.

Inventory by Bin Report

This option produces a report listing parts in order by bin. The report is used for the year end physical inventory count or for cyclical counts throughout the year. The report can be printed for all bins or selected bins only.

The fields on the Report Options - Inventory by Bin screen are:

Field	Description
Printer	Select a printer that will print the parts inventory by bin report.
or PDF	Select whether or not you would like to create a PDF file of the parts inventory by bin report, which can be viewed via the PDF Viewer.

The report produced when running a Parts Inventory by Bin report is:

WPSPR02D

Inventory by Bin

Use these buttons to complete your work on the Report Options - Inventory by Bin screen:

Button	Function
Run Report	Runs the parts inventory by bin report.
Close	Closes the Report Options screen without running the parts inventory by bin report and returns to the Selection tab.

Availability Report

Runs the availability report, which includes parts pricing, bin location and on hand quantity. This option produces an availability report, often referred to as a counter pad. The report is normally used as a hard copy reference when the computer is not running.

The field on the Report Options - Availability screen:

Field

Description

Select Desired Pricing Option

Select the pricing option you wish to display on the parts availability report (e.g. sell, list, cost, Landed Cost The Landed Cost of a part is the final cost of the part on an order after all applicable Order Creation and Order Update cost code factors have been applied to the Current Cost of the part. Cost factors are applied when the part is ordered and receipted into the system based on the order Type (eg. SO: Stock Order, MD: Machine Down, FI: Fill In, etc.) The Landed Cost of a part will, in turn, be factored into the Average Cost of a part (as specified in the Average Cost field of the Parts Profile tab.) For details regarding cost code logic, please see the Cost Code Logic topic in the FAQs and Troubleshooting section of the online help. For details regarding the Average Cost of a part, please see the Average Cost definition in the Glossary section of the online help. or Average Cost The average cost is automatically updated whenever parts are receipted in the system (either through inventory adjustments or parts orders). When a part is returned, the system uses the Average cost to return that part to Inventory. To calculate Average Cost, assume a part is added to the system with a cost of $10.00 and 2 parts are receipted. The average cost is $10.00 for each of these 2 parts. Now assume the cost increases to $12.00 later in the year and 1 additional part is receipted after that cost has increased. The new average cost is calculated as follows: (Old Avg Cost x Old on Hand) + (New Cost x Number of Parts Receipted at New Cost) / Old on Hand + Number of Parts Receipted OR (10.00 x 2) + (12.00 x 1) / (2 + 1) = $10.66).

The fields on the Report Options - Availability screen are:

Field	Description
Printer	Select a printer that will print the parts availability report.
or PDF	Select whether or not you would like to create a PDF file of the parts availability report, which can be viewed via the PDF Viewer.

The report produced when running a Part Availability report is:

WPSPR02C

Availability Listing

Use these buttons to complete your work on the Report Options-Availability screen:

Button	Function
Run Report	Runs the parts availability report.
Close	Closes the Report Options screen without running the parts availability report and returns to the Selection tab.

OFC Reclass Impact Report

Runs the OFC reclass impact report, which is an inventory impact report allowing you to view the impact of an applied option. An OFC Reclass Impact Report can be generated showing changes of OFC codes in Parts. This report calculates the amount that would be ordered compared to the amount ordered to the old code, It also lists prices.

The field on the Report Options - OFC Reclass Impact screen is:

Field	Description
Add Parts Sold in Non Stocking Branches to Central Branch if Phase in Parameters Met	If selected, adds any parts that were sold in non-stocking locations to the central location, if the Phase-in reclass parameters are met. See OFC Reclass - Add. Only reclassed parts are printed on the report. The report prints the vendor number and the return code if selected as a reclass parameter.

The fields on the Report Options - OFC Reclass Impact screen are:

Field	Description
Printer	Select a printer that will print the parts OFC Reclass Impact report.
or PDF	Select whether or not you would like to create a PDF file of the parts OFC Reclass Impact report, which can be viewed via the PDF Viewer.

The report produced when running an OFC Reclass Impact report is:

WPSPR02E

OFC Reclass Impact Report

Use these buttons to complete your work on the Report Options - OFC Reclass Impact screen:

Button	Function
Run Report	Runs the parts OFC reclass impact report.
Close	Closes the Report Options screen without running the parts OFC reclass impact report and returns to the Selection tab.

Data Source: Not Applicable

Security: 831 - Parts Reports

Revision: 2025.02