home

Web service guid netsuite @http://spreadsheets.about.com/od/excelfunctions/qt/20070922_mid.htm Dictionary download @http://opendata.baidu.com/appdown/s?tn=baiduipad&wd=dictionary%20ipad&ie=utf-8&oe=utf-8&dsp=ipad&from_mid=1&loc=http://itunes.apple.com/cn/app/ying-han-zi-dian-english-chinese/id475211454?mt=8 about CPA

@https://www.khanacademy.org

Khan academy Scarcity: Why Having Too Little Means So Much

httWp://bbs.wenxuecity.com/career/513256.html

accounting concept study Accounting concept and self study

FRM@http://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=874179&extra=page%3D8 @https://www.oursteps.com.au/bbs/portal.php?mod=viewlist&catid=133&page=12 @https://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=777258 ethic and governance pdf @https://www.dropbox.com/sh/86nlf0upp53yh8y/bZYfuiHc2a Tax text book @http://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=900505 @http://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=899409&extra=page%3D1 @http://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=868211&extra=page%3D3 CPA 117 @http://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=764623&extra=page%3D5 CPA 117 text Book CPA 2013 books@http://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=800469&extra=page%3D12

test centre address @https://wsr.pearsonvue.com/testtaker/registration/TestCenterDirections.htm?testCenterId=67712&clientCode=CPAAUSTRALIA change exam time @https://wsr.pearsonvue.com/testtaker/checkout/OrderPoliciesPage/CPAAUSTRALIA/3802 accounting coach @http://www.accountingcoach.com/blog/what-is-financial-reporting Foundation of Business Law @http://highered.mcgraw-hill.com/olc2/dl/931654/9780071013956.pdf 2014 auditing pdf ==How to reduce the FBT you pay[] == ATO. Tax deduction @https://www.ato.gov.au/Individuals/Income-and-deductions/In-detail/Deductions-for-specific-industries-and-occupations/Deductions-for-specific-industries-and-occupations/
 * CPA webpage** @https://www.cpaaustralia.com.au/login.aspx

Unique Superannuation identifier @https://secure.superfacts.com/attachments/Form/SA003_CombineMySuper_JUN13.pdf

It is visible. elimination intercompany transactions

Intercompany Eliminations Explained @http://www.pedersoncpareview.com/intercompany-eliminations-explained/
=Understanding Intercompany Settlements @http://docs.oracle.com/cd/E16582_01/doc.91/e15109/undrstand_intercom_settlmnt.htm = elimination of inter-company transaction- CPA forum 第​1​1​章​合​并​财​务​报​表​下​(​内​部​往​来​业​务​抵​销​2​) FAR practice Question@http://www.cpaexampracticetests.com/cpa_financial_accounting_and_reporting_practice_questions.htm @http://www.cpareviewforfree.com/

= [|2014 S1 SMA & FRM 材料分享] = @https://www.oursteps.com.au/bbs/forum.php?mod=viewthread&tid=871068 Accounting couching

Borrowing interest capitalisristic @http://baike.baidu.com/view/1025323.htm 在建工程 chart of accounts@http://www.windawin.com/simple/?t1120.html Solvency

Company ACN number @https://www.melbourne.vic.gov.au/enterprisemelbourne/SmallBusinessToolkit/Registrationsandlicences/Pages/SoleTraderorProprietaryLimited.aspx

@https://www.slideshare.net/loginAIM 

Account Payable: @http://www.slideshare.net/mukeshkumarraju/accounts-payable-ap-process-floe @http://www.beginner-bookkeeping.com/accounts-payable-procedures.html

http://www.slideshare.net/srahatkazmi/42-accounts-payable-interview-questions-and-answers# http://www.slideshare.net/srahatkazmi/42-accounts-payable-interview-questions-and-answers# @http://www.slideshare.net/suvrendu/sample-oracle-payable-user-manual @http://www.slideshare.net/byharris/accounts-payable-instructorguide-1 @http://www.slideshare.net/byharris/accounts-payable-instructorguide-1 @http://www.slideshare.net/gauravmohan31/ap1buy-to-pay

@http://www.slideshare.net/MadhusudanPatankar/accounts-payable-interview-questions @http://www.beginner-bookkeeping.com/accounts-payable-procedures.html

prepaid expense (deferred expense)@http://www.youtube.com/watch?v=GzKBe4ZuBRM
 * Deferred expense** and accrued expense

@https://www.boundless.com/accounting/detailed-review-of-the-income-statement/expense-recognition/difference-between-accrued-and-deferred-expenses/
 * Prepayment @http://accounting.answers.com/financial-accounting/accounting-for-prepaid-rent**

Change of equity statement @http://accounting-simplified.com/financial/statements/statement-of-changes-in-equity.html

Payroll tax @http://www.austrade.gov.au/Invest/Doing-business-in-Australia/Investor-Guide/Running-a-business/Understanding-Australian-taxes/Australian-business-taxes Squirrel Steals Airplane []

@http://m.youtube.com/watch?v=VQpmOmZO2mo

Compare energy @http://www.switchwise.com.au/step-02.asp Dice.com. -the us jobs

Nothing is impossible to the man who is willing to take on the challenge. there is nothing like busy.

Dodo contact number. @http://www.dodo.com/top-right-navigation/contact-us/

QLD brisbane city free loop http//www.brisbane.qld.gov.au/traffic-transport/public-transport/buses/city-centre-free-loops

@http://m.youtube.com/watch?p=PL08903FB7ACA1C2FB&feature=plpp&v=ZNObiptSMSI @http://www.youtube.com/watch?v=KzDEa-XgyOM @http://www.betterbottomline.com/docs/Sales%20Orders%20in%20QuickBooks.pdf @http://wiki.developerforce.com/page/Apex @http://www.77vcd.com/Occident/zuoyoubufengyuan/ @http://www.mps.com.au/locations/collection-centres/blt-balaclava.aspx Bulk Billing Service at Caulfield @http://www.womo.com.au/reviews/North-Caulfield-Medical-Centre-Caulfield-North/ @http://humanservicesdirectory.vic.gov.au/SiteDetails.aspx?SiteID=46072

