Manufacturing, Distribution, and Internet Applications

[JohnHanrahan]

I ran a valuation for the last day of a period.  I then compared the data to timInvtCalPerHist.  They are not the same and yet based on the documentation I would think they should be.  Any one have any ideas?  It seems like the valuation report is correct as it doesn't have a bunch of negative quantities (which we don't allow).

Thx.

John

[Ralph]

I just spot-checked a few random items in our 7.30.5 system and the values in the Inventory Valuation Report ran for last month matched the values in timInvtCalPerHist.

[trodman]

Does running "IM -> Activities -> Utilities -> Recalculate Inventory Quantities" fix the problem?

[JohnHanrahan]

Tim,

The help file doesn't mention fixing the history files so I wasn't thinking that would fix it.  Do you have information to the contrary?

Ralph,

Good info and I am jealous!

[trodman]

Ralph,

You're probably right, just thought it might be worth a try.  It looks like spimRecalcPeriodHist might do the trick.

[Ralph]

Tim, I think you were replying to John, but I'm fine with seeing "Ralph, you're probably right" on here.  That beats seeing "Ralph, you're an idiot," right? 

[trodman]

Ha, now I can correctly say "Ralph, you're right"! I read Ralph as the signature and missed the next line completely.  Reading too fast I guess.

[JohnHanrahan]

TIm,

I might actually run spimEOPInvtValCalPeriod which spimRecalcPeriodHist calls.  I was hoping someone from Sage would jump in and give some advice.  It will like take hours for the sp to run.  I will do it in a test environment and see what happens.

J

[gstorres]

Hi All,

To recalculate the inventory history tables (timInvtFiscPerHist and timInvtCalPerHist) just call the following stored procedure.  You should get a return value of 1 for success.  Be sure to replace 'SOA' with your Company ID.  The number 2 tells the proc to recalculate both Fiscal and Inventory Periods.

declare @RetVal int
EXEC spimRecalcPeriodHist 'SOA', 2, @RetVal OUTPUT
select @RetVal