Adjust cost and post to GL with wrong posting date

szh

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

Chinmoy

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

bbrown

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

bbrown

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.

bbrown

Of course the above assumes this is the only "problem" entry. (although the entry does not appear to be the problem)

szh

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

szh

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_Chow

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...

szh

Hi all,

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

Thanks & Regards
SZH

Alex_Chow

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...