摘要：
--Purpose: To validate whether a transaction's REC is equal to its REV plus TAX or notSELECT c.trx_number, c.complete_flag, c.customer_trx_id, a.customer_trx_line_id, (SELECT payment_schedule_id FROM ar.ar_payment_schedules_all d WHERE a.customer_trx_id = d.customer_trx_id) payment_schedule_id, 阅读全文
摘要：
背景:最近用户反映,一些已经完全付款的发票仍然可以选择并进行零金额的付款,目前我们没有开启这样的功能(enable the Allow Zero Payments option in the Payables Options region of the Bank Accounts window.)原因:个人认为可能是bug,导致没有同步更新flag措施:1>找出相应的发票;SELECTDISTINCTai.invoice_id, ai.invoice_num invoice_num,pv.segment1 vendor_num, pv.vendor_name vendor_name,&# 阅读全文
摘要：
要求:现有A产品5000pcs,只做一个订单,但想生成五个AR发票[出货5000 Pcs的成品A, 但客户需求开5张发票，也就是每张1000 Pcs.不能手工开发票，要从OM模块导入]措施:1>重新定义Autuinvoice的Grouping rule; 把可选属性SALES_ORDER_LINE定义为强制性属性(在定义窗口的Group by区域选择SALES_ORDER_LINE),可参考AR的UG[如果开启grouping rule的可选属性,使之成为强制性属性]2>重新定义(或修改)AR Source 在定义窗口的Autoinvoice option中选择第一步新定义的Gro 阅读全文
摘要：
中文名称英文名称流动资产CURRENT ASSETS：现金Cash on hand银行存款Cash in bank有价证券Marketable securitiea应收票据Notes receivable应收帐款Accounts receivable坏帐准备Provision for bad debts预付帐款Advances to suppliers其他应收款Other receivables待摊费用Deferred and prepaid expenses存货Inventories存货变现损失准备Provision for loss on realization of inventory一 阅读全文
摘要：
RTP报错信息: RVTPT-020: Subroutine rvtoe_RmaPushApi() - EDelivered quantity cannot exceed received quantity. returned error原因:部分接收时,系统没有自动split这个RMA订单行;现假设RMA订单行数量为10个,先前已成功接收5个,现再接收余下5个时报上面的错误.解决方法(假设RMA行的id为1234567):BEGIN dbms_application_info.set_client_info(123);--假定OU为123 oe_rma_receiving.push_rece 阅读全文
摘要：
如果SELECT语句中有使用Alias,DISTINCToperator,CURSORexpression,SET(union,union all,minus,intersect)operators,group_by_clause, oraggregate(count,max,mix,avg)functions,则无法到查询返回值进行更新;eg:TABLE:empid name salary==========================10 aaaa 123413 abcd 231315 cdue 1245... ... ...case 1> 使用别名;select id emp_ 阅读全文
摘要：
SELECT OHA.ORDER_NUMBER, HS.HOLD_ENTITY_CODE CREDIT_CHECK_CRITERIA_CODE, FLV.MEANING CREDIT_CHECK_CRITERIA, HD.NAME HOLD_NAME, HD.TYPE_CODE HOLD_TYPE, HR.RELEASE_REASON_CODE, FLV1.MEANING RELEASE_REASON, HS.RELEASED_FLAG, HS.HOLD_ENTITY_ID, OH.HOLD_RELEASE_ID, OH.HEADER_ID, HS.HOLD_SOURCE_ID FROM ON 阅读全文
摘要：
How to change the status of Prepayment invoice from ‘Fully Applied’ to ‘Available’,In fact the prepayment invoice has been applied./Files/benio/aaa.doc 阅读全文
摘要：
The issue occurs twice again, the problem should be a bug[patch 5256307].Solution:-----------------------------------------------------------------------------Step1>update po's unit price to the price that it has been used by receiving;udate po_lines_allset unit_price = 766.99where po_line_id 阅读全文
摘要：
AR transactions should be created on 6-JUL-2010,in fact they weregenerated on 25-JUN-2010. Because the SHIP_DATE_ACTUAL is on 25-JUN-2010.----------------------------------------------------------------------------------Original date: TRX_DATE=25-JUN-2010,GL_DATE=25-JUN-2010,DUE_DATE=25-JUL-2010---- 阅读全文
摘要：
Payables displays the status of the payment. You can change the value in this field under ertain circumstances for future dated payments. Note that the statuses that Payables uses for cleared payments and reconciled payments depends on your setting for the Account for Payment When Payment Clears Pay 阅读全文
摘要：
你可曾发现,在ap_invoice_distributions_all中有时rcv_transaciton_id为空,有时却又是有值的, 这是为什么呢?(请参考po_line_locations_all.match_option)或许你还记得我们在发票工作台上选择匹配时,有时是Match PO,有时却是Match Receipt,其实这就是原因所在, 当然影响这个匹配项的根本还是PO的shipment上的一个开关:是Receipt,还是Purchase Order,如果这里是Receipt,在匹配PO时,只能选择Receipt(匹配成功保存后rcv_transaciton_id是有值的),反之 阅读全文
摘要：
Cost Cutoff Date is a new feature that is available in Oracle Applications 11.5.7 (DMF Family Pack G). This functionality is developed to allow businesses theoption of changing labor rates and overhead rates at the beginning of theaccounting period while transactions in the next period wait for thes 阅读全文
摘要：
待摊费用场景:一次性支付1年房租24000.001）AP发票 DR: 待摊费用-房租 24000.00 CR: 应付帐款-其它 24000.002）AP付款 DR: 应付帐款-其它 24000.00 CR: 银行存款 24000.003）GL日记帐(每月做) DR: 管理费用-房租分摊 2000.00（1/12) CR: 待摊费用 2000.00（1/12) 阅读全文
摘要：
Purchase Price Variance(PPV)account need to be set up only in a Standard Costing OrganizationExplanation-----------For Standard Costing Organizations, the PPV account is mandatory,for Average Costing Organizations, the PPV Account is optional.After the fix, the form logic will be as follows: if (Sta 阅读全文
摘要：
12 How to Match a Credit Memo to an Invoice for Correction? [ID 1314520.1]--------------------------------------------------------------------------------Applies to:Oracle Payables - Version: 12.0.0 to 12.1.3 - Release: 12.0 to 12.1Information in this document applies to any platform.SolutionHere ar 阅读全文
摘要：
资产调整财务信息，有摊销调整和费用调整两种方式处理。举例1200元资产折旧一年，在第三个月新增600为例：标准费用调整计算方法：1200/12＝100 月折旧（未调整时），折旧第三个月调整，那么新增了600，应该追加折旧，即：1800/12=150。 （调整后折旧），如果费用调整，调整金额一次性计入第三个月费用，则(150-100)*2 前两个月应该计提实际没有计提的折旧。那么3月折旧为 150+(150-100)*2=250。标准摊销调整计算方法： 摊销调整就是把调整但是没有摊销的金额在以后月份进行摊销：(150-100)*2/10＝10，就是3月开始，每月需要摊销调整10第三月折旧 150 阅读全文
摘要：
block的lock mode属性为automatic或immediate，在修改记录时Forms会立即锁定数据库记录；如果设为delayed，在保存时Forms才尝试锁定记录。 阅读全文
摘要：
可能的问题:1）锁表SELECT dob.OBJECT_NAME Table_Name ,lo.LOCKED_MODE, lo.SESSION_ID, vss.SERIAL#, vps.spid, vss.action Action, vss.osuser OSUSER, vss.process AP_PID, VPS.SPID DB_PID, 'alter system kill session ' || '''' || lo.SESSION_ID || ',' || vss.SERIAL# || ''' 阅读全文
摘要：
场景: 员工借款1000.00, 实际用900.00,归还100.001)预付发票-员工借款 Dr: 预付款-员工借款 1000.00 Cr: 应付帐款 1000.002)预付款发票全额支付 Dr: 应付帐款 1000.00 Cr: 银行/现金 1000.00 ----合并分录如下---- Dr: 预付款-员工借款 1000.00 Cr: 银行/现金 1000.003)标准发票(实际发生额形成发票，900.00) Dr: 员工费用 900.00 Cr: 应付帐款 900.004)核销预付款发票 Dr: 应付帐款 900.00 Cr: 预付款-员工借款 900.00----------至此，员工 阅读全文