Transcript Oracle-AP模組介紹 企業資源規劃 報告人：林筱菁 e

Oracle-AP模組介紹
報告人：林筱菁
企業資源規劃
企業 e 化之營運管理
課程大綱
•
•
•
•
•
•
•
•
•
什麼是應付帳款管理
AP如何產生
Oracle AP的前置設定
Supplier
Enter Invoice
Match to PO
Approve and Cancel Invoice
Payment
練習題
ERP功能架構
銷售預測
FCST
粗略產能規劃
RCCP
採購需求
PR
主需求排程
MDS
主生產排程
MPS
物料需求規劃
MRP
採購訂單
PO
收料作業
receive
付款作業
payment
應付帳款
AP
倉儲管理
inventory
會
計
總
帳
GL
發料作業
issue
顧客訂單
orders
生產排程
schedule
在製品管理
WIP
產能需求規劃
CRP
出貨作業
shipping
收款作業
receipt
應收帳款
AR
什麼是應付帳款管理
• 應付帳款立帳
• 付款作業
• 應付帳款管理
什麼是應付帳款管理
驗收入庫
借：存貨
貸：暫估應付帳款
立帳
借：暫估應付帳款
貸：應付帳款
開票
借：應付帳款
貸：應付票據
票據兌現
借：應付票據
貨：銀行存款(或現金)
Procure to Pay modules
Manual:
•Match to PO
•Match to Receipt
Automatic:
•Pay on Receipt
Cash mgmt
Reconcile
Journal (unpost)
GL interface
Transfer
•Invoice
•Payment
Purchasing
Interface
Tables
Payables
Mass Addition
Interface Tables
Prepare Mass Addition
•Invoice merge to 1 asset
•Invoice spilt to many assets
•Cost adjust
Post
Asset number
Assets
Interface
Tables
General Ledger
Oracle Payables Overview
Receive invoices
Enter invoice
Approve invoice
Post invoice
Match to PO
View invoice
Pay invoice
File invoice
AP如何產生
• 手動立帳
• 自動立帳
– 可以透過PO模組-AutoCreate Invoice的方式，
由系統自動產生應付憑單資料。
Oracle AP前置設定
• GL相關設定已完成
– 會計科目設定
– 幣別匯率設定
– 會計期間的設定
– 帳本架設完成
– 會計期間的開啟
課程大綱
•
•
•
•
•
•
•
•
•
什麼是應付帳款管理
AP如何產生
Oracle AP的前置設定
Supplier
Enter Invoice
Match to PO
Approve and Cancel Invoice
Payment
練習題
Supplier and Supplier Site Settings
Supplier
Tokyo
Paris
New York
Purchasing site
RFQ only site
Purchasing site
pay site
Pay site
Contacts
Contacts
Contacts
Supplier and Supplier Site Settings
• For every supplier, you can create an unlimited
number of sites with different addresses and
contacts.
• You can designate supplier sites as one of the
following types:
– Pay Site: You can only enter an invoice for a supplier
site that is designated as Pay Site.
– Purchasing Site: You can only create purchase
orders in a Purchasing Site.
– RFQ Only Site: In Oracle Purchasing you can only
create request for quotations from a RFQ Only Site.
課程大綱
•
•
•
•
•
•
•
•
•
什麼是應付帳款管理
AP如何產生
Oracle AP的前置設定
Supplier
Enter Invoice
Match to PO
Approve and Cancel Invoice
Payment
練習題
Enter Invoice: Overview
Receive invoices
Enter invoice
Approve invoice
Post invoice
Match to PO
View invoice
Pay invoice
File invoice
Invoice Information
Invoice
BASIC
Invoice information
Supplier information
Default information
DETAIL
Scheduled payments
Invoice distribution
Invoice Types
Type
Standard
Credit memo
Description
來自供應商的Invoice
(Standard Invoice可與採購單匹配也可不與採購單匹配)
貸項通知單
Debit memo
借項通知單
Expense Reports 其為應付員工、以及與業務有關之費用的一種Invoice
PO Default
爲與採購單匹配而輸入的Invoice (輸入一個採購單編號，Oracle Payable
會自動提供供應商資訊)
Prepayments
QuickMatch
這種Invoice是爲了支付供應商或員工的費用預付款而輸入的
爲與採購單匹配而輸入的Invoice (輸入一個採購單編號，Oracle Payable
會自動提供供應商資訊，並與該訂單上的每個shipment匹配)
Invoice Distribution Types
Type
Description
Item
Tax
Freight
Miscellaneous
Withholding
記錄已購買商品或服務供應商的收費金額
記錄已購買商品或服務到期銷售稅額或其他稅額
記錄供應商運輸和搬運的收費金額
記錄Invoice上的雜項費用金額
記錄已從Invoice中預扣的稅額
Invoice Total & Distribution Total
• During approval, Oracle Payable places a
hold on an invoice if the distribution total
does not equal the invoice amount. A
distribution variance hold prevents
payment and transfer to the general ledger.
The Expense Report Process
Enter expense
reports
Apply
advances
Create invoices by
submitting payables
invoice import
Payment to employees
Setting Up Expense Report Entry
Enter employees
and locations
Define employee
as a supplier
Define expense
report templates
Recurring Invoice
You can enter invoices for periodic business
expenses for which you may not receive
invoices (such as rent).
To enter recurring invoices:
• Define a special calendar
• Define a recurring invoice template
• Create invoices based on the template
Recurring Invoice
With a recurring invoice template, you can:
• Specify the intervals for which invoices will
be created.
• Define recurring invoices to increase or
decrease by a fixed percentage from
period to period.
Holds
• Apply holds to supplier site invoices
• Apply holds to selected invoices
• Apply holds to scheduled payments
課程大綱
•
•
•
•
•
•
•
•
•
什麼是應付帳款管理
AP如何產生
Oracle AP的前置設定
Supplier
Enter Invoice
Match to PO
Approve and Cancel Invoice
Payment
練習題
Match to PO: Overview
Receive invoices
Enter invoice
Approve invoice
Post invoice
Match to PO
View invoice
Pay invoice
File invoice
Match Invoice to Purchase Order
• Oracle Payable shares purchase order
information from your purchasing system
to enable online matching with invoices.
• You can match a single invoice to multiple
purchase order shipments, or you can
match multiple invoices to a single
purchase order shipment.
練習
• http://test5.erp.shu.edu.tw:8000
• User:shu
• Password:123456
課程大綱
•
•
•
•
•
•
•
•
•
什麼是應付帳款管理
AP如何產生
Oracle AP的前置設定
Supplier
Enter Invoice
Match to PO
Approve and Cancel Invoice
Payment
練習題
Approve Invoice: Overview
Receive invoices
Enter invoice
Approve invoice
Post invoice
Match to PO
View invoice
Pay invoice
File invoice
Approve Invoice
• Before you can pay or post an invoice, you
must submit approval for the invoice.
• If you are approving a credit or debit
memo, select Approve Related Invoices to
submit online approval for invoices
associated with the credit or debit memo.
Canceling Invoices
• You can cancel only unpaid invoices.
• You can cancel any unapproved invoice.
• If an invoice has a hold that prevents
posting, you must release the hold before
you cancel the invoice.
• You cannot cancel an invoice that has
been selected for payment in a payment
batch.
Invoice Inquiry: Overview
Receive invoices
Enter invoice
Approve invoice
Post invoice
Match to PO
View invoice
Pay invoice
File invoice
Invoice Inquiry
• You can find invoices to respond to
supplier inquiries including questions
about invoice payment status, invoice
payment date and reasons an invoice has
not been paid.
• You can also find invoices to make
adjustments to them or to perform actions
on them such as approval or cancellation.
課程大綱
•
•
•
•
•
•
•
•
•
什麼是應付帳款管理
AP如何產生
Oracle AP的前置設定
Supplier
Enter Invoice
Match to PO
Approve and Cancel Invoice
Payment
練習題
Invoice Payment: Overview
Receive invoices
Enter invoice
Approve invoice
Post invoice
Match to PO
View invoice
Pay invoice
File invoice
Manual Payments
• Prerequisites for processing manual
payments in Oracle Payables are:
– Create the payment outside of Payables.
– The invoice you paid must be approved,
uncancelled, without holds, and must have
the same currency as the payment.
Oracle Payables Payment Methods
Payment Method
Definition
Check
列印並發送給供應商的支票
Electronic
電子資金轉帳到供應商銀行
Wire
通過與銀行聯繫並請求電匯給供應商銀行來啓動的資金轉帳
課程大綱
•
•
•
•
•
•
•
•
•
什麼是應付帳款管理
AP如何產生
Oracle AP的前置設定
Supplier
Enter Invoice
Match to PO
Approve and Cancel Invoice
Payment
練習題
練習
• http://test5.erp.shu.edu.tw:8000
• User:shu
• Password:123456