thanks, it works now using new provider free CCA
26 09/11/2018 01:59:04 am
Re: get exchange rates not working from ECB YAHOO GOOGLE BLOOMBERG (2 replies, posted in Banking and General Ledger)
27 09/11/2018 01:56:40 am
Re: Update google url for currency converter (13 replies, posted in Report Bugs here)
thanks for info, just applied with add code below, now it works.
elseif ($provider == 'CCA')
{
$val = getInnerStr($contents, '{"val":', '}}');
}
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://'; }
28 09/10/2018 04:27:20 am
Topic: get exchange rates not working from ECB YAHOO GOOGLE BLOOMBERG (2 replies, posted in Banking and General Ledger)
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
29 04/16/2018 06:20:27 am
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
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
30 08/30/2017 06:28:27 am
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
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 08/23/2017 04:32:07 am
Re: Error Rounding with Tax (8 replies, posted in Accounts Payable)
thanks for the feedback,
we still try first to check this will rounding to expected values.
thanks
32 08/23/2017 04:11:49 am
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
base currency is USD, but we operate for costing is IDR
sorry for delay, seems punbb dont email for the updates.
thanks
33 08/14/2017 07:55:06 am
Re: Exchange Variance Error (27 replies, posted in Banking and General Ledger)
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 08/14/2017 07:30:58 am
Re: Error Rounding with Tax (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
35 12/26/2012 10:34:44 am
Re: How print invoice in 1/2 letter size page. (13 replies, posted in Reporting)
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;
36 12/26/2012 09:25:08 am
Re: How print invoice in 1/2 letter size page. (13 replies, posted in Reporting)
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