How To: Show Total Weight on Sales Invoice Report

Basic Reports Setup is an Advanced User feature. You can customise Sales Invoice reports to show the weight of individual invoice lines and the total weight of the items being shipped. 
Warning: Before making changes to any Basic Report template, take a backup of the existing template.

Before you begin

You need Admin permission to access Basic Reports Setup, and Basic Reports functionality must be enabled on your system. 

The calc_weight_sent field is available in the DBDetails data fields. It displays the weight of the stock being sent, using either the calculated Average Weight or a weight manually entered during Confirm Shipment. 

Add the total shipment weight to the Sales Invoice

  1. Go to System Operations > Basic Reports Setup.
  2. On the Reports List tab, double-click Invoice Report to load its settings.
  3. Click the Design button to open the Sales Invoice template in Report Builder Designer.
  4. Select the srDetails: DBDetails section tab at the bottom-centre of the Report Builder window.
  5. Locate the Summary area.
    Note: If the Summary area is not visible, select Report > Summary from the menu at the top of Report Builder.
  6. From the Data Components toolbar, select the DBCalc component.
  7. Click and drag within the Summary area to add the DBCalc field.
  8. With the new field selected, use the Object Inspector on the left to configure:
    • Data > DataField: calc_weight_sent
    • Text > DisplayFormat: Weight: ###,##0.00kg
    Tip: If the Object Inspector is not visible, right-click beneath the Report Tree and select Object Inspector from the context menu.
  9. Adjust the field's size, position and font to match the rest of your invoice.
  10. Select File > Save to save the report template.
  11. Test the Sales Invoice and check that the total weight is displayed correctly.
  12. If necessary, return to Report Builder and adjust the positioning or formatting.
Note: The Summary section appears directly underneath the invoice items. It does not automatically appear at the bottom of the page.

Display the weight of individual invoice lines

You can also add calc_weight_sent directly to the Detail area of srDetails: DBDetails when you want each invoice line to display its own weight.
The field is available from the DBDetails data source and represents the weight of the stock sent for that invoice line. 
For more information about configuring Basic Reports, see System Operations - Basic Reports Setup. 


See Also


Did you find this article helpful?