Report working really slow

fmhigue

Hi guys:
Let me explain the problem that I got.
I a got report Agged Accouts Payables that is working fine but I added a new field to include lat date item received. But it is taking a lot of time to get the information

I am filtering on the item ledger entry table. Using the following
Entry Type: Purchase
Source No: Vendor No.

I am using this key Entry Type, Posting Date. I am not using any key with Source No. becuase I need the last purchase regardless the vendor.

any ideas

ara3n

you probably have to create a new index or change the setcurrentkey based on your filter and then loop through it to find earliest date.

crisnicolas

fmhigue wrote:

I am filtering on the item ledger entry table. Using the following
Entry Type: Purchase
Source No: Vendor No.

I am using this key Entry Type, Posting Date. I am not using any key with Source No. becuase I need the last purchase regardless the vendor.

If you need the last purchase price regardless the vendor... then why are you filtering using the vendor?

Couldn't you use the Last Direct Unit Cost on Item table instead of searching for that price on the Item Ledger Entry table?

ara3n

if you are purchasing the item from multiple vendor last direct cost would not work.

crisnicolas

ara3n wrote:

if you are purchasing the item from multiple vendor last direct cost would not work.

Why not? He said he wants the last purchase price regardless of the vendor...
But at the same time he is using the vendor no. for filtering (which I do not understand)

ssingla

crisnicolas wrote:

ara3n wrote:

if you are purchasing the item from multiple vendor last direct cost would not work.

Why not? He said he wants the last purchase price regardless of the vendor...
But at the same time he is using the vendor no. for filtering (which I do not understand)

fmhigue wrote:

I a got report Agged Accouts Payables that is working fine but I added a new field to include lat date item received. But it is taking a lot of time to get the information

Moreover the data is required in Aged Account Payable report and without reference to vendor which means the value will be same for all the vendors. I would therefore recommend to get the value on "OnPreReport" trigger or on "PreDataItem" trigger of Vendor dataitem. This way the records will be filtered only once.