Adjusment from a physical inventory

[Mary]

I have this batch, that was created during a phisycal inventory. this batch
is making an adjustment to leave quantity and cost in zero, which is correct.
But batch is partially released and log establishes that quantity is gonna be
less than zero which is not true due to the fact that I have 1 piece on hand
and is avialable . I thought it was about cost because as you know, sometimes
SL mess around with decimals, but this is not the case either. I have checked
itemsite, itemcost, location, intran, batch, loctable and all of them have
consistent data. Is there anything like this that you have been through?? Pls
help me!! :)

Thanks in advance.

[wang fang]

How do you make adjustments?

Submitted via EggHeadCafe - Software Developer Portal of Choice
Changing WCF Service Implementation at Runtime
http://www.eggheadcafe.com/tutorials/aspnet/d9263dcc-f7ed-42f3-bc96-321461be3306/changing-wcf-service-implementation-at-runtime.aspx

[Mary]

in screen Adjustments (10.030.00)

"wang fang" wrote:

> .
>

[Gail J-N]

In my experience, the three major reasons that Physical Inventory batches
fail to release are:
- one of the inventory items has a Transaction Status of "Inactive" when
batch is released
- there is a cost to quantity imbalance for one of the inventory items
- for systems not allowing negative inventory (or for any lot/serial
tracked item), the quantity will go negative for an item

If you have a Cost to Quantity imbalance, then any transaction for that item
will fail (receipts, sales, transfers, adjustments, etc.).

What your log is telling you is that the problem is the adjustment will
cause inventory for that item to go negative, and your system doesn't allow
negative quantities.

Having an "Available Quantity" is different than an "On Hand" quantity.
The Physical Inventory adjusts "On Hand" quantity, and the "Available
Quantity" is recalculated as a result.

You can often use the Inventory integrity check (10.990) for a specific item
to correct a specific item. Preferably with no one else in the system, and
after a backup.

If you have a Cost to Quantity imbalance, you run it this way:
Check "Validate Inventory", which makes more items appear
Check "Rebuild Quantities and costs"
Enter "Inventory ID"
Optionally you can enter Year and Site. If you have deleted transaction
history, you may want to go back to last year.
Hit "Begin Processing"

This procedure recalculates location/itemsite/itemcost/lotsermst using
ItemHist/Item2Hist and INtran/LotSerT, and makes sure that they agree.

Once complete, you can try to re-release your Physical Inventory batch.

If the quantity is going negative for that item, you'll have to adjust
quantity for the offending item to offset the amount the phsyical inventory
batch will be posting. Then re-release the Phsyical Inventory Batch. At
that point, you'll have to look at the item's quantity on hand after
processing the physical inventory batch, and compare to what it should be to
determine if an additional adjustment should be made.

You can also use the Inventory Integrity check (10.990) to fix "Quantity
Available". Simply check "Rebuild Order Quantities", and hit "Begin
Processing". This process will add up all PO, Sales Order, Shipper, and
Work Order quantities, and recalculate Quantity Available in all sites for
all items. In a large database, this can take awhile. Preferably, it
should run after a backup and with no one else in the system.

Hope this helps.

Best regards,

Gail J-N