Documents and Reports Questions and Answers

What is the syntax for number formatting strings?

Number formatting strings use a syntax similar similar to Microsoft Excel and other Microsoft products. Key points:

• Use a # symbol as a placeholder for a numeric digit.
• Use a 0 symbol as a placeholder for a numeric digit, padding the number with zeros on the left.
• Use . for the decimal point. Numeric placeholders to the right of the decimal show the precision to be printed for the number
• Add a % symbol to display the number as a percent (multiply by 100)
• Other text and punctuation is place unmodified in the output.

Examples:

How do I get EX Numbers to appear on my bill of lading?

EX Number appear by default on the Bill of Lading, but if you've edited your template here is how to get them to appear again:

In application settings you can customize the bill of lading to include the EX numbers for all products in the shipment. The EX numbers are automatically sorted and duplicates are removed. The following template will print the correct basic description on the first line for each hazardous material, followed by the EX numbers in smaller text.

  {{#if hazardousMatBasicDescription}}{{hazardousMatBasicDescription}}
  <br/><small>EX Numbers: {{exNumberListFormatted}}</small>
  {{else}}Not hazardous
  {{/if}}

The template needs to be set on the Entry description field in Application Settings, Documents tab, Bill of Lading sub-tab.

How do I print to Dymo, Wasp, Zebra, or other barcode label printers?

Create a report with the information that is required to appear on each label. Set the "Page break" option on the last primary column so that each label's information appears on its own page of the report. Create a page template for the report and set a custom paper size for the page template to match the size of your label, and customize the page template to place the fields from the report where you want them to appear on the label. In the formatting section of the report, make sure the page template you created is selected as the page template to use for the report. Now when you print the report to PDF, each label should appear on its own page which should match the size of your labels, and your label printer will be able to print the PDF on to the labels.

How do I print a reports showing the total cost, price, weight, or NEQ of a magazine / sub-location?

Use the stock history reports to print totals of various values for specific magazines / sub-locations. These reports correctly include the values for all stock as well as any packed shipments. Find the stock history reports page by going to the reports page (linked from the top nav and the home page), and then select the link for "Stock history reports" in the section labeled "Stock reports".

The totals columns need to be enabled in the table of available columns near the bottom of the page. The reports can be run on all magazines / sub-locations or can be filtered to specific one. Find the totals for specific date, select a date range that ends on the date in question (this will exclude all transaction after the specified date).