Search options (Page 3 of 5)

Hello,

  This issue can be solved using the FrontAccounting Fonts at download link. Please try to downloads the dejavu font at

https://frontaccounting.com/wbt/modules … hp?file=57

Follow the step below to deployed into your FrontAccounting.
1) Extract the dejavu.zip
     Files will be extracted as below:
     - dejavu.ctg.z
     - dejavu.php
     - dejavu.z
   
  2) Use the FTP program (Filezilla) to migrate all the 3 files into reporting/fonts folder.
  3) Login to your FrontAccounting and access your PDF report now. It should work now.

  Hope it help.

Cheers,

tclim

Hi civil777,

    You are welcome. You can extend the API as you need. I agree that the Downloads section for "FA Mobile Edition" should be rename to "REST API & Mobile Edition".

  Hi Joe, please help to rename and make it clear for all developers who wish to get started with REST API. Thanks You.

Cheers,

tclim

Hi erwindebruin,

   Since I have send you the files in the past 2 days without further replied. I assume that you already fixed your issue. Hence, this issue will be closed.

  For those who are facing the same issue where after upgrading your FA 2.3.5 to 2.3.7 having login issue, please get the download from http://www.anterp.com/downloads/fa_237.zip.

Cheers,

tclim

Hi erwindebruin,

  It seem like the issue was due to FA 2.3.5 does not have LDAP Authentication. In FA 2.3.6 onward, FrontAccounting does support for External LDAP Authentication. Can you send me the files below and I will help you to check it.

1) includes/session.inc
2) includes/current_user.inc
3) includes/hooks.inc
4) admin/db/users_db.inc

Cheers,

tclim

Hello All,

  We have added another Open Source Shopping Cart System - CRE Loaded into our Data Sync Suites. We are now supporting CRE Loaded Version 6.0 - 6.4.1a.

  For more information, please visit us at http://www.anterp.com/shop/creloaded-ac … ntegration . Thanks You.

Cheers,

tclim

Hi briankeesbury,

  Thanks you for using FrontAccounting Mobile Edition and I hope that you can help in continuing improve this version and remember to release back to the community. Let us work together to make it work.

Cheers,

tclim

Hi Tom,

   The data sync suites are available for downloads only applicable for PAID services via

OsCommerce FrontAccounting Integration.

     I don't think you need it as you can build it yourself. If you have time, please spend some time referring to FrontAccounting SOAP Web Service API. This module will create Customers and Contacts into FrontAccounting. You can "duplicate" it for the rest of the modules.

     I hope you enjoy it.

    For those who wish to use our Data Sync Suites. You may buy it from our Shop at  http://www.anterp.com/shop

  Cheers,

  tclim

Hi All,
 
   As I understand that Tom is the person in charge with OsCommerce Import/Export module and it should work great if you always Import/Export data from and to between the 2 system. The idea is great for those who are running the small business using OsCommerce.

   We are currently provide more convenience solutions to resolve the issue of OsCommerce FrontAccounting Integration by automate the process with automatically sync data from Oscommerce into FrontAccounting.

   This solutions will reduce the duplicate data entry while increasing your productivity. You should focus on your "Sales". The system will automatically sync your Customers, Contacts, Categories, Products, Inventory Status, Sales Order and Sales Invoice into frontaccounting.

a) OsCommerce FrontAccounting Integration
This "plugin" is running a single  batch process only. The data synchronization features covers Customers, Contacts, Categories, Products, Stock Status, Sales Order and Sales Invoices. The Sales Order enter in OsCommerce will be automatically sync into frontaccounting while Sales Invoices are 2-ways sync.

For Inventory Status like Stock Price and Stock Quantity will be automatically sync from FrontAccounting into OsCommerce. No more Import/Export need to be done...The only requirements is you need to enter your Purchase Order or Stock Adjustment in FrontAccounting. The items you received with the selling price and quantity will be automatically sync to OsCommerce.

The solutions will solve the issue below:

1) No more Import/Export need to be done. It's automatically synced.
2) No more copy & paste your customer, contact, categories, products, orders & etc from oscommerce to frontaccounting.
3) No duplicate data entry. The data sync suites will automatically map the data and perform insert/update data into frontaccounting.

