Difference between revisions of "11.7 UNHRD Alerts"

From UNHRD Customer Service Sales
Jump to: navigation, search
(Open SOs (SOs without ODs))
(OD with Zero Measure Materials)
(33 intermediate revisions by the same user not shown)
Line 26: Line 26:
  
  
== Duties of DOTS focal points ==
+
Duties of DOTS focal points are listed below:
  
 
UNHRD Focal Points for the Alerts report perform a weekly check of data related to operations by accessing the “UNHRD Alerts” page on DOTS and disseminate information at hub level to grant consistency of sales and operational data:
 
UNHRD Focal Points for the Alerts report perform a weekly check of data related to operations by accessing the “UNHRD Alerts” page on DOTS and disseminate information at hub level to grant consistency of sales and operational data:
Line 74: Line 74:
 
The UNHRD Alerts page on DOTS includes the information on below statistics:
 
The UNHRD Alerts page on DOTS includes the information on below statistics:
  
• '''Open SOs'''  (SOs without ODs): these are the SOs issued with regards to any operational matters that require despatching of NFI/FI from Inventory Stock or thru Direct Delivery or thru In-transit processes, which have not generated the consequent ODs. Keeping this data under control prevents the so called “overbooking” and allows to cancel commitments no longer required of stocks (e.g. when Partner’s opts out)
+
• '''Open SOs'''  (SOs without ODs): these are the SOs issued with regards to any operational matters that require despatching of NFI/FI from Inventory Stock or thru Direct Delivery or thru In-transit processes, which have not generated the consequent ODs. The list includes balance of quantities not despatched from the SO (i.e., when SO quantity is higher than quantity on OD), as this is considered as an "open quantity" waiting to be eventually included in a second OD or delta to be removed from SO. Keeping this data under control prevents the so called “overbooking” and allows to cancel commitments no longer required of stocks (e.g. when Partner’s opts out or request to reduce cargo configuration). Also the list highlights eventual "over-picking", i.e., when the quantity on the Outbound Delivery exceed the quantity on the SO. This features support the Logistics team to eventually spot and highlight the matter to Management. Any of this case make the SO "open".
  
• '''Open ODs''' (ODs without GIs): these are the ODs that might have not been despatched yet. Keeping this data under control allows the control of missing GI posting and ensure the alignment of stock in WMS with physical balances on hands
+
• '''Open ODs''' (ODs without GIs): these are the ODs that might have not been despatched yet or those despatched but requiring the Good Issue to be posted. Keeping this data under control allows the control of missing GI postings and ensure the alignment of stock in WMS with physical balances on hands.
  
• '''Open PODs''' (ODs with GIs but without PODs): these are the ODs with Good Issue posted that therefore have been despatched and not yet received at final destination. Keeping this data under control allows Customer Service to monitor the Sales closure as PODs is one of the requirements that trigger the submission of Service Confirmation Form to Finance for Sales closure
+
• '''Open PODs''' (ODs with GIs but without PODs): these are the ODs with Good Issues posted that therefore have been despatched and not yet received at final destination or eventual ODs that have been received by consignees and requiring Proof of Delivery to be posted. Keeping this data under control allows Customer Service to monitor the Sales closure as PODs is one of the requirements that trigger the submission of Service Confirmation Form to Finance for Sales closure or to spot missing PoD postings.
 
   
 
   
 
• '''ODs without Means of Transport''': this view lists the ODs where the indicator of Means of Transport has not been filled in any of the document that precedes it. In fact the system simply warns the user if no means of transport is filled at Inquiry/Quotation/Sales Order stages, as it is not a mandatory field. This type of warnings should not be ignored by the users at any stage. Anyhow the systems allows the editing of the means of transport at any stage, and lastly at OD stage, even if GI is already posted. Keeping this data under control ensures that Information Management resources are ready and completed at any given time.  
 
• '''ODs without Means of Transport''': this view lists the ODs where the indicator of Means of Transport has not been filled in any of the document that precedes it. In fact the system simply warns the user if no means of transport is filled at Inquiry/Quotation/Sales Order stages, as it is not a mandatory field. This type of warnings should not be ignored by the users at any stage. Anyhow the systems allows the editing of the means of transport at any stage, and lastly at OD stage, even if GI is already posted. Keeping this data under control ensures that Information Management resources are ready and completed at any given time.  
  
