创建成批增加不能导入ap发票的资产！（固定资产 fa）

纵横四海

AP和FA的设置都没有问题，但是就是导入不成功。
我查了metalink，和如下的情况类似：

fact: Oracle Payables 11.5
fact: FAMCR - Mass Additions Create
symptom: Asset Invoice Line Distributions is Imported thru Mass Addition
Process
Unable to find the Invoice in mass Addition Report
symptom: Asset_additions_flag = 'N' which means Rejected
cause: The output of Query stated that asset_additions_flag = 'N' which
means Rejected
This need to be changed to 'U' for successful transfer of Invoice line to Assets



fix:

Fix
----

Following are the conditions for ASSET Invoice Line Distributions to be
Imported:

a) The line is charged to an account set up as an Asset account.
b) The account is set up for an existing Asset Category as either the Asset
   Clearing Account or the CIP Clearing Account.
c) The Track as Asset check box is checked. (It is automatically checked
   if the account is an Asset account).
d) The invoice is approved.
e) The invoice line distribution is posted to Oracle General Ledger from
   Payables.
f) The General Ledger date on the invoice line distribution is on or before
   the date you specify for the FAMACR program.

To be picked up for Mass Additions, the following settings are required against
the line in the ap_invoice_distributions_all table:

    assets_tracking_flag = 'Y'
    asset_additions_flag = 'U'    (U = Untested, Y = Accepted, N = Rejected)
    posted_flag = 'Y'
    accounting_date = ? (must be <= to the date entered when running
                         the FAMACR process)

Run the following SQL Script for the problem Invoice, which will provide the
information about the status of Invoice line, if eligible for transfer and
further transfered to Assets

SQL> select assets_addition_flag, assets_tracking_flag, posted_flag
           from ap_invoice_distributions_all where
           invoice_id = <<invoice ID>>;

If a line is Rejected in the Mass Addition process, the status of column
asset_additions_flag will be 'N' and that need to be changed to 'U'.

For datafix, please log a TAR in Oracle support

1. Select apid.accounting_date,
   
2. apid.assets_tracking_flag,
   
3. apid.assets_addition_flag,
   
4. apid.posted_flag,
   
5. apid.set_of_books_id,
   
6. glcc.chart_of_accounts_id,
   
7. glcc.account_type,
   
8. apid.invoice_id
   
9. from ap_invoice_distributions_all apid, gl_code_combinations glcc
   
10. where invoice_id = 63354
    
11. and glcc.code_combination_id = apid.dist_code_combination_id

复制代码

纵横四海

问题检查出来了，asset clearing和cip clearing的科目设置有错误，该科目应该和ＡＰ导入的借方科目保持一致。

jessie

应该都是固定资产中转的科目吧？？？在做发票的时候，分配行里面应该选的是固定资产中转吧

纵横四海

原帖由 jessie 于 2007-10-14 20:44 发表
应该都是固定资产中转的科目吧？？？在做发票的时候，分配行里面应该选的是固定资产中转吧

科目的名字无所谓了，只要保证：
资产类别设置界面中asset clearing和cip clearing的科目设置＝ＡＰ导入的借方科目（发票分配行的科目）
就可以导入固定资产。
oracle官方文档把这样的科目取名为：固定资产清理科目（asset clearing）。

huxf66818

学习了 ，，

houwanglong

学习中……谢了

huangxiaopeng8

绝对实用的贴子

erp263860195

好东西，我再检查一下，看看我这边是不是也是这样的问题