Finance | Project Operations, Human Resources, ...

Need to pull multiple invoice lines on check report using Electronic Reporter

(0) Share

Report

Posted on by SLindsays

I'm using the Payment check model in Electronic Reporter and am pulling information in from the SpecTrans and joining into VendTransOpen and VendTrans to get the data that I need. If I look at the tables for either SpecTrans or even VendTrans (where I need to get the invoice number and description from) I see two lines showing for the two invoices, but each time I run the ER report, it only pulls in one line.

SGY are the custom fields added.

Because I'm pulling the total amount from the LedgerJournalTrans table, I'm getting the correct total amount for the payment.

SpecTrans table

Example of a multiple line output in AX 2012.

I need to have multiple invoice lines to come in on the output file using the Electronic Reporter.

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Alireza Eshaghzadeh 14,684 Super User 2025 Season 2 on at

Like (0)

Report

Hi SLindsays,

It seems that you need to define a record list (like. SpecTransLines) and add the SGY custom fields under that field.

Then on model designer, you can bind the SpecTransLines to Lines.

As an example:

Was this reply helpful? Yes No
SLindsays 5 on at

Like (0)

Report

In essence this is what I have done. I'm wondering if it is because of how I am doing it. I added the table as a calculated group under the main db for the report though. I'm pulling those into the custom fields that I created. (I had previously went into the model and added a total separate area for the "lines" data with custom fields and this did not work either.

I even tried using the group that I created directly in the formatting area to pull from the group, but instead it pulls all likes under each individual. It still isn't finding the second invoice transaction that is found in the SpecTrans (and other tables).

Could it be because I'm not creating a separate DB from the temp table? I still want it to pull the data as it is matched from when the file is ran however to make sure the right journal is being pulled in.

Was this reply helpful? Yes No