Electronic Reporting - Collection letter report (Excel)

(1) Share

Report

Posted on by Tini Bosch

Hi,

I'm investigating the options to add the following two fields from the collection letter journal transaction table (collection letter lines) to the report.

- Calculation amount (=original invoice amount)

- Collection letter code

Has anyone of you did this before? If so, how did you manage to do that? As I'm getting stuck in the data source part.
For the Calculation amount, I added a new name label to the Excel Document and I managed to bind it with the AmountInCur field in the DataModel. This however is not bound yet to a datasource.
I would like to bind this DataModel Field to the Calculation amount from the CustCollectionLetterTrans table. This seems not to be available as a data source. Whereas other fields from the same table are available.

Any suggestions to make this work?

Regards,

Tini

Electronic Report...

I have the same question (0)

All responses (2)

Answers (0)

Sort by

BillurSamdancioglu 20,825 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hi,

Please fill with details.

Was this reply helpful? Yes No
Ramit Paul 22,805 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

MODERATOR UPDATE ****UPDATED THE QUESTION FROM WORD DOC TO TEXT HERE******

Hi,
(For some reason my description is not visible to others, hence I’ll try a word attachment).
I'm investigating the options to add the following two fields from the collection letter journal transaction table (collection letter lines) to the report.
- Calculation amount (=original invoice amount)
- Collection letter code
Has anyone of you did this before? If so, how did you manage to do that? As I'm getting stuck in the data source part.
For the Calculation amount, I added a new name label to the Excel Document and I managed to bind it with the AmountInCur field in the DataModel. This however is not bound yet to a datasource.
I would like to bind this DataModel Field to the Calculation amount from the CustCollectionLetterTrans table. This seems not to be available as a data source. Whereas other fields from the same table are available.
Any suggestions to make this work?
Regards,
Tini

Was this reply helpful? Yes No