@http://www.truelocal.com.au/business/monash-doctors-surgery/clayton Health @http://blog.wenxuecity.com/myblog/591636/201307/334.html @http://blog.wenxuecity.com/myblog/725149/201307/495.html @http://blog.wenxuecity.com/myblog/60191/ ultrasound @http://www.mps.com.au/locations/collection-centres.aspx Online library @http://blog.wenxuecity.com/myblog/591636/201307/3070.html @http://guides.library.harvard.edu/hks/economics @http://bbs.wenxuecity.com/kxtw/25077.html

AVaLON CENTER INCOPORATE Avalon center

ABN 545 89625215 @http://help.abr.gov.au/BC/Index/ABR_(Australian_business_register)/About_AUSkey/ @https://www.adminbandit.com.au/money_transaction.php?add=payment

Prepare asset register @http://m.wikihow.com/Prepare-an-Asset-Register Maintain fixed assets @http://www.fundsforngos.org/financial-management-for-ngos/maintain-fixed-assets-register-ngo-financial-management-policy/

How to maintain Fixed Asset register@http://www.wikihow.com/Prepare-an-Asset-Register

Effective life of asset list @http://law.ato.gov.au/atolaw/view.htm?docid=ITD/EF20131/00001 @http://www.affho.org/info/info08.php depreciation guide @http://www.ato.gov.au/uploadedFiles/Content/MEI/downloads/ind00342355n19960613.pdf Simplified depreciation rules Claiming low value pool

Register BAS GST online

@https://www.auskey.abr.gov.au/Homepage.aspx?Task=11a023e4-bdec-4873-8961-2ffce2fd5b88&NavGraph=Home&View=HomeView&pid=71&js=1 @http://www.ato.gov.au/Business/Registration/Add-or-cancel-a-registration/AUSkey/ @http://www.ato.gov.au/Business/Registration/Add-or-cancel-a-registration/ @http://www.ato.gov.au/Business/Registration/Work-out-which-registrations-you-need/

Auskey video @http://www.youtube.com/watch?v=KzDEa-XgyOM Computer decline in value /depreciation @http://www.ato.gov.au/Individuals/Income-and-deductions/In-detail/Deductions-for-specific-industries-and-occupations/IT-professionals---claiming-work-related-expenses/?page=21 = = =ATO@ATO= =Asset write off threshold $6500= @http://www.ato.gov.au/Business/Deductions-for-business/What-you-can-claim-and-when/Expenses-you-can-claim-over-time/ Instant asset write-off and simplified depreciation

= How do I Complete my Business Activity Statement? = @http://www.youtube.com/watch?v=cZ-FdmXZ_00

free TV @http://www.couchtuner.eu/

the middle @http://www.kanvcd.cc/dianying-html/zuoyoubufengyuandisanji2011/ hair style @http://hairstylesweekly.com/the-graduated-bob-hairstyles/graduated-bob-back-view/

exercise @http://bbs.wenxuecity.com/health/372699.html Quickbooks processes. Quickbooks. @http://www.youtube.com/watch?v=DXsHe4XFYA8 Purchase order---receive inventory---enter bill---pay bill or write check(create bill may avoid double payment because it has bill no.) sales ordersales order fulfillmentinvoiceReceive payment Enter bill. With terms @http://www.youtube.com/watch?v=ZID7Q-1Cmwk write check @http://www.youtube.com/watch?v=2cgfj1uAzdY pay by credit card

Quickbooks receive customer's payment @http://www.youtube.com/watch?v=DcvXO6HIFNk

Credit Memo/ Refund @http://nerdenterprises.com/2012/05/how-to-issue-customer-refunds-in-quickbooks/

Sales order @http://www.betterbottomline.com/docs/Sales%20Orders%20in%20QuickBooks.pdf

create invoice from sales order---sales order to invoice -receive payment @https://www.google.com.au/url?sa=t&rct=j&q=quickbooks%20create%20invoice%20sales%20order&source=web&cd=3&ved=0CEEQtwIwAg&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DzQ30B8yyuZo&ei=sN6FUovoAsOriAfD9oDQAg&usg=AFQjCNENqHDaaf_ycOK2Glel5VfTjGJcfA&bvm=bv.56643336,d.aGc

Download Netsuite: @http://f.dataguru.cn/thread-21359-1-1.html (augates) IT information---book/ training

Netsuite Purchase Order/bills @https://ewh.ieee.org/reg/3/ieee_r3_files_ackerman/IEEE.Accounts.Payable.Reference.Guide.pdf AR guide @http://ieeetmc.com/reg/3/ieee_r3_files_ackerman/IEEE.Accounts.Receiveable.Reference.Guide.pdf

Project Accounting@https://www.youtube.com/watch?v=_c7-iwN1Cw0

PAYG: Debit PAYG expense account Credit PAYG withholding account payroll occurs

Debit PAYG Withholding account Credit bank cheque account - payment to ATO: pay last month' Employee 's PAYG

Netsuite Demo ---consolidation General Ledger Reference Guide SuiteScript 101 = = = @Netsuite Study =

Netsuite processing transactions @http://www.youtube.com/watch?v=rjEAsbZGb6c PO (Purchase Order)- ---Manager Approve or RejectIf Approved--(receive Inventory for online store purchase inventory)---New Bill or authorize return---New Bill--Save---Approve Bills--Save--New Bill Payment

@http://www.youtube.com/watch?v=54DYbF1aVkg

NetSuite Order & Billing Management

Purchase order --receive itemsback to purchase order --Bill(create bill ) make payment

Bill has relation with bill credit (return to supplier ), and with bill payment

Sales order--- item fulfillment -- packing and shipping (warehouse despatch) invoice (create invoice) ---credit or accept payment(deposit money in )

invoice relates to credit(refund to customer ), and Relates to deposit (un deposit fund (customer prepayment), accept customer payment deposit)

Netsuite Sales Process

Quote proforma invoice

Bank reconciliation, credit card reconciliation ; Write cheque, use credit card. Bank fund transfer.

