K3后台修改销售模块（销售订单、发货通知单、销售出库单）单价及金额语句

来源：互联网发布：苹果智能拨号软件编辑：程序博客网时间：2024/04/28 15:25
------如下语句为更改销售出库数据---------------------------------------------------------------------------------------------------------------select * from icstockbill where Fbillno='xout010589'--首先通过销售出库单找到单据内码select * from ICStockBillEntry where finterid='137777'--然后通过内码找单据体数据update ICStockBillEntry set fconsignprice='2508' where finterid=92679 and FENTRYID=1--修改单价update ICStockBillEntry set fconsignamount='2508' where finterid=92679 and FENTRYID=1--修改金额------如下语句为更改发货通知单数据-------------------------------------------------------------------------------------------select * from SEOutStockEntry where forderbillno='SEORD170116002'--首先通过销售订单号码找到分录数据,查看对应修改数据的单据内码和行数据编码update SEOutStockEntry set fprice='313' where finterid=14913 and FENTRYID=1update SEOutStockEntry set fauxprice='313' where finterid=14913 and FENTRYID=1--修改单价update SEOutStockEntry set famount='3130' where finterid=14913 and FENTRYID=1update SEOutStockEntry set fstdamount='3130' where finterid=14913 and FENTRYID=1--修改金额--------如下语句为更改销售订单数据----------------------------------------------------------------------------------------------select * from seorder where fbillno='SEORD170116002'--查找销售订单内码select * from SEOrderEntry where finterid='16053'--通过销售订单内码查找行数据update SEOrderEntry set fallamount='3130' where fINTERId=16053 AND FENTRYID=1update SEOrderEntry set fallstdamount='3130' where fINTERId=16053 AND FENTRYID=1--修改含税总金额update SEOrderEntry set fauxpricediscount='313' where fINTERId=16053 AND FENTRYID=1update SEOrderEntry set fpricediscount='313' where fINTERId=16053 AND FENTRYID=1update SEOrderEntry set fauxtaxprice='313' where fINTERId=16053 AND FENTRYID=1update SEOrderEntry set ftaxprice='313' where fINTERId=16053 AND FENTRYID=1--修改含税单价update SEOrderEntry set fprice='313' where fINTERId=16053 AND FENTRYID=1update SEOrderEntry set fauxprice='313' where fINTERId=16053 AND FENTRYID=1--修改不含税单价，需要手工计算一下update SEOrderEntry set famount='3130' where fINTERId=16053 AND FENTRYID=1--修改不含税总金额，需要手工计算一下update SEOrderEntry set ftaxamt='0' where fINTERId=16053 AND FENTRYID=1--修改税额，需要手工计算一下
阅读全文
0 0