Hello,
I am a beginner as designer and I am trying to create a report to show the last Item ledger entry from a range of items.
This report must show the last Item ledger entry for an item per Location.
I`ve created a report but it only works when I apply a filter for only one item, I would like to run this report without applying any item filter.
You can find below the result that I got when I run the report with an item in the filter.
G10= NL("Last";"Item Ledger Entry";"Item No.";"Item No.";$C$5;"+Entry No.";"*";"Filters=";$B$2:$C$5)
H10 =NL("Rows";"Item Ledger Entry";"Location Code";"Item No.";$G10;"+Entry No.";"*";"Filters=";$B$2:$C$4)
I10 =NL("Last";"Item Ledger Entry";"Entry No.";"Item No.";$G10;"Location Code";$H10;"Entry Type";$C$3;"Posting Date";$C$2;"+Entry No.";"*")
I really appreciate your help.
Thank you.
