Average Costing method- Value to become 0 when quantity is 0

tthyagu

Hi,

I work in Nav 4.0 SP3

The costing method is Average.

I have completed the required batch processes.

When I take the inventory valuation report, for some items, the quantity has become 0. But some values are shown. For some items postive value and for one item negative value, but the quantity is 0.

How to make the value also 0 when quantity has become 0.

I need help on this issue.

Thanks & Regards
TTHYAGU

Alex_Chow

The reason has been explained here:
http://dynamicsuser.net/blogs/alexchow/ ... n-5-0.aspx

And becareful of this:
http://dynamicsuser.net/blogs/alexchow/ ... dates.aspx

You can prevent it with proper use of Allow Posting From and Allow Posting To

jversusj

i have seen cases, however, where the allow posting from/to is meticulously controlled and the adjust/cost routine is run nightly and we still see unusual cost issues (like an adjustment posted back to April when the adjust ran in October and the allow dates were only for october). some people have suggested it is because we have not closed the inventory period, but I have not found much regarding inventory period in our Nav (3.7b). we are using the 5.0 client, so when i check the help i see "inventory period" as a table, but that table is not in our objects. this suggests this is new functionality. can anyone confirm?

we use average cost.

Alex_Chow

Yes, the inventory period functionality is only in objects for version 5.0 forward.

When you run your ACIE, is it possible that the user set the Posting Date to April while your Allow Posting From date is set to October?

jversusj

Alex Chow wrote:

Yes, the inventory period functionality is only in objects for version 5.0 forward.

When you run your ACIE, is it possible that the user set the Posting Date to April while your Allow Posting From date is set to October?

thanks for the info on 5.0.

our ACIE job is automated via NAS. The dates being used should all be programmatically defined (and/or limited by the allow posting from/to) it does not seem to be something that happens a lot, but it has happened.

thanks again for inventory periods info.