How To: Show Availability on Picking Tickets / Despatch Notes using Basic Reports


WARNING icon
Basic Reports Setup is an Advanced User feature.
WARNING icon
WARNING: Before making changes to ANY of your Basic Report templates it is advisable to take a backup.

This functionality allows the user to add the Availability field on the [ Stock | Detail | Properties ] screen into the Picking Tickets / Despatch Notes using Basic Reports. In order to use this functionality, it will first need to be configured using the Report Builder Designer tool.


  1. Follow the menu route [ System Operations | Basic Reports Setup ] to open the 'Basic Reports Setup' dialog.
  2. Double-click on the 'Picking Ticket/Despatch Note Report'.
  3. Press the Basic Reports Design button button to open the Design tab and edit the selected report template.
    Note: select the brand if one has been setup before using the Design button.
  4. Click on the section tab srDetails: DBDetails located beneath the layout area in the centre bottom of the screen.
  5. Click on the DBText button button on the Data Components toolbar at the top.
  6. Click in the relevant area to add the DBText field, for example the Detail area.
    Basic Reports - Click and drag in the relevant area to add the DBText field
  7. Make sure the DataPipeline is set to DBBase in the area at the top of the screen and from the drop-down to the left select stock_availability.
    Basic Reports - stock_availability.
    Note: you can also set this using the Object Inspector bar on the left. If the Object Inspector pane is not visible right click anywhere under the Report Tree (usually on the left side) and select it from the Context Menu.
  8. Set or match the size and fonts as desired in the Layout and Text areas on the left.
  9. Once complete save the report template changes by using the menu option [ File | Save ].

See Also


Did you find this article helpful?