You can use this report to display the inventory locations of items that were scanned by Mobile Scan and posted. This report can be launched from the Site dashboard, to display all available inventory items. Alternatively, launch the report from the Inventory List report by clicking the pin in the Inventory Locations cell. In this case, only the inventory locations for the selected inventory item are displayed.
Click the pin in the View On Map cell to open a map service provider page where the inventory locations of the selected item are displayed.
Because the report fetches the ident description from the ident data in BIR, the ident data needs to be synchronized before running this report.
-
This is an interactive report.
-
Click and select the column where you want to search, type the search criterion in the Search box, and click Go to apply the search.
-
To change the number of displayed rows, select a value from the Rows list.
Additionally, you can customize the report to meet your requirements, save the report, and download the result in csv or html format (see Use Actions menu).
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 |
Mobile Scan |
Table |
|
CIP |
m_pck_bir_custom.get_maps_url |
Log File |
|
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 |
Mobile Scan |
Project |
m_gps.proj_id |
Project from Mobile Scan |
Ident Code |
Mobile Scan |
Ident Code |
m_gps.ident -> m_idents.ident_code |
Ident Code of the inventory item recorded by Mobile Scan |
Quantity |
Mobile Scan |
Quantity |
m_gps.quantity |
The recorded quantity in Mobile Scan |
Quantity Unit |
Mobile Scan |
Quantity Unit |
m_gps.ident -> m_inv_items.unit_id -> m_units.unit_code |
The unit code from the Inventory Item |
Ident Description |
m_pck_std_custom.ident_desc The Ident’s description from the synchronized Ident data in Smart Materials Web |
|||
Document Type |
Mobile Scan |
m_gps.report_source_type |
The source type of Mobile Scan (can be MRR, MTR, MTRO, MTRI, OITO, OITI, PickItem, MIR, PICS) |
|
Document Number |
Mobile Scan |
The corresponding number based on the document type, For example, MRR number if the type is MRR. |
||
Receipt Status |
Mobile Scan |
The site material receipt status (status fetched form the corresponding document type) |
||
View On Map |
Map service provider URL returned from the CIP function m_pck_bir_custom.get_gps_url(). By default, the CIP returns the Google Maps page URL, followed by the GPS coordinates of the selected inventory item. |
|||
Warehouse |
Mobile Scan |
Warehouse |
m_gps.ident -> m_inv_items.wh_id -> m_warehouses.wh_code |
Warehouse of the inventory item |
Location |
Mobile Scan |
Location |
m_gps.ident -> m_inv_items.loc_id -> m_locations.loc_code |
Location of the inventory item |
Date Reported |
Mobile Scan |
m_gps.date_reported |
The date reported by Mobile Scan |