This plugin have divided into 2 section:

1-ways synchronization from OsCommerce to FrontAccounting for the action below:
a) Customers.
b) Contacts
c) Categories
d) Products

1-ways synchronization from FrontAccounting to OsCommerce for the action below:
a) Stock Status (price, quantity)

2-ways synchronization from both FrontAccounting and OsCommerce for the action below:
a) Sales Order
b) Sales Invoice

FREE OF CHARGE
FrontAccounting Mobile Edition, you are now able to view the status for Customers, Contacts, Suppliers, Products, Stock Status, Sales Order and Sales Invoices. It provide a conveniences for you to check your status using your Smartphone (Iphone / Android / BlackBerry/ Windows Mobile 7 etc).

Compatible version:

OsCommerce - 2.3.1 only

FrontAccounting - 2.3.5  / 2.3.6 only

If you are interested with this solutions, you may visit us at http://www.anterp.com/shop/oscommerce-f … ntegration

DEMO: OsCommerce Site:
**************************************************************************

Front-End:
http://www.anterp.com/osc/
Username: faccounting@anterp.com
Password: password1

Back-End:
http://www.anterp.com/osc/admin/login.php

Username: demo1
Password: password1
**************************************************************************

DEMO: FrontAccounting Site:
**************************************************************************
http://www.anterp.com/acctosc/

Username: demo1
Password: password1
**************************************************************************

DEMO: How to Access Your Mobile Edition:
**************************************************************************
http://www.anterp.com/acctosc/mobile/index.html

Username: demo1
Password: password1
**************************************************************************

Hi Austin,

   Yes, we are developed this Mobile Edition using iPhone. You can use your iPhone to test it.

Thanks

  Cheers,

  tclim

Hi old_guy,

  In order to insert products into FA. You may refer to the table stock_master. For stock category, you may refer to stock_category.

Below are my sample code that I created to synchronize the item in FA. If you need to use it, you need to change the parameter values in the array Object. I have hardcoded for my testing.

-------------------------------------------------------------------------------------------------------------------------------------
$objInfo = array();       

//Array Information           
$objInfo['units'] = 'Each';
$objInfo['units_of_measure'] = '0';
$objInfo['tax_type'] = '0';
$objInfo['qty'] = '1';    
$objInfo['mb_flag'] = 'B';                    

$objInfo['sales_act'] = '';
$objInfo['cogs_act'] = '';
$objInfo['inventory_account'] = '';
$objInfo['adjustment_account'] = '';
$objInfo['assembly_account'] = '';
$objInfo['dim1'] = '';
$objInfo['dim2'] = '';
$objInfo['actual_cost'] = '0';
$objInfo['last_cost'] = '0';            
$objInfo['labour_cost'] = '0';
$objInfo['overhead_cost'] = '0';
$objInfo['no_sale'] = '0';
$objInfo['editable'] = '0';            
       
//Set information
$objInfo['stock_id'] = '123';
$objInfo['description'] = 'abc';           
$objInfo['long_description'] = 'this is a description of the item';
$objInfo['category'] = 'productcategory';            
$objInfo['material_cost'] = '100.00';
$objInfo['price'] = '150.00'
$objInfo['reorder_level'] = '10';
//FA Active Record = 0 and InActive = 1
$objInfo['inactive'] = '0'

Method name: syncItem
-------------------------------------------------------------------------------------------------------------------------------------

