First of all I couldn't post the whole title so here is what I want to do:
I have created a Customer detailed trial balance report and I use NL("Sum") to retrieve the opening balance of the customer. However, my date filter takes the total of the entries from the previous fiscal year (Amount LCY), but does not present them revalued with the current fiscal year date filter. =NL("Sum";"Cust. Ledger Entry";"Amount (LCY)";"Customer No.";$E8;"Date Filter";Options!$D$10;;;;;;;;;;;;;"Company=";Options!$D$9)
where Options!$D$10 equals to prior year filter
This is an issue with Amount LCY since the entries should be presented at a revalued state based on the report's current year filter.
Thanks in advance!
Date
Votes
3 comments
-
Jet Reports Historic Posts Official comment Update: finally pulled if off!!!
I have created two separate NL("Sum") in the cell to retrieve Original Amount (LCY) and from Detailed Cust. Ledg. Entry, retrieved the Amount (LCY) excluding initial entries, from incorporation until the report period end. Lastly, I had to change the Filter from Date filter to Posting Date. I still don't understand why Date filter retrieved entries beyond the dates I used…Cell R8 =NL("Filter";"Cust. Ledger Entry";"Entry No.";"Posting Date";01/01/2011..31/12/2011;"Customer No.";$E8;;;;;;;;;;;;;"Company=";Options!$D$9) =NL("Sum";"Cust. Ledger Entry";"Original Amt. (LCY)";"Entry No.";R8;"Date Filter";01/01/2011..31/12/2011;;;;;;;;;;;"Company=";Options!$D$9)+NL("Sum";"Detailed Cust. Ledg. Entry";"Amount (LCY)";"Cust. Ledger Entry No.";R8;"Entry Type";"<>Initial Entry";"Posting Date";01/01/2011..31/12/2012;;;;;;;;;"Company=";Options!$D$9) -
Jet Reports Historic Posts Hi!
I'm not quite sure I understand what the problem is. Are you saying that you're filtering the Date Filter field for the previous fiscal year but you want it to filter by the current fiscal year? Why wouldn't you just change your date filter? I think maybe I just don't understand exactly what you mean by "revalued state based on the report's current year filter".
Regards,
Hughes -
Jet Reports Historic Posts I want to filter the entries posted in 2011 but with the Amount LCY values of 2012. I have created a filter that filters the entries made in 2011 and then an NL("Sum") in the Detailed Customer Ledger entry table, that retrieves the entries posted up to the end of 2012 for the entries retrieved in the previous filter (i.e. for 2011). It stills does not calculate the entries correctly, but up to today :(
Cell R17 =NL("Filter";"Cust. Ledger Entry";"Entry No.";"Customer No.";$E8;"Date Filter";01/01/2011..C31/12/2011;;;;;;;;;;;;;"Company=";Options!$D$9) =NL("Sum";"Detailed Cust. Ledg. Entry";"Amount (LCY)";;;"Customer No.";$E8;"Cust. Ledger Entry No.";R17;"Posting Date";01/01/2011..31/12/2012;;;;;;;;;"Company=";Options!$D$9)
Please sign in to leave a comment.