k3bills下标越界_k3提示下标越界

k3bills下标越界_k3提示下标越界 _k3提示下标越界

       今天，我将与大家共同探讨k3bills下标越界的今日更新，希望我的介绍能为有需要的朋友提供一些参考和建议。

1.k3bills?±????

2.金蝶ERP错误代码:18000

k3bills?±????

       今天我也遇到此类问题。现在与大家分享吧！

        销售出库单中有一笔分录没有订单（有下级单据也能删除有点奇怪）。发货通知里面FAuxPrice字段为空值，自然销售出库也为空值。到了做销售发票FAuxPrice字段为空值就会跳出错误提示。

       请把"此处输入销售出库单号"替换成你的销售出库单号。

       如下代码可以找出销售出库单有异常的数据行，有了Fsourcebillno,Fsorderbillno就去前台找吧

declare?@xout?varchar(50)

       set?@xout=(select?finterid?from?icstockbill?where?FBillNo='此处输入销售出库单号')

       SELECT?v1.FSupplyID?AS?FAddress,t1.FAddress?AS?FAddress1,t1.FAddress?AS?FAddress2,u2.FAmount*((CASE?WHEN?tnew1.FValue?<>?'1'THEN?u2.FTaxRate?ELSE?0?END?)/100)?AS?FAmtDiscount,

        u2.FTaxPrice*t7.FCoefficient?AS?FAuxOrderPrice,(CASE?WHEN?tnew1.FValue?<>?'1'?THEN?(CASE?WHEN?(IsNull(u2.FEntryID,0)>0?AND?t17.FValue<>'1')?THEN?IsNull(u2.FAuxPrice,0)?WHEN?IsNull(u2.FEntryID,0)=0?THEN?u1.FConsignPrice?ELSE?0?END)?ELSE?u1.FConsignPrice?END)?AS?FAuxPrice,

        t4.FUnitGroupID?as?FItemUnitGroupID,sign(t4.FAuxClassID)-sign(u1.fauxpropid)?AS?FAuxPropCls,

        u1.FAuxPropID,t105.FName?AS?FAuxPropName,t105.FNumber?AS?FAuxPropNum,Case?When?(u1.FAuxQty-u1.FAuxQtyInvoice)*sign(v1.FROB)>0?Then?(u1.FAuxQty-u1.FAuxQtyInvoice)?Else?0?End?AS?FAuxQty,

        (CASE?WHEN?tnew1.FValue?<>?'1'?THEN?(CASE?WHEN?IsNull(u2.FEntryID,0)>0?THEN?CAST(u2.FAuxTaxPrice?AS?FLOAT)/CAST(t257.FCoefficient?AS?FLOAT)*CAST(t7.FCoefficient?AS?FLOAT)?WHEN?t17.FValue='1'?THEN?u1.FConsignPrice?ELSE?0?END)?ELSE(CASE?WHEN?T17.FVALUE=1?THEN?u1.FConsignPrice?ELSE?0?END)?END)?AS?FAuxTaxPrice,

        v1.FSupplyID?AS?FBank,t1.FBank?AS?FBank1,t1.FBank?AS?FBank2,t10.FName?AS?FBaseUnitName,

        u1.FBatchNo,v1.FBillNO,t7.FCoefficient,u1.FContractBillNo,u1.FContractEntryID,u1.FContractInterID,

        CASE?WHEN?tnew1.FValue?<>?'1'?THEN?(case?when?u1.forderinterid>0?then?v2.FCurrencyID?else?1?end)?ELSE?(CASE?WHEN?t1.FCyID<>0?THEN?t1.FCyID?ELSE?1?END)?END?AS?FCurrencyID,

        CASE?WHEN?tnew1.FValue?<>?'1'?THEN?(case?when?u1.forderinterid>0?then?t14.fname?else?(select?fname?from?t_Currency?where?fcurrencyid=1)?end)?ELSE?(CASE?WHEN?t1.FCyID<>0?THEN?(select?fname?from?t_currency?where?fcurrencyid=t1.fcyid)?ELSE?(select?fname?from?t_Currency?where?fcurrencyid=1)?end)END?AS?FCurrencyName,

        CASE?WHEN?tnew1.FValue?<>?'1'?THEN?(case?when?u1.forderinterid>0?then?t14.fnumber?else?(select?fnumber?from?t_Currency?where?fcurrencyid=1)?end)?ELSE?(CASE?WHEN?t1.FCyID<>0?THEN?(select?fnumber?from?t_currency?where?fcurrencyid=t1.fcyid)?else?(select?fnumber?from?t_Currency?where?fcurrencyid=1)?end)END?AS?FCurrencyNumber,

        v1.FSupplyID?AS?FCustID,t1.FName?AS?FCustName,t1.FNumber?AS?FCustNumber,v1.FDeptID,

        t2.FName?AS?FDeptIDName,t2.FNumber?AS?FDeptIDNumber,(CASE?WHEN?tnew1.FValue?<>?'1'?AND?ISNULL(u1.FOrderInterID,0)?>0?THEN?(CASE?WHEN?u2.FTaxRate?<>?0?THEN?u2.FTaxRate?WHEN?u2.FAuxTaxPrice?*?u2.FUniDiscount?>?0?THEN?(CASE?WHEN?tnew4.FValue?=?'1'?THEN?CONVERT(DECIMAL(28,?16),?u2.FUniDiscount?*?100?/?u2.FAuxTaxPrice)?ELSE?CONVERT(DECIMAL(28,?16),?u2.FUniDiscount?*?100?/?u2.FAuxPrice)?END)?ELSE?0?END)?ELSE?u1.FDiscountRate?END)?AS?FDiscountRate,

        v1.FEmpID,t3Emp.FName?AS?FEmpIDName,t3Emp.FNumber?AS?FEmpIDNumber,u1.FEntryID,CASE?WHEN?tnew1.FValue?<>?'1'?THEN?(case?when?u1.forderinterid>0?then?v2.fexchangerate?else?1?end)?ELSE?1?END?AS?FExchangeRate,

        (CASE?WHEN?u1.FOrderInterID<0?or?u1.FOrderInterID>0?THEN?ISNULL((v2.FExchangeRateType),0)ELSE?(CASE?WHENu1.FSourceTranType?IN?(82,83)?THEN?ISNULL((SELECT?FExchangeRateType?FROM?SEOutStock?WHERE?FInterID=u1.FSourceInterId)?,0)?ELSE?0?END)END?)?AS?FExchangeRateType,

        (select?fname?from?v_base_exratetype?where?fid=(CASE?WHEN?u1.FOrderInterID<0?or?u1.FOrderInterID>0?THEN?ISNULL((v2.FExchangeRateType),0)ELSE?(CASE?WHENu1.FSourceTranType?IN?(82,83)?THEN?ISNULL((SELECT?FExchangeRateType?FROM?SEOutStock?WHERE?FInterID=u1.FSourceInterId)?,0)?ELSE?0?END)END?))?AS?FExchangeRateTypename,

        (select?fnumber?from?v_base_exratetype?where?fid=(CASE?WHEN?u1.FOrderInterID<0?or?u1.FOrderInterID>0?THEN?ISNULL((v2.FExchangeRateType),0)ELSE?(CASE?WHENu1.FSourceTranType?IN?(82,83)?THEN?ISNULL((SELECT?FExchangeRateType?FROM?SEOutStock?WHERE?FInterID=u1.FSourceInterId)?,0)?ELSE?0?END)END?))?AS?FExchangeRateTypenumber,

        v1.FExplanation,v1.FHeadSelfB0147?AS?FHeadSelfB01470,v1.FHeadSelfB0147?AS?FHeadSelfB01471,

        v1.FHeadSelfB0147?AS?FHeadSelfB01472,v1.FHeadSelfB0149?AS?FHeadSelfB01490,v1.FHeadSelfB0149?AS?FHeadSelfB01491,

        v1.FHeadSelfB0149?AS?FHeadSelfB01492,v1.FInterID,u1.FItemID,u1.FKFDate,u1.FKFPeriod,

        V1.FManagerID,t15_1.FName?AS?FManagerIDName,t15_1.FNumber?AS?FManagerIDNumber,u1.FMapName,

        u1.FMapNumber,t4.FName?AS?FMatName,t4.FNumberas?FMatNumber?,t4.Fmodel,u1.FMTONo,

        u1.FNote,u1.FOLOrderBillNo,u1.FOrderBillNo,u1.FOrderEntryID,u1.FOrderInterID,u2.FTaxPrice?AS?FOrderPrice,

        v1.FPayCondition,pay16.FName?AS?FPayConditionName,pay16.FNumber?AS?FPayConditionNumber,

        u1.FPlanMode,tPlanMode.FName?AS?FPlanModeName,tPlanMode.FID?AS?FPlanModeNumber,

        t4.FPriceDecimal,CASE?WHEN?(u1.FQty-u1.FQtyInvoice)*sign(v1.FROB)>0?THEN?(u1.FQty-u1.FQtyInvoice)?ELSE?0?END?AS?FQty,

        t4.FQtyDecimal,v1.FSaleStyle,t18.FName?AS?FSaleStyleName,t18.FID?AS?FSaleStyleNumber,

        (CASE?WHEN?ABS(u1.FSecQty)>ABS(u1.FSecInvoiceQty)?THEN?(u1.FQty-u1.FQtyInvoice)/(u1.FSecQty-u1.FSecInvoiceQty)?ELSE?0?END)?AS?FSecCoefficient,

        (CASE?WHEN?ABS(u1.FSecQty)>ABS(u1.FSecInvoiceQty)?THEN?u1.FSecQty-u1.FSecInvoiceQty?ELSE?0?END)?AS?FSecQty,

        t501.FName?AS?FSecUnitName,v1.FTranType?AS?FSelTranTypeID,(SELECT?FName?FROM?v_ICTransType?WHERE?FID=v1.FTranType)?AS?FSelTranTypeName,

        (SELECT?FName?FROM?v_ICTransType?WHERE?FID=v1.FTranType)?AS?FSelTranTypeNumber,

        u1.FSEOutBillNo,u1.FSEOutEntryID,u1.FSEOutInterID,v1.FSettleDate,v2.FSettleID,Case?When?v2.FSettleID=0?then?''?else?t8.FName?end?AS?FSettleIDName,

        Case?When?v2.FSettleID=0?then?''?else?t8.FNumber?end?AS?FSettleNumber,v1.FBillNo?AS?FSourceBillNo,

        u1.FEntryID?AS?FSourceEntryID,v1.FInterId?AS?FSourceInterID,v1.FTranType?AS?FSourceTranType,

        v1.FSupplyID?AS?FTaxNum,t1.FTaxNum?AS?FTaxNum1,t1.FTaxNum?AS?FTaxNum2,CASE?WHEN?tnew1.FValue?<>?'1'?THEN(CASE?WHEN?u1.forderinterid>0?AND?v2.FClassTypeID<>1007100?THEN?u2.FCess?WHEN?t13.FValue='1'?THEN?t4.FTaxRate?ELSE?t1.FValueAddRate?END)ELSE?(CASE?WHEN?t13.FValue='1'?THEN?t4.FTaxRate?ELSE?t1.FValueAddRate?END)?END?AS?FTaxRate,

        t4.FTrack,(CASE?WHEN?tnew1.FValue?<>?'1'?THEN?(CASE?WHEN?u2.FUniDiscount?<>?0?THEN?u2.FUniDiscount?WHEN?u2.FAuxTaxPrice?*?u2.FTaxRate?/100?>?0?THEN?CASE?WHEN?tnew4.FValue='1'?THEN?CONVERT(DECIMAL(28,?16),?u2.FAuxTaxPrice?*?u2.FTaxRate?/100)?ELSE?CONVERT(DECIMAL(28,?16),?u2.FAuxPrice?*?u2.FTaxRate?/100)?END?ELSE?0?END)?WHEN?u1.FDiscountAmount?<>?0?THEN?u1.FDiscountAmount/u1.FAuxQty?ELSE?0?END)?AS?FUniDiscount,

        u1.FUnitID,t7.FName?AS?FUnitName,t7.FNumber?AS?FUnitNumber,t1.FValueAddRate

       INTO?#TmpSelBills?FROM?ICStockBill?v1

        INNER?JOIN?ICStockBillEntry?u1?ONv1.FInterID=u1.FInterID

        LEFT?OUTER?JOIN?t_Organization?t1?ONv1.FSupplyID=t1.FItemID

        LEFT?OUTER?JOIN?t_SubMessage?t18?ONv1.FSaleStyle=t18.FInterID

        LEFT?JOIN?t_Emp?t15_1?ONv1.FManagerID=t15_1.FItemID

        LEFT?OUTER?JOIN?t_SystemProfile?t13?ONt13.FCategory='IC'?AND?t13.FKey='SaleTaxRateOption'

        LEFT?OUTER?JOIN?t_SystemProfile?t17?ONt17.FCategory='IC'?AND?t17.FKey='SEOrderTaxInPrice'

        LEFT?JOIN?t_Department?t2?ONv1.FDeptID?=?t2.FItemID

        LEFT?JOIN?t_Emp?t3emp?ONv1.FEmpID?=?t3emp.FItemID

        LEFT?OUTER?JOIN?t_SystemProfile?tnew1?ONtnew1.FCategory='IC'?AND?tnew1.FKey='SalesInvoicePrice'

        LEFT?OUTER?JOIN?t_SystemProfile?tnew4?ONtnew4.FCategory='IC'?AND?tnew4.FKey='DisCountIncludeTax'

        LEFT?OUTER?JOIN?t_PayColCondition?pay16?ONv1.FPayCondition=pay16.FID

        INNER?JOIN?t_ICItem?t4?ONu1.FItemID=t4.FItemID

        LEFT?OUTER?JOIN?t_MeasureUnit?t7?ONu1.FUnitID=t7.FItemID

        LEFT?JOIN?t_AuxItem?t105?ONu1.FAuxPropID=t105.FItemID

        LEFT?OUTER?JOIN?SEOrderEntry?u2?ONu1.FOrderInterID=u2.FInterID?AND?u1.FOrderEntryID=u2.FEntryID

        LEFT?OUTER?JOIN?t_SubMessage?tplanmode?ONu1.FPlanMode=tplanmode.FInterID

        LEFT?OUTER?JOIN?t_MeasureUnit?t10?ONt4.FUnitID=t10.FItemID

        LEFT?OUTER?JOIN?t_MeasureUnit?t501?ONt4.FSecUnitID=t501.FItemID

        LEFT?OUTER?JOIN?SEOrder?v2?ONu2.FInterID=v2.FInterID

        LEFT?OUTER?JOIN?t_MeasureUnit?t257?ONu2.FUnitID=t257.FItemID

        LEFT?OUTER?JOIN?t_Currency?t14?ONv2.FCurrencyID=t14.FCurrencyID

        LEFT?OUTER?JOIN?v_base_exratetype?texratetype?ONv2.FExchangeRateType=texratetype.FID

        LEFT?OUTER?JOIN?t_settle?t8?ONv2.FSettleID=t8.FItemID

       WHERE?((v1.FInterID=@xout?AND?u1.FEntryID?IN?(27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55)))

       ORDER?BY?v1.FInterID,?u1.FEntryID;?update?#TmpSelBills?set?FuniDisCount=Fauxprice*(FDiscountRate/100)?where?FuniDisCount=0;

       --销售出库单插入#tmpselbills表的数据

       select?*?from#tmpselbills?--查询刚刚插入临时表的数据

金蝶ERP错误代码:18000

这种情况意思是系统环境有问题或者摘要太长。

       系统环境有问题：客户端有问题，机器情况不好就会导致识别不出，出现下标越界。

       摘要太长：凭证字号对应的数据库表没有更新、凭证的日期超过软件允许的范围就会导致出现下标越界。

解决错误代码：18000(4650H)所描述的问题，造成应付无法结账，此语句中的期间和年份需根椐自己的需要填写。PT095164(去验证).rar客户端组件COMRemote.dll，k3bills.dl。

       金蝶erp是一套财务管理软件，是一个企业资源计划的统称，它包含了很多值得我们一生都在学习和研究的知识，它是管理信息化、系统化、智能化的象征。

       现在金蝶ERP是南方最流行的ERP管理系统，金蝶ERP面向不同的服务群体有不同类别的软件，主要有企业管理软件、协同管理软件、政府非盈利组织管理软件。

       好了，今天我们就此结束对“k3bills下标越界”的讲解。希望您已经对这个主题有了更深入的认识和理解。如果您有任何问题或需要进一步的信息，请随时告诉我，我将竭诚为您服务。