Ageing report

Giovanni Carletti

Hello,

In the ageing (list) report, there isn't some data: in particular, in case of the user inserted some journal entries and now these are due to date.

I created a user query to retrieve these information: then in the layout definition I put query1=swa_ld_document:document, query2=myquery, linkfield=cardname, linkfield2=cardname (with the correct case sensitive char..)

but when I press layout design, there's no action....

Could you help me to find any solution?

best regards,
giovanni

Philipp Knecht

Hi Giovanni

Document is only for Marketing Documents.
Check in the Layouter how the Table is called in the main tree. Then make a query with exactly this name (dummy query like SELECT 1 or so) and then use this one on the left side.

hth

Giovanni Carletti

Hello,

I think I've some problem to understand "in the Layouter how the Table is called in the main tree"

I found "Doc1" under Document tree: then I create the query and update the layout but when press layout design there is an error..

I attached the screen...

regards,
giovanni



Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/cargio/dacanc.JPG]dacanc.JPG[/url]