CRM Dashboard (BUP) report

Emanuele Croci

Im testing the CRM Dashboard (BUP) report.
In the finance overview we need to show the Dunning level field. Which field does it give this information? In the Finance object we are not able to find the dunning level.

If this kind of information is not available in any object inside the report, we shoul implement a query. To do this we need to do this sql statemet :
select DunnLevel from INV6 where InstlmntID = xxxxxx AND DOcEntry = yyyyyy
So where can we find in the report object these two fields( InstlmntID and DocEntry ) ?
regards, Emanuele

Philipp Knecht

Hi Emanuele
Save a query like:

SELECT * FROM INV6 T0 INNER JOIN OINV T1 ON T0.DocEntry = T1.DocEntry WHERE T1.CardCode = '[%CardCode]'

Then copy for example the SWA_LD_Document query and save it as JournalEntries
Then You can use it within the JournalEntries DataBand.
hth
Attachment
[url=http://www.coresystems.ch/wp-content/../wp-content/forum-image-uploads/philipp/layoutdef.jpg]layoutdef.jpg[/url]

Emanuele Croci

Dear Philipp,
thank you for your help.
Sorry, but in your screen-shot I don't' understand what's the "SWA_LD_Data:Installments".
I haven't this Query in the SWA_LD_Data.
Regards,
Emanuele

Philipp Knecht

Hi Emanuele
This is a dummy query. The name is important.
Save a query like SELECT 1 with this name.
hth

Emanuele Croci

Dear Philipp,
thank you for your answer.
I don't undestand if the Finance structure of CRM Dashboard (BUP) report has a field for the DocEntry.
Regards,
Emanuele