做日终处理时，出现Return posting后，显示processing Day End Entry 3620, 1..
【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=''*/
页:
[1]