Oracle EBS GL
文章平均质量分 79
田攀
tian.pan@qq.com
展开
-
General Ledger Useful SQL Scripts – Oracle Applications 11i
General Ledger Useful SQL Scripts – Oracle Applications 11iContentsGL Set of Books Configuration Overview转载 2012-12-17 10:40:30 · 72567 阅读 · 0 评论 -
Inventory Transfer To GL(11i)
How Inventory Passes Journals To General Ledger (GL)Inventory Transactions transfer to GL normally done by Program called INCTGL.The accounting information related to transactions in INV module is tra转载 2012-12-15 19:12:50 · 3348 阅读 · 0 评论 -
Does Subinventory Transfer Transaction create Accounting Entries?
Answer is 'Maybe'.One subinventory xfer creates 2 inventory transactions. (mmt records)Those inventory transactions do NOT create a/c entries if both subinventories are tied to the same accounts.Howev原创 2013-01-28 10:49:22 · 3123 阅读 · 0 评论 -
Oracle ERP系统借贷关系表
成本核算会计信息归纳,按照事务处理的来源类型归纳。一、 采购接收入库和退货: 1.接收: 借:材料采购 (订单价格) 贷:应计负债 (订单价格) 2.入库: 借:原材料 (标准成本) 贷:材料采购 (订单价格) 借或贷:材料成本差异_材料订单价格 3.退货至接收时产生与上面第2步相反的分录,退货至供货商时产生与上面第1步相反的分录。二、 子库存转移:只有转出转载 2013-02-02 16:02:22 · 2779 阅读 · 0 评论 -
The script which used to Check GL-PO-AP-INV Period Status
--需要输入set_of_books_id,set_of_books_id可以从GL_SETS_OF_BOOKS查,Demo环境中的Vision Operations (USA)的set_of_books_id是1 SELECT a.period_name, a.period_num, a.gl_status, b.po_原创 2013-02-05 11:47:18 · 4397 阅读 · 0 评论 -
How to generate an GL debug log file
Detail Log for GL programsUsed for concurrent request problems where we need to know what sql was used in key areas or we need to retain temporary tables. Note: Be aware that temp tables are never dr原创 2013-05-13 16:41:45 · 4119 阅读 · 0 评论 -
Add accounting periods to your calendar
开库存期间,但期间的里最新的期间离现在都有段时间了,并且库存期间内无法新增期间。解决方法:需要给Accounting Calendar中增加期间,然后才能在库存期间里开启新增的期间。首先找到你的Accounting Calender的名字,GL > Setup > Ledger Sets(11i里这个叫SOB,Set of books,在12R下面, SOB 已经由一个新的名词 ledger 所取原创 2013-05-30 19:26:35 · 2806 阅读 · 0 评论