问题版本: |
812-U6普及版3.1 plus1 |
问题模块: |
30-其他问题 |
所属行业: |
0-通用 |
问题状态: |
2-UU通注册用户 |
关 键 字: |
单据格式设置——表头项目加上‘客户联系人’ |
适用产品: |
U63.1PLUS1 |
补 丁 号: |
|
开放状态: |
0-UU通注册用户 |
>问题号: |
|
提交时间: |
2008-7-20 16:05:35 |
问题名称: |
单据格式设置——表头项目加上‘客户联系人’ |
问题现象: |
销售发票上没有联系人,请在单据格式设置——表头项目加上‘客户联系人’这个项目 |
原因分析: |
在查询分心器相应的帐套中执行如下语句: 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 (17,13,100,'客户联系人',0,0,0,null,null,'customer','ccusperson',1,5,null,'T','','', 0,200,3800,0,0,1,'|0',NULL,NULL,0,0,0,0,0,1000,100,4340,285,45,'',NULL,'','宋体,9,0,0,1 ',1,0,NULL,0,0,NULL,0,1,0,NULL,NULL,0) 操作之前建议备份好帐套! |
解决方案: |
在查询分心器相应的帐套中执行如下语句: 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 (17,13,100,'客户联系人',0,0,0,null,null,'customer','ccusperson',1,5,null,'T','','', 0,200,3800,0,0,1,'|0',NULL,NULL,0,0,0,0,0,1000,100,4340,285,45,'',NULL,'','宋体,9,0,0,1 ',1,0,NULL,0,0,NULL,0,1,0,NULL,NULL,0) 操作之前建议备份好帐套! | |