Allocating Serial and Lot Numbers in Material Transactions — Overview

Sage ERP Accpac Project and Job Costing 6.0

Allocating Serial and Lot Numbers in Material Transactions — Overview

If you have a license to use Sage ERP Accpac Serialized Inventory and Lot Tracking, you can allocate serial numbers and/or lot numbers to items that you remove from or return to inventory in material usage and material returns transactions.

When you process material usage transactions that include serialized or lotted items, you use the Serial/Lot Numbers Allocation form to allocate serial numbers or lot numbers to items in a transaction detail.

An inventory item is serialized if the Serial Number option is selected in the I/C Item record.

An item is lotted if the Lot Item option is selected for the item in the L/T Item Defaults form.

When you return serialized or lotted items to inventory in material return transactions, you use the Serial/Lot Numbers Generation form to reassign serial numbers or lot numbers to the items you are returning in each detail.

Note: You can use the PJC Adjustments form to transfer material usage or material return transactions for serialized or lotted items to a different contract, project, or category. However, you cannot adjust these transactions using the Adjustment type. If you need to change the quantity or an item number used in a transaction, you can process a material return, then process another, correct, material usage transaction using the correct quantities and items.

Before you can allocate serial numbers or lot numbers to items in transactions:

  • Sufficient serial numbers or lot numbers must available for the item at the inventory location from which you are shipping the items.

Use the Serial Number Inquiry and Lot Number Inquiry forms in Inventory Control to check whether serial numbers or lot numbers are available for the items you plan to use in a material usage transaction.

If the I/C item record allows the serial quantity or the lot quantity to be different from the entry quantity, you can post a transaction even if you have not allocated numbers to the total quantity of serialized or lotted items.

  • If you are returning serialized inventory, identify the serial numbers assigned to the items, as well as the contract, project, category, and resource used in the transaction that transferred the items to the job.

  • If you are returning lotted items to inventory using material returns transactions, identify the lot, or partial lot, from which you are returning items.

To allocate serial numbers in material usage transactions

To allocate serial numbers in material return transactions

To allocate lot numbers in material usage transactions

To allocate lot numbers in material return transactions