Post Inventory Cost to G/L

eugencerchez

Hello everybody,

I hope this message finds you well.

I like to have your advices / opinions in a specific situation we have encountered in Navision.

We need to re-calculate the Average Cost for the entire year 2008 after changing the "Average cost calculation type" (from "Item, Location, Variant" to "Item")
The procedure re-calculates the cost for each item and after that it post the entries in the GL Ledger.

The process of posting the entries ends with the following error:
The operating system returned the error (131)
An attempt was made to move the file pointer before the beginning of the file

The Database dimension 80 GB.
The Navision version is 4.0 SP 2 and the database is installed on an SQL Server 2005 SP2.


Do you have any idea how to overcome this issue?
I would appreciate any help or advise from you.


Best regards,
Eugen

ara3n

I would modify the CU 5810 Change Average Cost Setting

Function

ProcessItemsFromDate(StartingValuationDate : Date)
IF Item.FIND('-') THEN
  REPEAT
    IF Item."Costing Method" = Item."Costing Method"::Average THEN
      ProcessItemAvgCostPoint(Item,StartingValuationDate);
  UNTIL Item.NEXT = 0;

loops through item. I would modify it to filter to run it for set of items at a time.