委外接收单税率输入错误,在数据库后台进行修改
–字段说明
/*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