Inventory Listing

This Help File Page was last Modified on 03/20/2020

<< Click to Display Table of Contents >>

Navigation:  Inventory Tracking & Job Costing System > Inventory Tracking Reports >

Inventory Listing

This Help File Page was last Modified on 03/20/2020

The Inventory Listing Report provides complete list of the Sale-Purchase Items which have been identified as Inventory Items - based on the choices you make (explained below).

Understanding the Cost and Value columns on the Inventory Listing Report:

The Quantities listed on this report are those that are maintained by the Inventory Tracking System as Inventory Items and are tracked as follows:

Inventory Used in Job Costing (see the Inventory and related sub-chapters in the Job Costing section of the Help Files)

Ordered (see the Purchase Orders chapter)

Purchased (see the Vendor Bills chapter)

Sold (see the Invoices chapter)

 

The Cost is the current COGS Value and represents the Unit Price (wholesale) in the Sale-Purchase Items Form for each Inventory Item listed.

The Cost of each Inventory Item that is reported is based on the currently selected Inventory Valuation Method - which should be the Average Cost of Inventory

 

The Current Value is calculated as the Cost (current COGS Value) times the Quantity On Hand.

 

Note:  The "Current Value" (the last column on the right of this report) will match the Inventory Account value on the Balance Sheet as long as your Company is using the Average Cost of Inventory - Inventory Valuation Method.

 

To access the Inventory Listing Report:

a)From the Backstage Menu System Select Reports then Choose Inventory Reports and Select the Inventory Listing option, or

b)From the Quick Access Menu, Select Reports then Choose Inventory Reports and Select the Inventory Listing option

 

HelpFilesInventoryListingReportOptions

Inventory Listing Report - Options tab

 

Options - Initially only the Options tab is shown (until you make your Options selections and Select Print).

Detail/Summary - Select whether you want a detailed or summary style Inventory Listing report.

The Summary choice will simply list the basic information for each Inventory Item.

The Detail report will, additionally, breakdown the information by Warehouse.

 

Order By - Establish the sequence the Inventory Items will be listed.

Group Code and Part Number - The default - sorts the Inventory Items by Part Group Code, then within each Part Group, by Part Number (Item ID).

Note: The Group Code refers to the "Part Group" Code that may be assigned in the Part Group field within the Inventory Info section of the Sale-Purchased Item Form.

The Part Group Code may have 1 - 4 characters and letters in the Code should be capitalized.

Part Number - Sort the Inventory Items by Part Number (Item ID).

Vendor - Sort the Inventory Items by Vendor Name, then within each Vendor, by the Inventory Item's Part Number (Item ID).

Sale Item Group - Sort the Inventory Items by Sale Item Group Name, then within each Sale Item Group, by the Inventory Item's Part Number (Item ID).

 

Group Code/Part Number/Vendor/Sale Item Group - Based on the Order By choice made above:

If Group Code and Part Number order was selected, you may include Inventory Items for All Part Group Codes, or for One designated Part Group Code.

a)All - By default, all Inventory Items will be listed, regardless of their Part Group Code or Part Number (Item ID).

b)One - Click this button to report Inventory Items for only one Part Group Code.

i.Use the Drop-Down Selection List to Choose the appropriate Part Group Code.

ii.There is also an Unclassified option available to list those Part Numbers which have not yet been assigned a Part Group Code

 

If Part Number order was selected, you may include All Inventory Items, or for One designated Inventory Item's Code.

a)All - By default, All Inventory Items will be listed, regardless of Part Number (Item ID).

b)One - Click this button to report Inventory Items for only one Part Number.

i.Use the Drop-Down Selection List to Choose the appropriate Part Number (Item ID).

 

If Vendor order was selected, you may include Inventory Items for All Vendors, or One specific preferred Vendor.

a)All - By default, all Inventory Items for All Vendors be listed.

b)One - Click this button to report Inventory Items for one preferred Vender.

i.Use the Drop-Down Selection List to Choose the appropriate Vendor.

 

If Sale Item Group order was selected, you may include Inventory Items for All Sale Item Groups, or One specific Sale Item Group.

