3.2.14. Reports xTuple :
xTuple Logo Solutions About Us Resources News

Our Products
xTuple Open Source ERP Products
PostBooks
Standard Edition
OpenMFG Edition

Free Demo Download
 Please login:
username:
password:
 ... or click here to register:

  ... End Users
  ... Solution Providers

More Open Source
 OpenRPT Report Writer
 PostgreSQL Database
 Pricing for all services


xTuple ERP 3.0 won the LinuxWorld product excellence award for best Business Application! Read more here!


xTuple has also been recognized as a "Market Leader" by CRM Magazine, for "helping companies streamline business processes, maximize profitability, and provide more value to customers" with the integrated CRM functionality in xTuple ERP.

Our Community
 xTuple.org Home
 Forums & Mail
 Issue/Bug Tracker
 Search xTuple.org
 Downloads

Industry case studies
 Automotive aftermarket
 Bearings and pulleys
 Fresh/frozen foods
 Garments (make to order)
 Inks and ink technology
 Pumps and valves
  - View all case studies

3.2.14. Reports

The Physical Inventory area contains its own reports section.

3.2.14.1.  Frozen Item Sites

To display a list of Item Sites that have been frozen, select the "Frozen Item Sites" option. The following screen will appear:

Frozen Item Sites

When displaying frozen Item Sites, you are presented with the following options:

All Warehouses

Select to display frozen Item Sites for all Warehouses.

Selected

Specify Warehouse whose frozen Item Sites you want to display.

Count Tags

Display lists frozen Item Sites, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

PRINT

Runs the report associated with this screen.

Right-clicking on an Item Site in the frozen Item Sites list enables you to select from the following menu options:

Thaw

Select to thaw the specified Item Site.

Export Contents

Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

3.2.14.2.  Count Slip Edit List

To edit Count Slips entered for an associated Count Tag, select the "Count Slip Edit List" option. The following screen will appear:

Count Slip Edit List

When displaying the Count Slip Edit List, you are presented with the following options:

Count Tag #

Enter the Count Tag Number of the Count Tag whose Count Slips you want to display.

Item Number

Displays Item Number automatically when Count Tag Number is entered into "Count Tag #" field.

UOM

Inventory Unit of Measure.

Warehouse

Displays Warehouse where Count Tag and Count Slips originate from.

Count Slips

Display lists the Count Slip Edit List, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

PRINT

Runs the report associated with this screen.

NEW

Opens screen for creating a new Count Slip.

EDIT

Enables you to edit highlighted Count Slip. The edit screen is the same as that for creating a new Count Slip—except that when editing, the fields will contain Count Slip information. Double-clicking on a Count Slip will also bring you to the editing screen.

DELETE

Highlight a Count Slip and then select this button to remove the Count Slip from the list.

POST

Posts individual Count Slip quantities to the associated Count Tag's total. Highlight the individual Count Slip you want to post.

POST ALL

Posts all Count Slip quantities displayed in the "Count Slips" list to the associated Count Tag's total.

Right-clicking on a Count Slip in the Count Slips list enables you to select from the following menu options:

Edit Count Slip

Select to edit the specified Count Slip.

Export Contents

Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

If the Count Slip has not been posted, the following additional menu option will also be available:

List Items in this Inventory Cost Category

Select to display Item Sites using the specified Cost Category

3.2.14.3.  Count Tag Edit List

The Count Tag Edit List displays the unposted Count Tags currently available in your system. From this list, you can manage current Count Tags and their associated Count Slips. To display available Count Tags, select the "Count Tag Edit List" option. The following screen will appear:

Tip

By default, the system allows only one unposted Count Tag per Item Site. Use the Count Tag Edit List to view all unposted Count Tags in your system.

Count Tag Edit List

When displaying the Count Tag Edit List, you are presented with the following options:

Search For

To search for a Count Tag in the edit list, begin typing in the search field. As you type, the list will automatically scroll toward the Count Tag you are typing. You can also search for Count Tags manually by scrolling through the list.

