关于生产退税计算的系统修改记录
1)商品明细
此界面中增加user_scbacktaxrate:生产退增值税率用于记录生产退税率,清空贸易退税率(也就是原有退税率字段)
2)合同商品明细增加user_scbacktaxrate:生产退增值税率,user_scbacktax:生产退增值税额
3)合同明细TAC
proc dataSetFieldPosting()
if (event.col == event.dataSet.columnAt("cgcode"))
user_scbacktaxrate=sqlSelect1("select user_scbacktaxrate from cgcode where cgcode='"+event.value+"'")
event.dataSet.setValue("user_scbacktaxrate",user_scbacktaxrate)
end if
end proc
proc dataSetFieldPosted()
dataSetm = getDataSetForDTID(121550100)
dataSetg = getDataSetForDTID(121550101)
cgcode=dataSetg.getValue("cgcode")
user_scbacktaxrate = sqlSelect1("select user_scbacktaxrate from cgcode where cgcode='"+cgcode+"'")
if (event.col == event.dataSet.columnAt("upric_p"))
customrmb =dataSetg.getValue("customrmb")
user_scbacktax=customrmb*user_scbacktaxrate
event.dataSet.setValue("user_scbacktax",user_scbacktax)
elif (event.col == event.dataSet.columnAt("qtp"))
customrmb =dataSetg.getValue("customrmb")
user_scbacktax=customrmb*user_scbacktaxrate
event.dataSet.setValue("user_scbacktax",user_scbacktax)
elif (event.col == event.dataSet.columnAt("customupric"))
customrmb =dataSetg.getValue("customrmb")
user_scbacktax=customrmb*user_scbacktaxrate
event.dataSet.setValue("user_scbacktax",user_scbacktax)
end if
end proc
4)成本模型
os20的0150出口退税修改为TBLD(gTable,user_scbacktax)
郭姐写的针对现在系统中出口合同中退税额是国内采购不含税价乘退税率算出来的,这个是改为销售价乘退税算出来的,
贸易企业是采购不含税价*退税率
生产企业 = 销售价*退税率