Search options (Page 5 of 5)

05/14/2011 07:30:46 am

Greeting,

First of all, I would like to thanks you for the great open source front accounting which is very useful and powerful ERP software. Sorry that I am going to post a long topic here. We have make it pretty hard to make it work seamlessly integrate with vtiger crm and now reach a milestone that we have completed our mission by integrate both products into one dashboard using Single Sign On (SSO) with the back-end powered by Open LDAP Server.

The concept is simply make both system having the same information with our data sync suites. The idea is to eliminate all the duplicate works and also reduce the time for duplicate data entry. Your data will be sync in either ways. You can enter your data in vtiger and it will show up in front accounting and vice-versa.

We have spend for about 3 months to developed the connectors. The issue arising here is because the front accounting does not provide any Webservices API for integration purpose. Our idea is we do not want to make a major changes in Front Accounting nor vtiger crm. Hence, we study the Front Accounting source code and create our own REST Webservice API in Front Accounting. The best will go to vtiger since it already provide the REST webservice API and we re-use their existing framework to complete our task with additional custom REST API created for Quotations, Sales Order, Purchase Order and also Invoices.

We have successfully integrate these 2 open source applications with minimum changes for the following modules:

1 ways synchronization:

1) Currency (From FA to vtiger)

2 ways synchronization:

1) Accounts – Customer Information
2) Contacts – Customer Contact Information
3) Vendors – Suppliers Information
4) Products Category
5) Services Category
6) Manufacturers Category
7) Products – Products Information
8) Services – Services Information
9) Prices – Price for all Products and Services Information
10) Multi Currencies Support (future release)
11) Purchase Orders
12) Quotations
13) Sales Orders
14) Invoices

The missing part is we DO NOT implement is the DELETION in both system. Deletion will be done manually which does not supported in our data sync suites.

For those who wish to test the 2 ways synchronization, you may test our DEMO version at http://www.anterp.com/anterp/login.php

User ID: vtiger@anterp.com
Password: password1

User ID: faccounting@anterp.com
Password: password1

04/27/2011 05:48:45 am

Thanks Joe. I understand your concern now.

04/26/2011 08:58:12 am

Thanks for your replied. Is that possible to be implemented in near future? Sometime, we really need to adjust the total amount for our customer. The adjustment can be plus or minus from the total amount.

04/26/2011 06:50:13 am

Hi,

I am having some issue when dealing with the items price that need to be adjusted to some others amount. The scenario as below:

1) Create New Quotation/SalesOrder/Invoice/PurchaseOrder
2) Under Item list:

2.1) Item A 290.00
2.2) Item B 15.00
Shipping Charge 10.00
Sub-total 315.00
Amount Total 315.00

From the above information, I wish to adjust the Amount Total from 315.00 to 310.00 (by adjusted 5.00 from the total amount) and the final Total Amount become 310.00

Below show the adjusted Total Amount:

2.1) Item A 290.00
2.2) Item B 15.00
Shipping Charge 10.00
Sub-total 315.00
Adjustment 5.00
Amount Total 310.00

How can I adjust it?

04/09/2011 04:59:16 am

Hi apprayo,

Great to know that you have solve your issue. This forum is great to share our experience and knowledge with each others. Hope you enjoy it.

04/09/2011 04:53:17 am

Hi,

I agree with spott as I have the same issue with item no 4) Create new customer should also automatically create branch and branch contact. I need to create a custom function just to handle this issue. Below are some of the code extract from FA:

=========================================================================================================

begin_transaction();

add_customer($_POST['CustName'], $_POST['cust_ref'], $_POST['address'],
$_POST['tax_id'], $_POST['curr_code'], $_POST['dimension_id'], $_POST['dimension2_id'],
$_POST['credit_status'], $_POST['payment_terms'], input_num('discount') / 100, input_num('pymt_discount') / 100,
input_num('credit_limit'), $_POST['sales_type'], $_POST['notes']);

$selected_id = db_insert_id();

add_branch($selected_id, $_POST['br_name'], $_POST['br_ref'],
$_POST['br_address'], $_POST['salesman'], $_POST['area'], $_POST['tax_group_id'], $_POST['sales_account'],
$_POST['sales_discount_account'], $_POST['receivables_account'], $_POST['payment_discount_account'],
$_POST['default_location'], $_POST['br_post_address'], 0, $_POST['group_no'],
$_POST['default_ship_via'], $_POST['notes']);

$branch_id = db_insert_id();

add_crm_person($_POST['contact_name'], $_POST['contact_name'], '', $_POST['br_post_address'],
$_POST['phone'], $_POST['phone2'], $_POST['fax'], $_POST['email'],
$_POST['rep_lang'], '');

add_crm_contact('cust_branch', 'general', $branch_id, db_insert_id());

commit_transaction();

=========================================================================================================

Hope it clear. Thanks

04/09/2011 04:40:28 am

Hi apprayo,

I was unable to view your issued. Anyway, if you have any good suggestion, kindly let me know.

Thanks.

04/09/2011 04:13:11 am

Hi All,

Beware of using SQL Trail.

I have some issue when using SQL trail for debugging. I have spend quite some time to understand how it work. And finally, I have turn off this features and everything work fine.

The scenario was:

1) Create a new customer branch
2) Add Branch Contacts and here it hit an error. (The branch id should be pass to the branch contact when you create a new contact information in branch). When you activate the SQL trail. The branch id doesn't return but it return the wrong id when you execute the sql statement to retrieve the branch id using db_insert_id();

