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:
Share
Report
All responses (
Answers (
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.
#1
André Arnaud de Cal...
291,391
Super User 2024 Season 2
#2
Martin Dráb
230,445
Most Valuable Professional
#3
nmaenpaa
101,156
