Search options (Page 1 of 5)

Hi FineWinesUK / apmuthu,

This mobile edition was initially created by myself and I have submitted to FrontAccounting since FA 2.3.5 until 2.3.7. That was the last version I stop development after FA 2.3.7. The reason was I do not have fund and resources to continue...

  Anyway, if you have time and you are free to change it to suite your need. I appreciate if you could share the changes to the community and resubmit your changes back to FrontAccounting. Thanks You.

Cheers,

tclim

Hi kusuma,

  Yes, we have done the integration between open source POS with FrontAccounting and currently have been deploy into our customers in Malaysia. We support almost all features in open source POS except for item serialized and item kits.

  I have also posted the information in the forum at https://frontaccounting.com/punbb/viewtopic.php?id=3366. If you are interesting with the POS solutions, please read our blog at http://www.cartbooks.com/frontaccounting-point-of-sale/

You may also play around with our DEMO Site at

FrontAccounting Point Of Sales Demo Site:

FrontAccounting POS: http://www.cartbooks.com/fapos
Username: demo1
Password: password123

PHP POS Terminal 1: http://www.cartbooks.com/pos1
Username: demo1
Password: password123

PHP POS Terminal 2: http://www.cartbooks.com/pos2
Username: demo2
Password: password123

Thanks You.

Cheers,

tclim

FrontAccounting Point Of Sale Integration Suites

FrontAccounting is a great piece of software with robust back-end accounting software that support multi-currency, multi-location, stock mangement and is a lightweight ERP package. However, there are no Point Of Sale support for Retail Store.

We received quite a numbers of request from our customers mainly who are using FrontAccounting as their Accounting Software. We hereby take a step forward to developed this missing piece of code that integrated FrontAccounting with PHP POS.

The Concepts:

FrontAccounting will be the Main Office (HQ) for your company. You manage all your customers, suppliers, inventory control like item pricing, quantity, reorder level for all branches in FA. The POS Terminal will automatically populate the data into each branch respectively depending on POS Locations.

The customers and suppliers data will be share among each branches. The inventory data will be populated depending on POS Locations. This is because the customers can buy any items from different POS locations and able to use the GiftCard to redeem the goods.

For each branch, you have to setup GL Account, Bank Account, Point Of Sales, Inventory Locations and assigned your staff to each POS. These is because we need to have clear bookkeeping data for each branch.

When the customer buy item from any POS location, the sales orders will be automatically sync back to Main Office (HQ). FA will automatically create Customer, Sales Order, Sales Invoice, Delivery Order and Customer Payment depending on your setting in Payment Terms.

Note: CASH payment will create Customer Payment directly.

Online and Off-line Terminal

Our solutions support online and offline sync. The reason is if your internet line have been cut-off (downtime), your POS Terminal WILL NOT BE AFFECTED and will be operate as usual WITHOUT ANY INTERRUPTION. When your internet line resume back to normal, the data will be sync back to HQ to consolidate the Inventory, Sales Order, Customers, GiftCard and so on.

The Solutions:

Open Source POS is another great piece of software that support basic functionality of POS system but is sufficient to be use by most retail businesses. Before we use the Integration Suites, we need to setup the parameters correctly.

FrontAccounting POS configuration:

1) Setting up Inventory Locations
    - KL – Kuala Lumpur
    - PJ – Petaling Jaya

2) Setting up GL Accounts for each POS Retail Store
    - KL GL Account
    - PJ GL Account

3) Setting up Bank Accounts for each POS Retail Store
    - KL Cash Account
    - PJ Cash Account

4) Setting up Point Of Sales for each POS locations
    - POS – Kuala Lumpur
    - POS – Petaling Jaya

5) User Account Setup for each User POS. Assign Each Users to different POS location
     demo1 – Kuala Lumpur
     demo2 – Petaling Jaya

6) Payment Terms need to setup for POS at least for the Description below:
    Type: Cash, Description: Cash Only
    Type: Cash, Description: Credit Card
    Type: Cash, Description: Debit Card
    Type: Cash, Description: Gift Card
    Type: Cash, Description: Split Payments