Inventory adjustment work sheet over write previous records' quantities and value. Item transfer from deferent location, inventory adjustment change quantities.

aged debtors - generate customer statement --- send the statement to the customer for debt collection.

Freight charge include : Duty, Gst, government charge, other fee charge, Qube freight charge from melbourne to geelong, APC overseas shipment charge against weight And fuel surcharge ( 9.5%* rate per KG).

Sales in Netsuite Quote--sales Order---approved receive(inventory fulfillment---item picking and packing printing layout for delivering dispatch to customers )--Sales Order to Bill to generate new Invoice to customer-- - click customer -- accept payment(Should apply to the pacific customer invoice)

Sales order fulfillment NetSuite Ecommerce: From Promotion to Order/Fulfillment and Reporting

Live Product Demo — NetSuite Wholesale Distribution Edition

CRM sales representative create lead first. Lead--prospect--opportunity--customer Customer can be classified by setting up categories, such as retails and wholesale industries, skincare salon, medical center etc.

lead and customer have territory field which should be setup at setup>company or accounting cannot remover>sales>territory and also setup territory rules! such as Australian, New Zealand. The list of territory could be Vic,Nsw,act etc. One sale rep can look after one territory only also can look after vic as well. Fionaau:Vic fionaAu:NSW Nicol---Au:TAS

employee setup setup an employee as a sales rep with class. Class is the classification of the items. And setup sales role with the restriction of their own class. So the sales rep only can see the price level of the item level which they are suppose to see. In addition should set up the press level for the customer first.

Netsuite help @http://www.exploreconsulting.com/netsuite_tips_and_tricks.htm @http://www.youtube.com/watch?v=54DYbF1aVkg

@http://www.youtube.com/watch?v=R5-5gsTyxFw

How netsuite streamlines orders to cash

suite script @http://stackoverflow.com/questions/11281345/how-to-partially-fulfill-a-sales-order

@http://www.netsuite.com.au/portal/products/netsuite/order/quote-order.shtml

Netsuite tutorial. @http://www.exploreconsulting.com/netsuite_tips_and_tricks.htm http://www.exploreconsulting.com/netsuite_tips_and_tricks.htm#netsuite_tip_91 Netsuite CRM Solution. @http://youtu.be/OxhZ6ewBz2I @http://youtu.be/Qh4AANSsiuQ. Netsuite for software company @http://youtu.be/yK0sCYVxeWY Netsuite website. @http://www.fourthwc.com/netsuite/2013/07/free-netsuite-test-drive-account.html @http://www.fourthwc.com/netsuite/2013/03/netsuite-staging-web-site.html NetSuite Manufacturing Capabilities -- Build to Fulfill

Netsuite overview

NetSuite ERP Workflow Netsuite introduction Netsuite training part 1 Multi division ERP in the cloud

ERP guru training @http://erpguru.com/resources/videos Netsuite software tutorial Netsuite demo @http://www.netsuite.com/portal/products/netsuite/erp.shtml Netsuite self paced training. @http://www.netsuiteblogs.com/easy-elearning-netsuite-self-paced-training @http://www.youtube.com/watch?v=LkvnI6y1lsk&list=PLdSO4-qAjX-2CgbXFdOanedhCobp1j5Ty NetSuite Business Intelligence Capabilities NetSuite OneWorld in action

Netsuite Chart of accounts @http://www.youtube.com/watch?v=5vI9Irrv2Ww The Latest Innovations in Cloud ERP for Manufacturers

Netsuite record customise

Netsuite Oneworld NetSuite SuiteCommerce (1 of 2) NetSuite SuiteCommerce (2 of 2 )

NetSuite Order & Billing Management NetSuite's Sales Process: From Lead to Payment

NetSuite SuiteCommerce (2 of 2 ) NetSuite SuiteCommerce (1 of 2)

NetSuite Procurement NetSuite Purchasing

@COGS


 * Fiscal Calenar yearFiscal year bad debt written off **


 * Bloomberg **
 * @http://investing.businessweek.com/research/stocks/people/person.asp?personId=110003552&ticker=ARH:AU **

Corporate finance community @http://www.proformative.com/sitesearch?type=Resources&type=&keywords=resource&op=Search&orit=1

MYOB

MYOB screenshot

MYOB purchase pay bills Create Invoice MYOB Payroll MYOB Day4purchase commons myob

Myob training

apply credit note@http://www.youtube.com/watch?v=ibZBwf5zAWc []

@http://www.onlineaccountingservices.com.au/myob_training.html reverse against sales []

Entering Supplier's invoices : [|http://community.myob.com/t5/AccountRight-information-hints/entering-supplier-invoices/m-p/64583#M8008]

Record Simple Expense with MYOB
Transferring money between accounts End of Payroll year report @http://myob.com/images/support_notes/EOPY_Guide2014.pdf End of year send to accountant @http://myob.com/images/support_notes/EOFY_Guide2014.pdf Purchase Purchase order---changes to Order---Receive items--changges to Bill ---Pay Bill

Sales Quote--Change to Orders--Change to Invoices(Open Invoice)---Receive Payment

Return Inventory purchased

1) If the inventory has not been paid, just has Bill: Go to Accounts--TransactionFind the purchase journal for the Bill--click in ---right click---Reverse purchase--Record it---go back to purchase registerclick returns and DebitApply to purchase--Click Amount put amount inRecord---Check Item list, the quantities has changed back to the quantities number before new purchase item received AP Aging, balance Sheet reports are back to normal 2) If the purchased Inventory has been paid: Accounts--Disbursement--- Find the payment journal--click in (tick Includes closed Bill) --reverse Payment--Record---So the bank many reverse backnow the AP aging report shows the amount unpaid-- Go to transaction journal--purchase--- find the Journal for the Bill---Right Click Reverse purchase---record---Check items List,,,the quantity has changed back to purchase-now we have open bill and returns&Debit which are a pair transactions-- click Returns & Debit---Apply purchase---done Inventory and bank account (Asset) are back to normal.

