Report or query which mimics the logic in the FindApplnEntries

Regal

Hi all

I am trying to write either a report or query which mimics the logic in the FindApplnEntriesDtldtLedgEntry() function of page 61 Applied Customer Entries. I have tried several approaches:

1. Exposing Page 61 as a webservice and attempting to call it externally passing a recid or entry number (was told by our external developer that Local functions are not available outside of the object).
2. Creating a codeunit that takes the logic of the FindApplnEntriesDtldtLedgEntry() function and calling that (I could not make this work).
3. Creating a report which had that function embedded in it but I was not able to make this work.
4. Creating a report which joins from Cust. Ledger Entry to Detailed Cust. Ledger Entry and so on using Applied Cust. Ledger Entry No being equal to Cust. Ledger Entry.Entry No, and Cust. Ledger Entry No. being equal to Entry No as per the function itself
5. Creating a query which had that function embedded in it but I was not able to make this work.

I have also looked at report 211 - Customer - Payment Receipt as it seems to be close to what I am trying to achieve however that seems to be limited to payment document types whereas I would like to look at essentially every line of the Customer Ledger Entry and produce the output (i.e. if Credit Note, then what invoice it was applied to, exactly as you can see in the page view.

I am interested to know what approaches others here would take to solve this problem, or if there is something obvious I am missing. My preference would be to use like a web service passing Cust. Ledger Entry No. and getting a response but I understand this is not possible.
I am new to NAV and appreciate any help that can be offered - but not expecting others to do my work for me

wait

I guess one approach would be to create a temp table and insert the records you want to show. If you want to create a web service to return this then it should not be a problem as the web services can return temp tables.

Regal

Thanks wait. That would be a good approach.

I ended up writing the output to a temporary table in sql, not the most elegant solution but enough to solve my immediate problem.

I may revisit at some point and implement he way you suggest.

wait

I guess one approach would be to create a temp table and insert the records you want to show. If you want to create a web service to return this then it should not be a problem as the web services can return temp tables.

Regal

Thanks wait. That would be a good approach.

I ended up writing the output to a temporary table in sql, not the most elegant solution but enough to solve my immediate problem.

I may revisit at some point and implement he way you suggest.