We've had this same issue before and the problem was due to exactly what you discovered. What fixed it for us was to schedule a job that runs the following code every night just in case the history tables get out of sync during the day. I'd be curious to know if this fixes your issue too.

/*
This SP recalculates each inventory record's period history in timInvtFiscPerHist & timInvtCalPerHist.
*/

SET NOCOUNT ON

DECLARE @P1 int

EXEC spimRecalcPeriodHist null, 2, @P1 OUTPUT

IF @P1 = 1

PRINT 'Recalculation Successful!'

ELSE

PRINT 'Recalculation Failed!'

Hi John,

This sounds like a support issue which might require a data fix.

Please open a web case on support.na.sage.com, mention this thread.  You can also review and reference KB Article ID 56961 - Inventory valuation report is not consistent when ran for a single date versus a date range.

While we can't verify that this is for sure something that would be resolved with a data fix, Sage support can review your issue and then make that determination.

As a precaution we recommend that you test any data fixes in a test environment and have a verified back up before running fixes in your production environment.

Thanks,

Jennifer Pitt

Tim I manually fixed timFiscPerHist so didn't need the SP.  I'm going to review timInvtHist further.  I am not planning on calling support.  We are currently on 7.4 and I did call about it but felt it was better to review it internally.