销售出库单下推生成销售发票,携带出库单上的日期至发票上日期字段的方法
问题描述:
销售出库单下推生成销售发票,或销售出库单审核后自动生成发票,需要将销售出库单上的“日期:”字段值携带至发票上“日 期:”字段,如何实现?
解决方案:
注意:请务必备份好账套,在测试账套中测试确认正常后再到正式账套中执行。
销售出库→销售发票(专用):
Insert Into ICSelBills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias)
values('I04','FOutStockInterID','Fdate',2,0,'Fdate','Fdate','ICStockBill','v1')
Insert Into ICSelBills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias)
values('I04','FOutStockInterID','Fdate',2,1,'Fdate','Fdate','ICStockBill','v1')
Insert Into ICSelBills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias)
values('I04','FOutStockInterID','Fdate',2,2,'Fdate','Fdate','ICStockBill','v1')
销售出库→销售发票(普通):
Insert Into ICSelBills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias)
values('I05','FOutStockInterID','Fdate',2,0,'Fdate','Fdate','ICStockBill','v1')
Insert Into ICSelBills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias)
values('I05','FOutStockInterID','Fdate',2,1,'Fdate','Fdate','ICStockBill','v1')
Insert Into ICSelBills(FID,FFieldName,FDstCtlField,FSelType,FDK,FColName,FName,FTableName,FTableAlias)
values('I05','FOutStockInterID','Fdate',2,2,'Fdate','Fdate','ICStockBill','v1')
销售出库单下推生成销售发票,携带出库单上的日期至发票上日期字段的方法
本文2024-09-22 14:52:37发表“k3wise知识”栏目。
本文链接:https://wenku.my7c.com/article/kingdee-k3wise-77844.html