Electronic Reporting - Collection letter report (Excel)

(3) 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

Categories:

Administration and Setup

All responses (1)

Answers (0)

Anton Venter 18,504 Super User 2024 Season 2 on at

Like (0)

Report

Electronic Reporting - Collection letter report (Excel)

Can you add you question again? Someting went wrong and there is no text, just 2 bullets.