Have any of you out there ever face when sometimes you inquiry Aging report, the total at footer is missing? Have you ever though what is the reason that causes this?
Well the reason is pretty simple, if your result consists of more than 1 currency debtor, the total column at the footer will be hidden. Thinking back logically, if you are trying to add up and get the total from debtors with multi-currency, don’t you feel that the amount is not correct? Could you be adding 10 USD + 10 MYR and showing you 20.00 amount is an accurate result?
So what can I do if I wish to have a total column at the footer to summarize my aging report? Well, no worries on such matter. There are two ways that you can apply in order to view this total column at the footer.
1st Method:
Filter your debtor to only inquiry particular currency debtor, the system able to detect if there is only 1 currency, the total column at the footer will automatically be shown.
2nd Method:
You can trigger our local currency option at “More Options” so that you can view the total column of all debtor under your account book home currency. It will automatically convert those foreign amount into local amount so that the total added up would be meaningful.
Hope that this would help some of you out there that face this issue before and unlock your curiosity on this.