a)All - By default, all Inventory Items for All Sale Item Groups will be listed.

b)One - Click this button to report Inventory Items assigned to one designated Sale Item Group.

i.Use the Drop-Down Selection List to Choose the appropriate Part Group Code.

 

Inventory Status - Retired Inventory Items - those Checked as Inactive on the Sale-Purchase Items Form - may be included or excluded in this list.

All - All Inventory Items will be listed.

Active - Only Active Inventory Items will be listed.

Inactive - Only Inactive Inventory Items will be listed.

 

Exclude Items with Zero Quantity? - Check this box to prevent those Inventory Items which have a Quantity of "0" in all reporting columns from being included in this report.

 

HelpFilesInventoryListingZeroQuantities

Inventory Item shown on Inventory Listing that has Zero Quantities is all categories

 

Note: Understanding the Current Value column when the General Ledger System is Activated:

 

HelpFilesInventoryListingReportHeaderContents-CurrentValueColumn

a)The Values in the "Current Value" column will match the Inventory Asset Account (a Mandatory Account) Value on the Balance Sheet providing that the Inventory Valuation Method: Average Cost Inventory is being used.

b)The Current Value calculation is: "On Hand" * COGS .

 

Print - Click the Print button HelpFilesPrintButton to Preview and optionally Print (to a File or a Printer) this Inventory Listing report.

To Exit this Report dialog, Click the Close button HelpFilesReportDialogCloseButton toward the bottom of the Options tab.

 

HelpFilesInventoryListingReportHeaderContents

Inventory Listing Report header showing the detailed information that is available

 

Preview - The Preview tab presents the report which resulted from the Options selected above.

Up Arrow/Down Arrow - hi - Moves the report one line up, or one line down, respectively.

Page Up/Page Down - Moves the report to the previous or next page, respectively.

 

HelpFilesInventoryListingReportPreview

Inventory Listing Report - Preview tab

Home - HelpFilesHomeKey- Using either the screen icon or your Keyboard's Home key, moves the report to the top of the first page.

End - HelpFilesEndKey- Using either the screen icon or your Keyboard's End key, moves the report to the bottom of the last page.

Arrows - The arrows allow you to move back and forth, from page to page.

Number - Indicates the page number you are viewing.

You may also type in a specific page number, Press 8 Enter and that page will be displayed immediately.

If you enter an invalid page number, it will be ignored.

Fit To Page - Click the first button after the arrows to size a full page of the report to fit the screen.

Zoom To 100% - Click the second button after the arrows to display the page at 100% (of the printed view).

Fit To Page Width - Click the third button after the arrows to size the page of the report to fit the full width of the screen.

Zoom To Percentage - Click the fourth button after the arrows to re-size the page of the report by percentage.

 

HelpFilesPercentageOfViewAdjuster

When you Click the Zoom To Percentage button, the Percentage selector will be displayed.

You may then Click the Up  or Down arrows to set the exact amount of Zoom you want.

Print - Click the Print button to Print (to a File or a Printer) HelpFilesPrintIconthe displayed Inventory Listing Report.

Email - Click the Email button HelpFilesEmailButtonto send the Report to an Email Address of your choosing.

To Exit the Preview tab and Close this Report dialog Form, Click the Close box HelpFilesCloseBox on the right at the top of the Preview tab.

 

Data View - This view provides a tabular (spreadsheet style) presentation of the selected data.

 

HelpFilesInventoryListingReportDataView

Inventory Listing Report - Data View tab

 

Arrows - Click the arrows to move through the record.

Export - Exporting the data from this Data View Form (note the "fly-over" help available on these buttons):

Export to CSV - Click the first button after the arrows to export the data to a Comma Separated Values (CSV) file format.

Export To Excel - Click the second button after the arrows to export the data to an Excel (.xls) file format.

Export To Html - Click the third button after the arrows to export the data to an HTML formatted file.

To Exit the Data View tab and Close this Report dialog Form, Click the Close box HelpFilesCloseBox on the right at the top of the Data View tab.