• '''OD with Zero Measure Materials''': this view shows eventual ODs containing material with zero value, zero gross weight or zero volume. Keeping this data under control allows Logistics teams and Hub Managers to monitor the cases where the information on cargo despatched don't reflect expected data  
+
• '''OD with Zero Measure Materials''': this view shows eventual ODs containing material with zero value, zero gross weight or zero volume. Keeping this data under control allows Logistics and Information Management teams to monitor the cases where the information on cargo despatched don't reflect expected data
 
 
• '''Quantity not yet delivered/extra delivered quantity''': this view shows eventual SOs containing partial quantity not included in a OD or extra quantity despatched above the planned quantity of the SO. Keeping this data under control allows Logistics teams to remove extra booking or spot wrong data entry
 
  
 
== How to access UNHRD Alerts report ==
 
== How to access UNHRD Alerts report ==
Line 98: Line 96:
 
On the top of the page the report presents the several tabs available and a preview of data aggregated by hubs:
 
On the top of the page the report presents the several tabs available and a preview of data aggregated by hubs:
  
[[File:DOTS52.png]]
+
[[File:DOTS52.png|800px]]
 +
 
 +
Data is presented as tables and grapfhics.
 +
Each tabs present the alerts with different filtering and contents.
 +
To filter the data  click on [[File:DOTSfilter.png|20px]] to expand the selection.
 +
 
 +
[[File:DOTS51.png|200px]]
 +
 
 +
Selection of multiple entries is not allowed; by leaving the field empty, the report shows data across the Network and provide the detailed view of items by columns that can be sorted in ascending or descending order:
  
Each tabs present the alerts with different filtering and contents:
+
[[File:DOTS6.png|500px]]
 +
 
 +
Click on "Clear" to remove the filters.
 +
Also graphics can be filtered by clicking on the single histogram, while the whole graphic views can be minimized by clicking on [[File:DOTSfilter.png|20px]].
  
=== Open SOs (SOs without ODs) ===
+
By right-clicking on the table in each view, it is possible to download the reports in MS Excel format:
To filter the data by Sales Office click on [[File:DOTSfilter.png]] to expand the selection. Data can be filtered by Sales Office and by Sales Order:
 
  
[[File:DOTS51.png]]
+
[[File:DOTSOOD3.png|600px]]
  
Selection of multiple Sales Offices is not allowed; by leaving the field empty, the report shows data across the Network, by year and profile the detailed view of items by columns that can be sorted in ascending or descending order:
+
=== Open SOs (SOs without ODs) ===
  
[[File:DOTS6.png]]
+
Data can be filtered by Sales Office and by Sales Order:
  
Click on "Clear" to remove the filters.
+
[[File:DOTS51.png|200px]]
  
By clicking on each Outbound Delivery, the report expand the detailed lines  
+
By clicking on each SO, the report expands the detailed lines:
  
[[File:DOTS7.png]]
+
[[File:DOTS7.png|500px]]
  
 
By right-clicking on the table, it is possible to download the report in MS Excel format:
 
By right-clicking on the table, it is possible to download the report in MS Excel format:
  
[[File:DOTS9.png]]
+
[[File:DOTS9.png|500px]]
  
On the very right side or the "Open SO" report the column "Quantity not yet delivered" shows the eventual quantity not yet derived into an Outbound Delivery from the Sales Orders:
+
On the very right side of the "Open SO" report the column "Quantity not yet delivered/extra delivered quantity" shows the eventual quantity not yet derived into an Outbound Delivery from the Sales Orders. This information shows eventual SOs containing partial quantity not included in a OD or extra quantity despatched above the planned quantity of the SO. Keeping this data under control allows Logistics teams to remove extra booking or process Outbound Deliveries for the quantity remained available on the SOs.
  
[[File:DOTS101.png]]
+
[[File:DOTS101.png|500px]]
  
 
In case of extra picking quantity, meaning and extra quantity of items despatched thru an Outbound Delivery, the column "Quantity not yet delivered" shows a negative quantity:
 
In case of extra picking quantity, meaning and extra quantity of items despatched thru an Outbound Delivery, the column "Quantity not yet delivered" shows a negative quantity:
  
[[File:DOTS10.png]]
+
[[File:DOTS10.png|500px]]
  
 
=== Open ODs (ODs without GIs) ===
 
=== Open ODs (ODs without GIs) ===
  
 +
Data can be filtered by Sales Office, by Sales Order and Delivery:
 +
 +
