Sunday, March 15, 2015

MAINTAIN ITEM TEMPLATE

Source of Video: https://www.youtube.com/watch?v=e8JW2OS4560&feature=youtu.be
Youtube Channel: SQL MYSOFTWARE

Where to maintain?
Stock > Maintain Item Template


MAINTAIN STOCK OPENING VALUE

Source of Video: https://www.youtube.com/watch?v=j2lyrxV2fDw
Youtube Channel: SQL MYSOFTWARE

Where to maintain?
File > Maintain Stock Value > Edit


BILL OF MATERIAL (BOM)

Source of Video: https://www.youtube.com/watch?v=aMRZSKTJf-s&feature=youtu.be
Youtube Channel: SQL MYSOFTWARE


MAINTAIN STOCK VALUE

Source of Video: https://www.youtube.com/watch?v=j2lyrxV2fDw&feature=youtu.be
Youtube Channel: SQL MYSOFTWARE

Where to maintain?
GL > Maintain Stock Value


MAINTAIN STOCK GROUP & STOCK ITEM

Source of Video: https://www.youtube.com/watch?v=CS4f2dsVxUI&feature=youtu.be
Youtube Channel: SQL MYSOFTWARE

Where to maintain?
Stock > Maintain Stock Group
Stock > Maintain Stock Item


START GST

Source of Video: https://www.youtube.com/watch?v=QkOH9NAvN1E&feature=youtu.be
Youtube Channel: SQL MYSOFTWARE

Where to Start?
GST > Start GST


MAINTAIN FORM MODE (BY AGENT)

Source of Video: https://www.youtube.com/watch?v=bqSDZlAhM5I
Youtube Channel: eStream SQL

Where to maintain?
Tools > Maintain Form Mode


Saturday, March 14, 2015

MAINTAIN OPENING BALANCE

Source of Video: https://www.youtube.com/watch?v=43y_4awgSlA
Youtube Channel: eStream SQL

Where to maintain?
GL > Maintain Opening Balance


MAINTAIN CHART OF ACCOUNT

Source of Video: https://www.youtube.com/watch?v=hsdpDJImya4
Youtube Channel: eStream SQL

Where to maintain?
GL > Maintain Account 


SET FINANCIAL YEAR END & SYSTEM CONVERSION DATE

Source of Video: https://www.youtube.com/watch?v=yH8VfNGjEr0
Youtube Channel: eStream SQL

WHERE TO SET?
Tools > Options > General Ledger


INSTALLATION + COMPANY PROFILE + REPORT HEADER

Source of Video: https://www.youtube.com/watch?v=Bd-7_iRyE_k
Youtube Channel: eStream SQL



Friday, March 13, 2015

HOW TO PRINT PRODUCT ACTIVATION REQUEST

Source of Video: https://www.youtube.com/watch?v=fwevx3XdzuQ&index=7&list=PL9yBgJ57cXKCqw9KYNFUdj_mWTIE_LC8V
Youtube Channel: SQL MYSOFTWARE

Where to print?
File > Production Activation > Print Activation Request

p/s Please make sure your company name and company address correct before you print.


Sample of Product Activation Request

Saturday, January 31, 2015

HOW TO RESTORE

Source of Video: https://www.youtube.com/watch?v=wXP2eQfGIbk
Youtube Channel: SQL MYSOFTWARE

RESTORE Steps
  • Before login to your SQL, click the three dots "..."
  • Click "Restore"
  • Click "..." to find your backup file
  • Double click your backup file 
  • Click "OK"
  • Let it run, do not close it until it shows you a message informing restore database successful
  • Double click your latest restore, login 


HOW TO BACKUP

Source of Video: https://www.youtube.com/watch?v=mQkL5ndEzG0
Youtube Channel: SQL MYSOFTWARE

BACKUP Steps
  • File > Backup Database 
  • Click the three dots "..."
  • Choose your destination folder (it may be your external hard disk)
  • Click "OK"
  • Let it run, do not close the window until it shows you a message informing backup database successful 
  • Check your destination folder to ensure your backup is complete 


Remember to do backup regularly to avoid any malfunction of your PC and data corruption.