thanks, it works now using new provider free CCA

thanks for info, just applied with add code below, now it works.

        elseif ($provider == 'CCA')
        {
                $val = getInnerStr($contents, '{"val":', '}}');
    }
boxygen wrote:

I am using free.CurrencyConverterAPI.com and it works for almost all Currencies

elseif ($provider == 'CCA') //free.currencyconverterapi.com
    {
        $filename = "/api/v5/convert?q={$curr_b}_{$curr_a}&compact=y";
        $site = "free.currencyconverterapi.com";
        $proto = 'https://';

    }

current test with FA 2.4.4 and php PHP 5.4.16 (cli) (built: Apr 12 2018 19:02:01)
suddenly in 3 sept last record for get exchange rate automatically, changing provider doesn't help
is there any new gl_db_rates.inc need to modify?
pls advice

thanks

we are using IDR for second currency, and in the our petty cash for IDR, in somehow, in the gl transaction, balance show -, after some automatic exchange variances, and then calculation got double every time trans got input in the bank payment for account petty cash IDR.

as show in the screenshot, we have turn off automatic Exchange Varience, in the Setup Company.
1. gl inquiry -> bank payment ref 11 and journal entry ref 12 15-jan-2018, created negative balance for petty cash
2. bank account inquiry -> balance for the petty cash showing 205,393.00 (not negative value)

https://www.dropbox.com/s/fsgzrhaj9bd2h61/negative%20value%20for%20automatic%20exchange%20variance.zip?dl=0


thanks

I have seen this is not problem with rounding error, but somehow any transaction that causes exchange variance does not calculate from the transaction value, but it seems double value from the previous exchange rates values.

We got very confused as to how we can report and diagnose this problem, except if possible we send our database dump by PM?

31

(8 replies, posted in Accounts Payable)

thanks for the feedback,
we still try first to check this will rounding to expected values.

thanks

base currency is USD, but we operate for costing is IDR

sorry for delay, seems punbb dont email for the updates.

thanks

Rupiah exchanges rates is generated automatically from
/*
    Choose Exchange Rate Provider
    Default is ECB for backwards compatibility
*/
$xr_providers = array("ECB", "YAHOO", "GOOGLE", "BLOOMBERG");
$dflt_xr_provider = 2;

the problem that may need to elaborate, in the different vendor and value, the exchange rates seems doubled from the last transaction, we check in the table currency, values in the some dates is wrong get from google shown 0.0001, but we have correctly this to 0.000074954090619496, even in the pages https://domain/fa/gl/manage/exchange_rates.php? this always shown 0.0001.

other trans is seems correct to automatically calc for exchange rate difference, but in this case, we still dont have any clue but some transaction will cause exchage rate difference double from the last value:
Journal Entry    360    30-Jun-2017             36,153,961,430,173.00        72,307,922,870,772.69    Exchange Variance
Journal Entry    361    30-Jun-2017             72,307,922,860,346.00        144,615,845,731,118.69    Exchange Variance
Journal Entry    362    30-Jun-2017             144,615,845,720,690.00        289,231,691,451,808.69    Exchange Variance
Journal Entry    365    30-Jun-2017             289,231,691,439,930.00        578,463,382,891,738.75    Exchange Variance

pls advice how we can solve this?

thanks

34

(8 replies, posted in Accounts Payable)

Hi,

sorry for late reply, current vps server is using:
httpd-2.4.6-45.el7.centos.4.x86_64
mariadb-5.5.52-1.el7.x86_64
on centos 7, this problem is that will very likely to happen, as vendor do include tax in their price, sometimes don't
so the calc will cause floating point decimal.

pls advice. already tested in the latest FA 2.4.2

thanks

thank you for the quick respose,

dunno about this "Also have a look at line 66 in reporting/includes/class.pdf.inc."

but no success, print inv, page seem like resized, but the content is cut off,
where I can modify for inv pdf format to match with new paper size?

--
I have changed file config.php
$pagesizes              = array("Letter", "A4", "A5"); // default PDF pagesize

and pdf_report.php
                  case 'A5':
                          // Portrait
                          if ($orientation == 'P')
                          {
                                  $this->pageWidth=421;
                                  $this->pageHeight=595;
                                  if (!isset($margins))
                                  {
                                          $this->topMargin=40;
                                          $this->bottomMargin=30;
                                          $this->leftMargin=40;
                                          $this->rightMargin=30;
                                  }
                          }
                          // Landscape
                          else
                          {
                                  $this->pageWidth=595;
                                  $this->pageHeight=421;
                                  if (!isset($margins))
                                  {
                                          $this->topMargin=30;
                                          $this->bottomMargin=30;
                                          $this->leftMargin=40;
                                          $this->rightMargin=30;
                                  }
                          }
                          break;

is there update regarding this request?
as I just upgrade from sql-ledger considering for FA 2.3.13,

any manual for change cust. invoice page size to half paper A4?

thank you