怎样实现在凭证上面显示及打印现金流量信息？

通过以下配置可以实现在凭证上面显示及打印分录行的现金流量信息。

步骤一：通过数据库执行以下SQL来创建一个现金流量信息的视图。

-- 创建一个现金流量信息视图（现金流量显示在本方分录后面）

create view v_gl_cashflowbal as select FACCTBOOKID,FVOUCHERID,FVCHENTRYID as FEntryID,FVCHENTRYID as FID,FVCHOPPOENTRYID,FCASHACCOUNTID,FITEMID,FSUBITEMID,FCURRENCYID,FAMOUNTFOR as FCFAMOUNTFOR,FAMOUNT as FCFAMOUNT from t_gl_cashflowbal;

--创建一个现金流量信息视图（现金流量显示在对方分录后面）

create view v_gl_cashflowbal as select FACCTBOOKID,FVOUCHERID,FVCHENTRYID,FVCHOPPOENTRYID as FEntryID,FVCHOPPOENTRYID as FID,FCASHACCOUNTID,FITEMID,FSUBITEMID,FCURRENCYID,FAMOUNTFOR as FCFAMOUNTFOR,FAMOUNT as FCFAMOUNT from t_gl_cashflowbal;

注意：以上两个SQL根据需要选择一个执行，重复执行必须先删除原视图（drop view v_gl_cashflowbal）

步骤二：通过BOS设计器扩展凭证后，在凭证上面增加一个子单据体。

1)         现金流量子