piola

朋友馬克最新力作，

piola wait for bus

Piola大集合之夏日版桌布

月結作業 - 固定資產系統 FA

Step 1. Make Sure to post all invoices distribution
which marked as “Track as asset” (AP)

Run Expense Distribution Detail Report

列印所有 Unpost 之Track as Asset交易,
Check un-posted reason , fix it and post associated invoice
into Oracle General Ledger

Submit Create Mass Additions for Assets Program

System will automatically generate
Mass Additions Create report.

Step 2. Make sure to post all “UN-POST” assets

Run Unposted Mass Additions Report

列印所有 Unpost 之Mass Additions
Check un-posted reason , fix it and post associated invoice
into Oracle Fixed Assets

Submit Post Mass Additions

System will automatically generate
Mass Additions Posting report.

Reconcile Unposted Mass Additions Report with
Mass Additions Posting Report

Step 3. Make adjustment for exceptional conditions

Cost Adjustment in “mass-additions”

AP : Dr -- Clearing Acct $20,000
Cr -- AP $20,000
FA : Dr -- Asset Cost Acct $20,200 (Cost Adjustment $200)
Cr -- Clearing Acct $ 20,200
GL : Dr -- Clearing Acct $200 (Adjustment Journal)
Cr -- AP $200

Manual error on AP (non-clearing account)

AP : Dr -- Asset Cost Acct $20,000
Cr -- AP $20,000
FA : Dr -- Asset Cost Acct $20,000 (Manual Addition)
Cr -- Clearing Acct $ 20,000
GL : Dr -- Clearing Acct $20,000 (Adjustment Journal)
Cr -- Asset Cost Acct $20,000

Cancel Original AP -> Re-enter AP -> Approval -> Post to GL -> Post to Mass Additions -> Post to FA

Step 4. Final posting in mass-additions

Run Unposted Mass Additions Report

列印所有 Unpost 之Mass Additions
Check un-posted reason , fix it and post associated invoice
into Oracle Fixed Assets

Submit Post Mass Additions

System will automatically generate
Mass Additions Posting report.

Reconcile Unposted Mass Additions Report with
Mass Additions Posting Report

Step 5. Run projection report to see projected depreciation expense

Step 6. Run Depreciation (Close Current Period & Open Next)

Step 7. Reconciliation Reports with Oracle General Ledger

Reconciling Journal Entry to General Ledger Accounts

Reconciling Asset Cost Accounts

Reconciling CIP Cost Accounts

Reconciling Reserve Accounts

Reconciling Depreciation Expense Accounts

Google 2008 台北程式開發日來囉

誠意邀請您參與 Google 2008 台北程式開發日

了解如何充分運用Google

開發人員產品建立各種應用程式，以因應如社交、行動產品、地理/地圖，以及 AJAX/JavaScript 等不同需求。

http://code.google.com/intl/zh-TW/events/developerday/2008/home.html

安裝 Oracle Database 10g Express

Oracle Database 10g Express的安裝其實是相當簡便的，幾乎只要一直下一步就可以完成安裝了

接受合約，下一步

因為只有一個產品可以選擇安裝，安裝路徑可以改變，下一步

設定SYS與SYSTEM USER的密碼，下一步

顯示Database一些listener的相關資訊，下一步安裝

完成安裝後，可以到資料庫管理首頁做相關設定

以SYS身份登入

XE的 Web管理頁面還蠻方便，大部分的工作不用再透過其他工具來執行，算是一套不錯的免費資料庫。

對於個人或小企業來說，4GB的資料庫應該很好用了。