Account Settings Description
For Branch code is to different multiple branch transaction. (Only 1 branch, you can ignore to set and use default value).
Cash Sales/Credit Note account settings description
Name |
Description |
Remark |
Sales |
This is a GL code, you obtain the account details from SQL Accounting > GL > Maintain Account |
|
Customer Code |
This is a customer info which set in SQL Accounting > Customer > Maintain Customer. |
|
Rounding |
Sets the rounding adjustment for the indicated values (up to the selected values). |
|
Short |
Displays the outstanding payment remaining in the account. |
|
Over |
Displays the amount overpaid in the account. |
|
Terms |
The Terms which indicate when payment is due for sales made on account. you get from SQL Accounting > Tools > Maintain Terms. |
|
Account Payable account Settings description.
* Set in Vendor Masterfile
Name |
Description |
Remark |
Account Payable (Purchase) |
This is a GL code, you obtain the account details from SQL Accounting > GL > Maintain Account. |
|
Vendor Code |
This is the Supplier, You can get from SQL Accounting > Supplier > Maintain Supplier. |
|
* Please take note, Customer(Debtor)/Supplier (Vendor) code must exist in SQL Accounting.
* Important Tips: Account Code symbol can accept for SQL Accounting is "-"
-
Refer to the ARMS system user guide list below for instructions on how to export data.
- Before open import tool, please make sure you has open SQL Accounting Software and login.
-
Click
from Desktop.
(Please download the text import tools from HERE if you experiencing the GST calculation is wrong).
- Select Sales or Purchase menu from SQL Accounting Software.
For Cash Sales, click on "Sales" and select "Cash Sales…".
For Account Receiver, click on "Sales" and select "Invoice…".
For Credit Notes, click on "Sales" and select "Credit Note…".
For Account Payable, click on "Purchase" and select "Purchase Invoice…".
- Click on “Get File” and select text file which export from ARMS System Account Module.
- Click on "Verify".
- Click on “Post To Acc” and please wait a while minutes, System will clear data on screen after successful to import data.
- If successful import data you can go to SQL Accounting, Sales Invoice/Cash Sales/Purchase Invoice to click on “Refresh” to view data.