Customer Refund --- credit noteremember to choose account (such as ebay clearing account) whilst refunding money @http://myobaustralia.custhelp.com/app/answers/detail/a_id/9098

return @http://myob.com/images/support_notes/Credit%20Notes.html

Credit memo and credit note for customer refund

sales register---closed invoice---find the transaction--- right click and revise the transaction---click return & credit--refund(remember to choose the account like cheque account or ebay clearing account)

GST ---GST free @http://myobaustralia.custhelp.com/app/answers/detail/a_id/9265 Basic Tax @http://myob.com.au/blog/basic-tax-explained-for-startups-small-business/

GJ adjustment [] Super

Super cut off date: @http://www.ato.gov.au/Business/Employers-super/How-much-to-pay-and-when-to-pay/When-to-pay/ How to pay your employee's super @http://www.youtube.com/watch?v=xQZSAzNaw9A Payroll --click Pay liabilities--super supplier---payroll catagory is super-record either generate ABA file for loading or write a check How to pay PAYG withholding to ATO @http://www.youtube.com/watch?v=tHepzbsjET4 PAYG ATO instruction @http://www.ato.gov.au/Business/Employers/Preparing-to-engage-workers/Pay-as-you-go-(PAYG)-withholding/ @http://www.precisionpays.com.au/download/PAYG-Payment-Summary.pdf @http://www.precisionpays.com.au/download/PAYG-Payment-Summary.pdf @http://www.ato.gov.au/Forms/PAYG-payment-summary-statement/ @http://www.ato.gov.au/Business/PAYG-withholding/In-detail/Payment-summaries-for-employees/Providing-electronic-payment-summaries-to-payees/

How to lodge your pay as you go (PAYG) withholding annual reports electronically

Payroll [] @http://myobaustralia.custhelp.com/app/answers/detail/a_id/11140

How to pay employee @http://myobaustralia.custhelp.com/app/answers/detail/a_id/11207/kw/bas [] myob ELECTRONIC PAYMENT aba FILE @http://myob.com/images/support_notes/electronic_payments.html

Handling overpayment at MYOB @http://myobaustralia.custhelp.com/app/answers/detail/a_id/9100 BANK CODE @http://www.thebsbnumbers.com/

Payroll category @http://www.youtube.com/watch?v=Minma3xms6Q

Sick and Hourly payment ---time sheet http://myobaustralia.custhelp.com/app/answers/detail/a_id/11114#combine

Cash flow forcast. @http://www.business.vic.gov.au/operating-a-business/managing-finances-and-tax/cash-flow/cash-flow-forecasting

@http://www.youtube.com/watch?v=En2A0WKAP9s

Excel @http://www.addictivetips.com/microsoft-office/excel-2010-split-column-data-into-two-parse-cells/ Cells cannot update automatically @http://stackoverflow.com/questions/6622232/cells-not-updating-automatically

excel MID function.(cut off unwanted characters) @http://spreadsheets.about.com/od/excelfunctions/qt/20070922_mid.htm Key END + CTRL + arrow for selecting the whole column

Salesforce @http://www.tudou.com/programs/view/KanTBEDRNPc/

salesforce training @https://help.salesforce.com []

suitscript @https://system.netsuite.com/core/media/media.nl?id=5732122&c=NLCORP&h=5fca4bf5dd825a28ab41&_xt=.pdf&addrcountry=US netsuite implementation guide http://www.netsuite.com.au/portal/partners/integration/download/NetSuiteWebServicesRecordsGuide_2_0_0.pdf#page122

Apex [] Administrators Best Practice Sessions - Dreamforce @https://itunes.apple.com/us/podcast/administrators-best-practice/id573218105?mt=2

VBA tutorial @http://excelexperts.com/Free-vba-Training-Videos [|http://msdn.microsoft.com/en-us/library/office/ee814735.aspx#odc_office14_ta_AddingVBAProgrammingToYourOfficeToolkit_VBAProgramming101] [] VBA example Code

AIG Insurance @http://www.ehow.com/how_2148808_calculate-property-casualty-insurance-rates.html contingency and profit @http://pmbook.ce.cmu.edu/12_Cost_Control,_Monitoring,_and_Accounting.html @http://wenku.baidu.com/view/a1295028915f804d2b16c1ee.html

travel in Melbourne @http://bbs.51766.com/article/948969.html @http://harbourtownmelbourne.com.au/transport.html

Management accounting CPA @http://www.youtube.com/watch?v=mVRJCzI8Jcc

writing financial reports [] financial ratio @http://ro.uow.edu.au/cgi/viewcontent.cgi?article=1025&context=commpapers Statistic reports writing @http://www.federalreserve.gov/releases/z1/ @http://www.federalreserve.gov/econresdata/default.htm

Budget @http://www.youtube.com/watch?v=Lm1MIPx88YM

@https://www.google.com.au/url?sa=t&rct=j&q=managerial%20accounting%20flexible%20budget%20%20and%20standard%20cost%20youtube&source=web&cd=1&ved=0CDEQtwIwAA&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DYDG8nyPAzNc&ei=-EXfUe6RBpChiAfcsoDYDQ&usg=AFQjCNEtHhutWkN9B7wVD0V0XMJ1mcFAkw&sig2=61MDuyAa--nvIIexr5JyKQ&bvm=bv.48705608,d.aGc @http://www.youtube.com/watch?v=UAXKbnIEBC0

Budget Variance @http://www.youtube.com/watch?v=vUbCxvPQK74 = = @http://www.youtube.com/watch?v=vUbCxvPQK74

Capital Budgeting @http://www.youtube.com/watch?v=IW2qvXcrx6k&list=PL08F1DBDE50099E8D Financial Model @http://www.youtube.com/watch?v=Lm1MIPx88YM

refund to customer @http://accounting-simplified.com/accounting-for-sales-return.html

Adjust inventory @http://www.cliffsnotes.com/more-subjects/accounting/accounting-principles-i/accounting-for-a-merchandising-company/adjusting-the-inventory-account

@http://www.accountingunplugged.com/2008/09/07/cost-of-goods-sold-work-in-progress-and-inventory/

