MRRs per Day - Intergraph Smart Materials - 10.2 - Help - Hexagon

Intergraph Smart Materials Web Help (10.2)

Language
English
Product
Intergraph Smart Materials
Subproduct
Web
Search by Category
Help
Smart Materials/Smart Reference Data Version
10.2

The MRRs per Day metric summarizes and reports on the total number of receivings (MRR - material receiving report) per day, week and/or month at a particular jobsite. This information may be useful when reviewing field materials management resource levels, when monitoring jobsite receipt activity over time and/or when reviewing shipments from a particular supplier over time.

Before you run this report, you must execute a database job that prepares the data for the report. It is recommended to run this job at least once a day. For more details see Manage Synchronization Jobs.

  • The report considers only the initial and posted MRR (revision 0).

  • The report does not consider direct receiving MRRs and MRRs by package.

To generate a MRRs per Day report, select the appropriate format from the Report Formats group in the Selection box.

Select a month in the From and To boxes to define the time frame for the report output. By default, the last 3 months are set as time frame. All MRRs with a receipt date within the specified time frame will be considered.

Additionally, you can select one or multiple values from the following lists to filter and limit the displayed data accordingly:

  • Project - Project for which the agreement is issued

  • Supplier - Supplier assigned to the agreement

  • Buyer - The buyer assigned to and responsible for the agreement

  • Expediter - The expediter assigned to the agreement

  • Origin - Office (origin) on whose behalf the agreement is issued

  • Item Type - Material's item type. With the item type, you can specify if you want to track bulk material or equipment material, having a particular item type.

The selection is limited to a maximum number of 1,800 entries.

SHARED Tip To select multiple values, press and hold CTRL while selecting values from the list.

After selecting the values, click Go to apply the filter.

To remove the filter and display all data, click Clear All.

SHARED Tip Click BIROpenSelectionButton to collapse the Selection box. To display the Selection box again, click BIRCloseSelectionButton.

The chart legend entries are truncated if their length exceeds 30 characters.

Report Formats

The MRRs per Day report includes the following report formats:

(1) MRRs per Week

The (1) MRRs per Week report format contains the week on the x-axis and the MRR count on the y-axis. This report format provides a quick visual of the weekly MRR count (blue) and the 4-week average (red). The 4-week-average is calculated dividing the total MRR count of the selected week and the previous 3 weeks by 4. The calculation does not consider months which do not have any MRR assigned.

If the selected timeframe exceeds the maximum of 120 weeks, the report output changes to MRRs per month.

(2) MRRs per Day

The (2) MRRs per Day report format outlines the MRR received date on the x-axis and the MRR count on the y-axis. This report format provides a quick visual of the total MRR count and cumulative MRR count for a particular day and over time, and is a good management level report to outline the number of jobsite shipments that can be expected for a certain project type.

(3) MRRs per Month

The (3) MRRs per Month report format is automatically displayed just below the diagrams and cannot be selected from the Report Formats list. The MRR count is calculated based on the MRR receipt dates. This report is useful to highlight the total number of jobsite shipments per month. This is a good management level report to monitor the monthly jobsite receipt activity for a particular project.

Data Sources

The table below shows the Smart Materials screen(s) where the data is entered that is displayed in this report. Additionally, this table shows the synchronization table and the CIPs used by the report, and the name of the log file created by the sync job or the report.

Screen

C.20.01 Prepare MRR by PO

Table

CIP

n/a (no CIP)

Log File

prepare_mrrpd_data_......log

The following table shows all values displayed in the report, with the related Smart Materials screen and field where the value is displayed, the database table and column where the value is stored, and CIPs, functions, or procedures that are used to retrieve the value. Optionally, additional comment on the value is entered in the last column.

Value

Screen

Field

Database Column

Other Source/Comment

Project

P.50.01

Project

m_po_headers.proj_id

all projects accessible for the login user

Supplier

P.50.07

Supplier

m_po_headers.sup_id (-> m_suppliers.sup_code)

all suppliers accessible for the login user

Buyer

P.50.07

Buyer

m_po_headers.buyer

Expediter

P.50.07

Expediter

m_po_headers.expediter

Origin

P.50.01

Origin

m_po_headers.origin_id (-> m_origins.origin_code)

Item Type

P.50.07

A.10.15

Item Type

m_item_ships.ident ((-> m_idents.commodity_id -> m_commodity_codes.ity_id -> m_item_types.ity_code)

all item types from Smart Materials source screen

MRR Count

C.20.01