2014-02-12 00:01:47
2013年结以后,进入2014打开供应商存货价格表,进入过滤界面,点击过滤,
提示btaxpricemain无效,通过事件跟踪,select (id) as id,(itemId) as itemId,(cvencode)
as cvencode,(cvenabbname) as cvenabbname,(cinvcode) as cinvcode,(cinvname) as cinvname,
(cinvstd) as cinvstd,(cComunitCode) as ccomunitcode,(ccomunitname) as ccomunitname,
(dEnableDate) as dEnableDate,(dDisableDate) as dDisableDate,(cExch_Name) as cExch_Name,
(bPromotion) as bPromotion,(cMemo) as cMemo,(iLowerLimit) as iLowerLimit,(iUpperLimit) as
iUpperLimit,(iUnitPrice) as iUnitPrice,(iTaxRate) as iTaxRate,(iTaxUnitPrice) as iTaxUnitPrice,
(cinvaddcode) as cinvaddcode,bTaxpriceMain from pu_veninvpricelist where cVenCode>='010008'
and cVenAbbName>='京华铭扬五金公司' and cInvCode>='30704001' and cInvName>='耐火土'
and dEnableDate>='2011-06-27' and dDisableDate>='2011-07-27' and cExch_Name ='人民币' and
bPromotion ='是',但是在视图pu_veninvpricelist没有btaxpricemain,请问如何处理?
,pu_veninvpricelist视图索引到pu_veninvpricerule视图,后张视图调用数据表Ven_Inv_Price_Rule,
此表中有btaxpricemain字段,建议您新建一新账套,对比列名,若问题账套无此字段进行追加即可,操作之前请
做好备份,