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 的值.