------如下语句为更改销售出库数据---------------------------------------------------------------------------------------------------------------
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=1
update SEOutStockEntry set fauxprice='313' where finterid=14913 and FENTRYID=1
--修改单价
update SEOutStockEntry set famount='3130' where finterid=14913 and FENTRYID=1
update 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=1
update SEOrderEntry set fallstdamount='3130' where fINTERId=16053 AND FENTRYID=1
--修改含税总金额
update SEOrderEntry set fauxpricediscount='313' where fINTERId=16053 AND FENTRYID=1
update SEOrderEntry set fpricediscount='313' where fINTERId=16053 AND FENTRYID=1
update SEOrderEntry set fauxtaxprice='313' where fINTERId=16053 AND FENTRYID=1
update SEOrderEntry set ftaxprice='313' where fINTERId=16053 AND FENTRYID=1
--修改含税单价
update SEOrderEntry set fprice='313' where fINTERId=16053 AND FENTRYID=1
update 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
--修改税额,需要手工计算一下
K3后台修改销售模块(销售订单、发货通知单、销售出库单)单价及金额语句
最新推荐文章于 2021-06-25 14:54:00 发布