-
收料通知单序时簿放开应收数量的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 '%应收数量%'