View data from table purchase line + archive

love2courtney

Hi all,
I think i'm not the first one which has to capture data from both this 2 table toghether. Basically, I need to report on purchase, I don't want to do 2 different report. Somebody as any suggestion?

neilgf

Hi

You have probably already thought of this but just use 2 dataitems (not linked) to create the report. Only trouble is you cannot sort across both dataitems.

Neil

love2courtney

neilgf wrote:

Hi

You have probably already thought of this but just use 2 dataitems (not linked) to create the report. Only trouble is you cannot sort across both dataitems.

Neil

Yes, I did it. But I was wondering if there was another way to do it. It is a very strange way to separate those information.

neilgf

Hi

Is auto archiving switched on? If so all purchase orders will have an archive if posting has started so you could run the report purely from the archive table. Not ideal I know.

Neil