Search options (Page 2 of 4)

Hello,

Find bellow a simple way to let the outstanding FA package support characters ID's in the Classes/Types Accounts.

1 - use en_US-Demo.sql  & en_US-New.sql Supporting Classes/Types Characters
     id's. This will be done easly by changing :

       - all varchar(11) should be changed to varchar(15) in the .sql file

       - CREATE TABLE `0_chart_class` (
         `cid` varchar(3) NOT NULL default '',
         `class_name` varchar(60) NOT NULL default '',
         `ctype` tinyint(1) NOT NULL default '0',
         `inactive` tinyint(1) NOT NULL default '0',
          PRIMARY KEY  (`cid`)
          ) TYPE=MyISAM  ;

       - CREATE TABLE `0_chart_master` (
         `account_code` varchar(15) NOT NULL default '',
         `account_code2` varchar(15) default '',
         `account_name` varchar(60) NOT NULL default '',
         `account_type` varchar(10) NOT NULL default '0',
         `inactive` tinyint(1) NOT NULL default '0',
          PRIMARY KEY  (`account_code`),
          KEY `account_code` (`account_code`),
          KEY `account_name` (`account_name`)
          ) TYPE=MyISAM  ;

        - CREATE TABLE `0_chart_types` (
         `id` varchar(10) NOT NULL default '',
         `name` varchar(60) NOT NULL default '',
         `class_id` varchar(3) NOT NULL default '0',
         `parent` varchar(10) NOT NULL default '-1',
         `inactive` tinyint(1) NOT NULL default '0',
           PRIMARY KEY  (`id`),
          KEY `name` (`name`)
          ) TYPE=MyISAM;

2 - do those simple modifications in the bellow files :

    * gl/includes/db/gl_db_account_types.inc

          - function add_account_type
            $sql = "INSERT INTO ".TB_PREF."chart_types (id, name, class_id, parent)
          VALUES (".db_escape($id).", ".db_escape($name).", ".db_escape
                                    ($class_id).", ".db_escape($parent).")";         
                     // FA original was  : VALUES ( $id,.......

          - function get_account_types
               $sql .= " ORDER BY class_id, id, parent ";
                    // FA Original : " ORDER BY class_id, id"

          - function get_account_classes
               $sql .= " ORDER BY ctype,cid";         
                   //  FA Original : " ORDER BY cid"

    * gl/manage/gl_account_classes.php
            1. comment the following lines:
      /* if (!is_numeric($_POST['id']))
        {
              display_error( _("The account class ID must be numeric."));
               set_focus('id');
                          return false;
         }
                */
            2. in the delete check :
         $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_types
                          WHERE class_id=".db_escape($selected_id)." ";
                             // FA Original:  class_id=$selected_id

     * gl/manage/gl_account_types.php
            1. comment the following lines:
    /*   if (!input_num('id'))
          {
            display_error( _("The account id must be an integer and cannot
                                                 be empty."));
            set_focus('id');
            return false;
           }
                */
            2. minor changes:
                 - $th = array(_("Group ID"), _("Group Name"), _("Subgroup Of"),
                                    _("Class Type"), "", "");    // khaled : ID ; Name

                 - if ($myrow["parent"] == "0")
                        //FA Original :   if ($myrow["parent"]== ANY_NUMERIC)
     
      * gl/manage/gl_accounts.php
    - text_row_ex(_("Account Code:"), 'account_code', 15);     
                       //FA Original was 11
                -  text_row_ex(_("Account Code 2:"), 'account_code2', 15);   
                      //FA Original was 11

       * includes/ui/ui_lists.inc
       'order' => array('account_code','type.id'),   
                      // FA Original :  array('type.id','account_code'),

Should also change in config.php : $accounts_alpha = 1;

I hope you will find those modifications usefull.

Finally, This is how I use FA & in every new version I do those modifications.

Regards,

Khaled

Hello Joe,

Can you give us please a simple example of the new Group Accounts Multi Level Feature.

And how we can profit from the new facility of :
  " GL Account Types (Groups) allows up to 10 digits  " ?

From other side is it possible from your side to include an option for changing :

id (chart_types) to Character in Config.php ?

Thanks

khaled

Hello,

I wish from your side, to expand the possibility of using " Characters " when defining the ID numbers in Classes & Types accounts tables.

This will help efficiently in developing reports by grouping the descendent accounts under any group type or class using simple SQL statements.

In this case , using RepGen 2.2 will be very simple to explore & report any grouping of accounts transactions & data.

I am sure that with such simple modification
Note when using character types in :

chart_class (cid)   
I suggest : cid varchar(3)   

chart_types (id ; class_id)   
I suggest : id varchar(8)   & class_id varchar(3)   

chart_master (account_code ; account_type)         
I suggest : account_code varchar(15) & account_type varchar(8)

So you may build an interrelated hierarchical tree for your chart of account who can be accessed at any level you want from a simple SQL Statement using RepGen2.2.

I am sure it will be a wonderfull solution for reporting.

ex. :

1        Class
11       Type
111     Sub-Type
11111  Account

Regards,

Khaled

Hello Joe,

in RepGen, if you try to go :

Account List [Run] ==> then next if you try to :

press the  Button [ Test the SQL Statement ], you will find a Bug.

And this is how I fix it in 2 steps :

1. Replace in : repgen_create.php ( line 203 #  )

from :
-------

$txt = "<input type='button' name='test_sel' value='".TEST_SEL.
    "' onclick=\"openWindow('".REPGENDIR."/repgen_test_sel.php"."', 'SQL');\" >";

to :
----

$txt = "<input type='button' name='test_sel' value='".TEST_SEL.
    "' onclick=\"openWindow('".REPGENDIR."/repgen_test_sel.php?var101=".$sql."', 'SQL');\" >";

2. Add in :    repgen_test_sel.php  ( line 22 # )

$sql =$_GET['var101']; 

So the Bug is fixed at this stage.
----------------------------------------------------------

But, If you enter a New SQL statement in the textarea & try to

press the  Button [ Test the SQL Statement ], you will find that now , the $sql

variable was not passed through ( var101 ) to the pop up window like if it treats

$sql = "".

Instead of that, if you press the [Page Definition for Strings], you will find

that the page is directed to a new page and $sql now is treated well.

I could not find the clue. Can you help resolving this bug please.

Regards,

Khaled

Hi,

When duplicating the ID's of Classes, Types or Account

the system do not display the msg :

"The entered information is a duplicate. Please go back and enter different values."

as expected and as it was in FA215

Kalido