Serial/Lot and Dimension Item

You cannot select the Suspense option for items that are serial/lot controlled and dimension controlled because dimension quantities must be matched against serial/lot quantities when the transaction is entered.

Note: The example below assumes the Inventory Module Control option Assign dimension by individual serial/lot is not selected. If this option is selected, the method for data entry varies.

Example of transaction line entry for a lot and dimension controlled item

  1. Enter a transaction line quantity of 1200 metres.
  2. The Serial/Lot Number Entry form displays, and you enter lot details.
  3. The Required quantity is always equal to the line quantity, and you must enter lot quantities which add up to the quantity if the calculated Difference is zero. You cannot enter dimension details unless the Entered quantity is equal to the Required quantity.

  4. Click OK to proceed with entering dimensions.

The form and column headings reflect the dimension type that is assigned to the line item. For example, the dimension type is Length.

The Required quantity defaults from the transaction line quantity. This is converted into the stocking unit of measure if a purchasing or selling unit was used on the line, and an item-specific or generic unit of measure conversion applies. You must enter dimension quantities so that the Entered quantity equals the Required quantity. You cannot save the dimension details (and the transaction) unless this condition is met.

Any dimension quantity entered must also be for a specific lot. The lot number must be selected first on the dimension line, before the dimension quantity is entered.

You can only select from a list of lots previously entered using the Serial/Lot Entry form. You cannot save the dimension details (and the transaction) unless the sum of dimension quantities entered for a specific lot is equal to the total quantity for that lot. For example, you must enter a quantity of 600M for Lot 0001 (which can consist of one or more dimension quantities), and a quantity of 600LM for Lot 0002.

After the lot is selected, you must select the dimension. The Qty Avail Units and UOM defaults in read-only format to the current available quantities for the specific item/lot/dimension combination.

Note: If locations are in use, the quantity available uses the location that was entered into the transaction line.

You must enter the Qty Units, which is the number of pieces of the selected dimension. Greentree Desktop applies the dimension conversion to calculate and display, in read-only format, the Qty UOM on the line. In this example, the conversion for 1.2 length = 1.2, so 500 units converts to 600M, if M is the item's stocking unit of measure.

Note: Total units value on the form header updates with the number of pieces entered as each new line is added.

The dimension details can be saved by clicking OK when the Difference is zero, which indicates the sum of the Qty UOM for each dimension in the table is equal to the Required quantity, and lot quantities have also been validated in the transaction line.

You can press Cancel when entering a transaction to close the form without saving changes. You can't save the transaction until both serial/lot and dimension details have been entered and quantities have been validated.

Once the transaction outlined in this example is saved, the item parent and dimension quantities is updated, and can be viewed using the Location Balances by Dimension enquiry.

For a serial/lot and dimension-controlled item, a special condition applies for transactions that have a decreasing effect on inventory. If the Quantity entered for a lot (on the Serial/Lot Number Entry form) is equal to the complete quantity available for the item/location/serial/lot combination the entire contents of the lot are being adjusted by the transaction), then when the Enter Dimension Details form displays, it is pre-populated with the dimension details and quantities for that lot.

Data Entry Variations

There are three Inventory Module Control options which allow for a variation in the way dimension details are entered for items that are both serial/lot and dimension controlled: