View data from table purchase line + archive

love2courtneylove2courtney Member Posts: 16
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?

Comments

  • neilgfneilgf Member Posts: 148
    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
  • love2courtneylove2courtney Member Posts: 16
    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.
  • neilgfneilgf Member Posts: 148
    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. :D

    Neil
Sign In or Register to comment.