accpac 54 AECOM No entry created from AP post

stone

【Q】accpac 54 AECOM No entry created from AP post
【A】数据库损坏造成多个孤项记录，解决方法是运行下面的查询（在sql management studio或sdk的accpac sql scope中皆可）:
DELETE FROM APPJD WHERE NOT EXISTS (SELECT * FROM APPJH H WHERE H.TYPEBTCH=APPJD.TYPEBTCH AND H.POSTSEQNCE=APPJD.POSTSEQNCE AND H.CNTBTCH=APPJD.CNTBTCH AND H.CNTITEM=APPJD.CNTITEM)