How would you go about making an Inventory Count Adjustment

[NYFashionToGo]

Hello, I have access keeping inventory for me. I have a PO account where I Originally enter the data and sales where it deducts the amount. Everything was working perfectly .... Until now.... I need to make an adjustment to the numbers so I show a zero quantity rather than 1.

Can anyone recommend a way to do such a thing? to add or subtract a value. so everything still is correct.

 

[Golom]

You want to adjust what exactly? Every stock item? Only those where the current quantity is 1?

If it's the later then

UPDATE Inventory SET Quantity = 0 Where Quantity = 1

But you need to think about this a bit more. Making this kind of adjustment to inventory levels leaves no tracks and you can have a tough time reconciling the numbers in your database with transaction records in other parts of the system. Perhaps you need a table to identify adjustments with a DateTime stamp for when the adjustment was made and a reason for why it was made.

 

[JoeAtWork]

I need to make an adjustment to the numbers

And where do these "numbers" reside? It's impossible to make a recommendation if you tell us nothing about your database design, table structures, etc.

If you are a using a transactions table, I would create a special type of "adjustment" transaction, along the lines Golom suggested.

 

[missinglinq]

The overriding question here, I think, is why you have to make an adjustment. Was the item damaged? Has it simply disappeared from stock? Has it been donated to charity? Ass golom suggested, you need to have a way of doing this so that down the line you can tell where it went. You apparently currently track where inventory goes by tracking sales to buyers. Perhaps you simply need to set up an dummy inhouse "account" to cover the kind of losses mentioned; either one "account" for each type of loss/reduction, or a catchall "account" for all non-sales reductions in inventory.

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[NYFashionToGo]

Yes missling It is along those lines. Damaged. Returns that can not be resold... That is a great Idea about creating that kind of account specifically for these type items.......

Thanks I think I can take it from here.