Cash Flow @http://www.youtube.com/watch?v=WGpsGdQest0 @http://www.investopedia.com/exam-guide/cfa-level-1/financial-statements/cash-flow-indirect.asp

How to prepare bankreconciliation @https://www.google.com.au/url?sa=t&rct=j&q=how%20to%20prepare%20bank%20reconciliation&source=web&cd=3&ved=0CDQQtwIwAg&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D-UhQ92wzk-w&ei=rbDtUbhkiLeSBYqtgdAG&usg=AFQjCNEhQg_V9Jb7jEdugSyQODge2zxvlQ&sig2=ZC9_AP0uZqDdftT-0SjybA Sap payroll aAustralia @http://help.sap.com/printdocu/core/print46c/en/data/pdf/PYAU/PYAU.pdfCPA mentor @http://bbs.canet.com.cn/thread-440502-1-1.html Posting pay run to accounting @http://help.sap.com/saphelp_45b/helpdata/EN/81/42b09e4a3711d189490000e8323c4f/frameset.htm CPA Auditing @http://www.youtube.com/watch?v=sRIfpNta0gc

MS SQL

@http://www.youtube.com/watch?v=Kp3dS-T16x4 Install SQL Server @http://www.youtube.com/watch?v=cNPR0wX_IBM Sql tutorial @http://m.youtube.com/watch?p=PL08903FB7ACA1C2FB&feature=plpp&v=ZNObiptSMSI Foreign key constrain

Create view@http://www.youtube.com/watch?v=VQpmOmZO2mo&app=desktop

SQL Server Services and Instance--config services @http://www.youtube.com/watch?v=Y1j6AO8TMDA How To Connect SQL Server Through Internet Commend prompt> Ipconfig (Find out IP Address) add SQL Server Browser Service

Administering Microsoft SQL Server 2012, 01, Install and Confi

SQL Server DBA Interview Questions Part 1 DBA Interview Question & Answer: Part 2, The Answers

SQL DBA @http://www.brentozar.com/archive/2008/03/sql-server-2005-setup-checklist-part-1-before-the-install/

MS SQL入门基础:SQL数据库备份 [|SQL server How to back up] with Management Studio

Transition Backup @http://technet.microsoft.com/library/Cc917565 @http://technet.microsoft.com/zh-cn/library/ms177446(v=sql.90).aspx @http://www.sqlskills.com/blogs/kimberly/database-maintenance-best-practices-part-iii-transaction-log-maintenance/ SQL Server BACKUP LOG command

differential backup@http://www.youtube.com/watch?v=OR44SZNqFpg @http://www.todo-backup.com/products/features/differential-backup.htm

sql server performance turning @http://www.youtube.com/watch?v=hoOUdZVsacE @http://www.youtube.com/watch?v=XmE_Utp8CY0

full back up and log file--differencial backup @http://www.youtube.com/watch?v=OR44SZNqFpg data and log file @http://www.youtube.com/watch?v=peW8xJ_dJno

SQL server log file @http://www.youtube.com/watch?v=lcmYeE-cqQo @http://www.youtube.com/watch?v=-uVmtMAe4fQ restore database @http://www.youtube.com/watch?v=9U7QxPsA0tw

Union, union all, join @http://m.youtube.com/watch?v=9w5uRCFOiTo MS Dynamic ERP @http://www.youtube.com/watch?v=NDVhq7mageY cost accounting @http://www.youtube.com/watch?v=XYTVEPglhG8

@http://www.youtube.com/watch?v=NDVhq7mageY

http://m.youtube.com/#/playlist?list=PLEF2F87F176AB5BFA&desktop_uri=%2Fplaylist%3Flist%3DPLEF2F87F176AB5BFA

Finance @http://www.youtube.com/user/mattalanis

dimentions @https://www.google.com.au/url?sa=t&rct=j&q=ms%20dynamic%20dimentation&source=web&cd=3&ved=0CD4QtwIwAg&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Df9TQ4erZ0yw&ei=nNTUUe3ZB4ujiAf8mIHgDg&usg=AFQjCNHVKswFdiQ2V9Sd7driQJWko32Ljw&sig2=EP5Ww375rfcWVcs4ZpacpA&bvm=bv.48705608,d.aGc Consumer and Commercial Debt

@http://www.ehow.com/info_8144534_difference-consumer-debt-commercial-debt.html

Chinese custom @http://www.customs.gov.cn/publish/portal0/tab3889/module1188/info362458.htm = 6 Hour of The Best Beethoven - Classical Music Piano Studying =

[]

yaogua. Zhou Yi

http://www.fututa.com/ceming?xmv=门开蔓&xmt=1&bm=1&t=bagua@http://zhidao.baidu.com/question/244723704.html @http://www.guazhun.com/hdx/yaogua.html @http://huangdaxian.911cha.com/

@http://bbs.wenxuecity.com/fortune/216478.html

@http://www.jbxue.com/db/7886.html A1 Sheepskin Factory Outlet is located at 144 Middle Street, Glenroy, VIC. http://www.factoryoutletshopping.com.au/Directory/Women_s_Footwear/Slippers.aspx#.UYeR93UqFcR Opera Prayer@http://www.prayer-and-prayers.info/christian-prayers/prayer-for-employment.htm Netsuite script @http://www.netsuite.com/portal/developers/dev-resources.shtml

youku download @http://v.youku.com/v_show/id_XNDI1MzkxMzcy.html?x

Using micros in excel @https://www.google.com.au/url?sa=t&rct=j&q=using%20macros%20in%20excel&source=web&cd=17&ved=0CE8QtwIwBjgK&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dp-ZDUaJtBQw&ei=s6icUdfZPOmXiAeb_4DIBg&usg=AFQjCNGv__u_4GGLwFXBIdwnWMVoXLDisg&bvm=bv.46751780,d.aGc crystal report @http://v.youku.com/v_show/id_XMTcyNDkyNjM2.html @http://v.youku.com/v_show/id_XNDM0NzIxNzk2.html crystal free download

@http://filetram.com/crystal-report-8

