Bay Diary Reports: Difference between revisions

From WMS
VisualWikitext
(Bay Diary)
 
(Added ORS Reports)
 
(One intermediate revision by the same user not shown)
Line 1: Line 1:
To run a report from the Diary (Front) view, select the report from the Report Type drop-down list and click the Run Report button.
To run a report from the Diary (Front) view, select the report from the Report Type drop-down list and click the '''Run Report''' button.
 
 
Most reports run for the day selected in the Main Diary screen.
 
Some reports require additional parameters and are specified in the below sections.
 
If parameters are required, they will be prompted for through a popup window, an example of which is below:
 
[[File:BAY_REPORT_1.png]]
 
Once parameters have been entered, the '''Run Report''' button will run the report.
The '''Reset''' button will reset the parameters to their default values, and the '''Cancel''' button will close the pop-up without running the report.
 


All reports extract in Microsoft Excel spreadsheet format, formatted with a header. Depending on the browser and settings, this may open in a browser window or tab, or prompt to download the file with an appropriate name.
All reports extract in Microsoft Excel spreadsheet format, formatted with a header. Depending on the browser and settings, this may open in a browser window or tab, or prompt to download the file with an appropriate name.


{{Note}} A new ''Rebook Report'' will be added to show full booking and contact information about all bookings, to aid in changing bookings over a period.


== Unloading Diary Report ==
== Unloading Diary Report ==
This report shows the following for the date selected:
This report shows the following for the date selected:
* Loading Bay
* ''Loading Bay''
* Date
* ''Date''
* Time
* ''Time''
* Booking Ref
* ''Booking Ref''
* Container Type
* ''Container Type''
* Container Number
* ''Container Number''
* Advice
* ''Advice''
* Carrier
* ''Carrier''
* Product Description
* ''Product Description''
* Stock Code
* ''Stock Code''
* Pallet Config
* ''Pallet Config''
* Cases Qty
* ''Cases Qty''
* Pallet Qty
* ''Pallet Qty''
* Owner
* ''Owner''
* Location
* ''Location''
* Arrived Date
* ''Arrived Date''
* Restituted Details
* ''Restituted Details''
* Contact
* ''Contact''
* Phone Number
* ''Phone Number''
Only Inbound direction bookings are shown.
Only Inbound direction bookings are shown.


== Diary Report ==
== Diary Report ==
This report shows the following for the date selected:
This report requires a parameter:
* Direction
* ''Only Non-Finalised Bookings?''
* Loading Bay
 
* Date
[[File:BAY_REPORT_1.png]]
* Time
 
* Booking Ref
 
* Container Type
The report shows the following for the date selected on the main screen:
* Container  
* ''Direction''
* Owner
* ''Loading Bay''
* Contact
* ''Date''
* Phone Number
* ''Time''
* Carrier
* ''Booking Ref''
* Special Instructions
* ''Container Type''
* Load Information
* ''Container''
* ''Owner''
* ''Contact''
* ''Phone Number''
* ''Carrier''
* ''Special Instructions''
* ''Load Information''
All bookings are shown.
All bookings are shown.




== Rebook Report ==
== Rebook Report ==
{{Note}} A new Rebook Report will be added to show full booking and contact information about all bookings, to aid in changing bookings over a period.
This report requires parameters:
* ''Date From''
* ''Date To''


This report shows the following for the date selected:
[[File:BAY_REPORT_2.png]]
* Direction
 
* Type
 
* Loading Bay
The report shows the following between the dates selected:
* Date
* ''Direction''
* Time
* ''Type''
* Booking Ref
* ''Loading Bay''
* Container Type
* ''Date''
* Container  
* ''Time''
* Owner
* ''Booking Ref''
* Contact
* ''Container Type''
* Email
* ''Container''
* Phone Number
* ''Owner''
* Carrier
* ''Contact''
* Contact
* ''Email''
* Email
* ''Phone Number''
* Phone Number
* ''Carrier''
* Special Instructions
* ''Contact''
* Load Information
* ''Email''
* ''Phone Number''
* ''Special Instructions''
* ''Load Information''
All bookings are shown.
All bookings are shown.


