The MainTrac Material Report is a fixed report that allows you to run reports based on processes completed in the MainTrac Material Posting and MainTrac Stock Room Transfer programs.
The Report Output Listing program contains a library of VSI-Standard reports as well as whatever custom reports your department has created.
Buttons on the screen…
Custom Title - Enter a free form text in this field, if desired. The text you enter here will overwrite the default report title. Leave this field blank to accept the default title.
Core Criteria
Materials (MTMaterialReport_MaterialDataGrid)
The Material Code DataGrid displays all the Materials in Stock Rooms in your database based on the DataGrid filters being used and your Permissions.
Highlight/select individual records, as needed, from the DataGrid. Multiple selection is allowed.
OR
Select the Use Material Code Range option.
THEN
Input the range of Materials that you wish to include.
Make selections in the DataGrid or use a Material Code Range or Both. Leaving the DataGrid blank and the Use Range option de-selected will result in NO MATERIALS being selected.
Click here for a full description of RecTrac DataGrids.
DeleteUse Material Code Range (MTMaterial_MaterialCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Material Codes.
THEN
Enter the range of Material Codes.
OR
Leave this option de-selected to skip the Material Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Material Code (MTMaterial_MaterialCode_Begin)
This field is applicable only if you opt to Use Material Code Range.
Click the Picklist icon to select the Beginning and Ending Material Codes for their respective fields. Material Codes within the range entered will be included in the process.
DeleteEnd Material Code (MTMaterial_MaterialCode_End)
This field is applicable only if you opt to Use Material Code Range.
Click the Picklist icon to select the Beginning and Ending Material Codes for their respective fields. Material Codes within the range entered will be included in the process.
DeleteMaterial Code Wildcard (MTMaterial_MaterialCode_Equals)
If opting to Use Material Code Range, then click the Picklist icon to select a single Material Code, if desired, to use as a base for a Wildcard selection.
OR
Enter a Wildcard value, if desired
THEN
Expand the Drop-down list to select a Wildcard Option. Depending on your selection, wildcard asterisks/periods may be required.
WildCard Option (MTMaterial_MaterialCode_Equals_Option)
Select your Wildcard Option for this process:
- Equals - The process will return a list of all records that equal the value entered. This must be an exact match. For Example: If this was a list of Family Members, entering 'Grace Somersby' would find 'Grace Somersby' because it is an exact match, but it would NOT find 'Grace J. Somersby' because it is not an exact match.
Note: When running Reports you can use a comma-delimited list (with no spaces) in the corresponding Wildcard field when your Wildcard Option is Equals. This applies to Reports only. For Example: Entering "48116 5851 88003" in a Zip Code Wildcard field on a Report and using the Equals Option would yield results from those three separate Zip Codes.
- Begins - The process will return a list of all records that begin with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'Gr' would find all members whose name begins with 'Gr' such as Grace Somersby but it would NOT find Ginny Weasley because her name begins with 'Gi.'
- Ends - The process will return a list of all records that end with the value entered. Wildcarding asterisks/periods are not needed. For Example: If this was a list of Family Members entering 'by' would find all members whose name ends with 'by' such as Grace Somersby but it would NOT find Sam McGee because his name ends with 'ee.'
- Matches - The process will return a list of all records where a value match can be found. Wildcarding and asterisks/periods must be used. For Example: If this was a list of Family Members entering '*om*' (asterisks must be included) would find Grace Somersby and Tom Sawyer because "om" appears in both names but it would NOT find Felicity Lemon because "om" does not appear anywhere in her name.
Note: See also: RecTrac Wildcarding.
Use Stock Room Code Range (MTStockRoom_StockRoomCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Stock Room Codes.
THEN
Enter the range of Stock Room Codes.
OR
Leave this option de-selected to skip the Stock Room Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Stock Room Code (MTStockRoom_StockRoomCode_Begin)
This field is applicable only if you opt to Use Stock Room Code Range.
Accept the default entries (<blank> to "ZZZZZZZZZ") or click the Picklist icon to select the Beginning and Ending Stock Room Codes for their respective fields if desired. Stock Room Codes within the range entered will be included in the process.
DeleteEnd Stock Room Code (MTStockRoom_StockRoomCode_End)
This field is applicable only if you opt to Use Stock Room Code Range.
Accept the default entries (<blank> to "ZZZZZZZZZ") or click the Picklist icon to select the Beginning and Ending Stock Room Codes for their respective fields if desired. Stock Room Codes within the range entered will be included in the process.
DeleteUse Category Code Range (MTMaterial_CategoryCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Category Codes.
THEN
Enter the range of Category Codes.
OR
Leave this option de-selected to skip the Category Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Material Category Code (MTMaterial_CategoryCode_Begin)
This field is applicable only if you opt to Use Category Code Range.
Accept the default values in these fields (<Blank> to 'ZZZZZZZZZZ') or click the Picklist icons to select an alternate range of Material Category Codes if desired. Only those Materials linked to a Material Category Code within your range will be included on the report output.
DeleteEnd Material Category Code (MTMaterial_CategoryCode_End)
This field is applicable only if you opt to Use Category Code Range.
Accept the default values in these fields (<Blank> to 'ZZZZZZZZZZ') or click the Picklist icons to select an alternate range of Material Category Codes if desired. Only those Materials linked to a Material Category Code within your range will be included on the report output.
DeleteUse Bin Code Range (MTMaterial_BinCode_UseRange)
This field appears in numerous programs. Its functionality may vary.
Select this option to limit your selection to a range of Bin Codes.
THEN
Enter the range of Bin Codes.
OR
Leave this option de-selected to skip the Bin Code Range check and make selections from the DataGrid if applicable.
- If there is a DataGrid for this program - In instances where you have a DataGrid and corresponding Range a selection in one or the other (or both) is required. Selecting nothing from the DataGrid and nothing from the Range yields a blank report or process.
- If there is NOT a DataGrid for this program - In instances where you do NOT have a DataGrid a selection here is NOT required. Leaving this option de-selected skips this filter and results in ALL Codes being included.
Begin Material Bin Code (MTMaterial_BinCode_Begin)
This field is applicable only if you opt to Use Bin Code Range.
Accept the default values in these fields (<Blank> to 'ZZZZZZZZZZ') or click the Picklist icons to select an alternate range of Bin Codes if desired. Only those Materials linked to a Bin Code within your range will be included on the report output.
DeleteEnd Material Bin Code (MTMaterial_BinCode_End)
This field is applicable only if you opt to Use Bin Code Range.
Accept the default values in these fields (<Blank> to 'ZZZZZZZZZZ') or click the Picklist icons to select an alternate range of Bin Codes if desired. Only those Materials linked to a Bin Code within your range will be included on the report output.
Delete