/*
* To Sync Item
* $arrObj            -    Item Array Object
* $return            -    Item ID
*/
function syncItem($arrObj) {
    global $log;
   
    $selected_id = '';
    $category_id = '';
    $item_unit_id = '';

    //Retrieve Item Units   
    $sql = "SELECT abbr FROM ".TB_PREF."item_units WHERE UPPER(name) = UPPER(" . db_escape($arrObj['units']) .")";
    $result = db_query($sql, "Unable to find units");
    $row = db_fetch_row($result);
   
    if (!$row) {           
        write_item_unit('', strtolower($arrObj['units']), $arrObj['units'], $arrObj['units_of_measure']);
        $item_unit_id = strtolower($arrObj['units']);
    } else {
        $item_unit_id = $row[0];
    }
   
    //Retrieve Category Id           
    $sqlCategory = "SELECT category_id FROM ".TB_PREF."stock_category WHERE description LIKE " . db_escape(stripslashes(trim($arrObj['category'])));
    $resultCategory = db_query($sqlCategory, "could not get stock category");

    $rowCategory = db_fetch_row($resultCategory);
   
    if (!$rowCategory) { //If category not exist, add new category
        add_item_category($arrObj['category'],$arrObj['tax_type'],    $arrObj['sales_act'],
                        $arrObj['cogs_act'], $arrObj['inventory_account'], $arrObj['adjustment_account'], $arrObj['assembly_account'],
                        $item_unit_id, $arrObj['mb_flag'],    $arrObj['dim1'], $arrObj['dim2'],    $arrObj['no_sale']);
   
        $category_id = db_insert_id();
    } else {
        $category_id = $rowCategory[0];
    }

    //Query Stock ID
    $sql = "SELECT a.stock_id FROM ".TB_PREF."stock_master a WHERE (a.stock_id = " . db_escape($arrObj['stock_id']) . " || a.description = " . db_escape($arrObj['description']) . ")";
   
    $result = db_query($sql, "stock item could not be retreived");
   
    $row = db_fetch_row($result);

    //Default to returning ID
    $selected_id = $arrObj['stock_id'];
   
    //Retrieve the default currency
    $currency_code = get_company_pref('curr_default');

    //Insert or update Item
    if (!$row) {
           
        add_item($arrObj['stock_id'], $arrObj['description'],
            $arrObj['long_description'], $category_id, $arrObj['tax_type'],
            $item_unit_id, $arrObj['mb_flag'], $arrObj['sales_act'],
            $arrObj['inventory_account'], $arrObj['cogs_act'],
            $arrObj['adjustment_account'], $arrObj['assembly_account'],
            $arrObj['dim1'], $arrObj['dim2'],$arrObj['no_sale'],$arrObj['editable']);
    } else {
            $sql = "UPDATE ".TB_PREF."stock_master SET long_description=".db_escape($arrObj['long_description']).",
                    description=".db_escape($arrObj['description']).",
                    category_id=".db_escape($category_id).",
                    tax_type_id=".db_escape($arrObj['tax_type']).",
                    units=".db_escape($item_unit_id).",
                    inactive=".db_escape($arrObj['inactive']).",
                    mb_flag=".db_escape($arrObj['mb_flag']) . " WHERE stock_id=".db_escape($arrObj['stock_id']);
           
            db_query($sql, "The item could not be updated");
       
            update_item_code(-1, $arrObj['stock_id'], $arrObj['stock_id'], $arrObj['description'], $category_id, $arrObj['qty']);
           
           
            if (isset($arrObj['currency_code'])) {
                $currency_code = $arrObj['currency_code'];
            }
           
            $sql = "UPDATE ".TB_PREF."prices SET curr_abrev=".db_escape($currency_code).",
                price=".db_escape($arrObj['price'])." WHERE stock_id=".db_escape($arrObj['stock_id']);
           
            db_query($sql,"an item price could not be updated");
        }
       
        //Update Item Codes
         $sql = "SELECT id from ".TB_PREF."item_codes WHERE item_code=" . db_escape($arrObj['stock_id']) . " || stock_id = " . db_escape($arrObj['stock_id']);
        $result = db_query($sql, "item code could not be retreived");
        $row = db_fetch_row($result);
        if (!$row) {
            add_item_code($arrObj['stock_id'], $arrObj['stock_id'], $arrObj['description'], $category_id, $arrObj['qty']);           
        } else {
            update_item_code($row[0], $arrObj['stock_id'], $arrObj['stock_id'], $arrObj['description'], $category_id, $arrObj['qty']);
        }
        
    return $selected_id;
}

-------------------------------------------------------------------------------------------------------------------------------------