design dadata warehouse @http://v.youku.com/v_show/id_XMzk2MTM2NjU2.html?x @http://v.youku.com/v_show/id_XMzk2MTM5NTg0.html?x Star schema @http://en.wikipedia.org/wiki/Star_schema @https://www.google.com.au/url?sa=t&rct=j&q=star%20schema&source=web&cd=2&ved=0CD4QtwIwAQ&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DLfehTEyglrQ&ei=eOWZUebmDO-hiAem8YCgDw&usg=AFQjCNF9-CDEyi2khtc0hAdPETtEuP7nsg&bvm=bv.46751780,d.aGc @http://www.teleiology.com/pdf/25/D050308.pdf

Difference between star schema. And flake schema

@http://wenku.baidu.com/view/bafcfc785acfa1c7aa00ccbf.html

Oracle function @http://www.oradev.com/decode.jsp @http://www.teleiology.com/pdf/25/D050308.pdf

oracle sql and pl/sql @http://sql-plsql.blogspot.com.au/

@http://www.2cto.com/database/201202/118200.html @http://blog.csdn.net/blueseesea/article/details/2072367 oracle sql @http://database.51cto.com/art/201011/232267.htm @http://www.itpub.net/forum.php?mod=viewthread&tid=1768097 learn code hard way @http://sql.learncodethehardway.org/book/

SQL tutorial @http://www.tutorialspoint.com/sql/sql-clone-tables.htm

ifSQL need " " @http://www.myexception.cn/oracle%20exception/2263.html

@http://www.blogjava.net/xzclog/archive/2006/08/24/65461.html advanced oracle sql sample @http://wenku.baidu.com/view/e54e7bdc6f1aff00bed51e66.html Rank over pparticipation @http://www.oracle-base.com/articles/misc/rank-dense-rank-first-last-analytic-functions.phpCognos video http://ptv.vic.gov.au/journey#jpsearch%5Baction%5D=search&jpsearch%5Bfrom%5D%5Btext%5D=Belmont+ave+glen+iris&jpsearch%5Bfrom%5D%5Btype%5D=any&jpsearch%5Bto%5D%5Btext%5D=Beatrice+st+st+killer+rd&jpsearch%5Bto%5D%5Btype%5D=any&jpsearch%5Btime%5D%5Barr_dep%5D=dep&jpsearch%5Btime%5D%5Byear_month%5D=201305&jpsearch%5Btime%5D%5Bday%5D=20&jpsearch%5Btime%5D%5Bhour%5D=10&jpsearch%5Btime%5D%5Bminute%5D=10&jpsearch%5Btime%5D%5Bam_pm%5D=am@http://v.youku.com/v_show/id_XNDc3ODY5MzQ4.html?x @http://www.senturus.com/technology-ibm-cognos-demonstration.php

creating etl @http://www.youtube.com/watch?v=9Akvz2x0az4

@http://v.youku.com/v_show/id_XNTMxOTkyMDUy.html?x

design report @http://www.youtube.com/watch?v=c170hFlmdWA Build a cube in 15 minutes @http://www.youtube.com/watch?v=Xah3JMV5Lmc cognos power play transformer tear @https://www.google.com.au/url?sa=t&rct=j&q=cognos%20transformer&source=web&cd=1&sqi=2&ved=0CEcQtwIwAA&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3Dd_rUNLJAUTU&ei=zDmSUfhMxo-IB-fTgOgJ&usg=AFQjCNFzMBU60g_YQUdtm7LIGZJwEU8NzAaustralia coat of arm http://en.wikipedia.org/wiki/Coat_of_arms_of_Australia#Design

Tutorial

@http://heisetoufa.iteye.com/blog/364146

@http://school.itzcn.com/index.html @http://thenewboston.org/tutorials.php @http://www.xin3721.com/

advanced sql online reading @http://www.doc88.com/p-503795484357.html

CBT Nugget @http://www.cbtnuggets.com/it-training-videos/series/database-various-sql-languages

SQL

MS Access SQL https://support.office.com/en-us/article/Access-SQL-basic-concepts-vocabulary-and-syntax-444d0303-cde1-424e-9a74-e8dc3e460671#bm2

MS Access SQL

@http://zhidao.baidu.com/question/112329345.html @http://it-ebooks.info/book/300/ @http://www.e-booksdirectory.com/listing.php?category=496

@http://blog.csdn.net/bobo12082119/article/details/6334955

@http://www.360doc.com/content/11/0911/18/19147_147511561.shtml @http://zhidao.baidu.com/question/61446841.html

@http://www.shmedu.com.cn/blog/item.aspx?id=1&logid=8 @http://v.youku.com/v_show/id_XMjI0MTgzMTY=.html?x http://video.baidu.com/v?ct=301989888&rn=20&pn=0&db=0&s=19&rsp=4&word=sql%D3%EF%BE%E4%BD%CC%B3%CC#pn=40 @http://blog.csdn.net/tianlesoftware/article/details/6638062 @http://www.wudisk.com/v-ebb43396db9160ec13d14da7b4bfa9f8.html Advanced SQL --complex join @http://ocw.mit.edu/courses/urban-studies-and-planning/11-521-spatial-database-management-and-advanced-geographic-information-systems-spring-2003/lecture-notes/lect4.pdf Advanced SQL -IBM @http://pic.dhe.ibm.com/infocenter/spssdc/v6r0m1/index.jsp?topic=%2Fcom.spss.ddl%2Fsql_queries_xtabs.htm @http://www.doc88.com/p-072840990100.html

@http://www.utteraccess.com/forum/Show-row-number-query-t1951178.html SAP SQL @http://it-ebooks.info/book/1894/

SQL insert update @http://www.gobookee.net/get_book.php?u=aHR0cDovL3d3dy5pbmYuZnUtYmVybGluLmRlL2xlaHJlL1NTMDYvMTk1MTMtVi9Gb2xpZW4tZXRjL2RiczA2XzA1X0RNTF9TUUwtMXBwLnBkZgpJbnNlcnQgYW5kIHVwZGF0ZSBkYXRhIFNpbXBsZSBTUUwgcXVlcmllcyBBZHZhbmNlZCBTUUwgLi4u

