1 Topic by MarkAndrew (edited by MarkAndrew 10/01/2014 09:55:19 am)

  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Topic: Supplier Balance Report

The following bug was noted in FA v21 in the Supplier Balances Report

1. We entered a supplier invoice on 25.12.13 for £1000 at an exchange rate of 18.3150 = ZAR18 315 (local currency)

2. Today, when we run the Supplier Balances Report (SBR) for a date range starting BEFORE the invoice entry date (24.12.13) the SBR converts £1000 to the local currency equivalent at the last available exchange rate in the exchange rate table.  So far, all works as expected.

But, when we run the SBR for a date range starting AFTER the invoice entry date (26.12.13) the SBR does not convert the £1000 to home currency, yet the report clearly states that all balances are in home currency.  The balance appears as 1000.

CONCLUSION:

The SBR can't be relied on to show correct supplier balances in home currency when run with no currency filter unless the start date selected is on or before the date of the very first supplier invoice entered into the system - which is not practical.

It looks like the logic in the code for looking up the exchange rate is wrong.

Where the start date of the report is after the entry date of the supplier invoice, no exchange rate is applied - which is wrong.

Where the start date of the report is before the entry date of the supplier invoice then the last available exchange rate is used - which is correct.

Whether the start date of the report is before or after the supplier invoice date, the latest available exchange rate should be used. 

Mark

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Supplier Balance Report

This is strange. Will have a look.

Joe

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Supplier Balance Report

Thanks Mark for detecting this. I wonder why so long time could last Before this bug was detected?
However, this has now been fixed and the HG repo is updated.

You can download the file /reporting/rep201.php1, rename it to rep201.php and replace it in the /reporting folder.

/Joe

Post's attachments

rep201.php1 8.6 kb, 1 downloads since 2014-10-01 

You don't have the permssions to download the attachments of this post.
  • From: Mauritius, Zimbabwe
  • Registered: 03/03/2013
  • Posts: 107

Re: Supplier Balance Report

thanks Joe.
Will the fix be in next release?

Also a small but confusing thing noted was that on the SBR if there are no transactions for the period the report is run, there is no line that appears on the report to separate one supplier from the next ... a bit confusing so I'll try show an example

Assume SBR is run for period 01.09.14 to 30.09.14
Assume there are 2 suppliers - 1) Property Maintenance and 2) Plumbing Services
Assume Property Maintenance has no transactions in the report period but does have an opening balance
Assume Plumbing Services has transactions in the report period but no opening balance

The SBR will run something like this making it look like one supplier not 2 suppliers.

______________________________________________
Property Maintance       1000                            1000
Plumbing Services   
                                            1250                  1250
______________________________________________


It would be more user friendly to separate the suppliers something like this
______________________________________________
Property Maintance       1000                            1000
______________________________________________
Plumbing Services   
                                            1250                  1250
______________________________________________


Mark

  • joe
  • Administrator
  • Offline
  • Registered: 03/15/2007
  • Posts: 5,107

Re: Supplier Balance Report

Yes it will go to the next minor release.

Your suggestions are implemented in both Customer Balances and Supplier Balances.

You can download the files here and here and replace them in the /reporting folder.

/Joe