1,發運行的接收應計(PO_LINE_LOCATIONS_ALL.ACCRUE_ON_RECEIPT_FLAG)控制接收時是否產生分錄.2,分配行的接收應計(PO_DISTRIBUTION_ALL.ACCRUE_ON_RECEIPT_FLAG)控制發票匹配PO時,分配行的科目取PO charge account,還是取暫估科目.3,強制接收時產生分錄:3.1,update PO_LINE_LOCATIONS_ALL set ACCRUE_ON_RECEIPT_FLAG='Y' where ...3.2,update PO_DISTRIBUTION_ALL set ACCRUE_ON_RECEIPT_FLAG='Y' where ...3.3,刪除delete from RCV_ACCOUNTING_EVENTS WHERE rcv_transaction_id = 9430(一般情況是RCV_ACCOUNTING_EVENTS有, RCV_RECEIVING_SUB_LEDGER 沒有)3.4,調用產生分錄的API,傳入transaction idRCV_AccEvents_PVT.Create_DeliverEvents(p_api_version => 1.0,p_commit ? ? ? ? ? ? => FND_API.G_TRUE,x_return_status ? ? ?=> l_return_status,x_msg_count ? ? ? ? ?=> l_msg_count,x_msg_data ? ? ? ? ? => l_msg_data,p_rcv_transaction_id => 9430)1.RCV_AccEvents_PVT.Create_DeliverEvents-->RCV_SeedEvents_PVT.Seed_RAEEvent--2. insert RCV_ACCOUNTING_EVENTS2.RCV_SeedEvents_PVT.Insert_RAEEvents-->-- Call Account generation API to create accounting entries-- insert RCV_RECEIVING_SUB_LEDGER3.RCV_CreateAccounting_PVT.Create_AccountingEntry-->4.CST_XLA_PVT.Create_RCVXLAEvent-->XLA_EVENTS_PUB_PKG.create_eventPSA_BC_XLA_PUB.Budgetary_Control5.xla_accounting_pub_pkg.accounting_program_events(p_application_id ? ? ? => 707,p_accounting_mode ? ? ?=> 'FINAL',p_gl_posting_flag ? ? ?=> 'Y'...-->6.xla_accounting_pkg.accounting_program_events-->events_processorxla_balances_pkg.massive_updatexla_transfer_pkg.gl_transfer_mainxla_accounting_pub_pkg.accounting_program_document-->fnd_request.submit_request(application ? ? => 'XLA',program ? ? ? ? => 'XLAACCPB'...7.xla_accounting_pkg.accounting_program_document-->xla_accounting_pkg.accounting_program_events3.5,查看錯誤信息:xla_accounting_err_pkg.insert_errors;select * from xla_accounting_errors;------------------------------Select aeh.ae_header_id,ael.ae_line_num,ael.accounting_class_code,ael.accounted_dr,ael.accounted_cr,rt.transaction_id,rt.shipment_header_idfrom xla_ae_headers ? ? ? ? ? aeh,xla_ae_lines ? ? ? ? ? ? ael,rcv_transactions ? ? ? ? rt,XLA_DISTRIBUTION_LINKS ? xdl,rcv_receiving_sub_ledger rrslwhere aeh.ae_header_id = xdl.ae_header_idand aeh.ae_header_id = ael.ae_header_idand ael.ae_header_id = xdl.ae_header_idand ael.ae_line_num = xdl.ae_line_numand xdl.source_distribution_type = 'RCV_RECEIVING_SUB_LEDGER'and xdl.SOURCE_DISTRIBUTION_ID_NUM_1 = rrsl.RCV_SUB_LEDGER_IDand rrsl.rcv_transaction_id = rt.transaction_idand rrsl.set_of_books_id = 2045and rt.transaction_id = 14449/* ?and rt.shipment_header_id IN(SELECT shipment_header_idFROM rcv_shipment_headersWHERE receipt_num = '&RECEIPT_NUM')*/order by rt.transaction_id, ael.ae_header_id, ael.ae_line_num;

總結

以上是生活随笔為你收集整理的PO接收产生分录的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。