Search options

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