Note: Split Payments mean the customers can partially paid by Cash and Credit Card or any combination.

7) Setting up POS Inventory Management – inventory control will be manage by FA
    - Create UOM, Categories and also create a new items
    - Set the seling pricing, re-order level for each items

8) Purchase Order Management
    - Create a new Suppliers and Contact information
    - Enter a new Purchase Order for all items until you received the items
    - Alternatively, you can make an Inventory Adjustment for each items

9) Create a universal customer called "CASH SALE", make sure the Customer Contact, Branch, Branch Contact are properly setting up. Alternatively, you should create it using PHP POS which will be automatically sync the "CASH SALE" into FA.

Below are some of the features supported by PHP POS

   - Customers, Suppliers, Items, Item Kit, Employee, Gift Cards Management
   - Sales Register – to handle sale and return items
   - Generate barcodes item for each products with label
   - Scan barcodes item into sale
   - Store Configuration
   - Summary Report
   - and so on

<b>Below are the features supported by FA POS Data Sync Suites</b>

Features     Sync Direction     Remark
Customer Contact     2-way sync     Create in FA / POSFA need to change at Contact Level
Supplier Contact     2-way sync     Create in FA / POSFA need to change at Contact Level
Category     1-way sync             Create in FA
Items     2-way sync             Create in FA / POS
Items Units     1-way sync     Create in POS
Item Locations     1-way sync     Create in POS
GiftCards     1-way sync             Create in POS
Payment Terms     1-way sync     Create in FA
                                                Type: Cash, Description: Cash
                                                Type: Cash, Description: Credit Card
                                                Type: Cash, Description: Debit Card
                                                Type: Cash, Description: Gift Card
                                                Type: Cash, Description: Split Payments
Sales Invoice     1-way sync     Create Sales Order, Sales Invoice, Delivery Order and Customers Payment
Sales Return     1-way sync     Create Customer Credit Notes on Return item

FrontAccounting Point Of Sales Demo Site:

FrontAccounting POS: http://www.cartbooks.com/fapos
Username: demo1
Password: password123

PHP POS Terminal 1: http://www.cartbooks.com/pos1
Username: demo1
Password: password123

PHP POS Terminal 2: http://www.cartbooks.com/pos2
Username: demo2
Password: password123

If you have any inquiry about the integration suites, kindly contact me to clarify. Thanks You.

Cheers,

tclim

Hi apmuthu,

  Thanks you for your time investigate and evaluating the SOAP Webservice package. These package is my initial package when I was found FA in the past 1 1/2 years ago. There are no update after the patches released until today. It will be great that you found this and hopefully Joe or Janusz will removed it from the repository.

  We have change our implementation from SOAP to REST API which was released our first REST API Mobile Edition for FA. You can downloads it from https://frontaccounting.com/wbt/pages/download/download-release-2.3.php.
   
  Again, the Mobile Edition have not been updated after the released of FA 2.3.7. The reason was I do not have time and resources to maintain it. Thanks you for your time.

Cheers,

tclim

Hi mikea,

  Sorry for the late replied.  I was not aware of this post. Although I do not setup PrestaShop FrontAccounting Sync, but it works pretty much the same as Opencart.

Cheers,

tclim

Hi Attila/Janusz,

  Do not activate Auth_LDAP if you do not have LDAP Server. If you have experience installed and activate Auth_LDAP and facing the Login problem. You need to De-activate it. Please follow the step below to De-activate the LDAP module.

  1) Edit the file located at FrontAccounting ROOT folder and also company folder. The company folder will start with company/0 company/1

   1.1) Open the file at installed_extensions.php, set the  'active' => false
       
       $installed_extensions = array (
  1 =>
  array (
    'name' => 'Auth_LDAP',
    'package' => 'auth_ldap',
    'version' => '2.3.5-1',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/auth_ldap',
  ),
);

   1.2) Open the file at company/0/installed_extensions.php, set the  'active' => false
       
       $installed_extensions = array (
  1 =>
  array (
    'name' => 'Auth_LDAP',
    'package' => 'auth_ldap',
    'version' => '2.3.5-1',
    'type' => 'extension',
    'active' => false,
    'path' => 'modules/auth_ldap',
  ),
);

  These module was submitted by myself, but if you do not have Ldap Server. It doesn't work. Hope it help.

