金蝶软件字段在序时簿的显示和是否进行合计

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 '%应收数量%'