Ensuring that quantities on hand match manual inventory counts

(0) Share

Report

Posted on by Community Member Microsoft Employee

I am trying to enter a stock entry count for some raw materials for which I never tracked usage before.

we are doing an end of year inventory count.

I created a stock schedule

I entered the counted value of say 10000 into the counted qty field in the stock entry dialog box.

My qty on hand for this material prior to manual stock entry was -66000. I processed the stock entry and the qty on hand is now -76000. I cannot enter negative values into the counted qty field. How can I correct this? I.E qty on hand = counted inventory value.

Someone earlier this year played with issuing purchase orders this year. We have a couple of valid purchase orders but have produced more finished goods using this material then purchased orders entered.

We are trying to reuse the system for purchase orders consistently from now on.

How do I get my qty on hand to match the counted value of inventory?

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

Ian Grieve 22,782 on at

Like (0)

Report

RE: Ensuring that quantities on hand match manual inventory counts

You can enter a negative Adjustment or Variance in Inventory Transaction Entry.

Before doing so, I'd recommend running an Inventory Reconcile to ensure that values are correct before doing an adjustment.