Reports

The standard rental reports (Quote, Order, Shipment, Return Confirmation, Invoice and Pro Forma Invoice), the packing documents (Packing List and Container Label), their layouts and email body templates, and the Report Selections page that ties each report to its rental document type.


How it fits in

Essential Rental ships with a standard report for each stage of the document flow, each producing a printable customer-facing document, plus two packing documents for shipments that go out in containers. The Print and Email actions on rental documents (Print Quote / Print Order / Print Shipment Manifest, Email Order Confirmation, Print Packing List, etc.) all run against these reports.

Which report runs for which rental document type is configured on the Report Selections - Rental page (accessible from the Rental Setup ribbon). You can assign more than one report per usage if you want a sequence to run, swap in a customised report you've built, and choose which report drives the email body separately from which report becomes the email attachment.

The standard reports

Every report prints from a Word (DOCX) layout by default. The Quote, Order, Shipment and Invoice also ship with an RDLC layout (the BC-native report layout format); the Shipment's RDLC layout is an empty placeholder, so print the Shipment from its Word layout. Each customer document also has an email body template (a DOCX layout designed for the message body when emailing the document, distinct from the attachment).

Standard Reports
Standard Rental Quote
The customer-facing quote document. Run from the Print or Email actions on a Rental Quote, or via Report Selections when the Quote usage is invoked.
Standard Rental Order
The Order Confirmation document. Run from the Order Confirmation / Email Order Confirmation actions on a Rental Order, or via Report Selections when the Order usage is invoked.
Standard Rental Shipment
The Shipment Manifest (delivery note). Run from Print Shipment Manifest on a Posted Shipment Order, from Post and Print on an open Shipment Order, or via Report Selections when the Shipment usage is invoked. Its Container column shows the container each line travelled in, or, when only part of a line was packed or it was split, each container with how many went in it (for example CHEP-01: 6, CHEP-02: 4). Shipments posted before containers came in show the container that was typed on the line.
Rental Return Confirmation
Prints a posted return: what came back, from which rental order, the quantity returned and anything recorded as lost. Run from Print Return Confirmation and Email Return Confirmation on a Posted Return Order (Print is on the Posted Return Orders list too), and from Post and Print and Post and Email on a Return Order, through the Rental Return usage on Report Selections. Word layout only.
Standard Rental Invoice
The Sales Invoice with rental-specific fields surfaced. Run via the standard BC Sales Invoice print/email actions; the rental fields (Rental From / To, Rental Quantity, Price Term Code, Rental Periods) appear on each line so the customer can see the period breakdown.
Rental Pro Forma Invoice
A read-only preview of what the next invoice run would bill. Run from (Next) Invoice Preview and Email (Next) Invoice Preview on a Rental Order, and from Preview Invoice on the Invoice Suggestion Worksheet. It does not lock the rental lines or move billing on. Word layout only.
→
Print Return Confirmation and the other return actions run whatever report is assigned to the Rental Return usage on Report Selections. The Rental Setup Wizard, and the upgrade to 28.5.2, assign the Rental Return Confirmation there with its email body, unless you have already chosen a report of your own.

Packing documents

Two Word reports print what you packed on a shipment (see Containers and Packing). Both print from an open Shipment Order, from the Pack page, from a Posted Shipment Order and from the Posted Shipment Orders list, through Print Packing List and Print Container Labels. Weights print in the shipment's Packing Weight Unit. From an open shipment, both are refused while a line has more packed in containers than it ships; a posted shipment prints as it went out, leaving out cancelled lines.

