Report - sorting 2 joined dataitems

Lec11

Hello,

I have an issue which I believe most of you have come across ... I'll try to brief it:
- a report with 2 dataitems: purchase invoice header and purchase cr. memo header
- the report has to be printed sorted by date, but not one dataitem after another ... the dataitems have to be joined and sorted

How can I solve this?
- a temporary table that contains the all the fields from both tables ?
- indenting the cr. memo header below the invoice header and link them by date ?
- any other suggestion?

Thanks in advance!

bbrown

I recently went thru a similar report except on the sales side. My approach was to use table 36 (Sales Header) as a temporary table. I wrote my posted table records into the temp table then ran the report from the temp table.

DaveT

Hi,

Have you considered using the vendor ledger entry table with a lookup to the purchase invoice header and purchase cr. memo header tables for details ?

Lec11

Actually, I thought about using Item Ledger Entry table, because the report prints item charges. This is a good solution as well.

The one with the temporary table was the first in my mind and using Purchase Header I think it will do it.

Thanks to both for your replies!