赛捷软件论坛's Archiver

erina.pan 发表于 2018-4-17 13:13

供应商未结清金额不对

未结清金额(Outstanding Balance)在数据库中保存在供应商表里,如果要修改,要用如下语句: UPDATE APVEN SET AMTBALDUEH=2000 WHERE VENDORID='1200'
UPDATE APVEN SET AMTBALDUET=3000 WHERE VENDORID='1200' 注: AMTBALDUEH:Vendor Balance Due (Functional) AMTBALDUET:Vendor Balance Due (Source) 如果交易(Transaction)里的明细不对,要改APOBL表。

页: [1]

Powered by Discuz! Archiver 7.2  © 2001-2009 Comsenz Inc.