Hello Susan:

It sounds as if you are building an Adjustment batch under LIFO/FIFO.

One of the columns in the Adjustment batch is Lot #. However, unless you have a lot of patience to edit the "batch" after importing, the practical solution is to use Lot #1 and fix the problems later.

Fortunately there is an easy way to fix the problems after posting (where Lot 1 is now negative and Lot 2 or 3 is too high).
-Create an Account Set with "Moving Average" as the costing method.
-Locate the first problem item
-Change the Account Set from the current to the new one you just created.
-Save the item
-Re-open the item - you will notice that all items have been rolled up into Lot 1.
-Change the Account Set back to the original (the FIFO/LIFO) one.

Use the same technique for the other items. This must be done item-by-item; the changes cannot be imported successfully. Steve Schwartz originally suggested this technique so you should be able to find his postings on the topic elsewhere in the Forum.