[[File:DOTSOOD1.png|200px]]
 +
 +
Graphics show the data by years, Sales Office and plant:
 +
 +
[[File:DOTSOOD11.png|200px]]
 +
 +
The table shows the data by providing the details of Outbound Deliveries contents:
 +
 +
[[File:DOTSOOD2.png|600px]]
 +
 +
This view shows the list of Outbound delivery by providing details at header level and allows Customer Service and Logistics teams to spot eventual errors in the use of WBS element of wrong country of destination.
  
 
=== Open PODs (ODs with GIs but without PODs) ===
 
=== Open PODs (ODs with GIs but without PODs) ===
  
 +
Data can be filtered by Sales Office, by Sales Order and Delivery:
 +
 +
[[File:DOTSOOD1.png|200px]]
 +
 +
Graphics show the data by Sales Office, plant and years:
 +
 +
[[File:DOTSOOD11.png|300px]]
 +
 +
The table shows the data by providing the details of Outbound Deliveries contents:
 +
 +
[[File:DOTSOOD2.png|600px]]
 +
 +
This view shows the list of Outbound delivery by providing details at header level and allows Customer Service and Logistics teams to control the status of the shipments in the system to proceed with SO closure when items have been received by consignees or to post missing PoDs, when required.
  
 
=== ODs without Means of Transport ===
 
=== ODs without Means of Transport ===
  
=== OD with Zero Measure Materials ===
+
Data can be filtered by Sales Office and by Sales Order:
  
=== Quantity not yet delivered/extra delivered quantity ===
+
[[File:DOTS51.png|200px]]
  
Data can be exported by clicking on "More Actions".
+
Graphics show the data by years, Sales Office and plant:
  
The page contains some graphics on the distribution of Open SOs during the years and across the Network:
+
[[File:DOTSOOD11x.png|300px]]
  
[[File:DOTS11.png]]
+
The table shows the data by providing the details of Outbound Deliveries contents:
  
Same format is applied on the Open ODs:
+
[[File:DOTSOOD2x.png|600px]]
  
[[File:DOTS12.png]]
+
This view shows the list of Outbound delivery by providing details at header level and allows Customer Service and Logistics teams to control if information on means of transport is not entered. In case of missing information on means of transport, the systems allows the editing of the ODs even if GI is already posted. Keeping this data under control ensures that Information Management resources are ready and completed at any given time.
  
Furthermore, in this case, graphics detail the data by Sales Office and Plant of departure, if not filtered on the top:
+
=== OD with Zero Measure Materials ===
 
 
[[File:DOTS13.png]]
 
  
Same format is also applied to the Open PODs:
+
This view presents 3 sub-views: "Zero Value OD", "Zero Volume OD" and "Zero Weight OD" and shows the data by Type of Delivery:
  
[[File:DOTS14.png]]
+
[[File:DOTSZERO.png|990px]]  
  
Also in this case, graphics detail the data by Sales Office and Plant of departure, if not filtered on the top
+
By clicking on each histogram of the graphics, the table contents are filtered to reflect the type of delivery selected:
  
[[File:DOTS15.png]]
+
[[File:DOTSZERO1.png|990px]]  
  
At the end of the page, the reports focuses on alerts related to the ODs without the Means of Transport for any OD created starting from year 2017:
+
Being a report separated in 3 sub-views, filters can be applied on data from the report itself. Thereof, download of the sub-views is required to apply filters by Sales Office.
  
[[File:DOTS16.png]]
+
By showing eventual ODs containing material with zero value, zero gross weight or zero volume, these sub-views allow to keep the data under control and eventually adjust information on cargo despatched that don't reflect expected data.

Revision as of 07:43, 27 September 2021

Perform Weekly checks
Performer: DOTS Focal Points
Role: DOTS Local Focal Points
Transaction : DOTS report


UNHRD Alerts is a report on DOTS that pulls the relevant data from WINGS and allows hubs to directly monitor their respective data in "real time". In fact the the report updates automatically approximately every two hours. Therefore, the report supports the Logistics Teams to monitor the activities related to outbound movements started with standard UNHRD sales process. It allows to spot any open item starting from materials listed in the Sales Orders waiting for Outbound Deliveries to be created, going up to the monitoring of Proof of Deliveries for the Outbound Deliveries, including alerts on potential wrong data e.g. wrong commodity values, missing means of transport, etc.

