[%- USE LxERP -%] [%- USE T8 -%] [%- USE L -%] [%- USE HTML -%] [%- USE P -%] [%- SET dec = 2 %]
[%- 'Account' | $T8 %] | [%- 'Description' | $T8 %] | [%- 'Starting Balance' | $T8 %] | [%- 'Balance with CB' | $T8 %] | [%- 'Closing Balance' | $T8 %] | |||
---|---|---|---|---|---|---|---|
[%- 'Debit' | $T8 %] | [%- 'Credit' | $T8 %] | [%- 'Debit' | $T8 %] | [%- 'Credit' | $T8 %] | [%- 'Debit' | $T8 %] | [%- 'Credit' | $T8 %] | ||
[% chart.accno | html %] | [% chart.description | html %] | [% IF chart.ob_amount < 0 %] [% LxERP.format_amount(chart.ob_amount * -1, dec) %] [% END %] | [% IF chart.ob_amount > 0 %] [% LxERP.format_amount(chart.ob_amount, dec) %] [% END %] | [% IF chart.amount_with_cb < 0 %] [% LxERP.format_amount(chart.amount_with_cb * -1, dec) %] [% END %] | [% IF chart.amount_with_cb > 0 %] [% LxERP.format_amount(chart.amount_with_cb, dec) %] [% END %] | [% # cb amounts: >/< are switched and cb_amounts are multiplied with -1. The closing balance as calculated by cb_amount negates the actual balance, but when displaying it as the closing balance we want to display it in the same form as the actual balance %][% IF chart.cb_amount > 0 %] [% LxERP.format_amount(chart.cb_amount * 1, dec) %] [% END %] | [% IF chart.cb_amount < 0 %] [% LxERP.format_amount(chart.cb_amount * -1, dec) %] [% END %] |
[% IF profit_loss_sum < 0 %] [% THEN %][% 'Loss' | $T8 %] [% ELSE %] [% 'Profit' | $T8 %] [% END %]: [% LxERP.format_amount(profit_loss_sum, dec) %]
[%- 'Account' | $T8 %] | [%- 'Description' | $T8 %] | [%- 'Balance with CB' | $T8 %] | [%- 'Closing Balance' | $T8 %] | ||
---|---|---|---|---|---|
[%- 'Debit' | $T8 %] | [%- 'Credit' | $T8 %] | [%- 'Debit' | $T8 %] | [%- 'Credit' | $T8 %] | ||
[% chart.accno | html %] | [% chart.description | html %] | [% IF chart.amount_with_cb < 0 %] [% LxERP.format_amount(chart.amount_with_cb * -1, dec) %] [% END %] | [% IF chart.amount_with_cb > 0 %] [% LxERP.format_amount(chart.amount_with_cb, dec) %] [% END %] | [% IF chart.cb_amount > 0 %] [% LxERP.format_amount(chart.cb_amount * 1, dec) %] [% END %] | [% IF chart.cb_amount < 0 %] [% LxERP.format_amount(chart.cb_amount * -1, dec) %] [% END %] |