Inventory valuation report with negative quantity

manjusree

Hi,

I have been searching the forum for almost an hour on Inventory valuation report with negative quantity. Yup, I got quite a few
ideas also. This is just to ensure that I've not missed out something important.

Causes for negative qty in inventory valuation report can be:-
1. Of course, open invoices within the valuation date range. When a user asked, I told that this could be the reason. But he forwarded 'Quantity received, not invoiced' report to me. Bad luck, none of my 'negative' items was there.
2. Sales and purchase return orders pending to be invoiced.
3. Back dated posting. Problem with 'Allow posting from-to' in G/L setup.
4. Since we are following 'Automatic cost posting to G/L', no need to worry about 'Adjust cost item entries'.

Did I include every possible reasons?. Any help would be highly appreciated .

Thanks,
Manju

crisnicolas

manjusree wrote:

Hi,
4. Since we are following 'Automatic cost posting to G/L', no need to worry about 'Adjust cost item entries'.

[-X

Navision Help wrote:

A check mark in this field indicates that the program will use the Automatic Cost Posting function.

If you use this function when posting items to an item account, the program will automatically post to the inventory account, adjustment account and COGS account in the general ledger.

If you use this function, however, it is still necessary to run the Adjust Cost - Item Entries (or use Automatic Cost Adjustment) and Post Inventory Cost to G/L batch jobs periodically. If you only use Automatic Cost Posting, your inventory account will not be accurate in cases where you do not know the cost of items at the time of sale. For example, if you sometimes sell before buying.

Alex_Chow

http://mibuso.com/blogs/alexchow/2007/10/23/why-you-have-negative-inventory-value-with-0-quantity-%e2%80%93-navision-37b-to-navision-50/

bbrown

Are we talking about "negative quantity" or "negative value"? Big difference. Your title says "negative quantity" but your problem description seems to be talking about "negative value".

manjusree

Thank u for ur posts. As of now, I am interested in quantity only. I have seen so many posts discussing negative value, but a very few about negative quantity. I think 'pending invoice' is the major problem, isn't it?

Thanks,
Manjusree

Alex_Chow

manjusree wrote:

I think 'pending invoice' is the major problem, isn't it?

No.