付款单新增引用应付单生成付款单单据，选不到已审批的应付单

付款单节点，新增时，选择应付单，在弹出查询框中输入对应的查询条件，查询不到已审批的应付单。比如应付单D12024121600007838


查询sql为：

select ( ap_payableitem.pk_payableitem ) from ap_payableitem where pausetransact = N'N' and money_bal != 0 and occupationmny != 0 and pk_payablebill in ( select distinct ( ap_payablebill.pk_payablebill ) from ap_payablebill ap_payablebill where ( ap_payablebill.pk_org = N'0001A110000000007LCZ' AND ( ap_payablebill.billdate >= N'2024-01-01 00:00:00' and ap_payablebill.billdate <= N'2024-12-23 23:59:59' ) ) and ap_payablebill.dr = 0 and ap_payablebill.effectstatus = 10 and ap_payablebill.pk_group = N'0001A11000000000037X' and ( isnull ( ap_payablebill.noinvoice , N'Y' ) = N'Y' or ap_payablebill.linkmoney > 0 ) and exists ( SELECT 1 FROM ap_payableitem WHERE pk_payablebill = ap_payablebill.pk_payablebill ) )

根据sql分析，即条件逐个去掉排查，发现是money_bal != 0 and occupationmny != 0导致，如下图。

查询数据字典，得只两字段的含义：

回看应付单，发现应付单的(money_cr)原币金额没填写，也就是含税金额(发票总额).