Inventory Costing, period enexpected date postings

mariussw

Scenario: NAV2009SP1. FIFO, has negative inventory levels, due to the way the customer work with consignment stock. As a result Inventory periods can not be closed.

Can someone confirm whether closing inventory periods apply to FIFO as well?

Next, users has used Job Journals to utilise Inventory on in the previous fin year. Now, if we post a physical inventory journal for a single Inventory Item, we get in addition adjustments being posted, using the document number of the orginal Job Journal, at the same posting date as the original Job Journal (previous fin year), with a resulting error message that posting is not within the range of the users allowed posting date.

The fact that the system try to post in the previous fin year appears to be a bug, or do I misunderstand something?

Due to the quote from the Inventory Costing White Paper below, one would expect the posting date to move forward to the first open inventory period following Allow Posting From field in the general ledger setup, however it is not the case. In our case Allow Posting = beginning of the current fin year. Even "Close Year" of the previous year has been run (Date Locked = TRUE). The system still tries to post using the date in the previous year, causing the error. When in response setting the User Setup to allow pasting in the previous year, the system in fact proceed to post the adjustments in the prior year, in spite of the year having been closed.

Taken from NAV 5.0 Inventory Costing Technical White Paper: "The new adjustment and rounding value entries have the posting dates of the original value entries, unless they fall within a closed accounting or inventory period, or if the posting date is earlier than the date in the Allow Posting From field in the general ledger setup. When this happens, the batch job assigns the posting date as the first date of the next open period".

Inventory Setup: Automatic Cost Adjustment = Always. Automatic Cost Posting = TRUE;
Job Setup: Automatic Update Job Item Cost = FALSE;

The Inventory Items for which the adjustment is posted is not only for the Item on the single Journal Line.
Item Card "Cost is Adjusted", "Cost is Posted to G/L" fields are set (TRUE) for all the related Items, prior to the posting.

Alex_Chow

It applies to all costing methods.

When you want to close the inventory period, the inventory quantities, at that point in time, has to be greater or equal to 0.

mariussw

Any indications if

1) NAV should respect Allow Posting From date as specified in G/L Setup, as I could not see that happening.

2) NAV should allow posting into a closed year? Date Locked = TRUE for the periods. I could see NAV allowing it to be violated, if User setup allows posting into the locked periods.

3) Any reason why NAV would post adjustments for a bunch of items unrelated to the Item in the Physical Inventory Journal line (one line posted in journal only)? Even if the Items Card indicates that cost is adjusted and cost is posted to G/L for all these Items, before the posting is made?