委外接收单税率输入错误后金蝶软件数据库修改方法
添加时间:2022-6-2
委外接收单税率输入错误,在数据库后台进行修改
--字段说明
/*FTaxRate --税率
FTaxOfRate --税率
FTaxAmount -- 税额
FUNHookAmount --不含税金额
FAmountIncludeTax --含税金额
FInterID --单据内码*/
--先查询出来对应单据的单据内码
SELECT FInterID,* FROM ICShop_SubcIn where FBillNo='单据编号'
--依据单据内码查询需要修改税率、税额等字段
SELECT FTaxRate,FTaxOfRate,FTaxAmount,FUNHookAmount,FAmountIncludeTax,FAmount
FROM ICShop_SubcInEntry
WHERE FInterID=1883
--更新委外接收单税率与含税金额
UPDATE ICShop_SubcInEntry
SET FTaxRate='13.0000000000',
FTaxOfRate='13.0000000000',
FTaxAmount='44.2000000000',
FAmountIncludeTax='384.2000000000'
WHERE FInterID=1883