Current Inventory List by Facility

Totals Only

False or True

False

True = This will only print Inventory Grand Totals

False = This will print each Part Record Selected and give line level information as well as a Grand Total Section at the end of the report

Facility

Equal To

Not Equal To

Less Than

Less Than or Equal To

Greater Than

Greater Than or Equal To

Starts With

Not Starts With

Ends With

Does Not End With

Contains

Does Not Contain

Is Between

Is Not Between

Is One Of

Is Not One Of

1 - 99999

Equal to Facility 1

Based on what condition option you select you can Include individual Facility Number or Numbers, and Ranges.

Or

You can exclude individual Facility Number or Numbers, and Ranges.

Part Number

Equal To

Not Equal To

Less Than

Less Than or Equal To

Greater Than

Greater Than or Equal To

Starts With

Not Starts With

Ends With

Does Not End With

Contains

Does Not Contain

Is Between

Is Not Between

Is One Of

Is Not One Of

First to Last Part Numbers in the System

<Blank> to zzzzzzz

Equates to First to Last

Based on what condition option you select you can Include individual Part Number or Numbers, and Ranges.

Or

You can exclude individual Part Number or Numbers, and Ranges.

1

Part Number

This is the Main Part Number found in the Parts Master List (See Parts List Link:)

1

Account Number

If using GL Account Codes this is the assigned Account number from the Parts File (See Link:)

2

Xref Number

This is the Primary Vendors Part Number assigned to the Part Record (See Link:)

2

Reorder Pt

This is the Reorder Trigger Point Threshold found in the Details Section of the Part Record (See Link:)

3

Description

This is the main Part Description assigned to the Part Record (See Link:)

3

Reorder QTY

This is the Reorder Quantity Amount found in the Details Section of the Part Record (See Link:)

4

BO QTY

This is a Back Order Amount. This gets updated from a Back Order Purchase Order to the the Part Record (See Link:)

5

QTY OO

This is a On Order Amount. This gets updated from a Current Purchase Order that still has parts on order and this is updated to the the Part Record (See Link:)

6

Last PO Number

This is the last Purchase Order Number this part was purchased on. This gets updated to the Part Record automatically. (See Link:)

7

Vendor

This is the Primary Vendor assigned to the Part Record (See Link:)

7

Last PO Date

This is the last Purchase Order Receive Date this part was purchased on. This gets updated to the Part Record automatically. (See Link:)

8

Markup

This is the Markup Percent assigned to the Part Record (See Link:)

8

Selling Price

This is the Part Selling Price found in the Part Record (Computed: Average Price or FIFO Price X the Markup Percent) (See Link:)

9

Order Price

This is the last Purchase Price for this part. This gets updated to the Part Record automatically. (See Link:)

Missing the Average Price Field????? I put in a Feedback Ticket FEED-4299

9

Ship Days

This is the Average Ship Days data which is found in the Master Part Record under the Inventory > Ordering Section (See Link:)

10

On Hand

This is the Total On Hand Quantity found in the Part Record (This includes all Stocking Areas added) (See Link:)

10

Total Cost

This is the Calculated Total Cost for each part based on Total On Hand Quantity Times Average Price

Parts Printed

This is the Total Number of parts counted with in the report (adding the On Hand Quantity for each Part).

Part (Type)

This is the Total Cost for all the parts with a Part Type assignment of Parts from the Parts File (See Link:)

Tire (Type)

This is the Total Cost for all the parts with a Tire Type assignment of Parts from the Parts File (See Link:)

Oil (Type)

This is the Total Cost for all the parts with a Oil Type assignment of Parts from the Parts File (See Link:)

ATF (Type)

This is the Total Cost for all the parts with a ATF Type assignment of Parts from the Parts File (See Link:)

Antifreeze (Type)

This is the Total Cost for all the parts with a Antifreeze Type assignment of Parts from the Parts File (See Link:)

Hyd Fluid (Type)

This is the Total Cost for all the parts with a Hydraulic Fluid Type assignment of Parts from the Parts File (See Link:)

Gear Oil (Type)

This is the Total Cost for all the parts with a Gear Oil Type assignment of Parts from the Parts File (See Link:)

Core (Type)

This is the Total Cost for all the parts with a Core Type assignment of Parts from the Parts File (See Link:)

Subtotal

Sub-Total Cost for all the above Part Types (Paid Parts Value)

Consignment (Type)

This is the Total Cost for all the parts with the Consignment Flag turned on in the Parts File (Parts paid in the rears) (See Link:)

Total (Grand Total)

Grand Total Cost for all of the Part Types including the Consignment (Complete Value)