解决方案: |
可以通过下面方法单据模版上面加上信用期限: 1、找到发货单对应的cardnumber select * from vouchers where ccardname like '%发%' 找到发货单的ccardnumber='01' 2、向VoucherItems表中加入一条纪录,即能够显示信用期间的项目(模仿已有的‘用户信用度’项目)。对应vouchers.cardnumber的是voucheritems.cardnum。 INSERT INTO [VoucherItems]([VT_ID], [CardNum], [CardItemNum], [CardItemName], [CanNotSelect], [ShowIt], [LinkIt], [LinkTbl], [LinkField], [TableName], [FieldName], [FieldType], [ReferType], [ReferTable], [CardSection], [CardFormula1], [CardFormula2], [CanModify], [MaxLength], [MaxShowLen], [NumPoint], [IsNull], [CanDelete], [UserCheck], [UserPrompt], [FormatChar], [IsMain], [NeedSum], [CalcField], [AliasNum], [isSelfDef], [COX], [COY], [Width], [Height], [TabIndex], [DefaultValue], [IsFixedLenght], [FormatData], [FontState], [PrintCaption], [PrintUpcase], [PrintInterval], [DataSource], [EnterType], [DataRule], [ValidityCheck], [ReserveSegTitlePos], [BuildArchives], [ReferReturnField], [cmemo], [nBorder]) values ('71','01','111','信用期间',0,1,0,null,null,'customer','icuscredate',4,5,null,'T','','',0,20,760,0,0,2,'|0',null,null,0,0,0,0,0,7320,5280,3720,285,30,'',null,0,'宋体,9,0,0,1',1,0,'',0,0,null,0,1,0,null,null,0) 3、调整单据模版,并修改单据模版的输入顺序,可以使用自动设置输入顺序。在打印模版上面加入‘信用期限’项目,同理。 |