很好的一个空间,好好研究
http://blog.163.com/sword_111/blog/#m=0&t=1&c=fks_087071093095085066087095081095082080084075093082087069
系统常用sql
http://www.erp100.com/forum.php?mod=viewthread&tid=80&extra=&authorid=8&page=1查看关键用户select distinct login_name from (select c.user_name &...
prepayment
prepayment的流程 1.先对一个供应商建立一个invoice, 这个invoice的类型的prepayment。2.需要对该prepayment invoice 做一个完全的付款3.对同一个供应商建立一个Standard invoice.4.然后再 action 里面选...
po 流程分析
5. PO: Purchase Order采购订单应用:Purchasing职责:Purchasing Super User 2007-1-5 14:06huajhua5.1. 基础业务学习PO模块概述首先,PO解决了企业...
how to enter new employee in the HRMS manage responsibility
在建立PO之前,需要建立新的 Employee,如果EBS已经安装了HR模块,那么必须在HRMS manager responsibility里面建立该用户。 在开发的时候如果发现一些错误信息:APP-PER-50022: Locations Screen: HRMS Does ...
lockbox
AutoLockbox (or Lockbox) is a service that commercial banks offercorporate customers to enable them to outsource their accountsreceivable payment processing. An AutoLockbox operation can processmillio...
automatic receipts
收款分为自动收款和手动收款:决定手动收款还是自动收款根据Receipt class还决定。通常的收款流程: 1.receipt2.remmitance3.clearance是否做 :remmitance 还是clearance也是Rceipt class来决定的。...
AR--deposit (定金) * Garantee(保证金)
记录定金和与此定金相抵的发票时,AR会计事务处理实例:1. 输入ABC 公司$10,000 的定金。借:应收帐款(定金)$10,000贷:未得收入$10,000可以打印定金发票给付款客户。ABC 公司收票之后付定金。􀂾...
OE
OM订单流程状态的分析?在做SO的订单过程中,可以根据订单的类型来生成不同的SO, SO订单中有两个状态,一个order information的status和order line的status,流程:entered--> booked---> pick release --> closed1...
INV Interface
--select * from mtl_onhand_quantities where organization_id=255INSERT INTO mtl_transactions_interface(transaction_interface_id,transaction_header_id,source_code,source_header_id,source_line_id,proces...
po
5. PO: Purchase Order采购订单应用:Purchasing职责:Purchasing Super User 2007-1-5 14:06huajhua5.1. 基础业务学习PO模块概述首先,PO解决了企业...
Oracle EBS库存管理基本操作实例(配图)
http://www.itpub.net/viewthread.php?tid=1207175http://blog.csdn.net/oraclebs
Debit memo and credit memo
ARCredit Memo 贷项通知单,减应收,冲原始发票 实际使用情况:客户退货,自己公司就需要开Credit Memo减小应收Debit Memo &nbs...
ar 常用表
ra_cust_trx_types_allra_bath_sources_allra_rulesper_people_f ar_cash_receipt_historyar_cash_receipts_all ar_bank_accounts_allra_cust_trx_line_gl_dist_all ra_customer_trx_allra_interface_lines...
AR
ar.ra_customer_trx_all rcta where trx_number='10009' 发票号 (rcta.customer_trx_id=apsa.customer_trx_id) ar.ar_payment_schedules_all apsa, 应收款表 ...