12
返回列表 发新帖
楼主: jason1688

[精华] 现金模块“结清事务处理”无法创建科目

[复制链接]
论坛徽章:
7
祖国60周年纪念徽章
日期:2009-10-09 08:28:00参与WIN7挑战赛纪念
日期:2009-11-06 14:50:072010新春纪念徽章
日期:2010-01-04 08:33:082010新春纪念徽章
日期:2010-03-01 11:19:59ITPUB9周年纪念徽章
日期:2010-10-08 09:28:532011新春纪念徽章
日期:2011-02-18 11:42:48咸鸭蛋
日期:2012-03-12 13:54:58
11#
发表于 2009-10-29 19:52 | 只看该作者
METALINK 如是說:早看到就好了,希望后來者慎重
11i Changes in the Architecture Design

The accounting tables ap_accounting_events_all, ap_ae_headers_all and ap_ae_lines_all
were created along with the concurrent process Payables Create Accounting.  This allows
the accounting to be created in AP and transferred to the GL as a whole package.

11i Pre FIN_D

Base Tables for Invoice
Ap_invoices_all
Ap_invoice_distributions_all

Base Tables for Payments
Ap_checks_all
Ap_invoice_payments_all

A new column ap_accounting_events_all has been added to ap_invoice_distributions_all
and ap_invoice_payments_all.

Once the Payables Create Accounting Process is run the posted_flag in
ap_invoice_distributions_all or ap_invoice_payments_all gets set to Y.  

The information creates in -  
Ap_accounting_events_all
Ap_ae_headers_all
Ap_ae_lines_all
The accounting_event_id created is populated in the cooresponding base table
ap_invoice_distributions_all or ap_invoice_payments_all.

FIN_D and later
The accounting process was changed.
At the time of invoice approval and payment confirmation a line in
ap_accounting_events_all gets populated with an event_status of CREATED.  
The cooresponding accounting_event_id gets populated and the posted_flag remains N
in the base table of ap_invoice_distributions or ap_invoice_payments_all.  
Run the concurrent process Payables Create Accounting, the posted_flag switches
to Y and the event status in ap_accounting_events_all table changes to ACCCOUNTED
or ACCOUNTED WITH ERROR.  Then the ap_ae_headers_all and ap_ae_lines_all get created.

When the data gets transferred to the GL the transfer_flag = Y and the transfer_run_id
gets populated in ap_ae_headers_all.  The detail data in ap_ae_lines_all gets tranferred
to the GL and the gl_sl_link_id in ap_ae_lines_all gets populated.

The Trial Balance prior to AP.I –
Each time the Trail Balance Report runs it uses the data in ap_ae_lines_all and
populates the temp table of ap_trial_bal.

使用道具 举报

回复

您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

TOP技术积分榜 社区积分榜 徽章 团队 统计 知识索引树 积分竞拍 文本模式 帮助
  ITPUB首页 | ITPUB论坛 | 数据库技术 | 企业信息化 | 开发技术 | 微软技术 | 软件工程与项目管理 | IBM技术园地 | 行业纵向讨论 | IT招聘 | IT文档
  ChinaUnix | ChinaUnix博客 | ChinaUnix论坛
CopyRight 1999-2011 itpub.net All Right Reserved. 北京盛拓优讯信息技术有限公司版权所有 联系我们 未成年人举报专区 
京ICP备16024965号-8  北京市公安局海淀分局网监中心备案编号:11010802021510 广播电视节目制作经营许可证:编号(京)字第1149号
  
快速回复 返回顶部 返回列表