Posting From/To date problem

TomekJot
TomekJot Member Posts: 23
edited 2010-06-18 in NAV/Navision Classic Client
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.

Comments

  • Savatage
    Savatage Member Posts: 7,142
    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.
    Harry Ruiz
    http://www.BiloBeauty.com
    http://www.autismspeaks.org
  • Alex_Chow
    Alex_Chow Member Posts: 5,063
    The inventory cost posting is determined from Allow Posting From from the G/L Setup.

    It's explained in the inventory costing manual.
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • TomekJot
    TomekJot Member Posts: 23
    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
    Alex_Chow Member Posts: 5,063
    The costing proces does not consider the allow posting from on the user setup...
    Confessions of a Dynamics NAV Consultant = my blog
    AP Commerce, Inc. = where I work

    Getting Started with Dynamics NAV 2013 Application Development = my book
    Implementing Microsoft Dynamics NAV - 3rd Edition = my 2nd book
  • Andwian
    Andwian Member Posts: 627
    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.
    Regards,
    Andwian

Categories