3208 销售发票传票 不含税金额为空

原因：1079 的合计不含税金额 程序未回写成功，是个空值。知道3208为空

解决：更新总单合计不含税金额，为细单的合计值

UPDATE bms_sa_settle_doc SET zx_infoamount ='1036.7' WHERE   sasettleid ='19189961';

批量刷新，已经开票，但是 这段为空的 zx_infoamount 为空的

update bms_sa_settle_doc
   set zx_infoamount   =
       (select sum(nvl(notaxmoney, 0))
          from bms_sa_settle_dtl
         where sasettleid = :sasettleid),
       zx_infotaxamount =
       (select sum(nvl(taxmoney, 0))
          from bms_sa_settle_dtl
         where sasettleid = :sasettleid)
 where sasettleid = :sasettleid

查询条件

SELECT  A.SASETTLEID FROM bms_sa_settle_doc_v A WHERE 1=1
and usestatus = 1 
and zx_infoamount is null 
and a.invno is not null
and a.total <> 0
and a.entryid= 96 
AND A.credate  >= TO_DATE('2025-7-1', 'yyyy-mm-dd hh24:mi:ss')
AND A.credate  <= TO_DATE('2025-7-31', 'yyyy-mm-dd hh24:mi:ss')