網路芳隣的安全設定

要設 XP 共享檔案夾的密碼, 可以參考這篇文章:

http://mypaper.pchome.com.tw/craighuang/post/1308608015

Personalize your EBS Home Page and make the Favorite shows up in your EBS Home Page

The article will show how to personalize your EBS Home Page and make the Favorite shows up in your EBS Home Page.

Add MOAC Preferences to a responsibility

The article shows how to add MOAC Preference function to the menu for the responsibility of Purchasing, Vision Operations (USA).

微積分的相關故事

數學家的介紹;
1.勒內·笛卡兒（René Descartes，1596年3月31日－1650年2月11日）
  * WIKI

2.Dirichlet, Johann Peter Gustav Lejeune 狄里克利 (1805-1859) 現代函數定義, 和其它數學家一起貢獻發展微積分。

3.Cauchy, Augustin Louis 柯西

4. Witch of Agnesi (安妮西的女巫) 

http://en.wikipedia.org/wiki/Witch_of_Agnesi

http://www.uh.edu/engines/epi217.htm

The "versiera" curve, or the Witch of Agnesi (drawing by John Lienhard)

Oracle E-Business 參考資料

Oracle Technical Reference Manual
[1] Oracle Inventory 11i, vol 1 [pdf]


Web Sites
[1] Oracle Help: Information, Tips, Solutions about Oracle ebusiness ERP from Experts.

[2] Oracle Apps Inventory Tables by Oracle Help, 2003



Books
[1] Oracle E-Business Suite 12 Financials Cookbook by Yemi Onigbode, 2011, sold by Amazon.com

General Ledger and Subledger

General Ledger 

 The general ledger is the core of your company financial records. These constitute the central ooks� of your system, and every transaction flows through the general ledger. These records remain as a permanent track of the history of all financial transactions since day one of the life of your company.

  Subledgers and the General Ledger

 Your accounting system will have a number of subsidiary ledgers (called subledgers) for items such as cash, accounts receivable, and accounts payable. All the entries that are entered (called posted) to these subledgers will transact through the general ledger account. For example, when a credit sale posted in the account receivable subledger turns into cash due to a payment, the transaction will be posted to the general ledger and the two (cash and accounts receivable) subledgers as well.

 Source: http://www.businesstown.com/accounting/basic-general.asp

How to create an employee and make him become a salesperson

This article demonstrates how to create an employee and designate him as a salesperson.

Setting Context-Sensitive Fields in the descriptive flexfield

The article demonstrate:
1. How to use a reference field to determine the context
2. How to use a profile value to determine the context
for descriptive flexfield.

運用 gmail 及 gtask 做工作管理

當有工作時,
1. 用 gmail 撰寫工作派工, 並指派給某人.派工單上撰寫: 工作要求, 完成條件, 截止時間,相關聯絡人.
2. 將 gmail 變成 gtask, 放到日曆上
3. 在日曆上進行控管

擴充之會計恆等式之擴充

