Forum Discussion
Solved
Inventory / stock checking discrepancy
Hello. I have done a stock check and would like to see the positive and negative quantities and costs. I don't know what formula I should use. The physical count of the stock is column D and the stock that our system shows is column E.
- Hi there - thats right I'm looking for a formulae in I and J to show if there is a positive order negative amount and value
6 Replies
helsbrooks1981 Added some formulae in I and J. Is that what you had in mind?
- Hi there - thats right I'm looking for a formulae in I and J to show if there is a positive order negative amount and value
helsbrooks1981 and you noticed the file I attached with the formulae in it?
