Hi everyone.
I want to show open invoices from the cust. ledger entry and show all the payments or credit notes already applied to those invoices but I dont know how to do it. Can anyone help me?
In the first row the invoices with the original amount
In the next rows all the credit notes or payments applied to that invoice.
thank you!!!
Rgds,
NACHO
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment For some reason, the "New to Jet Reports" forum doesn't have the feature enabled to mark a thread as solved. I'm not sure why they enabled that on the "How Do I?" forum but not this one. Anyway, hopefully it actually does solve the problem for you. :)
Hughes -
Jet Reports Historic Posts Hi Nacho,
My guess would be you want to use the "Detailed Cust. Ledg. Entry" table to get that information. For each line of the Cust. Ledger Entry, there are multiple lines in the Detailed Cust. Ledg. Entry with credit amounts, debit amounts, document numbers, etc. The Detailed Cust. Ledg. Entry table has "Cust. Ledger Entry No." and "Applied Cust. Ledger Entry No." fields which is how you would link the 2 tables. I'm no report writing expert, but this is my best guess for the information you want. Does that help?
Regards,
Hughes -
Jet Reports Historic Posts thank you Filthon. I will try it using that table!!
How can I put this query as "SOLVED"? I did it with others but now I dont know how to do it. :D -
Jet Reports Historic Posts Tweaked this forum so now you can mark items as solved.
Please sign in to leave a comment.