This document explains how to setup 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.
MYOB provides three Custom fields and WMS provides six custom 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 MYOB 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.
Decide on “mm” or “Mtrs” for measurements, selecting one type only and “gm” or “kg” for weights using one type only.
When entering in the fields it’s best to use only the numbers for example “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.
If your company uses Units of Measure - The weights and dimensions should be entered per unit or per quantity, not a mixture of both.
Length, Width and Height can also be entered into 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.
Fields can be imported in mass both into MYOB custom fields and WMS User Defined Fields.
For information about MYOB import/export please review the MYOB knowledge-base.