How to Integrate Popcorn into Million Accounting System

Server PC

Step 1: Identify the PC SQL Server ML001 port number 

• Go to Computer Management & Select Services and Application

• Select SQL Server Configuration Manager

• Select SQL Server Network Configuration

• Select Protocols for ML001

• Select TCP/IP

• Select IP Addresses & refer to TCP Dynamic Ports (This is the SQL ML001 Port) 

1. Do Port Forwarding for that SQL Port in Router

• Login to Router Admin Portal (192.168.1.1), and set Port Forwarding for SQL Port (Different brand of router may have different method to set)

Step 2: Server PC must Fix IP Address

Step 3: Window Defender Firewall: Create new rule for Inbound & Outbound Rule for SQL Port number

• Go to Window Defender Firewall & Select Advanced Settings

• Select Inbound Rule & Create New Rule

• How to create Inbound New Rule:

Step 1: Select Port

Step 2: Select TCP and key in Port Number

Step 3: Allow the connection

Step 4: Tick all the option

Step 5: Key in the Name and click Finish

Step 6: Continue the steps above to create UDP rule

• How to create Outbound New Rule:

Step 1: Select Outbound Rule & Create New Rule

Step 2: Select Port

Step 3: Key in The SQL Port Number

Step 4: Allow the Connection

Step 5: Tick all the option

Step 6: Key in the name and click Finish

Step 7: Continue the steps above to create UDP rule

Step 4: Go to www.popcorn-pos.com, Select Integration, Select connect to Million

Database Link : PUBLIC IP ADDRESS,PORT NUMBER (60.50.116.161,55512)
(You can Google Search: What is my Public IP) 

• Select Account Number in Million Accounting System

• Select outlet to export

• Can select date range , outlet and invoices that want to import to the Million Accounting System

• After click export, the status will show SENT

Million Accounting System

• Million Accounting will automatically show out the Double Entry