无法按销售类型查询-用友U8

对应版本:用友U8.61对应产品线：供应链对应模块：销售管理模块问题现象:在销售明细表中无法按销售类型查询，使得无法查清同一部门在不同类型下的销售情况。问题原因：因为销售明细表是自定义报表，可以在SQL语句中修改。解决方案：在SQL语句中修改：在销售明细表中，可以点数据按钮，点SQL语句，在SELECT后面加入：cstcodeas销售类型,全部的SQL语句如下：SELECTcstcodeas销售类型,Customer.cCusNameAS客户名称,Department.cDepNameAS部门名称,Person.cPersonNameAS业务员,SaleBillVouch.dDateAS日期,SaleBillVouch.cSBVCodeAS发票号,Warehouse.cWhNameAS仓库名称,Inventory.cInvNameAS存货名称,Inventory.cInvStdAS规格型号,SaleBillVouchs.iQuantityAS数量,SaleBillVouchs.iNatTaxAS本币税额,SaleBillVouchs.iNatMoneyAS本币无税金额,SaleBillVouchs.iNatSumAS本币价税合计,SaleBillVouchs.iNatDisCountAS本币折扣额,convert(nvarchar(24),Salebillvouch.sbvid)assbvid,v_aa_enum.enumNameas单据类别FROMSaleBillVouchLEFTJOINPersonONSaleBillVouch.cPersonCode=Person.cPersonCodeLEFTJOINDepartmentONSaleBillVouch.cDepCode=Department.cDepCodeLEFTJOINCustomerONSaleBillVouch.cCusCode=Customer.cCusCodeINNERJOINSaleBillVouchsONSaleBillVouch.SBVID=SaleBillVouchs.SBVIDLEFTJOINInventoryONSaleBillVouchs.cInvCode=Inventory.cInvcodeleftjoinWareHouseonSaleBillVouchs.cWhcode=WareHouse.cWhcodeINNERJOINv_aa_enumONv_aa_enum.enumtype=’SA.cVouchType’andSalebillvouch.cVouchType=v_aa_enum.enumcodewheresalebillvouch.ddate>=(selectisnull(cValue,’1900-01-01’)fromaccinformationwherecSysid=’Sa’andcName=’dStartDate’)andSalebillvouch.bfirst=0andrtrim(isnull(Salebillvouch.cInvalider,’’))=’’然后再次进入查询，点格式按钮，在视图中下的设置报表条件中，把销售类型加入过滤条件项中，设置时选择字符串和U8参照窗体，在参照窗体中选销售类型。

本文链接：https://www.bbsufida.com/u8/44727.html