Hi, our customer would like to have three new fields in the Customer transactions form: - Balance (in trans. currency) by date - Balance (in acc. currency) by date - Balance (in rep. currency) by date.
The new fields should work in conjunction with the option Open including closed on or after date for the field Show.
Exe.
- Invoice posted in June for 1000 EUR
- Payment A posted in June for 200 EUR
- Payment B posted in June for 100 EUR
- Payment of 200 EUR settled in JUNE with invoice
- Payment of 100 EUR settled in JULY with invoice
The question the form should answer is: " For each customer transaction, how much was open at the end of June?" The answer should be: Invoice = 800 EUR.
Presently it is not possible to retrieve this information from the Customer transactions form.
Thanks
