Receiving Goods in Two Quantities
Goods may be purchased and received in two different quantities. However, there may be no fixed conversion between these two quantities, and the only time the two quantities are known is at the time of receipt. This is different to unit conversion where there is only one quantity but different units of measure.
For example, goods are ordered in meters with the cost recorded as euro's per meter, but they use the base item unit of lengths in the inventory. There is an approximate conversion rate between meters and lengths which varies with every delivery within an agreed balance. When the goods are delivered, the inspection team records the exact number of meters and lengths received. The exact conversion factor between the two quantity units is then calculated by the system. After the goods receipt stage the items use the base item unit of lengths.
Setting up Your System
To achieve this you must set up your system with two independent value labels of the same type as those being marked as the two quantities to be used. For example, Qty and RNQty. Within Purchase Type or Movement Type, the first value label is marked as the Purchase Quantity or Movement Quantity, as normal. This is the quantity that updates stock and is used as the 'controlling' quantity within the system. For example, lengths in the above example. This quantity also drives invoice matching, cancel quantity, quantity complete at each stage, and so on.
The second quantity is highlighted as the 2nd RN Quantity. This quantity is the second quantity used with receipt notes as another quantity to be used.
If the Recalculation flag is set against the RN stages, then a formula can be used to calculate the actual conversion rate between the two quantity value labels.
Purchase Type Values Setup
- Purchase Quantity
Define a value for the purchase quantity to be used.
- 2nd Receipt Note Quantity
Define a value for the 2nd Receipt Note Quantity to be used.
Movement Type Values Setup
- Movement Quantity
Define a value for the movement quantity to be used.
- 2nd Receipt Note Quantity
Define a value for the 2nd Receipt Note Quantity to be used.
Purchase Type
- Prevent Costing Update at
Invoicing
If this is checked, it prevents costing being carried out at the Invoice Entry, Matching and Confirmation stages.
Inventory Receipt Note Entry
On receipt of the goods, you should enter the quantity (for example, of lengths) and unit of measure, and the second quantity (for example, of meters) and unit of measure.