AP: setup\calendar\accounting\AP accounting periods
PO: setup\financials\accounting\open and close periods
Inv: CH inventory\accounting close cycle\inventory accounting periods
GL: setup \open\close
AR: control\accounting\open\close periods
COST: accounting close cycle\inventory accounting periods
----------------------------------------------------------------------------- 1. 检查PO所有的交易(Completing all transactions for Oracle Purchasing):
1.1 Complete Requisitions
1.2 Complete Purchase Orders and Releases
1.3 Complete Receipts and Returns
1.4 PO>Receiving>Transaction Status Summary,检查该期间的所有交易的状态.对于有错误的交易要进行处理.
1.5 执行Confirm Receipts Workflow Select Orders程式,这只程式会把所有a Destination or Deliver–To Type of Expense, a Routing of Direct Delivery, and a Need–By date that is equal to or later than today’s date的记录发给requestors or buyers who create requisitions in Purchasing or Oracle Self–Service Purchasing.让操作人员知道有哪些货物应该要做收料(但还未完全收料)It lets people know they should have received an item. 结果在Notification Summary中查看.
1.6 执行Purchase Order Commitment By Period Report,统计指定期间和随后五个期间的采购合同(monetary value of purchased commitments),且可按采购员和供应商进行分类,以作统计分析之用.
判断PO属于哪个期间的依据是promise date,如果没有,就用need–by date.
如果一个PO既没有promise date也没有need–by date,那么都会归于最新的期间.(比如今天是07年1月,那么这些PO都会归于Jan-01这个期间)If both the need_by_date and promised_date are null then the date is taken as sysdate and the processing happens and hence the PO appears on the report.
注意:
1.7 检查未完成和过期的PO,使用以下三个程式: Purchase Order Detail Report Open Purchase Orders Report(by Buyer) Open Purchase Orders Report(by Cost Center) 这些程式可以查看所有或者是指定的采购单,且查看其订货和收料的数量.
1.8 Follow Up Receipts根据之前三个报表的结果,把需要做收料的PO做收料操作,如果安装了INV,就不能针对已经关帐的PO期间做收料的操作.
Business Requirements The period close process for Oracle Inventory enables summarising of costs related to inventory and manufacturing for a given accounting period. These costs are then transferred to the General Ledger for posting.
Steps Oracle Inventory and Oracle Cost Management provide the required features to effect the necessary period-end procedures to:
Reconcile the inventory and work in process costs and values. Transfer inventory and manufacturing costs to the General Ledger. Transfer summary or detail accounting information to the general ledger. Independently open and close periods for each inventory organisation. Perform. interim transfers to the General Ledger without closing the period. Maintain the same set of periods and fiscal calendar as for the General Ledger.
2.1 完成所有当期应该完成的交易,检查所以纸面单证,以确定没有漏输入系统的交易.
可选择执行:Cycle count entries and adjustments report
2.2 Check the Interface Managers window to ensure that there are no background or concurrent programs unprocessed.
检查Transaction Open Interface中是否有状态为Error的进程.
Check all three selections, Transactions Interface, Internal Transactions, and Demand Interface, and fix any rejected transactions.
2.3 检查所有的OM的sales order (Pick Release)已经完成--即使没有完成也不需要做完.确定其交易已经正确的提交到INV.
2.5 把当期库存交易的金额与GL交易的金额进行对帐(Balance the Perpetual Inventory).
执行Inventory Value Report:检查详细交易的数量,Item和金额信息,可以针对参考进行统计.
执行Period close value summary:统计已关闭期间关帐时点每个仓库的库存值,如果统计未关帐的期间,那么是以当前库存值作为统计结果.
选择执行Elemental Inventory Value Report
Material Account Distribution Detail Report:可选定交易日期范围查看.
Material Account Distribution Summary Report
2.6 检查WIP的库存交易
The WIP Account Distribution Report details account information for work in process cost transactions, including resource, overhead and outside processing charges, cost updates, and period close and job close variances.
2.7 把库存交易手工抛转到GL(Transfer Summary or Detail Transactions)
If time permits, run the Transfer transactions to GL process up to the period end date before closing the period. 尽管关期间程式会自动抛转,但是可以提前手工抛转以检验数据的准确性.
检查是否有错误的(状态为Error)抛转发生:PO>Accounting Close Cycle>View General Ledger Transfer.
Complete All Transactions for the Period Being Closed: Keep on Running queries from Apatghealthcheck.sql which will tell you about Orphan Records. Ensure that all transactions have been entered for the period being closed. Completing all transactions for Oracle Payables: Complete Invoicing and Credits Complete Prepayments Complete Expense Reports Complete Invoice Import
3.1 验证所有需要验证的商业发票以便作抛转总帐和付款的操作.
Invoice Validation
3.2 General Ledger检查抛转总帐的金额
Review and Resolve Amounts to Post to the General Ledger.
Accounting Entries Audit Report. The audit report provides, in detail or summary, a listing of accounting entries created by the accounting process.
Accounting Entries Exception Report. The exception report lists in detail all accounting entries that were created with an error status and a description of that error. The Entries Exception Report is generated only when the accounting process encounters accounting entries that fail validation.
3.6 Review the Unaccounted Transactions Report
By running a month end payment batch, you may arrange a payment for as many due invoices as possible.
AP-----Accounting----View Accounting Lines 界面中选择当月日期，在“Transferred to GL”选“NO”就能查询未过帐明细行。
选择性执行Payments Registers(该报表会显示付款是否已经做了Reconciled的操作),显示指定日期范围内所有的付款信息(less discounts and voids),该报表只显示付款净值,不包含折扣的信息,因此会比Posted Payment Register包含所有的付款金额要小(前者是显示付款的金额,后者是显示应付帐款减少的金额,付款净值+折扣=应付帐款减少额).因此在查看付款批次界面的金额的时候要减去折扣金额才能与这个报表对帐.
3.8 使用CE的功能利用银行对帐单调节付款信息.Reconcile Payments
Reconcile Payments to Bank Statement Activity for the Period.
(Refer to Period-End Procedures for Oracle Cash Management)
3.9 将当期所有发票和付款信息抛转至总帐.
可以具体在数据库里查询AP头信息及行信息的过帐情况 1、未正确过入GL的头信息： select * from ap_ae_headers_all apa where apa.gl_transfer_flag='N' and apa.period_name='01-2007'
2、未正确过入GL的行信息： select * from ap_ae_lines_all apl where apl.gl_sl_link_id is null and apl.program_id=-1 and apl.request_id=-1 and apl.creation_date>=to_date('2007-01-01','yyyy-mm-dd')
如果，查询结果没有数据，那就可以成功关闭当月AP帐了！
3.10 使用以下报表(不必要)检查AP资料
Payables Accounting Process Report
以下两只报表可以统计被抛转至总帐的发票和付款信息:
Posted Invoices Register
Posted Payments Register
3.11 把没有创建会计分录和抛转到GL的交易的总帐日期改为下一个期间的第一天.
执行Unposted Invoice and Payment Sweep Program.
当在the Control Payables Periods window直接关闭AP期间时候,如果存在没有抛转总帐和没有创建会计分录的交易,系统会自动启动该程式或者启动该程式报表,以移转或者显示将要移转的交易的信息.
3.12 关闭AP期间 Close the Current Oracle Payables Period
这个程式会把已收未立的费用性采购创建会计分录到GL(Oracle Purchasing creates an un-posted journal entry batch in the General Ledger for the receipt accruals.),借charge account,贷liability.需要使用这个程式必须把Purchasing option中的 Accrue Expense Items flag 选项设置为Period end.
当开启下一期PO期间的时候,GL自动回转receipt accrual journal.
檢查已收料未立帐的交易 (查看未立AP的驗收單資料)
1.(AP) PO Reports->Run 未開立商業發票之收貨報表“ Uninvioce Receipts Report “ Ps.1 注意Accrued Receipts選NO Ps.2 執行 “ Receipt Period End ”和關 PO 期間後 ( PO 期間可暫時不關) ,直接進 GL作 Import 2.1 Source :Purchasing Special group ID (Create Summary Journal 不勾選) 2.2 產生 Expense Unvoucher , 並回轉傳票至次月.
运行The Accrual Reconciliation Report is used to analyse un-invoiced receipts and to reconcile the balance of the Accounts Payable accrual accounts.
这个报表有以下两种版本:
The Accrual Reconciliation Rebuild Report This version of the report selects the accounting entries from the appropriate source (sub-ledgers). This accounting information resides in a temporary table, and remains until this information is rebuilt again. Typically, this report is run at period end.
The Accrual Reconciliation Report This version of the report uses the accrual information residing in the temporary tables that was selected the most recent time the Accrual Reconciliation Rebuild Report was run. This report is typically run throughout the accounting period, providing interim reports, whereas the rebuild report is used to select and report on current accrual information at period end.
以上两个报表能够用来检查PO收料数量与立帐数量的不同,
Accrual Write-Off Report can be used as supporting detail for the manual journal entry in General Ledger.
