Using Weights and Dimensions in reporting

Description

This document explains how to set up items to allow reporting on item weight, dimensions and cubic.

With any reporting system, information needs to be entered and available in a structured format to allow accurate reporting.

Detailed Steps

WMS provides user-defined fields for additional reporting.

In this instance, we advise if you only require WMS reports to provide the information that you enter the data in the additional fields in the WMS.

This leaves the Accounting software fields free for more financial related items.

When entering the data into the fields, there should be an agreement on the data formats in the fields.

For example:

Decide on “mm” or “Mtrs” for measurements, selecting one type only and “gm” or “kg” for weights using one type only.

When entering the fields, it’s best to use only the numbers, such as “310 x 410 x 120” for dimensions and “14.124” for weight.

Avoid variations of these formats such as “310cm x 410cm x 120cm” or “310x410x 120” and “14.124kg” or “14. 124”.

Once the data is entered, the fields can be used in reporting.

Related Information

If your company uses Units of Measure - the weights and dimensions should be entered per unit or quantity, not a mixture of both.

User can also enter Length, Width and Height in to three separate fields for ease of use in reporting; however, we recommend combining them in a defined format to allow the additional fields to be used for other purposes such as colour, type, material, Dangerous Goods codes etc.