The option Section 1.1, “Linking a Form Name to a Report Definition and Customer”.)
, located on the menu, enables you to see a customer's default shipping form by entering a sales order number, and override it if you chose. (To see how this is set up, please seeAt run-time, the order's internal reference number is passed to the report definition in the value of the parameter cosmisc_id
. This parameter can be employed in a query that derives information from a join on the tables cosmisc
and shipto
to retrieve information pertinent to shipping labels.
The table below shows these and other parameters that are passed to the report definition and may be used to query other tables (if applicable) or display their value on the report. For example, the user's input for watermark is passed in the parameter watermark and may be referenced in a report's properties and displayed as a dynamic watermark.
Table 5.2. Parameters passed to the shipping forms reports
Field | Parameter | Table Reference |
Sales Order # | cosmisc_id | cosmisc |
Shipping Form | not a parameter | n/a |
Shipping Charges | shipchrg_id | shipchrg |
# of Copies | not a parameter | n/a |
Watermark | watermark | n/a |
Show Prices | showcosts | n/a |