关闭不了应付会计期,请大侠指教一下！

yegiant

1 --根据是否传送总帐的标志，检查发票付款会计分录
select DISTINCT bb.accounting_date,aa.reference5 发票编号,aa.reference1 供应商,aa.reference6,
gcc.concatenated_segments,aa.accounted_dr,aa.accounted_cr
from  AP_AE_LINES_ALL aa,
      AP_AE_HEADERS_ALL bb,
      GL_CODE_COMBINATIONS_KFV gcc
WHERE BB.PERIOD_NAME <= '2004-02'
      AND BB.GL_TRANSFER_FLAG != 'Y'  
      AND BB.org_id=81
      AND aa.AE_HEADER_ID=BB.AE_HEADER_ID
      AND gcc.code_combination_id=aa.code_combination_id
order by bb.accounting_date
2:一般是分录产生混乱,需要修改,比如改帐户,改金额,多余分录删除;然后传送总帐

amwlq

我提供我们的遇到的问题及解决过程　：
我们发生两次这种情况，我自己查发现：
at table AP_AE_HEADER_ALL have some line's field "GL_TRANSFER_FLAG" is set to 'N'.
并运行ORACLE提供的：APClosing115.sql
The following error can be found on the output file:

ERROR - This Org_Id has 22 untransferred Journals for this SOB. All Journal Entries must be transferred before this period can be closed.

When I check the records listed I can see that they are not related to any invoice or check. So it seems to me that they are orphan records that need to be deleted before the period can be closed.

后来ORACLE方面提供了两个脚本：
) Run the scrip orphans_report.sql and upload the file created
2) Run the script undo_orphans_with_backup.sql with rollback at first and upload the file created
3) I will check the results and tell if the undo_orphans_with_backup.sql can be run with commit

之后就解决了。所以建立你还是建个TAR

hotwish

我們沒有遇見如此情形﹐只是有遇到因為deptment code inactive二引起的不能關閉期間的問題