UNHRD Alerts Focal Points

At each hub level, the Hub Managers nominate a DOTS focal point who grants consistency of local sales and operational data by the use of UNHRD alerts report on DOTS. Hub Managers nominate also alternates to the main Focal Points. to perform same roles in case of focal point's absence.

DOTS focal points must run the report at least once a week to ensure that involved staff and Hub Manager are promptly informed in case of wrong data, to ensure that required corrections are applied, when applicable, to grant solidity of sale flows and consistency of operational data. Also, keeping this data under control ensures that Information Management resources are ready and completed at any given time while weekly checks reduce the time required to correct data.

In case of intense activity it is recommended to step up controls and inspect the UNHRD Alerts space on daily base.


Duties of DOTS focal points are listed below:

UNHRD Focal Points for the Alerts report perform a weekly check of data related to operations by accessing the “UNHRD Alerts” page on DOTS and disseminate information at hub level to grant consistency of sales and operational data:

• Check the number of SO in progress and compare it with data related to previous week

• Consult the list of SOs in progress and notify SO creators for outstanding SOs, if reasons are not known.

• When required, escalate to Hub Manager the long outstanding SOs

• Submit to Hub Manager the graphic related to SOs in progress (sample graphic below):

DOTS1.png

• Check the number of open ODs (i.e. OD without Good Issue) in progress and compare it with data related to previous week

• Consult the list of ODs with Good Issue not posted and notify the Logistics team for outstanding ODs, if reasons are not known

• When required, escalate to Hub Manager the long outstanding ODs

• Submit to Hub Manager the graphic related to ODs in progress (sample graphic below):

DOTS2.png

• Check the number of open PODs (i.e. OD without Proof of Delivery) in progress and compare it with data related to previous week

• Consult the list of PODs not posted and notify the Customer Service team for outstanding PODs, especially if long outstanding, to apply SOP criteria for posting of POD when confirmation from consignee is not received

• Submit to Hub Manager the graphic related to PODs not posted (sample graphic below):

DOTS31.png

• Consult the list of ODs without the means of transport and notify the Logistics team accordingly

• If same ODs remain without means of transport between the weeks, escalate the matter to Hub Manager

• Submit to Hub Manager the graphic related to ODs without means of transport (sample graphic below):

DOTS4.png

• Submit to Hub Manager the graphic related to ODs with zero measure materials (sample graphic below):

DOTS5.png

Information available on the UNHRD Alerts report

The UNHRD Alerts page on DOTS includes the information on below statistics:

Open SOs (SOs without ODs): these are the SOs issued with regards to any operational matters that require despatching of NFI/FI from Inventory Stock or thru Direct Delivery or thru In-transit processes, which have not generated the consequent ODs. The list includes balance of quantities not despatched from the SO (i.e., when SO quantity is higher than quantity on OD), as this is considered as an "open quantity" waiting to be eventually included in a second OD or delta to be removed from SO. Keeping this data under control prevents the so called “overbooking” and allows to cancel commitments no longer required of stocks (e.g. when Partner’s opts out or request to reduce cargo configuration). Also the list highlights eventual "over-picking", i.e., when the quantity on the Outbound Delivery exceed the quantity on the SO. This features support the Logistics team to eventually spot and highlight the matter to Management. Any of this case make the SO "open".

Open ODs (ODs without GIs): these are the ODs that might have not been despatched yet or those despatched but requiring the Good Issue to be posted. Keeping this data under control allows the control of missing GI postings and ensure the alignment of stock in WMS with physical balances on hands.

Open PODs (ODs with GIs but without PODs): these are the ODs with Good Issues posted that therefore have been despatched and not yet received at final destination or eventual ODs that have been received by consignees and requiring Proof of Delivery to be posted. Keeping this data under control allows Customer Service to monitor the Sales closure as PODs is one of the requirements that trigger the submission of Service Confirmation Form to Finance for Sales closure or to spot missing PoD postings.

ODs without Means of Transport: this view lists the ODs where the indicator of Means of Transport has not been filled in any of the document that precedes it. In fact the system simply warns the user if no means of transport is filled at Inquiry/Quotation/Sales Order stages, as it is not a mandatory field. This type of warnings should not be ignored by the users at any stage. Anyhow the systems allows the editing of the means of transport at any stage, and lastly at OD stage, even if GI is already posted. Keeping this data under control ensures that Information Management resources are ready and completed at any given time.

