非典型性网瘾患者
金蝶K3即时库存成本计算逻辑是什么？
主要想弄明白2个问题：
K3即时库存成本取数逻辑是什么？
核算参数勾选计算即时成本；
只支持加权平均【76】、分批认定法(批内加权平均法)【20309】；
K3即时库存为什么不能按天查询？商贸版却可以。
文中的参考内容后续再做研究；
即时库存查询SQL语句分析
Set Nocount on;
Create Table #TempInventory(
[FBrNo] [varchar] (10)
NOT NULL ,
[FItemID] [int] NOT NULL ,
[FBatchNo] [varchar] (200)
NOT NULL ,
[FMTONo] [varchar] (200)
NOT NULL ,
[FSupplyID] [int] NOT NULL ,
[FStockID] [int] NOT NULL ,
[FQty] [decimal](28, 10) NOT NULL ,
[FBal] [decimal](20, 2) NOT NULL ,
[FStockPlaceID] [int] NULL ,
[FKFPeriod] [int] NOT NULL Default(0),
[FKFDate] [varchar] (255)
NOT NULL ,
[FMyKFDate] [varchar] (255),
[FStockTypeID] [Int] NOT NULL,
[FQtyLock] [decimal](28, 10) NOT NULL,
[FAuxPropID] [int] NOT NULL,
[FSecQty] [decimal](28, 10) NOT NULL,
[FHelpCode] [varchar](200) NOT NULL,
[FProperty] [int] NOT NULL Default(0),
[FChartNumber] [varchar](255) NOT NULL,
[FBatchNo2] [VarChar] (200) NOT NULL Default(''),
[FStockID2] [int]
NOT NULL Default(0)
Insert Into #TempInventory
u1.FItemID,
u1.FBatchNo,
u1.FMTONo,
u1.FSupplyID,
u1.FStockID,
u1.FStockPlaceID,
u1.FKFPeriod,
ISNULL(u1.FKFDate,''),
ISNULL(u1.FKFDate,''),
u1.FQtyLock,
u1.FAuxPropID,
u1.FSecQty,
s.FProperty ,
0 From ICInventory u1 left join t_stock s
on u1.FStockID=s.FItemID
where u1.FQty&&0 ;
Insert Into #TempInventory
Select u1.FBrNo,
u1.FItemID,
u1.FBatchNo,
u1.FMTONo,
u1.FSupplyID,
u1.FStockID,
u1.FStockPlaceID,
u1.FKFPeriod,
ISNULL(u1.FKFDate,''),
ISNULL(u1.FKFDate,''),
u1.FStockTypeID,
u1.FAuxPropID,
u1.FSecQty,
s.FProperty,
0 From POInventory u1 left join t_stock s
on u1.FStockID=s.FItemID
where u1.FQty&&0 ;
DECLARE @CalculateType AS INT
SELECT @CalculateType=FValue FROM t_SystemProfile
WHERE FCategory='IC' AND FKey='CalculateType';
UPDATE t1 SET
FBatchNo2=(SELECT CASE t2.FTrack WHEN 80 THEN t1.FBatchNo WHEN 20309 THEN t1.FBatchNo ELSE '' END ),
FStockID2=(SELECT CASE @CalculateType
WHEN 0 THEN 0 WHEN 1 THEN t1.FStockID ELSE t3.FGroupID END)
#TempInventory t1
INNER JOIN t_ICItem t2 ON t1.FItemID=t2.FItemID
INNER JOIN t_Stock
t3 ON t1.FStockID=t3.FItemID ;
Select distinct
t2.FProperty as FProperty,--良品、不良品
u1.FAuxPropID,
case when u1.FSecQty=0 then 0 else ROUND(u1.FQty/u1.FSecQty,t1.FQtyDecimal) end as FConvRate,
u1.FStockTypeID,
t1.FName as FMaterialName,
t1.FModel as FMaterialModel,
t19.FName as FSecUnitName,
t19.FNumber as FSecUnitNumber,
u1.FBatchNo,
u1.FMTONo,
u1.FSupplyID,
t_8.FName AS FSupplyName,
t_8.FNumber AS FSupplyNumber,
t2.FName as FStockName ,
u1.FQtyLock as FBUQtyLock,
u1.FQtyLock/t4.FCoefficient as FCUUQtyLock,
t5.FName as FSPName,
u1.FKFPeriod,
case when isdate(u1.FKFDate)=1 then Convert(datetime,u1.FKFDate) else null end as FKFDate,
case when isdate(u1.FMyKFDate)=1 then Convert(datetime,u1.FMyKFDate) else null end as FMyKFDate,
t3.FName as FBUUnitName,
t3.FNumber as FBUUnitNumber,
ROUND(u1.FQty,t1.FQtydecimal) as FBUQty,
t4.FName as FCUUnitName ,
ROUND(u1.FQty/t4.FCoefficient,
t1.FQtyDecimal) as FCUUQty,
t1.FQtyDecimal,
t1.FPriceDecimal,
0 as FSumSort,
Case when isdate(u1.FKFDate)=0 then NULL else Convert(datetime,u1.FKFDate) + u1.FKFPeriod END AS FMaturityDate,
t2.FNumber AS FStockNumber,
t2.FNumber AS FStockLongNumber ,
t1.FNumber AS FMaterialNumber,
t1.FNumber AS FLongNumber,
t5.FNumber as FSPNumber,
t4.FNumber as FCUUnitCode,
t4.FMeasureunitID as FCUUnitID,
t1.FitemID ,
T2.FitemID FStockID,
t2.FIncludeAccounting,
T5.FSPID FSPID,
t9.FName as FAuxPropName,
t9.FNumber as FAuxPropNumber,
ROUND(u1.FSecQty,t1.FQtyDecimal) AS FSecQty,
t1.FSecCoefficient AS FItemSecCoefficient,
t1.FHelpCode as FHelpCode,
t1.FChartNumber ,CASE WHEN
t2.FIncludeAccounting=1 THEN ISNULL(t20.FPrice,0) ELSE 0 END as FPrice,
CASE WHEN t2.FIncludeAccounting=1 THEN ISNULL(t20.FPrice * t4.FCoefficient,0) ELSE 0 END as FCUPrice,
CASE WHEN t2.FIncludeAccounting=1 THEN ISNULL(ROUND(t20.FPrice * u1.FQty,2),0) ELSE 0 END as FAmount
From #TempInventory u1
left join t_ICItem t1 on u1.FItemID = t1.FItemID
left join t_Stock t2 on u1.FStockID=t2.FItemID
left join t_Supplier t_8 on u1.FSupplyID=t_8.FItemID
left join t_MeasureUnit t3 on t1.FUnitID=t3.FMeasureUnitID
left join t_MeasureUnit t4 on t1.FStoreUnitID=t4.FMeasureUnitID
left join t_StockPlace t5 on u1.FStockPlaceID=t5.FSPID
left join t_AuxItem t9 on u1.FAuxPropID=t9.FItemID
left join t_Measureunit t19 on t1.FSecUnitID=t19.FMeasureunitID
left Join ICRealtimeCost t20 ON u1.FItemID=t20.FItemID AND u1.FBatchNo2=t20.FBatchNo AND u1.FStockID2=t20.FStockID
--ICRealtimeCost即时库存表的成本来源，但是这个表的来源是什么？；
--来源是p_CheckRealtimeCost，点击‘校对’会执行该存储过程，然后更新ICRealtimeCost表；详细过程及说明见本文&即时成本&部分。
Round(u1.FQty,t1.FQtyDecimal)&&0 OR Round(u1.FQty/t4.FCoefficient,t1.FQtyDecimal)&&0
and t1.FDeleted=0
AND t2.FItemID=1714
--select * from #TempInventory U1 left join T1 left join T2 left join .... where
--Round(数值,四舍五入到几位小数)；示例：select round(1.235,2)=1.24
Order By t1.FNumber,u1.FBatchNo,u1.FMTONo
Drop Table #TempInventory
校对即时成本SQL语句分析
EXEC p_CheckRealtimeC
-- 校对即时库存时执行该存储过程;
-- EXEC主要用来执行存储过程或动态SQL语句串
详细内容：
SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
ALTER PROCEDURE [dbo].[p_CheckRealtimeCost]
--***alter procedure as ...这句话的后半部分是哪里???
--'下面是官方注释：
--BT779284
--BT780524
--经过多次的确认，只支持加权平均【76】、分批认定法(批内加权平均法)【20309】
--其他的一概不支持，如果还要支持直接找李老师'
--商贸版为什么可以支持所有的计价方法?
SET NOCOUNT ON
--这个看懂了，不返回详细的消息信息
DECLARE @CurYear
--当前年份
DECLARE @CurPeriod
--起始的会计期间
DECLARE @StartTime
--期间开始日期
DECLARE @EndTime
--期间结束日期
DECLARE @CalculateType INT
--核算方式
--↑声明变量declare，↓给变量赋值：
--关于数据库局部变量的详细说明请[参考]博客或文末附件(blog.csdn.net/changwei07080/article/details/7561602)
SELECT @CalculateType=FValue
FROM t_Systemprofile WHERE FKey='CalculateType' And FCategory='IC'
SELECT @CurPeriod=FValue FROM t_Systemprofile WHERE FKey='CurrentPeriod' And FCategory='IC'
SELECT @CurYear=FValue
FROM t_Systemprofile WHERE FKey='CurrentYear' And FCategory='IC'
EXECUTE GetPeriodStartEnd 0, @CurPeriod, @StartTime OUTPUT, @EndTime OUTPUT
--***************************************计算加权平均法的物料**********************************
--计算期初数据
SELECT t1.FItemID, t1.FStockID, ISNULL(t1.FBatchNO, '') as FBatchNO,(t1.FBegQty) AS FQty, (t1.FBegBal) AS FAmount
INTO #RealTimeCost
FROM ICInvBal t1
--'库存余额表，字段包含期初、收入、发出、结存、本年累计；结账时生成本月的期初，上月的收入、上月的发出、上月的结存；'
inner join t_ICItem t2 on t1.FItemID=t2.FItemID
inner join t_Stock t3 on t1.FStockID =t3.FItemID
and t3.FIncludeAccounting =1 --'仓库属性：是否参与核算'
WHERE t2.FTrack=76
AND t1.FPeriod = @CurPeriod
AND t1.FYear = @CurYear
--入库单据和红字出库单
--'（个人注解：此处统计的是入库类单据和出库类单据；出库类单据统计时要（*-1），因为在明细表里面蓝字单据的出库数量显示是正数，红字单据数量显示是负数。）
--ICSTOCKBILLENTRY明细表中的实际显示如下
--+—————————————————————————+
--|单据类型|物料|数量|单价|金额 |
--|——————|———|————|————|————+
--|蓝字入库|A | 2
|2.00|4.00|
--|红字入库|A | -1 |2.00|-2.0|
--|蓝字出库|A | 1
|2.00|2.00|
--|红字出库|A | -1 |2.00|-2.0|
--#realtimecost表中需要上述合计，就需要把出库*-1 '
INSERT INTO #RealTimeCost
t1.FItemID,
case when t2.FTranType=24 then t1.FSCStockID else
t1.FDCStockID end
AS FStockID,--仓库
ISNULL(t1.FBatchNO, '')
AS FBatchNo,--批号
(CASE WHEN t2.FTranType IN (21,24,28,29,43)
THEN (-1* t1.FQty) ELSE t1.FQty END ) AS FQty, --数量（出库类型*-1）
(CASE WHEN t2.FTranType IN (21,24,28,29,43) THEN (-1* t1.FAmount) ELSE t1.FAmount END ) AS FAmount
FROM ICStockBillEntry t1
inner join ICStockBill t2 on t1.FInterID = t2.FInterID
inner join t_ICItem t3
t1.FItemID=t3.FItemID
WHERE t2.FCancelLation = 0
--'作废（0未作废）'
AND t3.FTrack=76
--'加权平均，看到这里就明白了，为什么只支持了加权和批内加权，如果是其他计价方法就需要重新写sql了，可能需求不多，没继续做这个功能吧。之后有时间看看商贸版的即时库存表吧。'
AND t2.FTranType IN (1,2,5,10,40,100,101,102,21,24,28,29)
--'efeng_zhong
废品专项，核算仓库数据才参与核算'
and ((EXISTS(select FItemID
from t_Stock where FItemID =t1.FSCStockID and FIncludeAccounting=1 ) )
or(EXISTS (select FItemID
from t_Stock where FItemID =t1.FDCStockID and FIncludeAccounting=1 )))
AND FDate &= @StartTime
--调拨单 调入成本
INSERT INTO #RealTimeCost
SELECT t1.FItemID, t1.FDCStockID AS FStockID, ISNULL(t1.FBatchNO, ''),
t1.FQty, (t1.FAmtRef) AS FAmount
FROM ICStockBillEntry t1
inner join ICStockBill t2 on t1.FInterID = t2.FInterID
inner join t_ICItem t3
on t1.FItemID=t3.FItemID
t2.FTranType =41
AND t2.FCancelLation = 0
AND t3.FTrack=76
--'efeng_zhong
废品专项，核算仓库数据才参与核算'
and ((EXISTS(select FItemID
from t_Stock where FItemID =t1.FSCStockID and FIncludeAccounting=1 ) )
or(EXISTS (select FItemID
from t_Stock where FItemID =t1.FDCStockID and FIncludeAccounting=1 )))
AND FDate &= @StartTime
--调拨单 调出成本
INSERT INTO #RealTimeCost
SELECT t1.FItemID, t1.FSCStockID AS FStockID, ISNULL(t1.FBatchNO, ''),
(-t1.FQty) AS FQty, (-t1.FAmount) AS FAmount
FROM ICStockBillEntry t1
inner join
ICStockBill t2 on t1.FInterID = t2.FInterID
inner join t_ICItem t3
on t1.FItemID=t3.FItemID
t2.FTranType =41
AND t2.FCancelLation = 0
AND t3.FTrack=76
--'efeng_zhong
废品专项，核算仓库数据才参与核算 '
and ((EXISTS(select FItemID
from t_Stock where FItemID =t1.FSCStockID and FIncludeAccounting=1 ) )
or(EXISTS (select FItemID
from t_Stock where FItemID =t1.FDCStockID and FIncludeAccounting=1 )))
AND FDate &= @StartTime
--VMI入库单 BT782711
INSERT INTO #RealTimeCost
select t1.FItemID,t1.FStockID,ISNULL(t1.FBatchNo,''),t1.FQty,t1.FAmount from ICVMIInStockEntry t1 inner join t_ICItem t2
on t1.FItemID =t2.FItemID
AND t2.FTrack=76
--********计算成本***********************
DELETE ICRealtimeCost
SELECT t1.FItemID, t1.FStockID,t1.FQty,t1.FAmount
INTO #RealTime76
FROM #RealTimeCost t1
IF @CalculateType=0
--总仓核算
INSERT INTO ICRealtimeCost (FItemID,FStockID,FBatchNo,FQty,FAmount)
SELECT t1.FItemID, 0,'',SUM(t1.FQty) AS FQty, SUM(t1.FAmount) AS FAmount
FROM #RealTime76 t1
GROUP BY t1.FItemID
IF @CalculateType=1 --分仓核算
INSERT INTO ICRealtimeCost (FItemID,FStockID,FBatchNo,FQty,FAmount)
SELECT t1.FItemID, t1.FStockID,'',SUM(t1.FQty) AS FQty, SUM(t1.FAmount) AS FAmount
FROM #RealTime76 t1
GROUP BY t1.FItemID,t1.FStockID
--分仓组核算
INSERT INTO ICRealtimeCost (FItemID,FStockID,FBatchNo,FQty,FAmount)
SELECT t1.FItemID, t2.FGroupID,'',SUM(t1.FQty) AS FQty, SUM(t1.FAmount) AS FAmount
FROM #RealTime76
INNER JOIN t_Stock
t2 ON t1.FStockID=t2.FItemID
GROUP BY t1.FItemID,t2.FGroupID
--***************************************计算分批認定法(批內加權平均法)物料**********************************
DELETE #RealTimeCost
----期初数据
INSERT INTO #RealTimeCost
SELECT t1.FItemID, t1.FStockID, t1.FBatchNo,(t1.FBegQty) AS FQty, (t1.FBegBal) AS FAmount
FROM ICInvBal t1
inner join t_ICItem t2
on t1.FItemID=t2.FItemID
inner join t_Stock t3 on t1.FStockID =t3.FItemID and t3.FIncludeAccounting =1
WHERE t2.FTrack=20309 AND t1.FPeriod = @CurPeriod
AND t1.FYear = @CurYear
--入库单据和红字出库单
INSERT INTO #RealTimeCost
t1.FItemID, case when t2.FTranType=24 then t1.FSCStockID else
t1.FDCStockID end
AS FStockID, ISNULL(t1.FBatchNO, '') as FBatchNO,
(CASE WHEN t2.FTranType IN (21,24,28,29,43)
THEN (-1* t1.FQty)
ELSE t1.FQty END ) AS FQty,
(CASE WHEN t2.FTranType IN (21,24,28,29,43) THEN (-1* t1.FAmount)
ELSE t1.FAmount END ) AS FAmount
FROM ICStockBillEntry t1
inner join ICStockBill t2 on t1.FInterID = t2.FInterID
inner join t_ICItem t3
t1.FItemID=t3.FItemID
WHERE t2.FCancelLation = 0
AND t3.FTrack=20309
AND t2.FTranType IN (1,2,5,10,40,100,101,102,21,24,28,29)
--'efeng_zhong
废品专项，核算仓库数据才参与核算'
and ((EXISTS(select FItemID
from t_Stock where FItemID =t1.FSCStockID and FIncludeAccounting=1 ) )
or(EXISTS (select FItemID
from t_Stock where FItemID =t1.FDCStockID and FIncludeAccounting=1 )))
AND FDate &= @StartTime
--调拨单 调入成本
INSERT INTO #RealTimeCost
SELECT t1.FItemID, t1.FDCStockID AS FStockID, ISNULL(t1.FBatchNO, ''),
t1.FQty, (t1.FAmtRef) AS FAmount
FROM ICStockBillEntry t1
inner join
ICStockBill t2 on t1.FInterID = t2.FInterID
inner join t_ICItem t3
on t1.FItemID=t3.FItemID
t2.FCancelLation = 0
AND t3.FTrack=20309
AND t2.FTranType =41
--'efeng_zhong
废品专项，核算仓库数据才参与核算'
and ((EXISTS(select FItemID
from t_Stock where FItemID =t1.FSCStockID and FIncludeAccounting=1 ) )
or(EXISTS (select FItemID
from t_Stock where FItemID =t1.FDCStockID and FIncludeAccounting=1 )))
AND FDate &= @StartTime
--调拨单 调出成本
INSERT INTO #RealTimeCost
SELECT t1.FItemID, t1.FSCStockID AS FStockID, ISNULL(t1.FBatchNO, ''),
(-t1.FQty) AS FQty, (-t1.FAmount) AS FAmount
FROM ICStockBillEntry t1
inner join
ICStockBill t2 on t1.FInterID = t2.FInterID
inner join t_ICItem t3 on t1.FItemID=t3.FItemID
t2.FTranType =41
AND t2.FCancelLation = 0
AND t3.FTrack=20309
--'efeng_zhong
废品专项，核算仓库数据才参与核算'
and ((EXISTS(select FItemID
from t_Stock where FItemID =t1.FSCStockID and FIncludeAccounting=1 ) )
or(EXISTS (select FItemID
from t_Stock where FItemID =t1.FDCStockID and FIncludeAccounting=1 )))
AND FDate &= @StartTime
--VMI入库单 BT782711
INSERT INTO #RealTimeCost
select t1.FItemID,t1.FStockID,ISNULL(t1.FBatchNo,''),t1.FQty,t1.FAmount from ICVMIInStockEntry t1 inner join t_ICItem t2
on t1.FItemID =t2.FItemID
AND t2.FTrack=20309
---********计算成本***********************
SELECT t1.FItemID, t1.FStockID,t1.FQty,t1.FAmount,t1.FBatchNo
INTO #RealTime20309
FROM #RealTimeCost t1
IF @CalculateType=0
--总仓核算
INSERT INTO ICRealtimeCost (FItemID,FStockID,FBatchNo,FQty,FAmount)
SELECT t1.FItemID, 0,t1.FBatchNo,SUM(t1.FQty) AS FQty, SUM(t1.FAmount) AS FAmount
FROM #RealTime20309 t1
GROUP BY t1.FItemID,t1.FBatchNo
IF @CalculateType=1 --分仓核算
INSERT INTO ICRealtimeCost (FItemID,FStockID,FBatchNo,FQty,FAmount)
SELECT t1.FItemID, t1.FStockID,t1.FBatchNo,SUM(t1.FQty) AS FQty, SUM(t1.FAmount) AS FAmount
FROM #RealTime20309 t1
GROUP BY t1.FItemID,t1.FStockID ,t1.FBatchNo
--分仓组核算
INSERT INTO ICRealtimeCost (FItemID,FStockID,FBatchNo,FQty,FAmount)
SELECT t1.FItemID, t2.FGroupID,t1.FBatchNo,SUM(t1.FQty) AS FQty, SUM(t1.FAmount) AS FAmount
FROM #RealTime20309
INNER JOIN t_Stock
t2 ON t1.FStockID=t2.FItemID
GROUP BY t1.FItemID,t2.FGroupID ,t1.FBatchNo
--************计算单位成本***************
--PT097541 csli_liu
出库核算提示算数溢出错误
--数量为0.当0处理
SET t1.FPrice=(SELECT CASE ROUND(t1.FQty,8) WHEN 0 THEN 0 ELSE ROUND(t1.FAmount/t1.FQty,t2.FPriceDecimal) END )
FROM ICRealtimeCost t1
INNER JOIN t_ICItem t2 ON t1.FItemID=t2.FItemID
--删除临时表
DROP TABLE #RealTime76
DROP TABLE #RealTimeCost
DROP TABLE #RealTime20309
[pr?’si:d??]
过程，程序
[d?’kle?]
[‘k?r(?)nt]
现在的，当前的
[‘p??r??d]
周期，期间
示例：在K3帐套里面使用，根据[@单号]和[@单据类型]查询单据明细
declare @tran int
declare @fnumber varchar(255) ;
select @tran='24',@fnumber = 'SOUT000002';
set @tran='24'
set @fnumber = 'SOUT000002';
--赋值;有2种方法：select可以连续赋值，通过逗号分割；set需要分别赋值；语法：select(set) @column = table.column from table where c
select @tran,@fnumber
print @tran
print @fnumber;
--输出;有2种方法：select可以连续输出，为表格形式；print需要分别输出，为文本形式
select * from ICStockBillEntry where FInterID in
(select FInterID from ICStockBill where FTranType = @tran and FBillNo = @fnumber
if...begin....end(else...if...begin...end)
0、把ICInventory库存表中的数量插入#TempInventory；
————————————————————————————
1、创建#RealTimeCost用来计算#RealTime76
2、删除#RealTimeCost
3、创建#RealTimeCost用来计算#RealTime20309
4、把#RealTime76和#RealTime20309插入ICRealtimeCost
5、把ICRealtimeCost的单价插入#TempInventory
没有更多推荐了，
加入CSDN，享受更精准的内容推荐，与500万程序员共同成长！温馨提示！由于新浪微博认证机制调整，您的新浪微博帐号绑定已过期，请重新绑定！&&|&&
LOFTER精选
网易考拉推荐
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
& & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & & &
阅读(642)|
用微信&&“扫一扫”
将文章分享到朋友圈。
用易信&&“扫一扫”
将文章分享到朋友圈。
历史上的今天
在LOFTER的更多文章
loftPermalink:'',
id:'fks_',
blogTitle:'金蝶KIS专业版 仓库调拨业务详解',
blogAbstract:'& & & & &概念：仓库调拨是仓库管理里的一项常见业务，它是指仓库物资发生位置的变动（所有权不发生变动），例如：从检验仓库调入原材料仓库，从成品仓调入客户仓等情况（销售调拨单）。\n\n& 调拨两种类型：\n\n& & & & & & & & & &成本调拨（同价调拨）：对于成本调拨，一般只影响仓库的数量和金额，不影响存货的科目余额。\n\n',
blogTag:'',
blogUrl:'blog/static/',
isPublished:1,
istop:false,
modifyTime:5,
publishTime:1,
permalink:'blog/static/',
commentCount:0,
mainCommentCount:0,
recommendCount:0,
bsrk:-100,
publisherId:0,
recomBlogHome:false,
currentRecomBlog:false,
attachmentsFileIds:[],
groupInfo:{},
friendstatus:'none',
followstatus:'unFollow',
pubSucc:'',
visitorProvince:'',
visitorCity:'',
visitorNewUser:false,
postAddInfo:{},
mset:'000',
remindgoodnightblog:false,
isBlackVisitor:false,
isShowYodaoAd:false,
hostIntro:'',
selfRecomBlogCount:'0',
lofter_single:''
{list a as x}
{if x.moveFrom=='wap'}
{elseif x.moveFrom=='iphone'}
{elseif x.moveFrom=='android'}
{elseif x.moveFrom=='mobile'}
${a.selfIntro|escape}{if great260}${suplement}{/if}
{list a as x}
推荐过这篇日志的人：
{list a as x}
{if !!b&&b.length>0}
他们还推荐了：
{list b as y}
转载记录：
{list d as x}
{list a as x}
{list a as x}
{list a as x}
{list a as x}
{if x_index>4}{break}{/if}
${fn2(x.publishTime,'yyyy-MM-dd HH:mm:ss')}
{list a as x}
{if !!(blogDetail.preBlogPermalink)}
{if !!(blogDetail.nextBlogPermalink)}
{list a as x}
{if defined('newslist')&&newslist.length>0}
{list newslist as x}
{if x_index>7}{break}{/if}
{list a as x}
{var first_option =}
{list x.voteDetailList as voteToOption}
{if voteToOption==1}
{if first_option==false},{/if}&&“${b[voteToOption_index]}”&&
{if (x.role!="-1") },“我是${c[x.role]}”&&{/if}
&&&&&&&&${fn1(x.voteTime)}
{if x.userName==''}{/if}
网易公司版权所有&&
{list x.l as y}
{if defined('wl')}
{list wl as x}{/list}金蝶加权平均法，可以随时查看成本吗_百度知道
金蝶加权平均法，可以随时查看成本吗
我有更好的答案
如果是金蝶KIS商贸版的话，查询库存时会提示重算本期成本，可以随时查看。如果是金蝶K3的话，需要先在存货核算模块-出库核算-进行材料出库核算，再到存货核算模块-报表查询-查询收发存汇总表。
采纳率：33%
为您推荐：
其他类似问题
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。 上传我的文档
 下载
 收藏
该文档贡献者很忙，什么也没留下。
 下载此文档
KIS专业版负库存出库成本核算
下载积分：500
内容提示：KIS专业版负库存出库成本核算
文档格式：PDF|
浏览次数：175|
上传日期： 17:10:43|
文档星级：
全文阅读已结束，如果下载本文需要使用
 500 积分
下载此文档
该用户还上传了这些文档
KIS专业版负库存出库成本核算
关注微信公众号金蝶K3软件中，计价方法按加权平均法,但材料库存单价为负数，怎么办?当月报表已出,结不了账无法做下月数._百度知道
金蝶K3软件中，计价方法按加权平均法,但材料库存单价为负数，怎么办?当月报表已出,结不了账无法做下月数.
根据咨询需做成本调整单,但不知道会不会影响当月的报表数据?材料的收发存汇总表数据应该会变吧?成本调整单又是什么意思?该怎样调整?
我有更好的答案
出库成本调整了肯定会影响当月损益的。材料的收发存汇总表数量不会影响，金额肯定要变。成本调整单就是额外的做一张结转成本的凭证。该怎样调整就要问软件的客服了，每个软件不同帐套做法都不一样。
结转成本的凭证该怎么做？分录是？我现在在4月出了一张成本调整出库单，材料的收发存汇总表数量不会影响，但发出金额及库存金额已变，财务报表只能在5月调整了，所以在5月出凭证，那5月具体的流程是？
结转成本的凭证该怎么做？借：营业成本贷：原材料（或库存商品） 软件上的处理建议你找软件客服
采纳率：36%
来自团队：
你们设置允许负库存结账了吗？成本调整单是针对负库存出库造成的成本差原调整，是正常的调整比如负库存出库了10个
单价10元，系统结账会让你估计一个成本价，比如你估的是8元，结账后，你做入库采购实际单价9元，它会调升以前转的成本1元
调价单，是调整成本（入库单价）的，有个日期，日期之后的按新价格计算成本
为您推荐：
其他类似问题
金蝶k3的相关知识
换一换
回答问题，赢新手礼包
个人、企业类
违法有害信息,请在下方选择后提交
色情、暴力
我们会通过消息、邮箱等方式尽快将举报结果通知您。