Note: This article applies to classic billing via the Sale/Purchase screen. Concepts apply to EBM users using the S/P screen.
Heading Totals in Invoices
You can specify if you want the heading totals in sale/purchase line items to appear above or below the heading group as follows:
[[*REPEAT|data_source=SP_LineItems|tablerow|heading_total_position=below|heading_total_height= 3 |*]] |
Where
heading_total_position=above|below (default = above)
heading_total_height=1-3 (1=default)
The total height is the number of lines to use in the "title" field. if set to 3 then the title will be 3 blank lines (thus making a "gap" after the header total).
This will simply add a new line after the header and its line items with just the quantity and amounts. The source header will have the quantity and amounts set to blank. The new line is also marked as a header so will get the header formatting for bold/italic etc.
Example
Show/Hide Headings and Line Items
Two options can be added to the REPEAT directive to manage the display of line items and headings:
- show_headings
- show_line_items
EXAMPLE:
[[*REPEAT|data_source=SP_LineItems|tablerow|heading_total_position=below|heading_total_height= 3 |show_headings=F|show_line_items=T/F|*]] |
show_headings = T or F (default is T)
show_line_items = T or F (default is T)
When set to false, the repeat block will not include the line items or headings.. this allows you to use TWO repeat blocks, a summary (headings only) on page 1 and detailed on page 2+.
If show_headings = F then only the line-items from the root level will be displayed (since the heading is removed it's children are also removed). show_line_items will hide all line items regardless of the level of the heading.