NIT
  • Business Models
    • Table Service
    • Quick Service
    • Retail
  • POS System
    • Tablet POS
    • All In One POS
    • Modular POS
  • POS Services
    • NeoPOS
    • NeoMobile
    • NeoCloud
  • E-Wallet Services
  • Clientele
  • Blog
  • NeoReport

Tutorial: NeoPOS - SQL Accounting Integration Guide

22/5/2018

0 Comments

 
Picture


NeoPOS - SQL INTEGRATION GUIDE 
This guide is to teach you how to setup and use the integration App to post the sales data to SQL accounting system.

SETTING

1. Please download the Import Tool Version 5 (SQLAccTxtImpV5-setup.exe) provided by SQL.

2. Please download the Export Too Version 1.0 (SQLIntegration V3.0.zip) provided by NIT.
​
3. Unzip and open the SQLIntegration V1.0.exe provided by NIT, fill in the account information and click save. Make sure the database connection to the POS system is active.
* The tools please contact NIT / SQL to get the download link.
Picture
Pic 1
  • The default value of “Invoice Prefix” will be “CS-”. For “Customer Code”, “Customer Name”, and “Description”, you have to follow the setting from SQL ACC software. Open your SQL ACC software, browse to “Customer”->”Maintain Customer” and look for “Cash Sales” just like the picture (Pic 2) shown below.​
Picture
Pic 2
​4. For “Terms”, open the SQL ACC software and browse to “Tools” -> “Maintain Terms” just like the picture (Pic 3) shown below. Make sure the terms name is saved exactly the same.  
Picture
Pic 3
​5. For “GL Code (Sales)”, open the SQL ACC software and browse to “GL”->”Maintain Account” and look for “SALES”. Get the GL code and save it in the setting. 
Picture
Pic 4
6. After the setting is saved, you can now generate the sales the day that you wish to import into SQL ACC software. ​Make sure the product name in the POS System is not in Chinese Character as it is not supported by the Import tool provided by SQL.


EXPORT AND IMPORT

​1. Install the SQLAccTxtImpV5-setup.exe. After the installation, make sure the SQL ACC Software is opened and logged in before you run the exe.
​
2. Browse to “Sales”->”Cash Sales” like the picture (Pic 5) shown at below:
Picture
Pic 5
  • Below interface (Pic 6) will appear once you clicked “Cash Sales” from above picture (Pic 5) . Click the “Get File” button and browse to the generated text file.
Picture
Pic 6
​3. Once you selected the text file, the data of the text file will be displayed inside the table just like the picture shown below. Click “Verify” button so that all the data can be verified before import into the SQL ACC Software.
Picture
Pic 7
  • Below image (Pic 8) shows the verifying process. You can see the status of each invoices. “Ok” means no problem for that particular invoice.
Picture
Pic 8
4. Make sure all the status are verified as “OK” and the checkboxes are checked/selected. Click the “Post To A/c” button to import into SQL ACC Software.
Picture
Pic 9
  • Import in progress is shown in below image (Pic 10).
Picture
Pic 10
​5. Imported successfully message will be prompted next.
Picture
Pic 11
​6. Browse to SQL ACC Software and check the invoices. (Go to “Sales”->”Cash Sales”). Export and import is completed successfully.
Picture
Pic 12
Kindly contact us if you have any question on this guide. If you are interesting to integration your NeoPOS system with SQL accounting system, please contact our sales person or live chat us now.


0 Comments



Leave a Reply.

    Translate This Blog

    Google
    Custom Search

    RSS Feed



    NIT - Neo Info Tech System S/B

    Established in 2004, is developing IT solutions especially in POS SYSTEM industry. About Us

    Archives

    June 2020
    February 2020
    August 2018
    July 2018
    June 2018
    May 2018
    July 2017
    March 2017
    February 2017
    July 2016
    April 2016
    March 2015
    October 2014
    May 2013
    August 2012
    July 2012

    Categories

    All
    Apple
    Food & Beverage
    Neopos
    NeoPOS Tutorial
    Others


POS Hardware

Tablet POS
All-In-One POS
Modular POS
​Your Own Hardware
​Refurbished

POS Software

NeoPOS
NeoMobile Android
NeoMobile Windows
​NeoCloud
​Key Features

Business types

Table Service
Quick Service
Retail
​Food Court
​Food Truck

Support

Contact Us
About Us
Terms of Use
​
Privacy policy of NeoMobile
​Form
Picture

Not sure which to buy?  (+60162011142 | +60163281142 | +60380791142).  Call us now, or find a reseller.
​
Copyright © 2016 NEO INFO TECH SYSTEM SDN. BHD. All right reserve.
Designed By Neo Info Tech System Sdn.Bhd.
  • Business Models
    • Table Service
    • Quick Service
    • Retail
  • POS System
    • Tablet POS
    • All In One POS
    • Modular POS
  • POS Services
    • NeoPOS
    • NeoMobile
    • NeoCloud
  • E-Wallet Services
  • Clientele
  • Blog
  • NeoReport