OD with Zero Measure Materials: this view shows eventual ODs containing material with zero value, zero gross weight or zero volume. Keeping this data under control allows Logistics and Information Management teams to monitor the cases where the information on cargo despatched don't reflect expected data

How to access UNHRD Alerts report

Follow this link to DOTS to access "UNHRD Alerts" report. The link to this report is also available on UNHRD Staff Portal.

NOTE Report is accessible if connection to VPN is established thru CISCO AnyConnect Secure Mobile Client.

View this presentation about restyled version of UNHRD Alerts report released in Sept. 2021 and the comparison with previous version.


UNHRD Alerts views

On the top of the page the report presents the several tabs available and a preview of data aggregated by hubs:

DOTS52.png

Data is presented as tables and grapfhics. Each tabs present the alerts with different filtering and contents. To filter the data click on DOTSfilter.png to expand the selection.

DOTS51.png

Selection of multiple entries is not allowed; by leaving the field empty, the report shows data across the Network and provide the detailed view of items by columns that can be sorted in ascending or descending order:

DOTS6.png

Click on "Clear" to remove the filters. Also graphics can be filtered by clicking on the single histogram, while the whole graphic views can be minimized by clicking on DOTSfilter.png.

By right-clicking on the table in each view, it is possible to download the reports in MS Excel format:

DOTSOOD3.png

Open SOs (SOs without ODs)

Data can be filtered by Sales Office and by Sales Order:

DOTS51.png

By clicking on each SO, the report expands the detailed lines:

DOTS7.png

By right-clicking on the table, it is possible to download the report in MS Excel format:

DOTS9.png

On the very right side of the "Open SO" report the column "Quantity not yet delivered/extra delivered quantity" shows the eventual quantity not yet derived into an Outbound Delivery from the Sales Orders. This information shows eventual SOs containing partial quantity not included in a OD or extra quantity despatched above the planned quantity of the SO. Keeping this data under control allows Logistics teams to remove extra booking or process Outbound Deliveries for the quantity remained available on the SOs.

DOTS101.png

In case of extra picking quantity, meaning and extra quantity of items despatched thru an Outbound Delivery, the column "Quantity not yet delivered" shows a negative quantity:

DOTS10.png

Open ODs (ODs without GIs)

Data can be filtered by Sales Office, by Sales Order and Delivery:

DOTSOOD1.png

Graphics show the data by years, Sales Office and plant:

DOTSOOD11.png

The table shows the data by providing the details of Outbound Deliveries contents:

DOTSOOD2.png

This view shows the list of Outbound delivery by providing details at header level and allows Customer Service and Logistics teams to spot eventual errors in the use of WBS element of wrong country of destination.

Open PODs (ODs with GIs but without PODs)

Data can be filtered by Sales Office, by Sales Order and Delivery:

DOTSOOD1.png

Graphics show the data by Sales Office, plant and years:

DOTSOOD11.png

The table shows the data by providing the details of Outbound Deliveries contents:

DOTSOOD2.png

This view shows the list of Outbound delivery by providing details at header level and allows Customer Service and Logistics teams to control the status of the shipments in the system to proceed with SO closure when items have been received by consignees or to post missing PoDs, when required.

ODs without Means of Transport

Data can be filtered by Sales Office and by Sales Order:

DOTS51.png

Graphics show the data by years, Sales Office and plant:

DOTSOOD11x.png

The table shows the data by providing the details of Outbound Deliveries contents:

DOTSOOD2x.png

This view shows the list of Outbound delivery by providing details at header level and allows Customer Service and Logistics teams to control if information on means of transport is not entered. In case of missing information on means of transport, the systems allows the editing of the ODs even if GI is already posted. Keeping this data under control ensures that Information Management resources are ready and completed at any given time.

OD with Zero Measure Materials

This view presents 3 sub-views: "Zero Value OD", "Zero Volume OD" and "Zero Weight OD" and shows the data by Type of Delivery:

DOTSZERO.png

By clicking on each histogram of the graphics, the table contents are filtered to reflect the type of delivery selected:

DOTSZERO1.png

Being a report separated in 3 sub-views, filters can be applied on data from the report itself. Thereof, download of the sub-views is required to apply filters by Sales Office.

By showing eventual ODs containing material with zero value, zero gross weight or zero volume, these sub-views allow to keep the data under control and eventually adjust information on cargo despatched that don't reflect expected data.