Batches/Lots
Home Products Support Downloads Feedback Contact Us


Back


The optional Batch / Lot Inventory module will provide complete tracking for small parts (consumables) inventory items. This will provide you with better cost reporting and better traceability directly back to PO's for a specific part. This could be invaluable for tax reporting purposes, or in the event of an aircraft problem, audit, etc.

Be aware that the Batch / Lot Tracking function tightens your Inventory control and management. Users will be forced to enter a valid batch or serial part when using Inventory parts. Parts in your Inventory database cannot be used on a Work Order or Invoice unless a valid batch or serial number is on hand.

The Batch Tracking system works primarily with your PO Receive functions. As items are received in on PO's, they are assigned to individual batches for each part number. A Batch # is assigned by AVM-2000, and an optional User Tracking # is available for you to enter your own number. (Note: New Batches can also be created from within the Inventory database.)

EXAMPLE:

1) You have 5 lamps # 330 in stock for $ 0.85 Cost, $ 1.35 List. Batch # is 2396.
2) You order 20 more lamps # 330 on a PO for $ 0.65 Cost, $ 1.25 List.
3) You receive in 10 of those lamps on 12/01/1998. A batch of 10 is created and assigned to part # 330. This batch gets its own batch # 2469 assigned by AVM-2000. You enter a User Tracking # of 95-4597.
4) On 12/07/1998 you receive the remaining 10 lamps. A batch of 10 is created and assigned to part # 330. This batch gets its own batch # 2575 assigned by AVM-2000. You enter a User Tracking # of 99-6584.
5) During use on Work Orders or Invoices, you enter part # 330. AVM-2000 realizes you have one or more batches for this part. You will be forced to choose which batch # the lamp you've used has come from: Batch # 2396, 2469 or 2575. Remember that Batch # 2396 has different pricing than the other two batches.

This type of function is dual-purpose. In the future, you can track down exactly which "Batch" and/or PO/Vendor that a part you used on a job came from. You will also have exact reporting for Costs of Inventory Used/Sold because each batch is using its own individual Cost values. Each Batch can also be assigned its own Classification, AEA Condition and ILS Condition, allowing you to generate more accurate Inventory reports.

The assigned Batch # and User Tracking # can print on a Shop PO, Shop Detailed WO, and basic Inventory report.

If you are "turning on" the Batch Tracking function, you must also Convert your Inventory at the same time. This will convert all of your existing Inventory items for use with the batch functions. Each non-serialized part # will be assigned a new batch that contains the current total QOH for that part.

IMPORTANT NOTE: If you use SKU Labels for Inventory, be aware that all OLD SKU Labels printed before the Batch Conversion will be incorrect !

OTHER NOTES: Inventory items will not be allowed to have a negative QOH while Batches are in use. The Inventory Part # "Combine" function will not be available while Batches are in use.

Detailed instructions about Batches can be found in the Inventory section of the AVM-2000 Help system or the AVM-2000 User's Guide. Information about Batch use can also be found in the Purchase Orders section, the Work Orders section and the Invoices section of the AVM-2000 Help or User's Guide.

REQUIREMENTS:

bullet

Users must be running AVM-2000 version 4.70 or above and have the optional Batch/Lot Tracking module registered.

Return to  AVM-2000 Feature Upgrades  (for existing users)

Return to AVM-2000 Features (for new users)

 

19 David Drive, Belmont, NH  03220  USA

(603) 524-5544 Voice      (603) 528-6213 FAX       (888) 826-4622 Toll Free

sales@tangoware.com