w3school @http://www.w3school.com.cn/sql/sql_primarykey.asp @http://hi.baidu.com/wjj1010/item/6d62de4202a95794833ae1b8

distinguish capital or non capital of the column and table name

@http://www.itpub.net/thread-318706-1-1.html @http://m.blog.sina.com.cn/s/blog_609f9fdd010108at.html @http://www.cnblogs.com/advocate/archive/2010/08/11/1797160.html

count

SQLbook http://en.wikibooks.org/wiki/Structured_Query_Language/Data_Query_Language#SELECT_clause

@http://en.wikibooks.org/wiki/Oracle_Programming/SQL_Cheatsheet SQLInterview @http://www.mianwww.com/html/2012/01/12802.html

Delonghi dl2401t oil heater @http://www.delonghi.com.au/support/instruction_manuals/CP2400T.pdf

The Java Tutorial

@http://school.itzcn.com/index.html @http://docs.oracle.com/javase/tutorial/i18n/locale/create.html @http://www.freejavaguide.com/java-interview-questions.html @http://java.about.com/od/gettingstarted/ss/firstprogram_2.htm @http://www.learnjavaonline.org/page/Objects @http://blog.wenxuecity.com/myblog/41076/201305/3265.html JS tutorial @http://v.youku.com/v_show/id_XNDU2NDk5NTc2.html?x Java interview @http://zhidao.baidu.com/question/40323285.html

javascript @http://v.youku.com/v_show/id_XNTQ5NjgxMDY4.html?x

financial accountant interview q&a @http://www.job-interview-site.com/finance-interview-questions-and-answers.html @http://www.youtube.com/watch?v=1STIOIC8r-U @http://www.job-interview-site.com/financial-analyst-interview-questions.html @http://www.wallstreetprep.com/blog/finance-interview-questions-and-answers/

@http://hr.od.nih.gov/hrguidance/employment/interview/occupation/510-interview.doc

@http://hspm.sph.sc.edu/courses/econ/invest/invest.html

@http://www.onemint.com/2010/11/23/what-is-irr-and-how-is-it-calculated/

@https://www2.mccombs.utexas.edu/Students/GFA/IB%20Interviewing/Finance%20Interviews/Finance%20Interview%20Preparation_3.doc

why IRR @http://answers.yahoo.com/question/index?qid=20110902155039AAiFdgT

Cash flow

@http://www.youtube.com/watch?v=SzMbBOtOuJ4 @http://www.youtube.com/watch?v=p05DcBS8rCg

Dictionry @http://dictionary.reverso.net/english-synonyms/reign @http://www.chinese-tools.com/tools/dictionary.html

buy Etag @http://www.onlymelbourne.com.au/melbourne_details.php?id=10345

Salary Payscale @http://www.payscale.com/research/AU/Job=Data_Analyst/Salary

interview tips @http://www.interviewsuccessformula.com/interview-answers-vsl1-aso1.php @http://www.globalguideline.com/interview_questions/Questions.php?sc=Accounts_Receivable_AR&page=3

telecom billing system @http://www.tutorialspoint.com/telecom-billing/quick-billing-guide.htm billing accountant @http://interviewquestionsandanswers.biz/billing-accountant-interview-questions-and-answers/

Map @https://maps.google.com.au/maps?hl=en&client=safari&q=1255+high+street+malvern&ie=UTF-8&hq=&hnear=0x6ad669e19253e98b:0x23e9074716f81848,1255+High+St,+Malvern+VIC+3144&gl=au&ei=D_gtUdO5JMeSiAeXz4HAAg&ved=0CBgQ8gEwAA @http://www.temando.com/ @http://overnightcourier.com.au/ @http://mobile.whereis.com.au/vic/camberwell?ref=onlineRedirect Moving

[]

@http://www.douban.com/group/topic/42088272/ Melbourne Rental Information @http://www.melbourneconnection.com/

@http://my.backchina.com/forum.php?mod=viewthread&tid=750428

@http://world.soufun.com/osnews/2012-07-05/8022977_2.htm @http://house.ksou.cn/cn/profile.php?q=Glen+Iris&sta=vic @http://www.aushome.info/australia_experience/legal_information/2012/1112/10903.html @http://my.backchina.com/forum.php?mod=viewthread&tid=750428

Give me a lever long enough, and a fulcrum strong enough, and I will move the Earth." -Archimedes  the big bang theory  @http://www.funshion.com/subject/104432/

animation swf file @http://www.360doc.com/content/12/0425/09/371684_206353015.shtml Melbourne budget hotle @http://www.truelocal.com.au/business/st-arnaud-budget-hotel/south-yarra find real estate agency @http://www.realestate.com.au/find-agent/in-glen+huntly,+vic+3163/list-1 Plan Jouney Melbourne @http://jp.ptv.vic.gov.au/ptv/XSLT_TRIP_REQUEST2?language=en&sessionID=VICWA05_3828898812&requestID=1&command=nop&tripSelection=on&tripSelector1=1&itdLPxx_view=detail&itdLPxx_return=simple&itdLPxx_emailAddress_origin=&itdLPxx_emailAddress_destination= @https://www.thebookingbutton.com.au/properties/starnaudghdirect

HTP--RTA @http://mylicence.sa.gov.au/hpt2/1/5

@http://www.transport.wa.gov.au/mediaFiles/lic_HPT_practice.swf

SAP BI BOOK Cheap saales: @http://www.nookibooks.com/sap-business-information-warehouse-reporting-building-better-bi-with-sap-bi-70-p-42805.html Berry Farm media type="custom" key="21966284"

@http://www.clyderiverberryfarm.com.au/location.php

Astrology 2014@http://www.findyourfate.com/astrology/year2014/sagittarius-2014-horoscope.html

Susan miller @http://mygod0328.pixnet.net/blog/post/42844840

Rising sign @http://www.kellystarsigns.com/rising-sign/what-rising-sign-am-i/ @http://www.douban.com/group/topic/1552479/