All Warehouses

Select to display Count Tags for all Warehouses.

Selected

Specify Warehouse whose Count Tags you want to display.

Item Sites in

Specify which of the following codes you want to have Count Tag displayed for:

Class Code

If selected, you will be presented with Class Code options.

Planner Code

If selected, you will be presented with Planner Code options.

Tip

One way to manage Count Slips associated with a Count Tag is by using the right-click menu options available from the Count Tag Edit List.

Show Count Slips

Select to display Count Slips associated with Count Tags. Count Slips will display in a nested manner beneath their associated Count Tag. Look for a plus "+" sign in the first column to determine if Count Slips are associated. Select the plus "+" sign to reveal the Count Slips. To hide the Count Slips, select the minus "-" sign.

No Highlighting

Select to not highlight Count Tags with variances.

Highlight Count Tag when Variance Value Exceeds

Select to highlight Count Tags whose dollar amount variance exceeds the value entered. In addition to checking the box, you must also enter a value in the field. Once the value is entered, select the QUERY button. Count Tags meeting your criteria will automatically be highlighted in red.

Note

Count Tags showing both positive and negative variances will be highlighted. For example, if you enter "100" in the field "Highlight Count Tag When Variance Value Exceeds," all dollar amount variances greater than $100 will be highlighted, but so too will negative variances exceeding -$100. The same principle holds true if a percentage value is entered.

Highlight Count Tag when Variance Exceeds %

Select to highlight Count Tags whose variance exceeds a user-defined percentage. In addition to checking the box, you must also enter a percentage in the percentage field. Once the percentage is entered, select the QUERY button. Count Tags meeting your criteria will automatically be highlighted in red.

Count Tags

Display lists Count Tag Edit List, using the specified parameters. If the count quantity displays in blue type, this means the Item has not been counted.

Tip

Count Tags may be created to count an entire Item Site—or a specific Warehouse Location within an Item Site.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

Note

The Count Tag Edit List supports multiple-select, using the SHIFT and/or CTRL keys.

EDIT

Enables you to edit highlighted Count Tags. The edit screen is the same as that for creating a new Count Tag—except that when editing, the fields will contain Count Tag information. Double-clicking on a Count Tag will also bring you to the editing screen.

DELETE

Highlight a Count Tag—or group of Count Tags using the SHIFT and/or CTRL keys—and then select this button to remove the Count Tag from the list.

POST

Highlight an individual Count Tag—or group of Count Tags using the SHIFT and/or CTRL keys—and then select this button to post the Count Tag(s). Posts Count Tag quantities to the Quantity on Hand for the associated Item Site(s)

ENTER SLIP

Select to enter a Count Slip.

Automatically Update

Select to automatically update the display every five minutes.

Right-clicking on a Count Tag in the Count Tags list enables you to select the following menu options:

Enter Count Slip

Select to enter a Count Slip.

Count Slip Edit List

Select to display the Count Slip Edit List for the specified Count Tag, if any.

View Pending Inventory History

Select to view Inventory transactions for the Item Site since the date the specified Count Tag was created.

Edit Count Tag

Enables you to edit highlighted Count Tags. The edit screen is the same as that for creating a new Count Tag—except that when editing, the fields will contain Count Tag information. Double-clicking on a Count Tag will also bring you to the editing screen.

Post Count Tag

Highlight an individual Count Tag—or group of Count Tags using the SHIFT and/or CTRL keys—and then select this button to post the Count Tag(s). Posts Count Tag quantities to the Quantity on Hand for the associated Item Site(s)

Delete Count Tag

Highlight a Count Tag—or group of Count Tags using the SHIFT and/or CTRL keys—and then select this button to remove the Count Tag from the list.

Export Contents

Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

3.2.14.4.  Count Slips by Warehouse

To view a display of Count Slips by Warehouse, select the "Count Slips by Warehouse" option. The following screen will appear:

Count Slips by Warehouse

When displaying Count Slips by Warehouse, you are presented with the following options:

All Warehouses

Select to display Count Slips for all Warehouses.

Selected

Specify Warehouse whose Count Slips you want to display.

Start Date

Count Slips entered on and after this date will be displayed.

End Date

Count Slips entered on and before this date will be displayed.

Show Unposted Count Tags

Select to display unposted Count Tags.

Treat Slip Numbers as Numeric

Select to treat Count Slip numbers as numeric. If selected, the display will treat existing Count Slips as if they were created in a numerical sequence. If numbers are missing from the sequence, the display will indicate the missing Count Slip numbers in red type.

Count Slips

Display lists Count Slips by Warehouse, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

PRINT

Runs the report associated with this screen.

3.2.14.5. Count Tags

Count Tag Reports section.

3.2.14.5.1.  Count Tags by Item

To view a display of Count Tags by Item, select the "Count Tags by Item" option. The following screen will appear:

Count Tags by Item

When displaying Count Tags by Item, you are presented with the following options:

Item Number

Enter the Item Number of the Item Count Tags you want to view.

UOM

Inventory Unit of Measure.

All Warehouses

Select to display Count Tags for all Warehouses.

Selected

Specify Warehouse whose Count Tags you want to display.

Start Date

Count Tags entered on and after this date will be displayed.

End Date

Count Tags entered on and before this date will be displayed.

Show Unposted Count Tags

Select to display unposted Count Tags.

Count Tags

Display lists Count Tags by Item, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

Right-clicking on a Count Tag in the Count Tags list enables you to select the following menu options:

View Availability

Select to view Inventory Availability for the specified Item Site.

Export Contents

Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

3.2.14.5.2.  Count Tags by Warehouse

To view a display of Count Tags by Warehouse, select the "Count Tags by Warehouse" option. The following screen will appear:

Count Tags by Warehouse

When displaying Count Tags by Warehouse, you are presented with the following options:

Show Unposted Count Tags

Select to display unposted Count Tags.

All Warehouses

Select to display Count Tags for all Warehouses.

Selected

Specify Warehouse whose Count Tags you want to display.

Start Date

Count Tags entered on and after this date will be displayed.

End Date

Count Tags entered on and before this date will be displayed.

Count Tags

Display lists Count Tags by Warehouse, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

Right-clicking on a Count Tag in the Count Tags list enables you to select the following menu options:

View Count Tag

Select to view the specified Count Tag.

Export Contents

Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.

3.2.14.5.3.  Count Tags by Class Code

To view a display of Count Tags by Class Code, select the "Count Tags by Class Code" option. The following screen will appear:

Count Tags by Class Code

When displaying Count Tags by Class Code, you are presented with the following options:

All Class Codes

Select to display Count Tags for all Class Codes.

Selected

Specify Class Code whose Count Tags you want to display.

Pattern

Enter a Class Code pattern to select a range of Class Codes. Refine your search using Regular Expressions, as described in Section 1.2.9, “Topic: Pattern Matching with Regular Expressions”.

Show Unposted Count Tags

Select to display unposted Count Tags.

All Warehouses

Select to display Count Tags for all Warehouses.

Selected

Specify Warehouse whose Count Tags you want to display.

Start Date

Count Tags entered on and after this date will be displayed.

End Date

Count Tags entered on and before this date will be displayed.

Count Tags

Display lists Count Tags by Class Code, using the specified parameters.

To the far right of the screen, the following buttons are available:

CLOSE

Closes the screen, returning you to the application desktop.

QUERY

Select to generate the display, using the specified parameters.

PRINT

Runs the report associated with this screen.

Right-clicking on a Count Tag in the Count Tags list enables you to select the following menu options:

View Count Tag

Select to view the specified Count Tag.

Export Contents

Export the data displayed on the screen into a plain-text, TAB-delimited file. This file may subsequently be imported into a spreadsheet or other office tool.



 
Copyright © 1998-2008 by xTuple. All rights reserved. 
 

SourceForge.net Logo