做日终处理时，出现Return posting后，显示processing Day End Entry 3620, 1..

stone

【Q】做日终处理时，出现Return posting后，显示processing Day End Entry 3620, 1..
接下来是
Internal error. reading posted header 1550 POINVZ1.C.
Day End processing could not process all transactions.
【A】公司数据库里有表POINVI（字段INVISEQ为序列号）和PORCPI（字段RCPISEQ为序列号），分别为日终处理保存PO发票和PO收货单的临时记录，日终处理完一行交易，这些表里的记录就删除一行。它们是根据序列号是统一排序的。所以，打开POINVI和PORCPI，比较INVISEQ和PORCPI值的大小，可知日终处理卡在较小的交易行里。

以下是操作公司数据库的SQL语句
1、找出要删除的单
比序列号大小，挑出较小的
SELECT * FROM POINVI        得出INVISEQ=337236
SELECT * FROM PORCPI        得出RCPISEQ=337261
通过比较可知POINVI值较小，日终处理卡在发票。

2、删除PO的发票
2.1 通过 SELECT INVNUMBER FROM POINVH1 WHERE INVHSEQ='337236' 找出有问题的发票的凭证号，根据其在PO/Invoice里找出，截图给客户，方便客户在AP模块里手工补入（日终处理无法将其从PO流转到AP）。
2.2 找出发票对应的INVHSEQ值。SELECT INVHSEQ FROM POINVI WHERE INVISEQ='337236'，得出INVHSEQ=22175715
2.3 以下是根据INVHSEQ的值将关于此发票的日终处理信息删除
DELETE FROM POINVH1 WHERE INVHSEQ='22175715'
DELETE FROM POINVH2 WHERE INVHSEQ='22175715'
DELETE FROM POINVL WHERE INVHSEQ='22175715'
DELETE FROM POINVHO WHERE INVHSEQ='22175715'
DELETE FROM POINVM WHERE INVHSEQ='22175715'
DELETE FROM POINVP WHERE INVHSEQ='22175715'
DELETE FROM POINVR WHERE INVHSEQ='22175715'
DELETE FROM POINVI WHERE INVHSEQ='22175715'
DELETE FROM POINVC WHERE INVHSEQ='22175715'

3、删除收货单
如果要删除收货单，就方便了，根据RCPISEQ的值就可以找到收货单号
已经知道RCPISEQ=337261
3.1 求RCPHSEQ的值
SELECT RCHPSEQ FROM PORCPI WHERE RCPISEQ=337261 得出 RCPHSEQ=336819
3.2 求收货单号RCPNUMBER，把它交给财务人员处理，在总帐检查是否要手工补入（日终处理可能过不去）。
SELECT RCPNUMBER FROM PORCPH1 WHERE RCPHSEQ='336819'
3.3 删除有关此收货单的日终处理信息
DELETE FROM PORCPI WHERE RCPISEQ='337261'
DELETE FROM PORCPM WHERE RCPISEQ='337261'

--------------------------------------------------------

--SELECT * FROM POINVI WHERE INVISEQ='337236'
--SELECT * FROM PORCPI WHERE RCPISEQ='337261'

--SELECT * FROM PORCPH1 WHERE RCPHSEQ='336819'
--SELECT * FROM PORCPM WHERE RCPHSEQ='336819'
--SELECT COUNT(*) FROM POINVI

--SELECT INVNUMBER FROM POINVH1 WHERE INVHSEQ='22175715'

DELETE FROM POINVH1 WHERE INVHSEQ='22175715'
DELETE FROM POINVH2 WHERE INVHSEQ='22175715'
DELETE FROM POINVL WHERE INVHSEQ='22175715'
DELETE FROM POINVHO WHERE INVHSEQ='22175715'
DELETE FROM POINVM WHERE INVHSEQ='22175715'
DELETE FROM POINVP WHERE INVHSEQ='22175715'
DELETE FROM POINVR WHERE INVHSEQ='22175715'
DELETE FROM POINVI WHERE INVHSEQ='22175715'
DELETE FROM POINVC WHERE INVHSEQ='22175715'

--DELETE FROM PORCPI WHERE RCPISEQ='336819'
--DELETE FROM PORCPM WHERE RCPISEQ=''*/