This db_insert_id(); should return the branch id but rather it return the wrong id from 0_sql_trail -> id.

For example: Insert branch return 100;
When you activate the SQL trail, it execute another sql statement to insert the debugging message in 0_sql_trail. and the sql_trail -> id now = 101.
When you execute the db_insert_id(), you expect the returning id is from branch id but instead it return 101.

When I turn off the SQL trail, and re-create the branch and branch contact. It works fine. The returning branch id is correct.

Suggestion: Please change these SQL Trail features to store the message in text file rather then in database. it will help a lot and save time for new developer like me who are trying to change FrontAccounting module. If you have any better idea, please share it with me. Thanks you.

03/22/2011 12:42:49 pm

Hi Tomarnst,

I think you can use this plugin to sync your customer contact information into FA. It regardless what Shopping Cart you are using. You can call the interface as below:

------------------------------------------------------------------------------------------------------------------------------------------------------------------------
$_company_name = "ABC Co";
$_short_name = strtolower(ereg_replace("[^A-Za-z0-9]`~!#'\"", "", str_replace(' ', '', $_company_name)));
$_first_name = "Your Name";
$_last_name = "Lim";
//Create Debtor Master
$param = array("company"=> $_company,
"user_id"=> $_uid,
"password"=>$_upswd,
"id"=>"",
"company_name"=>$_company_name,
"short_name"=>$_short_name,
"first_name"=>$_first_name,
"last_name"=>$_last_name,
"address"=>"123, Jalan ABC, Malaysia",
"email"=>"abc@yahoo.com",
"phone"=>"60311111111",
"mobile"=>"6012222288",
"fax"=>"",
"tax_group"=>"GST Tax",
"tax_id"=>"GST8888",
"area"=>"Asia",
"country_code"=>"MY",
"currency_code"=>"MYR",
"customer_type"=>"Retail",
"payment_terms"=>"Cash Only",
"credit_status_id"=>"1",
"notes"=>"Good Customer");
$antResults=$soapclient->call("create_debtors_masters",$param);

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

Hope it help...

03/16/2011 03:54:40 pm

I have created soap web services that may help to solve your issued. It's related to import customer into frontaccounting. It basically import the customer contact information which involves of debtors_master, cust_branch, crm_persons and crm_contacts. Please read my post at https://frontaccounting.com/punbb/viewtopic.php?id=1569

Hope it help.

03/16/2011 03:45:20 pm

Hi All, I have created a Soap Web Services that integrate with Customer Contact table and it will automatically populate the customer information into FrontAccounting system. This release is based on "Import Customers module" that is available in "download" page.

Initially, this web services API come with 3 methods:

1) get_debtors_masters (Query Customer Master Table)
2) get_debtor_trans (Query the Customer Transaction Table)
3) create_debtors_masters
3.1) Insert Action - Create Customer Master, Branch, Person and Contact information.
3.2) Update Action - Update Customer Master Table Only

You can used this web service to Sync Customers Contact Information with any e-Commerce and provide data integrity between
the two system.

PROBLEM: I was unable to perform Security Role Checking by using this web services. Maybe someone can share with me how FrontAccounting security Access Level rules.

You can download this "Plugin" from http://www.anterp.com/downloads/fa_soap_web_services.zip

For installation and User Guide, please read the document file at readme.txt and FrontAccounting-Web-Service.pdf

I would like to heard your suggestion, kindly reply to this forums or email to me. Thanks & Enjoy it.

Search options (Page 5 of 5)

Posts found: 101 to 111 of 111

101 Topic by tclim 05/14/2011 07:30:46 am

Topic: 2 ways synchronization between vtiger and front accounting - RELEASED (31 replies, posted in Modules Add-on's)

102 Reply by tclim 04/27/2011 05:48:45 am

Re: Quotation, Sales Order, Invoices and Purchase Order Pricing Adjustment (4 replies, posted in Accounts Receivable)

103 Reply by tclim 04/26/2011 08:58:12 am

Re: Quotation, Sales Order, Invoices and Purchase Order Pricing Adjustment (4 replies, posted in Accounts Receivable)

104 Topic by tclim 04/26/2011 06:50:13 am

Topic: Quotation, Sales Order, Invoices and Purchase Order Pricing Adjustment (4 replies, posted in Accounts Receivable)

105 Reply by tclim 04/09/2011 04:59:16 am

Re: SQL trail: inaccurate error message? (9 replies, posted in Setup)

106 Reply by tclim 04/09/2011 04:53:17 am

Re: Some of the problems and recommendations to the FA (3 replies, posted in Setup)

107 Reply by tclim 04/09/2011 04:40:28 am

Re: SQL trail: inaccurate error message? (9 replies, posted in Setup)

108 Reply by tclim 04/09/2011 04:13:11 am

Re: SQL trail: inaccurate error message? (9 replies, posted in Setup)

109 Reply by tclim 03/22/2011 12:42:49 pm

Re: SOAP Web Service (14 replies, posted in Modules Add-on's)

110 Reply by tclim 03/16/2011 03:54:40 pm

Re: Import Customers (1 replies, posted in Modules Add-on's)

111 Reply by tclim 03/16/2011 03:45:20 pm

Re: SOAP Web Service (14 replies, posted in Modules Add-on's)

Posts found: 101 to 111 of 111