Is there alternative link, this one is broken https://frontaccounting.com/sourceforge.net/projects/frontaccounting

I need to post direct sales automatically from another application into FA system.

Please help, I've struggled for hours trying to make use of the starting point SOAP web service by Gareth Obrien found here https://frontaccounting.com/wbt/pages/download/download-release-2.3.php but I don't seem to get it to work. Wish there was a sample working code.

28

(28 replies, posted in Banking and General Ledger)

Hi guys,
Any success on cashflow statement? I really need it so much.

29

(5 replies, posted in FA Modifications)

Thanks again for your reply,
please note, the remote journal entries are not in a Frontaccounting DB, that's why am building a function that will read it on every system load and pull any new entries into current Fronaccounting. What I don't understand, besides inserting records into 0_gl_trans are there other table that needs updated on every journal entry.

Also observing the journal table, there are fields such as counter,type,type_no,person_type_id that I don't know how to get whatever info that goes into them.

Thanks

Please help, have studied the module for importing journal entries from CSV, but I want to do the same but get them from a remote table, been trying but don't seem to get it right, here is my code

include_once($path_to_root . "/includes/ui/items_cart.inc");
           
function get_dimension_id_from_reference($ref)
{
    if ($ref == null || $ref == '')
        return 0;
       
    $sql = "SELECT id FROM ".TB_PREF."dimensions WHERE reference LIKE '$ref'";

    $result = db_query($sql, null);
   
    $row = db_fetch_row($result);
   
    return $row[0];
}       
add_access_extensions();
   
    global $Refs;

        $cart = new items_cart(0);
        $cart->order_id = 0;
        $cart->reference = $Refs->get_next(0);
        $cart->tran_date = new_doc_date();

        if (!is_date_in_fiscalyear($cart->tran_date))
            $cart->tran_date = end_fiscalyear();

        $_POST['memo_'] = $cart->memo_;
        $_POST['ref'] = $cart->reference;   
        $_POST['date_'] = $cart->tran_date;
   
        $_SESSION['journal_items'] = &$cart;
           
        //print_r($_SESSION['journal_items']);
           
        $dim1 = get_dimension_id_from_reference('1');
        $dim2 = get_dimension_id_from_reference('2');
           
           
            $data = array(0=>array(0 => '1060',1=>$dim1,2=>'90000',3=>"Savings Account"),
                          1=>array(0 => '204',1=>$dim1,2=>'-90000',3=>"Construction Donations")
                          );

            foreach($data as $r){
                // Check that the account code exists
                if (get_gl_account($r[0]) == null) die("Error: Could not find account code $r[0]");

                //$test .= $r[0]." ".$r[1]." ".$r[2]." ".$r[3]."</br>";
                $_SESSION['journal_items']->add_gl_item($r[0], $r[1], '', $r[2], $r[3]);
            }

31

(5 replies, posted in FA Modifications)

Thanks for your reply, I'll try and get my head round it. Actually am trying to have the system check for Journal entries in a remote table and have them entered into FA. This should be happening when the system loads, it checks whether there are any entries and then imports them, just like the CSV version, but this should read from a Database table instead of csv file.

32

(5 replies, posted in FA Modifications)

Hi all,
Is there some even listener method that one can create a plugin that does some stuffs such as wehn the application is loading  etc.

33

(13 replies, posted in FA Modifications)

Am also going through this problem and I don't seem to get it fixed, I have no idea what am doing wrongly, I have scoured the forums and can't figure out. Am trying to install new Human Resource tab and here is my code

<?php
define ('SS_HR',102<<8);

class human_resource extends application
{
        function human_resource()
        {
                global $path_to_root;
               
           
                $this->application("hr", _($this->help_context = "&Human Resource"));

                $this->add_module(_("Human Resource"));
                $this->add_lapp_function(0, _("Staff"),
                        $path_to_root.'/modules/human_resource/staff.php', 'SA_STAFF');
               

                $this->add_module(_("Payroll Management"));
                $this->add_lapp_function(1, _("Payroll Management"),
                        $path_to_root.'/modules/human_resource/payroll.php', 'SA_PAYROLL');
               

                $this->add_extensions();
        }
}


class hooks_hr extends hooks {
        var $module_name = 'human_resource'; // extension module name.

        function install_tabs($app) {
                set_ext_domain('modules/human_resource');        // set text domain for gettext
                $app->add_application(new human_resource); // add menu tab defined by example_class
                set_ext_domain();
        }


        function install_access()
        {
                $security_sections[SS_HR] = _("Human Resource");

                $security_areas['SA_HR'] = array(SS_HR|1, _("Human Resource"));
                $security_areas['SA_PR'] = array(SS_HR|2, _("Payroll"));
               
                return array($security_areas, $security_sections);
        }

}

?>

Trying my first ever FA module, it's installing without issues but tabs are not created and can't see the links anywhere after installation. Here is the hooks.php file, what am I missing

<?php
define ('SS_HR',102<<8);

class human_resource extends application
{
        function human_resource()
        {
                $this->application("hr", _($this->help_context = "&Human Resource"));

                $this->add_module(_("Human Resource"));
                $this->add_lapp_function(0, _("Staff"),
                        $path_to_root.'/modules/human_resource/staff.php', 'SA_STAFF');
               

                $this->add_module(_("Payroll Management"));
                $this->add_lapp_function(1, _("Payroll Management"),
                        $path_to_root.'/modules/human_resource/payroll.php', 'SA_PAYROLL');
               

                $this->add_extensions();
        }
}


class hooks_hr extends hooks {
        var $module_name = 'human_resource'; // extension module name.

        function install_tabs($app) {
                set_ext_domain('modules/human_resource');        // set text domain for gettext
                $app->add_application(new human_resource); // add menu tab defined by example_class
                set_ext_domain();
        }


        function install_access()
        {
                $security_sections[SS_HR] =     _("Human Resource");

                $security_areas['SA_HR'] = array(SS_HR|1, _("Human Resource"));
                $security_areas['SA_PR'] = array(SS_HR|2, _("Payroll"));
               
                return array($security_areas, $security_sections);
        }

}

?>