OK I've changed it to:
$acct_name = get_gl_account_name($acct_source_code);
$memo = "$percent% from transactions of account: $acct_source_code - $acct_name for period $start_date to $end_date";
and I get the desired output.
thx
1 08/15/2010 08:40:43 am
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
2 08/09/2010 12:18:00 pm
Re: Volunteer translators for installaion wizard messages needed (48 replies, posted in Translations)
Translating for id_ID now
3 08/05/2010 05:30:46 pm
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
OK I've edited so it looks like this:
$memo = "$percent% from transactions of account: $acct_source_code for period $start_date to $end_date";
and the output is:
2.5% from transactions of account: 41001000 for period 01/07/2010 to 31/07/2010
but my desired output is :
2.5% from transactions of account: 41001000 Sales Item-1 for period 01/07/2010 to 31/07/2010
how do I can get the account name not just the account code?
thx
4 08/05/2010 05:15:58 pm
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
that would be nice, I'll edit the source.
although in my mind it's more like this
2,5% from transaction 41001000 Sales Item-1 period 01/07/2010 - 15/07/2010
41001000 sales item-1 is the account number, in case there's more than 1 sales account or if the percentage different between sales account (ex: 41001000 sales item-1, 41002000 sales item-2, 42001000 service),
and period is for tracking, so we reduce the risk to double post the percentage in case we run it multiple times in one month
thx
5 08/05/2010 03:14:27 pm
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
well because you want to patch it anyway can I ask for an "default memo" entry on the setting? so in the journal entry after we run the modules, the memo entry there won't empty and it is usefull for tracking journal, ofcourse we can still edit it manually but an entry on the setting would be nice).
thx
6 08/05/2010 02:46:33 pm
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
Well actually I dont use dimension. I did create the dimension type 1 and no type 2.
After I put "dimension 1 to credit" entry on the editor and run it, it seems works, the journal entry is filled the credit entries on the journal is set to dimension I choose on the seeting.
But how about if I don't want my account percentage calculation and journalling related to certain dimension.
I mean if I let the dimension 1 or 2 blank on the editor, can I still use the modules? or is it really have to use dimension?
As for workaround on the journal entry form after running the tools I can edit the dimension back to blank (or another dimension) if it necessary anyway.
But it still feel nice knowing that the modules works for me.
thx
7 08/05/2010 04:21:39 am
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
OK just comment line 161 as you said tom and run it. here is the sql :
SQL..
SELECT next_reference FROM 6_sys_types WHERE type_id = '0'
SQL..
SELECT * FROM 6_company WHERE coy_code=1
SQL..
SELECT * FROM 6_fiscal_year WHERE id='3'
SQL..
SELECT * FROM 6_acct_percent_tool WHERE !inactive ORDER BY account_code_source
SQL..
SELECT * FROM 6_dimensions WHERE type_ = 1 ORDER BY reference ASC
SQL..
SELECT * FROM 6_dimensions WHERE type_ = 2 ORDER BY reference ASC
SQL..
SELECT SUM(amount) FROM 6_gl_trans
WHERE account='41001000' AND tran_date >= '2010-07-01' AND tran_date <= '2010-07-31' AND dimension_id = '1' AND dimension2_id = '0'
SQL..
SELECT SUM(amount) FROM 6_gl_trans
WHERE account='41001000' AND tran_date >= '2010-07-01' AND tran_date <= '2010-07-31' AND dimension_id = '2' AND dimension2_id = '0'
8 07/26/2010 03:43:11 am
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
tomhallman wrote:
Hello e-prast,
Thanks for sending that. I was thinking more of the config option "show_sql" rather than the sql trail. That way you'll see the SQL right on the account percentages module page.
Still, if I'm reading the sql trail correctly, it looks like there's a number of errors with the SQL queries. Lots of "can't update and can't retrieve" stuff. (See entries 61-68 and 74-83)
When you use the Account Percentages Editor (not the "Run" part), does it save your changes between page loads? That is, save the values in the editor, leave the page, and then come back to the editor.
Joe/Janusz, do those errors make sense to you? Any thoughts? It doesn't seem to be limited to the account percentages tool to me...
Tom
when I'm using the editor my settings is saved, I've checked the database too and here is the sql dump:
--------------------------------------------------------------------------------------------------------------------------------------------------------
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `frontaccount.tes`
--
-- --------------------------------------------------------
--
-- Table structure for table `6_acct_percent_tool`
--
CREATE TABLE IF NOT EXISTS `6_acct_percent_tool` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`account_code_source` varchar(11) NOT NULL DEFAULT '',
`account_code_credit` varchar(11) NOT NULL DEFAULT '',
`dimension1_credit` int(11) NOT NULL DEFAULT '0',
`dimension2_credit` int(11) NOT NULL DEFAULT '0',
`account_code_debit` varchar(11) NOT NULL DEFAULT '',
`percent` double DEFAULT NULL,
`inactive` tinyint(1) NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;
--
-- Dumping data for table `6_acct_percent_tool`
--
INSERT INTO `6_acct_percent_tool` (`id`, `account_code_source`, `account_code_credit`, `dimension1_credit`, `dimension2_credit`, `account_code_debit`, `percent`, `inactive`) VALUES
(1, '41001000', '21103900', 0, 0, '61901900', 2.5, 0);
----------------------------------------------------------------------------------------------------------------------------------------------------------
when using the editor here is the show_sql in view mode:
SELECT * FROM 6_acct_percent_tool WHERE !inactive ORDER BY account_code_source
SQL..
SELECT * FROM 6_chart_master WHERE account_code='41001000'
SQL..
SELECT * FROM 6_chart_master WHERE account_code='21103900'
SQL..
SELECT * FROM 6_dimensions WHERE id='0'
SQL..
SELECT * FROM 6_dimensions WHERE id='0'
SQL..
SELECT * FROM 6_chart_master WHERE account_code='61901900'
---------
and this the show_sql when I try to edit the settings in editor:
Source Account:SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
FROM 6_chart_master chart,6_chart_types type
WHERE chart.account_type=type.id ORDER BY type.id,account_code
Account to credit:SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
FROM 6_chart_master chart,6_chart_types type
WHERE chart.account_type=type.id ORDER BY type.id,account_code
Dimension 1 to credit:SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference
Dimension 2 to credit:SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference
Account to debit:SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
FROM 6_chart_master chart,6_chart_types type
WHERE chart.account_type=type.id ORDER BY type.id,account_code
when I click run it seems there's sql printed on screen but it's so fast so I can't put it here and then the journal entry show's with blank entries and here is the sql:
SELECT id FROM 6_quick_entries WHERE type='3'
SELECT * FROM 6_company WHERE coy_code=1
SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id
FROM 6_chart_master chart,6_chart_types type
WHERE chart.account_type=type.id ORDER BY type.id,account_code
SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0 AND type_=1) ORDER BY reference
is there something that I miss?
9 07/24/2010 05:16:24 am
Re: cURL? (6 replies, posted in Modules Add-on's)
-create a new customer
-create the purchase of this customer
-create an invoice and
-make a payment on that newly created invoice.
is'n that you can use the direct invoice tho achieve this at once?
10 07/23/2010 01:44:15 pm
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
here is the sql_dump when I run the modules
sorry if I put it here. the attachment seems don't work for me so here it is:
-------------------------------------------------------------------------------------------
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
--
-- Database: `frontaccount.tes`
--
-- --------------------------------------------------------
--
-- Table structure for table `6_sql_trail`
--
CREATE TABLE IF NOT EXISTS `6_sql_trail` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`sql` text NOT NULL,
`result` tinyint(1) NOT NULL,
`msg` varchar(255) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=86 ;
--
-- Dumping data for table `6_sql_trail`
--
INSERT INTO `6_sql_trail` (`id`, `sql`, `result`, `msg`) VALUES
(45, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(44, 'SELECT * FROM 6_chart_master WHERE account_code='61901900'', 1, 'could not get gl account'),
(42, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(43, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(41, 'SELECT * FROM 6_chart_master WHERE account_code='21103900'', 1, 'could not get gl account'),
(40, 'SELECT * FROM 6_chart_master WHERE account_code='41001000'', 1, 'could not get gl account'),
(39, 'SELECT * FROM 6_acct_percent_tool WHERE !inactive ORDER BY account_code_source', 1, 'could not get account percentage entries'),
(38, 'DELETE FROM 6_acct_percent_tool WHERE id = 2', 1, 'could not delete account percentage entry'),
(37, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(36, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(35, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(33, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(34, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(32, 'SELECT * FROM 6_chart_master WHERE account_code='61901900'', 1, 'could not get gl account'),
(31, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(29, 'SELECT * FROM 6_chart_master WHERE account_code='21103900'', 1, 'could not get gl account'),
(30, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(27, 'SELECT * FROM 6_chart_master WHERE account_code='11111990'', 1, 'could not get gl account'),
(28, 'SELECT * FROM 6_chart_master WHERE account_code='41001000'', 1, 'could not get gl account'),
(26, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(25, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(23, 'SELECT * FROM 6_chart_master WHERE account_code='11111990'', 1, 'could not get gl account'),
(24, 'SELECT * FROM 6_chart_master WHERE account_code='11111990'', 1, 'could not get gl account'),
(22, 'SELECT * FROM 6_acct_percent_tool WHERE !inactive ORDER BY account_code_source', 1, 'could not get account percentage entries'),
(46, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(47, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(48, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(49, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(50, 'SELECT * FROM 6_acct_percent_tool WHERE !inactive ORDER BY account_code_source', 1, 'could not get account percentage entries'),
(51, 'SELECT * FROM 6_chart_master WHERE account_code='41001000'', 1, 'could not get gl account'),
(52, 'SELECT * FROM 6_chart_master WHERE account_code='21103900'', 1, 'could not get gl account'),
(53, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(54, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(55, 'SELECT * FROM 6_chart_master WHERE account_code='61901900'', 1, 'could not get gl account'),
(56, 'SELECT * FROM 6_acct_percent_tool WHERE id = 1', 1, 'could not get account percentage entry'),
(57, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(58, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(59, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(60, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(61, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(62, 'UPDATE 6_acct_percent_tool SET account_code_source=41001000, \r\n account_code_credit=21103900, dimension1_credit=0, \r\n dimension2_credit=0, account_code_debit=61901900, \r\n percent='2.5' WHERE id = 1', 1, 'could not update account percentage entry'),
(63, 'SELECT * FROM 6_acct_percent_tool WHERE !inactive ORDER BY account_code_source', 1, 'could not get account percentage entries'),
(64, 'SELECT * FROM 6_chart_master WHERE account_code='41001000'', 1, 'could not get gl account'),
(65, 'SELECT * FROM 6_chart_master WHERE account_code='21103900'', 1, 'could not get gl account'),
(66, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(67, 'SELECT * FROM 6_dimensions WHERE id='0'', 1, 'The dimension could not be retrieved'),
(68, 'SELECT * FROM 6_chart_master WHERE account_code='61901900'', 1, 'could not get gl account'),
(69, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(70, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(71, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(72, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0) ORDER BY reference', 1, ''),
(73, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(74, 'SELECT next_reference FROM 6_sys_types WHERE type_id = '0'', 1, 'The last transaction ref for 0 could not be retreived'),
(75, 'SELECT * FROM 6_company WHERE coy_code=1', 1, 'The company preferences could not be retrieved'),
(76, 'SELECT * FROM 6_fiscal_year WHERE id='3'', 1, 'could not get current fiscal year'),
(77, 'SELECT * FROM 6_acct_percent_tool WHERE !inactive ORDER BY account_code_source', 1, 'could not get account percentage entries'),
(78, 'SELECT * FROM 6_dimensions WHERE type_ = 1 ORDER BY reference ASC', 1, 'The dimensions could not be retrieved'),
(79, 'SELECT * FROM 6_dimensions WHERE type_ = 2 ORDER BY reference ASC', 1, 'The dimensions could not be retrieved'),
(80, 'SELECT SUM(amount) FROM 6_gl_trans\r\n WHERE account='41001000' AND tran_date >= '2010-07-01' AND tran_date <= '2010-07-31' AND dimension_id = '1' AND dimension2_id = '0'', 1, 'Transactions for account 41001000 could not be calculated'),
(81, 'SELECT SUM(amount) FROM 6_gl_trans\r\n WHERE account='41001000' AND tran_date >= '2010-07-01' AND tran_date <= '2010-07-31' AND dimension_id = '2' AND dimension2_id = '0'', 1, 'Transactions for account 41001000 could not be calculated'),
(82, 'SELECT id FROM 6_quick_entries WHERE type='3'', 1, 'could not retreive quick entries'),
(83, 'SELECT * FROM 6_company WHERE coy_code=1', 1, 'The company preferences could not be retrieved'),
(84, 'SELECT chart.account_code, chart.account_name, type.name, chart.inactive, type.id\n FROM 6_chart_master chart,6_chart_types type\n WHERE chart.account_type=type.id ORDER BY type.id,account_code', 1, ''),
(85, 'SELECT id, CONCAT(reference,' ',name) as ref FROM 6_dimensions WHERE (closed=0 AND type_=1) ORDER BY reference', 1, '');
11 07/23/2010 01:42:09 pm
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
sorry just check the wiki and edit the config file to enable sql_trail. wait a moment
12 07/23/2010 11:12:37 am
Topic: Xampplite + FA 2.2.11 (1 replies, posted in FA Modifications)
Hello
I don't know if someone else has done the same but I've pack a portable xampplite that incorporate FA 2.2.11. Firstly it's for my learning purpose only but perhaps other's might need it just in case they want to try FA.
It can downloaded here:
http://www.4shared.com/file/wWnk1kzO/xampplite-win32-173FA-2211.html
it's packed with 7zip (cause the 7z is smaller so it upload faster)
you can get portable 7zip here:
http://portableapps.com/apps/utilities/7-zip_portable
just extract the downloaded file to the root of your drive (ex: drive D: ) then execute xampp-control.exe to start apache & mysql. after that just use your browser to http://localhost/frontaccount
user: admin
pass: admin
there's 3 company I include & it's use the same user&password. some are using Indonesia COA but you can change it later.
for the phpmyadmin on the package
user: root
pass: root
*) I don't make it very secure because for me it's for learning purpose only.
I just want to share
All the credits goes to xampplite developer & FA developer.
13 07/23/2010 09:45:09 am
Re: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
So how do I contact Tom Hallman is he in his forum ? Perhaps you could PM me his e-mail Joe.
14 07/17/2010 09:29:54 am
Topic: The behaviour of account percentage module (21 replies, posted in Modules Add-on's)
The behaviour of account percentage module
Hello Joe/Janusz
I have another question about modules.
I have successfully install&activated Account precentage module in 2.2.11.
I want to set so 2,5% of sales account each month will be donated to charity account. So I set it up like this on account percentage editor:
Source Account : Sales
Account to credit: Payables
Account to debit: Donation/charity
Percentage:2,5
And the above setting is saved & i've check in the database with phpmyadmin the value I entered also in 6_acct_percent_tool table
Now lets say that we are on August 18. Is it possible to run the account percentage tool in current month with start date 1-aug-2010 and end date 31-aug-2010 or can we only run it for the previous month with start date 1-jul-2010 and end date 31-jul-2010?
Because when I try to run it in current month it only gives me blank journal entry. I've try to set start date to 1-aug-2010 and end date 17-aug-2010 and it still give me blank journal entry.
Thx for the answer.
15 07/17/2010 06:29:14 am
Topic: Another question about tax (0 replies, posted in Setup)
Another question about tax
Dear FA developer.
I wonder how to setup FA tax system to fulfill my needs.
Here is the situation
Example I sell to the customer
Tax base amount : 100.000
Income Tax : 4.000
VAT : 10.000
The journal for that transaction is :
For cash payment
Dr Bank 106.000
Dr Prepaid Income tax 4.000
Cr Sales 100.000
Cr VAT Out Payable 10.000
Example I buy from the supplier
Tax base amount : 100.000
Income Tax : 2.500
VAT : 10.000
The journal for that transaction is :
For cash payment
Dr Inventory 100.000
Dr Prepaid VAT In 10.000
Cr Bank 107.500
Cr Income tax payable 2.500
For the VAT I think I can use the tax item no problem with that.
But for the Income tax I think I must use the tax group but I haven't found a way to get what I want. Each customer/supplier will have different percentage of income tax that related to good/service they bought/sell according to our tax law. The income tax is reducing the amount I pay to the supplier or the amount I get from the customer. On the COA I have create the separate tax account for every tax.
So how to setup the tax group to accomplish that?
Thanks for the answer and BTW when is the 2.3 final will release? Cant wait
16 07/16/2010 09:56:34 am
Topic: About Revenue / Cost Accruals Module (1 replies, posted in Modules Add-on's)
Hi there.
I'm just trying to use Revenue / Cost Accruals module and I think it's very useful. I have few ideas about it.
1. Is it possible to add custom memo to JE made by Revenue / Cost Accruals module? because the default is just add memo about the amount accrued and I think we need better memo just in case we want to track those JE.
2. If I accidentaly made mistake on making accrued cost/revenue is it possible to abort the accrued process made by Revenue / Cost Accruals module? for now I have to reverse the JE made by that module one by one.
3. Is it possible to use Revenue / Cost Accruals to help counting asset depreciation/amortization on straight line method? My thought is I just put the economical value of the asset on the amount and on the Accrued Balance Account we put the Accumulated Depretiation Account COA and on Cost Account we put Depr. Exp COA then set the period to 12 months
Oh and I think this module should become default on the next release.
Thx
17 07/15/2010 07:11:23 am
Re: maximum digit number for transactions and COA (3 replies, posted in Setup)
I just check it. it seems in journal entry is limited to 12digits only.
D Bank 123.456.789.123
C Equity 123.456.789.123
I tried to enter 13digit :
D Bank 1.234.567.891.234
C Equity 1.234.567.891.234
but it refuses and limited only to 12digit
but if I enter :
D Bank 999.999.999.999
C Equity 999.999.999.999
D Bank 999
C Equity 999
it shows total 1.000.000.000.998,00 and successfully posted
so is there a limitation in here and we just have to split into several line if we want to post more than 12digit?
thanks
18 07/15/2010 05:52:20 am
Topic: maximum digit number for transactions and COA (3 replies, posted in Setup)
Hi there.
Me & my friends have a question, how many digits that FA can handle in a journal entry and in COA number. Because it seems my friends want to post something like this:
D Bank 1.000.000.000.000
C Equity 1.000.000.000.000
Thanks