Packing Documents
Packing List
For the freight forwarder or customs. The header shows the shipper and the consignee, the rental order, shipment order and posted shipment numbers, the shipping agent, agent service and shipment method by name, and the delivery country. Then each container with its contents, quantities, unit and line weights, tare, net and crane weight (a container's crane weight includes the container itself and everything in it, containers inside it included), containers inside containers indented beneath them, a Shipped loose section for anything not packed, and the totals: pieces, tare, net and gross weight. A line with no weight prints "No weight" and is left out of the totals, with a note saying how many. Layout: Standard Packing List (Word).
Container Label
One label per container: gross weight, consignee, the shipment and rental order numbers, the container code as a barcode with its description and serial number, which container it sits inside, and what is packed in it: its items with their weights under Items, and the containers inside it under Containers inside. The gross weight leaves out goods with no weight recorded. From the shipment it prints a label for every container on it, including an outer container that holds only other containers; from the Pack page it prints just the container you are filling, or every container when none is chosen. The request page's Container field does the same. Layouts: Container Label A4 (Word), one label per A4 page, which is the default; and Container Label 4 x 6 in (Word), for 4 x 6 inch thermal labels.

Choose the layout on the Packing List or Container Label usage on Report Selections - Rental, for example to print labels on a 4 x 6 inch label printer: the packing documents print in the layout chosen there. The Rental Setup Wizard, and the upgrade to 28.5.3, select both reports when nothing is selected for them yet.

Line pricing schedule on the Quote and Order

Where a rental line carries duration tiers, multi-rate date windows, or a minimum billing period, the Standard Rental Quote and Standard Rental Order print a small per-line pricing schedule under the line, so the customer can see why the line's price varies over the hire. Lines without any of these print exactly as before.

The schedule shows up to three blocks, each only when the line has it:

→
The pricing schedule is laid out on the Word (DOCX) layouts of the Quote and Order only. The RDLC layouts carry the same data but do not render the schedule, so it does not appear when you print the RDLC layout. The Word layouts are the default, so the schedule prints unless you have switched a report to RDLC.

Layout formats: RDLC vs DOCX

The layout files live in the Report Documents folder. There are two formats:

RDLC (Report Definition Language Client-side): the native BC report layout format. Edit in SQL Server Report Builder or Visual Studio's RDL designer. Produces precise pixel-level control over the printed output. Shipped for the Quote, Order, Shipment and Invoice only, and not the default for any of them.

DOCX (Word): a Word document used as a templated layout. Edit in Microsoft Word using the BC report layout add-in. Easier for non-developer customisation; layout changes happen in familiar Word controls (paragraph styles, tables, images, branding) without RDL knowledge.

Switch between layouts per report on the Report Layouts page (BC standard) or by setting the layout on each Report Selections row. Every rental report prints from its Word layout until you choose another.

Email body templates

When a rental document is emailed (Email Order Confirmation, Email Quote, etc.), the email message itself is composed from a template. The shipped templates are DOCX files in Report Documents:

StandardRentalQuoteEmailBody.docx, StandardRentalOrderEmailBody.docx, StandardRentalShipmentEmailBody.docx, StandardRentalReturnEmailBody.docx, StandardRentalInvoiceEmailBody.docx, StandardRentalProFormaInvoiceEmailBody.docx.

These are the message bodies; the attached document (the report itself) is what the customer downloads. Set on Report Selections per usage via the Email Body Layout fields. When the Rental Setup Wizard selects the reports, it turns each report's email body on too; a document type that already had a report selected keeps its own settings.

The Report Selections - Rental page

Open from Rental Setup via the Report Selection - Rental action. The page is a worksheet keyed by the rental usage (Quote / Order / Shipment / Return / Invoice / Pro Forma / Packing List / Container Label); selecting a usage at the top filters the lines below to show the assigned report sequence for that usage.

Report Selections - Rental
Usage
The rental document type the lines below apply to. One of: Rental Quote, Rental Order, Rental Shipment, Rental Return, Rental Invoice, Rental Pro Forma, Packing List, Container Label. Switching the Usage at the top filters the lines.
Sequence
Order in which reports run when more than one is assigned to a single usage. Lower numbers first.
Report ID
The BC Report object ID. Pick from the standard rental reports or any custom report built for this usage. The report's caption shows alongside.
Report Caption
Auto-populated display name of the report selected by Report ID.
Use for Email Body
When ticked, this report's layout drives the email message body text when the document is emailed.
Use for Email Attachment
When ticked, this report's output is attached to the email as a PDF (or other format per layout).
Email Body Layout
The layout that becomes the message body (a DOCX template), such as Standard Rental Order Email Body (Word). Picked from the report's layouts.
Report Layout
The layout the report prints in (RDLC or Word), such as Container Label 4 x 6 in (Word). Picked from the report's layouts. Left empty, the report prints in its default layout.
Illustration. The real screen can differ in detail. The page with Usage set to Rental Order, as the Setup Wizard's Default Report Selections option leaves it: one line, for the Rental Order report, with its email body turned on. Usage is above the lines and decides which lines you see. Report Layout is empty until you choose a layout, so the report prints in its default Word layout.

Walkthrough: swapping the standard report for a customised one

A common operational need: replace the shipped Standard Rental Order report with a customised version branded for your operation.

1
Build (or import) the custom report

Develop the custom AL Report object in your customisation extension, or import an existing one from a partner. Compile and publish so the report appears in the BC Report list with its own Report ID.

2
Open Report Selections - Rental

From Rental Setup, run the Report Selection - Rental action. At the top of the page, set Usage to Rental Order to filter the lines below to that usage's assignments.

3
Replace the Report ID

On the existing Sequence 1 line, change Report ID from the standard H2B Rental Order to your custom report's ID. Report Caption updates to match. If you want both reports to run (e.g. yours first, then the standard as a backup), add a new line at Sequence 2 instead of replacing.

4
Configure email body and attachment if needed

If the custom report should also drive the email body or attachment when emailing Order Confirmations, tick Use for Email Body and Use for Email Attachment on its line. Set the Email Body Layout fields if you have a separate DOCX template for the message body.

5
Test from a Rental Order

Open any Rental Order and run the Order Confirmation print or email action. The custom report runs in place of the standard one. Repeat for Email Order Confirmation if you adjusted the email-body assignments.

Related pages