Adjust cost and post to GL with wrong posting date

szhszh Member Posts: 28
Hi all,

Please help to advice below issue to reverse posted adjust cost with correct posting date.

The follwoing are the scerion are happened in the live environment.

1. Posted invoice on 30/06/2012.
2. Run adjust cost and posted to GL posting date 02/07/2012 instead of 30/06/2012.
3. Due to above wrong date are affected to all year end closing report.

Thanks
SZH

Comments

  • ChinmoyChinmoy Member Posts: 359
    You can try reversing the journal created on 02/07 and re-create a fresh journal on 30/06 by copying the lines from the previous journal.

    Chn
  • bbrownbbrown Member Posts: 3,268
    A few questions:

    1. What version of NAV?

    If version 5.0 or greater, continue with the following questions

    2. What is the "Allow Posting Date From" in General Ledger Setup?

    3. Are you using Inventory Periods? If so, what is the endign date of the last closed period?

    Version 5 changed the way Adjust Cost picks the postign date for entries into "closed" periods. While it may not be the date you were expecting, it is the "correct date". As far as NAV is concerned.

    Background

    When “Adjust Cost” is creating entries it will first attempt to use the “Posting Date” from the original entry being adjusted. If this date falls into a “Closed Period” then “Adjust Cost” must determine an allowed date to use. A date is determined to be in a “Closed Period” if it falls before the “Allow Posting From” date in “G\L Setup”.

    Version 4.0

    The default date for closed period adjustments is the current work date. This date is displayed on the report request form and the user may change it.

    Version 5.0

    The default date for closed period adjustments is the “Allow Posting From” date in “G\L Setup”. This date is not displayed on the report request form and the user can not change it.

    Scenario

    Consider a system where the current work date is today (09/11/08) and the “Allow Posting Date” is set to 01/01/08. This is a very typical setup (in my experience) to prevent users posting back into the prior year.

    Now consider that “Adjust Cost” is run and that there are several adjustments to transactions that occurred prior to 01/01/08. With version 4 those adjustments would be posted to the current day of 09/11/08 (unless the user changed the date on the request form). This is the behavior that most customers have come to expect.

    With version 5 those adjustments would be posted to 01/01/08
    There are no bugs - only undocumented features.
  • bbrownbbrown Member Posts: 3,268
    Post a credit memo to 30/06/2012. Being sure to apply to the original Item Ledger Entries. Post and run Adjust Cost with current settings.
    There are no bugs - only undocumented features.
  • bbrownbbrown Member Posts: 3,268
    Of course the above assumes this is the only "problem" entry. (although the entry does not appear to be the problem)
    There are no bugs - only undocumented features.
  • szhszh Member Posts: 28
    Chinmoy wrote:
    You can try reversing the journal created on 02/07 and re-create a fresh journal on 30/06 by copying the lines from the previous journal.

    Chn

    Thank you for your advice. I have one concern on item cost will not tie if we only adjust cost are posted to gl. Since we have adjusted item cost as at 02/07/2012.

    Regards
    SZH
  • szhszh Member Posts: 28
    bbrown wrote:
    A few questions:

    1. What version of NAV?

    If version 5.0 or greater, continue with the following questions

    2. What is the "Allow Posting Date From" in General Ledger Setup?

    3. Are you using Inventory Periods? If so, what is the endign date of the last closed period?

    Version 5 changed the way Adjust Cost picks the postign date for entries into "closed" periods. While it may not be the date you were expecting, it is the "correct date". As far as NAV is concerned.

    Background



    When “Adjust Cost” is creating entries it will first attempt to use the “Posting Date” from the original entry being adjusted. If this date falls into a “Closed Period” then “Adjust Cost” must determine an allowed date to use. A date is determined to be in a “Closed Period” if it falls before the “Allow Posting From” date in “G\L Setup”.

    Version 4.0

    The default date for closed period adjustments is the current work date. This date is displayed on the report request form and the user may change it.

    Version 5.0

    The default date for closed period adjustments is the “Allow Posting From” date in “G\L Setup”. This date is not displayed on the report request form and the user can not change it.

    Scenario

    Consider a system where the current work date is today (09/11/08) and the “Allow Posting Date” is set to 01/01/08. This is a very typical setup (in my experience) to prevent users posting back into the prior year.

    Now consider that “Adjust Cost” is run and that there are several adjustments to transactions that occurred prior to 01/01/08. With version 4 those adjustments would be posted to the current day of 09/11/08 (unless the user changed the date on the request form). This is the behavior that most customers have come to expect.

    With version 5 those adjustments would be posted to 01/01/08

    Thank you for your reply. we are using nav 4.0sp3. Normally we change allow posting date before to run adjust cost at the user setup.

    The user forgot to change posting date before run the adjust cost.

    Regards
    SZH
  • Alex_ChowAlex_Chow Member Posts: 5,063
    szh wrote:
    Hi all,

    Please help to advice below issue to reverse posted adjust cost with correct posting date.

    The follwoing are the scerion are happened in the live environment.

    1. Posted invoice on 30/06/2012.
    2. Run adjust cost and posted to GL posting date 02/07/2012 instead of 30/06/2012.
    3. Due to above wrong date are affected to all year end closing report.

    Thanks
    SZH

    Once the Adjust Cost - Item Entries is ran, there's no way to reverse it... :(
  • szhszh Member Posts: 28
    Hi all,

    Is there any better solution in order to reverse wrong posting date and post with correct posting date?

    Thanks & Regards
    SZH
  • Alex_ChowAlex_Chow Member Posts: 5,063
    No, and I wouldn't try on the inventory level. Just make the G/L journals to move them to the correct dates.

    Make sure the users are more careful next time...
Sign In or Register to comment.