Hello guys,
I'm just going to ask on how is the
Applied vendor entries work.
because i'm making a report that's just similar to the vendor ledger entries and the applied vendor entries.
Scenario: I have a line rec. of Payment in vendor ledger entries .
in which this line of payment has more 3 invoices applied.
now for the report
it shoudl display both the Payment line.
and the Applied line.
*This post is locked for comments
I have the same question (0)
Hi,
Start your report with a loop on the Vendor Ledger Entry and add an integer Loop on the Detailed Vendor Ledger Entry.
Like this:
On the PreDataItem of the Integer Loop add the following filters to filter out the record itself and to filter to the records applied:
Share
Report
All responses (
Answers (
2,735
DetailedVendorLedgEntry.SETFILTER("Vendor Ledger Entry No.", '<>%1', "Vendor Ledger Entry"."Entry No.");
DetailedVendorLedgEntry.SETRANGE("Applied Vend. Ledger Entry No.", "Vendor Ledger Entry"."Entry No.");
In the RDLC Report you will need to create a group for the Vendor Ledger Entries on the Entry No. field and add a child group to it grouped on the Applied Vend. Ledger Entry No. field then filter the Group like this:
I hope this helps.
