Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Valuation timming

Status
Not open for further replies.
tenebrion

tenebrion

IS-IT--Management
Mar 19, 2008
1
US
We run quarterly valuations. Does anyone experience valuations reports taking > 48 hours long and eating up most of the SQL cpu(s)?

Any remedy would be nice.
 
Sort by date Sort by votes
Is this an Accpac question? What version, database, and "valuation" process are you talking about?
 
Upvote 0 Downvote
I'm guessing the IC item valuation report, try running it for Location Detail Costs instead of Transaction Costs.
 
Upvote 0 Downvote
And, read the readme and replace the datapipe versions with the ODBC versions.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

johnhugh
  • Locked
  • Question
Item Valuation question 1
Replies
7
Views
38
johnhugh
johnhugh
johnhugh
  • Locked
  • Question
Item valuation report
Replies
5
Views
59
ettienne
ettienne
ettienne
  • Locked
  • Question
speed up IC Valuation report
Replies
1
Views
36
johnhugh
johnhugh
johnhugh
  • Locked
  • Question
IC item valuation report different from location cost
Replies
5
Views
49
johnhugh
johnhugh
joetee
  • Locked
  • Question
Damaged data. Item Valuation. Data dictionary is inconsistent.
Replies
3
Views
60
Jay Converse
Jay Converse

Part and Inventory Search

Sponsor

Back
Top