aged inventory report slow

[johnhugh]

Hello,

In Accpac 5.5 is there a way to speed up the I/C aged inventory report?

 

[Jay Converse]

Service packs?
Database?
OS and deployment?
RAM?
Server speed?

 

[ettienne]

The report is a waste of time, it does not age correctly.

 

[johnhugh]

Thanks for your replies.

Is there a report which would give me a correct result?
I've read in this forum that the item movement report does not work properly as well?

 

[Jay Converse]

What "result" are you looking for?

 

[johnhugh]

Slow moving items, aged inventory.

 

[johnhugh]

Basically, I want to know which items have not been shipped, moved within the last 6 months.

 

[DjangMan]

The OESHDT table will have all sales and return transactions for items. You could run a report off of that. This would exclude transactions such as transfers, adjustments, receipts that you might not want in your report.

 

[johnhugh]

Thanks DjangMan.
I'm currently looking at the ICHIST table. We are using Internal Issues which I need to capture in my report as well.

 

[ettienne]

IC Stock Control Reports, Slow Moving Items

 

[johnhugh]

Hi ettienne,

Slow moving items doesn't seem to include adjustements for i.e. internal issue. It's just a sales report.

I think I'll have to do my own report here.