(期末)資產＝(期末)負債＋(期末)業主權益
                 ＝(期末)負債＋(期初業主權益 ＋業主增加投資-業主提取 ＋收益-費損）

Java 7 尚未通過 Oracle EBS R12 的認證

Java 7 尚未通過 Oracle EBS R12 的認證. 如果使用 Java 7 會出現 frm-92095 的錯誤訊息.

解決方式: 如果有安裝 Java 7, 移除此版本


參考:
https://blogs.oracle.com/stevenChan/entry/sun_jre_1_6_06

Expense account rule 在何時在會發生作用取代 employee charge account 的部segment?

Expense account rule 在何時在會發生作用取代 employee charge account 的部segment?

(Purchase Order Student Guide ch8-71)

當以下條件滿足時:

·       Destination type is expense

·       Purchase order was not created from a requisition

·       Account was not set in preferences (建立 PR 或 PO 使用的 preference window)

·       Account was not successfully derived from project-based rules

·       Account was not successfully derived from the item setup (料件的 expense account 屬性)

When determining the default charge account for a line with a destination type of expense, the account generator may reference the charge account defined on the employee record. If the account generator references the employee record, then the Expense Charge Account Rules enable you to override one or multiple segments of that default account based on the item category. This ability to override does not interfere with the action of the account generator, but simply replaces those segments you configure after the account generator has created a charge account.
Note: This feature is available for lines containing one-time or inventory items as long as their destination type is expense.
The account segments defined in this window can only be used when the following conditions are true:

·       Destination type is expense

·       Purchase order was not created from a requisition

·       Account was not set in preferences

·       Account was not successfully derived from project-based rules

·       Account was not successfully derived from the item setup

Reference:

l   Oracle Purchasing User’s guide, docs.oracle.com/cd/E18727_01/doc.121/e13410/T446883T443950.htm

Example:

In case of having the following a/c values:

Item expense a/c: 04-Software with a/c 01-520-7530-0000-000

Employee charge a/c: 01-110-7740-0000-000

Expense Account Rule resulted a/c: 01-110-7740-0000-150

Charge account in preference window: none

Oracle Purchase defaults the distribution to item’s expense account.

如果 item expense 及 preference 中沒有設, 且沒有 Expense Account Rule, 則預設 Employee charge a/c. 若加了 Expense Account Rule, 則會預設成 Expense Account Rule 的值.

Setups for setting Credit check in Oracle Order Management

Steps to setup the credit checking in Order Management. Go to: https://docs.google.com/document/d/1-Ae8v9oTWd0EPLLQIgTgCSWf-qRXeon3G7xgYKIgArQ/edit

Order flow in the Oracle Order Management
* Standard item order flow: 標準料件的流程
* Drop Ship Order Flow:  Drop Ship 的流程.

會計科目中英文名詞

會計科目中英文名詞:
* http://forum.pchome.com.tw/content/7/24382

On-Account Credit

On-account credits are credits you assign to your customer's account that are not related to a specific invoice. For example, if your customer remits payment of $100 for a $90 invoice, you can create an on-account credit for ten dollars. You can then apply this on-account credit to another transaction.

source: http://docs.oracle.com/cd/A60725_05/html/comnls/us/ar/credit11.htm

這個 on-account credit 中文要翻成什麼呢?

可以翻成 "信用帳戶" 嗎?

Credit Memo & Debit Memo 的概念

Q: Credit Momo & Debit Memo 是用來做什麼的呢?

以下為帳務處理觀點:
----
但在台灣的實務中這樣解釋似乎較為恰當. credit memo or debit memo均為應付帳款的減項。但若帳務處理中需要區分進貨折讓與進貨退出的科目的話, 則可以 credit memo表進貨折讓(與量無關), 以 debit memo 表進貨退出 (與量有關, 量自po模組而來)。

這樣便可避免oracle本身標準功能中 match 原 invoice or po 時由原科目進行迴轉。如此, 可透過標準報表中之參數選擇 invoice type, 可求得全年度之進貨折讓與進貨退出之總金額。



當然, 若帳務處理無需出現進貨折讓或是進貨退出之科目者, 則兩者皆視為應付帳款的減項, 只是是由廠商主動 (credit memo) 或是我方主動(debit memo)罷了。
-----

上述內容修改自: http://somebabytina.pixnet.net/blog/post/11181894-credit-memo%E8%88%87debit-memo 的留言。

上述的觀解釋和其它的定義有所衝突:

Credit memo:
form or document used by a seller to notify the buyer of merchandise that the buyer's accounts payable is being credited (decreased) due to errors or other factors requiring adjustments.(

Read more: http://www.answers.com/topic/credit-memorandum#ixzz1lIpNByuq)

Debit memo: form or document used by a seller to notify a buyer that the seller is debiting (increasing) the amount of the buyer's accounts payable due to errors or other factors requiring adjustments. (

Read more: http://www.answers.com/topic/debit-memorandum#ixzz1lIpC756S)

Credit memo 是payable 的增加, Debit 是 payable 的減少, payable 屬於貸方科目.

Pick Release

Order Management 中的 pick release 是什麼意思呢?
----
Pick release is the process by which the items on the sales order are taken out from inventory. The flow is as follows:
1) When an order is booked, based on the setups, the lines are scheduled and they are ready to release. This means the inventory is informed that there is requirement of certain quantity of certain items on certain date.
2) The inventory person ,according to availability allocates the items to those SO Lines and reserves them. 3) Then on the day of delivery or somewhere between these items are taken out of inventory and moved to staging subinventory. This means that the items are now ready for shipping and are out of inventory.
When the items reach staging subinventory, they are said to be picked and shipping execution can now ship these items.
-----
 引用自: http://www.geekinterview.com/question_details/15999