Hi everyone. Has anyone added data from a table extension to a report and had success?
I've been looking through the forum and saw a couple of threads that talk about creating custom reports but none of them lay out the steps required to link a table extension to a report using al code.
We created a table extension on the sales invoice line and I am trying to add the two fields that we added to the sales invoice form. Here is the code that i've written so far. I'm used to doing things like this in SQL where I'd just need to add a join but AL seems a lot different... any help is appreciated. It's not letting me just add another data item like i did to add the sales invoice line table.
Is this report in the same extension of your tableextension object or in another extension (app)?
If case 1: you should see the added field directly in Sales Invoice Line
If case 2: you need to add the extension containing your tableextension as dependency of the new extension where you have the report.
Hey Stefano, thanks for the response. I'm not sure I understand. The table extension is on the sales invoice line table, and one of the dataitems in the report is the sales invoice line. Are you saying that the fields in the table extension should just be available? In VS Code, I get a message that says "the name Gross Quantity does not exist in the current context" when i try to add a column.
Is the report you’re developing in the same extension project as your tableextension object? If so, fields are visible.
If it’s not in the same extension project but it a new one (new project in VS Code), then you need to add dependency in app.json.
This worked, thank you! I knew it had to be something simple.
Business Applications communities