== Additional Reports ==
In addition to the standard reports that have been created, and [[Oracle Reporting Suite]] reports that have been created on your user for report type "BAY_DIARY" will also be shown in the list. These reports are dependent on being created as BAY_DIARY reports and saved on your user.
{{Note}}Bay Diary will not prompt for parameters for these reports. Therefore, when creating the report, it is important that you save the selection criteria.


The following criteria is suggested:
{| class="wikitable"
!ORS_FIELD
!ORS_SEL_FROM
!ORS_SEL_TO
|-
|DIRECTION
|I
|
|-
|DELIVERY_RECEIPT_DATE
|sysdate-3
|sysdate+7
|-
|BOOKING_TYPE
|I
|
|}
[[Category:UG 340215 WMS Bay Diary User Guide|500]]
[[Category:UG 340215 WMS Bay Diary User Guide|500]]

Latest revision as of 09:34, 11 July 2025

To run a report from the Diary (Front) view, select the report from the Report Type drop-down list and click the Run Report button.


Most reports run for the day selected in the Main Diary screen.

Some reports require additional parameters and are specified in the below sections.

If parameters are required, they will be prompted for through a popup window, an example of which is below:

BAY REPORT 1.png

Once parameters have been entered, the Run Report button will run the report. The Reset button will reset the parameters to their default values, and the Cancel button will close the pop-up without running the report.


All reports extract in Microsoft Excel spreadsheet format, formatted with a header. Depending on the browser and settings, this may open in a browser window or tab, or prompt to download the file with an appropriate name.


Unloading Diary Report

This report shows the following for the date selected:

  • Loading Bay
  • Date
  • Time
  • Booking Ref
  • Container Type
  • Container Number
  • Advice
  • Carrier
  • Product Description
  • Stock Code
  • Pallet Config
  • Cases Qty
  • Pallet Qty
  • Owner
  • Location
  • Arrived Date
  • Restituted Details
  • Contact
  • Phone Number

Only Inbound direction bookings are shown.

Diary Report

This report requires a parameter:

  • Only Non-Finalised Bookings?

BAY REPORT 1.png


The report shows the following for the date selected on the main screen:

  • Direction
  • Loading Bay
  • Date
  • Time
  • Booking Ref
  • Container Type
  • Container
  • Owner
  • Contact
  • Phone Number
  • Carrier
  • Special Instructions
  • Load Information

All bookings are shown.


Rebook Report

This report requires parameters:

  • Date From
  • Date To

BAY REPORT 2.png


The report shows the following between the dates selected:

  • Direction
  • Type
  • Loading Bay
  • Date
  • Time
  • Booking Ref
  • Container Type
  • Container
  • Owner
  • Contact
  • Email
  • Phone Number
  • Carrier
  • Contact
  • Email
  • Phone Number
  • Special Instructions
  • Load Information

All bookings are shown.

Additional Reports

In addition to the standard reports that have been created, and Oracle Reporting Suite reports that have been created on your user for report type "BAY_DIARY" will also be shown in the list. These reports are dependent on being created as BAY_DIARY reports and saved on your user.

Note Note: Bay Diary will not prompt for parameters for these reports. Therefore, when creating the report, it is important that you save the selection criteria.

The following criteria is suggested:

ORS_FIELD ORS_SEL_FROM ORS_SEL_TO
DIRECTION I
DELIVERY_RECEIPT_DATE sysdate-3 sysdate+7
BOOKING_TYPE I
Retrieved from ‘https://calidusassist.adcservices.apteancloud.com/calidus-assist/WMS/index.php?title=Bay_Diary_Reports&oldid=6735’