sagittarius work aug @http://www.astrostyle.com/Scopes/Monthly_Scope/monthly_sagittarius.htm @http://www.douban.com/group/topic/43241499/ @http://www.molingshu.com/shierxingzuo/sheshouzuo/2657.html

@http://www.douban.com/group/topic/42088272/

@http://www.moonastro.com/monthly/sagittarius_monthly_dhanu2.aspx

@http://www.eastrolog.com/2013-horoscopes/sagittarius-2013-career.php @http://www.astrologyzone.com/forecasts/monthly/sagittarius_full.php @http://www.astrologyzone.com/forecasts/monthly/sagittarius.php @http://www.astrobix.com/horoscope-yearly/sagittarius-horoscope-2013.aspx @http://www.eastrolog.com/2013-horoscopes/sagittarius-2013-career.php @http://www.findyourfate.com/astrology/year2013/sagittarius-2013-horoscope.html

@http://m.blog.sina.com.cn/s/blog_61bd67650102e2c0.html

monthly horoscopes @http://monthlyhoroscopefor2013.blogspot.com.au/2013/08/sagittarius-november-2013-horoscope.html Travel by driving @http://au.totaltravel.yahoo.com/experiences/great-driving-adventures/nsw/

SAP BI portal training

@http://rahulursportal.blogspot.com.au/2008/07/free-sap-bi-portal-training.html

@http://e-university.wisdomjobs.com/sap-bw/chapter-280/sap-bw-tutorial.html(Good tutorial)

@http://wenku.baidu.com/view/3d802249852458fb770b565e.html @http://wenku.baidu.com/view/687dd63110661ed9ad51f35e?pt=rv&listNo=3&app=event @http://wenku.baidu.com/view/e2ed28f4f90f76c661371a3a.html

@http://www.learnsap.com/sap-self-study.php

BI tools @http://www.technologyevaluation.com/products-and-services/decision-support-system/tec-advisor/

OLAP @http://searchdatamanagement.techtarget.com/definition/OLAP

data mart @http://www.personal.psu.edu/glh10/ist110/topic/topic07/topic07_09.html

@https://www.google.com.au/url?sa=t&rct=j&q=data%20mart%20%20video&source=web&cd=30&ved=0CFwQFjAJOBQ&url=http%3A%2F%2Fafis.ucc.ie%2Ffadam%2Flectures%2FDesigning%2520the%2520data%2520warehouse%2520-%2520part%25201.ppt&ei=zi5dUfqxJ6PZigeWiIHQAw&usg=AFQjCNHsk-LKcDlzlcHHM8DTlLxRoqtsPA

@http://www.optimusbi.com/2013/02/08/data-mart-cube/ @http://docs.oracle.com/html/E10312_01/dm_concepts.htm

SAP BI

@http://m.youtube.com/user/FacultiesOnlineAdmin @http://www.51sap.cn/ @http://scn.sap.com/community/data-warehousing/netweaver-bw/blog/2012/10/11/learning-sap-bw-everything-that-beginner-needs-to-start-career-in-sap-netweaver-bw-part-i

SAP Training website @http://www.monstercourses.com/sap-bwbi

@http://nowlearning.com.au/course/details/2369/sap++business+intelligence @http://www.bigclasses.com/sap-bw-bi-online-training.html @http://www.bigclasses.com/sap-bw-bi-online-training.html

Self Training @http://www.erpselftraining.com/product/New_SAP_BPC_7_Consultant1.html @http://www.alibaba.com/product-free/120631684/SAP_BI_7_Consultant_Training_Video.html

SAP PUB @http://www.sappub.com/forum-38-1.html

SAP BI Admin @http://www.slideshare.net/jwfhaha/bw360-en-col62

SAP Pdf Download @http://pdfreedownload.com/pdf/sap-bi-tutorial @http://pdfreedownload.com/pdf/advanced-reporting-in-bbi-b-70-what-are-the-best-features-to-use-7634108.html @http://pdfreedownload.com/pdf/reporting-and-analytics-with-bsap-b-businessobjects-478226.html @http://pdfreedownload.com/pdf/bsap-b-bbusiness-intelligence-b-reporting-dophome-1436213.html @http://pdfreedownload.com/pdf/bsap-b-bbusiness-intelligence-b-galileo-press-der-verlag-fr-8552107.html

SAP PDF Certification @http://pdfreedownload.com/pdf/free-sap-bi-certification

SAP BI Key figure @http://help.sap.com/saphelp_470/helpdata/en/5b/d2310243c611d182b30000e829fbfe/content.htm @http://blog.sina.com.cn/s/blog_4d7d20bb0100x7t7.html

SAP HANA with SAP BI Tools []

SAP Sina Download @http://ishare.iask.sina.com.cn/f/13147188.html?from=like

@http://ishare.iask.sina.com.cn/search.php?key=sap+bi&from=file&format=

SAP blog on Sina @http://blog.sina.com.cn/s/blog_4d7d20bb0100x7t7.html

SCN SAP DOC @http://scn.sap.com/docs/DOC-7725 @http://www.erpselftraining.com/product/SAP_BI_70_Consultant_Audi1.html

SAP Terminology overview @http://scnblogs.techweb.com.cn/sapcan/archives/41.html

SAP Library: @http://help.sap.com/saphelp_erp2004/helpdata/en/84/81eb588fc211d4b2c90050da4c74dc/frameset.htm @http://help.sap.com/saphelp_erp2004/helpdata/en/f9/45503c242b4a67e10000000a114084/content.htm

ODS Vs InfoCUBE @http://www.saptechies.com/what-is-ods/

SAP download @http://www.filestube.com/s/sap+netweaver+portal+technology+the+complete+reference @http://ebooks.developersvoice.com/sap-business-information-warehouse-reporting.html

SAP BEx video =SAP BW BEx Overview = @http://v.youku.com/v_show/id_XMTc2NjM4OTA0.html @http://video.sina.com.cn/v/b/86508817-2930375727.html Scarcity: Why Having Too Little Means So Much

Mathematic