服务热线:

4006-6500-28

新闻资讯
联系我们

电话:400-665-0028


您当前位置:首页 > 新闻资讯  > 知识学习 > 正文知识学习
金蝶软件字段在序时簿的显示和是否进行合计
添加时间:2023-3-22

  1. 收料通知单序时簿放开应收数量的sql如下【下面SQL建议用户在备份的账套上测试OK后再在正式账套执行】:

DECLARE @MaxFInterID AS INT

SELECT @MaxFInterID=MAX(FInterID)+1 FROM ICChatBillTitle where FTypeID=82

IF NOT EXISTS(SELECT 1 FROM ICChatBillTitle WHERE FColName='FAuxQtyMust' AND FTypeID=82)

BEGIN

 INSERT INTO ICChatBillTitle(FInterID,FTypeID,FColCaption,FHeadSecond,FColName,FTableName,FColType,FColWidth,FVisible,FItemClassID,FVisForQuest,FReturnDataType,FCountPriceType,FCtlIndex,FName,FTableAlias,FAction,FNeedCount,FIsPrimary,FLogicAction,FStatistical,FMergeable,FVisForOrder,FColCaption_CHT,FColCaption_EN,FControl,FMode,FControlType,FPrecisionField,FAlign,FEditable,FFormat,FFormatType,FMustSelected,FViseForTDC)


 VALUES(@MaxFInterID,82,'应收数量$','','FAuxQtyMust','POInstockEntry',2,1000,3,-1,1,0,2,5,'FAuxQtyMust','u1','',1,0,'',1,0,1,'應收數量$','Due-in Qty$',0,0,5,'',1,0,'FQtyDecimal',3,0,0)

END


2.序时簿上【应收数量】不进行合计(收料通知单 的FtypeId是82 )

UPDATE  ICChatBillTitle SET  FNeedCount=0  where  FtypeId=82  and Fcolcaption like '%应收数量%'