Cheers,

tclim

Hi seahawk,

  Thanks you for your great suggestion. Creating a plugin on vtiger make sense. But our solutions need to cater for others open source software which come from the idea to bundle useful open source software into one dashboard through Single Sign On Process (SSO) via OpenLDAP Server.

  The best is Vtiger provide REST API which can be call remotely. Hence, we can simply call Vtiger API by passing all the requires parameters into their Web Services. The records will be sync in both system. Although not all Webservices are available in Vtiger but you can create your own custom WebServices and deployed into Vtiger easily. This is how our current solutions works on both system.

Cheers,

tclim

Hi Elax,
 
   I should into git and hg as well. Currently, we use SVN in our in-house development. I will take a look at git sometime later.

Hi RodW,

   Yes, SVN support Dreamweaver as well as Eclipse.  You might need to take a look.

Cheers,

tclim

Hi RodW,

   To developed the Report, you should follow the ways how it work in header2.inc. When you change the line height or whatever related to the fontSize, you should change it back after you use it. Let me show you some example below:

    $this->fontSize += 4;
    $this->Font('bold');
    $this->Text($ccol, $this->company['coy_name'], $icol);
    $this->Font();
    $this->fontSize -= 4;

  The first line indicate that you wish to increase the fontSize by 4. After you render the text, at the last line you should decrease the fontSize by 4. All setting will be back to normal. Hope I answer your question. Thanks you.

Cheers,

tclim

Hi rodw,

  Just share with you how I manage the source code in our development. Although most of the developers have their own preferences, you can use any tools to mange it. Let me share with you what I am using currently for developments.

My Linux Desktop:
1) Eclipse (IDE)
2) SVN (Source Code Version Control)
3) MySQL Client  Workbench (Database)
4) Fedora 15 (Desktop)
5) Meld (File/Directory comparison)

If you are running in Windows:
1) Eclipse (IDE)
2) SVN (Source Code Version Control)
3) MySQL Client  Workbench (Database)
4) Windows OS (Desktop)
5) WinMerge (File/Directory comparison)

Here how you can track your version control using Eclipse. I assume that your SVN is ready in Eclipse IDE. Right Click on any file  -> compare with -> Revision. You should see a list of the historical files that you have committed into SVN.

  Alternatively, you can use Meld/WinMerge to compare it. Hope it help.

Cheers,

tclim

Hi Janusz and All,

  I did not notice that all my long explanation here have been TRUNCATED to become "There are no" ? This will really confuse all FA users include Janusz and Excellence in the forums.  It could be a Bug in PunBB. I really appreciate you could fixed this issue  as soon as possible.

Where is my long explanation?  I have wrote a long explanation to let all users know the problem and the issue with UTF-8? But all gone and leave the word "There are no". And this "There are no" really killing my explanation. It kill myself as a helper in this topic and it confuse all FA users include FA Administrator.

My actual explanation have been repeat here by Janusz. Thanks Janusz for your explanation. This issue will be CLOSED after my last message here (I hope no more argument after this). We will stick to the current framework as it is.

My final word, please FIXED the forums TRUNCATED issued as it really confuse myself and all FA users. Thanks You.

Cheers,

tclim

Hello Excellence,

   I have granted the admin user id and password to you. You can change the Access Rights for your need. By the way, there are 2 type of Arabic COA. Previously, I have created with ARABIC EGYPT 8 DIGITS. I have now created another ARABIC EGYPT COA at the end of the combobox. I am not sure which 1 you are using. You can now login with the information below:

  URL:  http://www.anterp.com/fa/index.php
  Login ID: admin
  Password: password1

  Please reply to me your finding. Thanks you.

Cheers,

tclim