Posting From/To date problem

TomekJot

Hi everyone. I don’t understand why Nav in my scenario uses a different date in Value entry. I’ll be very happy if somebody can give me any suggestions.

Real date is 10.06.15
User “X”:
1.Posted Purchase Invoice on date 10.05.20: 1 pcs for 10 USD;
2. Posted Purchase Credit Memo on date 10.05.20: 1 pcs for 9 USD;

In this scenario – in Value entry (credit memo) appeared two entries, which are correct but I’m curious about the date:

Posting Date Document No. Cost Amount (Actual)
2010-05-20 Z/10/05/011 -9
2010-06-01 Z/10/05/011 -1

-why second entry has a 01.06.10 date – I understand that there is a first date of open period for every users; but shouldn’t been this date taken from user settings and according to this – shouldn’t be there a 10.05.20?

General Leder setup: Allow Posting From/To 10.06.01 .. 10.06.30
User “X” Setup: Allow Posting From/To 10.05.01..10.06.30
Dynamics Nav 5.0 SP1

Thank you In advance.

Savatage

I believe the user setup dates override the g/l setup dates if you are using both.

we just use the g/l setup dates, none on users, that way we don't have to keep updating each users date range each month.

Alex_Chow

The inventory cost posting is determined from Allow Posting From from the G/L Setup.

It's explained in the inventory costing manual.

TomekJot

Thank you for swift reply
Savantage – unfortunately it’s very common here that postings periods are different for all and specific users, so there is no possibility at the moment to use only one-general period for everyone.

Alex Chow – thank you for explanation. Apart from costing’s manuals I think that NAV Help for “Allow Posting From” field in GL Setup could be a bit confusing in this part “If the User Setup window does not contain an interval, the program checks the date in the Allow Posting From field”. – so if the user has a “user’s date” from 10.05.01.. in my scenario why to check it – if 1 USD correction in Value Entry is made with 10.06.01 date.

Greetings

Alex_Chow

The costing proces does not consider the allow posting from on the user setup...

Andwian

ADJUST COST – ITEM ENTRIES


The following describes some different example scenarios of when Adjustments are made in regards to the Adjust Cost - Item Entries batch routine.


5.0 Scenarios – Adjustment Value Entries – 1st Available Open Date from GL Setup or Inventory Period

Automatic Cost Adjustment = Always
1. PO Receipt, Posting Date 01/01/08 $10 Cost
2. Sales Invoice, Posting Date 01/01/08
**All Scenarios below are based on Steps 1 and 2 above.


Scenario 1
3. Set Allow Posting From and To Dates:
GL Setup 01/01/08 – 02/28/08 (MM/DD/YY)
User Date 02/01/08 – 02/28/08

4. Reopen the PO, change Posting Date 02/15/08 and $11 Cost, Post Invoice….


5. Change GL Setup to 02/02/08 – 02/28/08 (From Date is within User Date Range)

6. Post Invoice
ILEs


VEs - Note the 02/02/08 Adjustment for the Sale




Scenario 2 To illustrate a prior version example Results- 4.0 SP3 Objects
(Repeat Steps 3 – 5 in Scenario 1)

6. Post Invoice
ILEs


VEs – Sale Adjustment Date is the same as the PO Invoice Date



Scenario 3
3. Set Allow Posting From and To Dates:
GL Setup: <blank>
User Date 02/01/08 – 02/28/08

4. Reopen the PO, change Posting Date 02/15/08 and $11 Cost, Post Invoice….


Resolution – To enter an ‘Allow Posting From’ date within GL Setup which is within the User Date Range…OR… Set the ‘Allow Posting From’ date for the User back to 01/01/08 to allow for the adjustment on the Sale Invoice date.

Scenario 4 - With January 2008 Inventory Period Closed
(Repeat Steps 3 & 4 in Scenario 1)
Result from posting the Invoice (No Error)….
VEs – Now the Sale Adjustment is posted with the first available open date, 02/01/08… (in regards to Inventory Period dates).


Note – The first available Open Date 02/01/08 still must be within the User Posting Date Range (02/01/08 – 02/28/08). If User Date Posting Range was 02/02/08 – 02/28/08, the Posting Date Range error would have occurred.