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
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:
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,113 Super User 2024 Season 2
Martin Dráb 229,918 Most Valuable Professional
nmaenpaa 101,156