SQL Accounting Software – The Secret Code “3050”
Before you start to use SQL Accounting Software, there are 2 compulsory setting, we have discussed the first, which is the Regional Setting. The second one is open a Windows Firewall Port with Port Number “3050” for SQL Accounting Software. Let us check out, how it can be done.
SQL Accounting Software Q&A – Conversion Error From String
This is a common error while using SQL Accounting Software. The reason for it is user did not do the initial setting correctly. There are 2 compulsory setting before using SQL Accounting Software. The first one is Regional Setting, which is also the solution for this error.
Supplier Invoice with Supplier Refund. Possible?
Supplier Invoice with Supplier Refund. Possible?
SQL Accounting Software Q&A – How to add “Payment By” in Payment Voucher
In this video, Bryan Cheong will show you how to add “Payment By” Account in SQL Accounting Software Payment Voucher. The same concept can be applied to Supplier Payment, and also “Received In” field in Customer Payment/Cash Book Official Receipt.
SQL Accounting Software Customisation – Customer Payment Receipt Show Outstanding
SQL Accounting Software Customisation – Customer Payment Receipt Show Outstanding
SQL Accounting Software – Transfer money from cash to bank and bank to cash
SQL Accounting Software – Transfer money from cash to bank and bank to cash
SQL Accounting Software Advance Technique– A x B = Quantity Customisation
SQL Accounting Software Advance Technique– A x B = Quantity Customisation In normal situation, we just need to key in the quantity of an item in Invoice, SQL Accounting Software will auto multiply the quantity with unit price to get the total amount. But in certain industries, the formula is not so direct, where the […]
SQL Accounting Software Advance Technique– How to Handle 3 Currencies in Customer Payment
SQL Accounting Software Advance Technique– How to Handle 3 Currencies in Customer Payment This is an advance SQL Accounting Software Technique. Take an example, you are a Malaysia company, Base Currency is in Ringgit Malaysia, you have a Singapore Dollar bank account. You Invoice your customer Company ABD in US Dollar, but they pay you […]
SQL Accounting Software – How to handle Foreign Bank Account
SQL Accounting Software – How to handle Foreign Bank Account In SQL Accounting Software, if you need to process Foreign Currency Bank Account transactions, you need to have Advance Foreign Currency Module. The Realise Foreign Exchange Gain/Loss will process automatically. However, you need to pass journal for Unrealise Foreign Exchange Gain/Loss. @askbryancheong SQL Accounting Software […]
10 Steps To Setup Commission Scheme For Your Company
10 Steps To Setup Commission Scheme For Your Company 01) Commission is based on Sales, Collection, Profit Margin or Combination? 02) Different Stock Group Different Rate? 03) Different Stock Item Different Rate? 04) Different Salesman Different Rate? 05) Different days of collection different rate? 06) Different Terms Different Rate? 07) Does it had combination for Q2 […]