Oracle EBS OM App, Ship Confirm 後, line 無法 Close

解法參考: Ship Confirm 後, line 無法 Close

Sale Order 到 AR 的操作流程

手動 Sales Order 到  AR 的操作流程 https://blogs.oracle.com/ptian/entry/oracle_ebs%E8%AE%A2%E5%8D%95%E7%9A%84%E6%B5%81%E7%A8%8B_order_ar

手動執行 Ship Confirm 的操作可參考： http://oraclemasterminds.blogspot.tw/2014/11/manual-ship-confirm-process-in-order.html

Create accounting for an invoice

Create accounting for an invoice

hychen39@gmail.com

Create accounting for an invoice from Hung-Yi Chen

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.

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.

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 的流程.

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 

Cost types in Oracle Inventory

Oracle Inventory is installed with three predefined cost
types: Frozen, Average, and Pending. These are costs currently in use
for an item and include material and overhead charges. See: Defining
Cost Types, Oracle Cost Management User’s Guide.