Average Cost Period must not be in Accounting Period GB

xSwazi

Hi,

I get this error message when I try to run the Adjust Cost-Item Entries batch job in the GB version of Microsoft Dynamics NAV 2009 Service Pack 1: Average Cost Period must not be in Accounting Period GB Period type='Year'. Note: I see also that there is a knowledgebase article 970763 for the NAV 5.0 SP1 upgrade and I wonder if it is the same problem as I am having?

I have upgraded a customer database from NAV 2.6 (Financials) using the upgrade toolkits, first to version 4 sp3 and then to 2009 SP1..

My problem is that my site is live and has been for almost a week. How do I fix this now as I can not change table 10560 (to select an Average Cost Period), nor can I re run the codeunit from the upgrade toolkit???? ](*,) . I have created a test DB to try any suggestions...

Help much appreciated... [-o<

DenSter

The first time you are running adjust cost in an upgrade project is a week after they go live?

xSwazi

It seems so.

I did run the update job in 2.6 last thing before the upgrade and I thought I had run it after the upgrade too (but there is nothing in the upgrade instructions that suggests this).

The users run the job weekly as prices do not change much at all.

How can I change the Calendar setup table now which looks like this:-


Period Period Period Period Period Average Average Closed
Type Start End No. Name Cost Cost Calc.
Period Type
Year 01/07/92 C30/06/93 1992 1992 Yes
Year 01/07/93 C30/06/94 1993 1993 Yes
Year 01/07/94 C30/06/95 1994 1994 Yes
Year 01/07/95 C30/06/96 1995 1995 Yes
Year 01/07/96 C30/06/97 1996 1996 Yes
Year 01/07/97 C30/06/98 1997 1997 Yes
Year 01/07/98 C30/06/99 1998 1998 Yes
Year 01/07/99 C30/06/00 1999 1999 Yes
Year 01/07/00 C30/06/01 2000 2000 Yes
Year 01/07/01 C30/06/02 2001 2001 Yes
Year 01/07/02 C30/06/03 2002 2002 Yes
Year 01/07/03 C30/06/04 2003 2003 Yes
Year 01/07/04 C30/06/05 2004 2004 Yes
Year 01/07/05 C30/06/06 2005 2005 Yes
Year 01/07/06 C30/06/07 2006 2006 Yes
Year 01/07/07 C31/12/08 2007 2007 Day Item No
Year 01/01/09 C31/12/09 2009 2009 Day Item No
Year 01/01/10 C31/12/10 2010 2010 Day Item No

Thanks

Rory

xSwazi

Thanks I have sorted this I think. On a test copy, I have inserted Year and Item (do not use locations) into the closed years by making these two field editable in table properties and commenting out the Modify code on the table too (this checks if period is closed etc).

After updating these I have reinstated modify code and then I have run a Item Cost update and this worked. This has also corrected the drill down on item cost on the item card. The unit cost values for my selection of items look reasonable too.

Thanks

kriki

[Topic moved from 'NAV 2009' forum to 'NAV/Navision' forum]