Negative Qty On Hand Inventory :: Adjust Inventory with Negative

Epicor ERP 10
1

Team. I’m running into an issue with Epicor. Some customers want to adjust the inventory but it does not take negative Values. How can they adjust the inventory ?

2

They should be able to enter a negative. Note, they must enter a reason in order to make an adjustment.

1 Like
3

@windowsmanager
Are you using “Quantity adjustment” form to adjust ?
Does the part have on-hand quantity ?

4

Yes, it has a negative Value…

5

If the QOH is -10 and you want it to be zero, enter a Qty of 10 in Adjust Qty program.

In addition to selecting a Reason code, you must select the Bin you’re adjusting too.

If the problem is that you actually have 15 physically on hand, but the system says you have 25 in bin A, and -10 in bin B (which nets to 15), then use an Inventory transfer to move 10 from Bin A to Bin B.

edit

Also there is a company level setting that can disable transactions that would cause QOH to go negative.

1 Like
6

Thank You for the reply. Yes, we were able to do that … Thanks again …

7

@windowsmanager,
cross check the part class setup.
If the “STOP” option selected for the negative quantity action. It will not allow negative on-hand transaction.

image
image836×365 14.5 KB

8

If we do this to 0 -ve qty…
Is there any impact on any GL.
Please tell

9

A Quantity Adjustment will create GL transactions. As the value of inventory will change.

If you do inventory transfers to zero out a bin, then there should be no GL transactions. Because the total inventory qty remains the same.

10

we have the problem is that you actually have 0 physically on hand, but the system says you have 39 in bin A, 6 in bin B and -45 in bin C (which nets to 0), then which method we should use to adjust qty. Its urgent please suggest asap.

11

@aarti
Could you cross check the UOM in each bin and the Inventory UOM in the part master.
Are they same ?
If the answer is yes, then use the UOM split merge option.
Material Management → Inventory Management → General Operations → UOM Split / Merge.

1 Like
12

You should be able to use ‘Inventory Transfer’ to move the part from the positive bins to the negative bin and bring the negative bin up to zero.

1 Like