[av_textblock size=” font_color=” color=”]
If an SAP invoice has several pages, the sum of all the positions of the current page at the end of a page should be displayed. It is the classical demand for a representation of the carry over on a bill.
Example
We have an invoice with 3 pages.
[/av_textblock]
[av_hr class=’invisible’ height=’10’ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/Rechnung-mit-3-Seiten.png’ attachment=’16085′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_textblock size=” font_color=” color=”]
Invoice with 3 pages
[/av_textblock]
[av_hr class=’invisible’ height=’-50′ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’]
[av_heading tag=’h3′ padding=’0′ heading=’Step 1) Create a numeric field after the printout of the position value’ color=” style=” custom_font=” size=” subheading_active=” subheading_size=’15’ custom_class=”][/av_heading]
[av_textblock size=” font_color=” color=”]
A field with the following properties is added to each line where the position value is printed. In our example, this affects the line at material number level (if no conditions are printed) or in the condition line (if conditions are printed in detail).
[/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Übertrag.png’ attachment=’16086′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_hr class=’invisible’ height=’-50′ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’]
[av_textblock size=” font_color=” color=”]
- Type: numeric field
- Presence: invisiblet)
[/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Übertrag-2.png’ attachment=’16087′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_textblock size=” font_color=” color=”]
- Display pattern: 2 decimal places
[/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Subtotal.png’ attachment=’16088′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Subtotal-2.png’ attachment=’16089′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_textblock size=” font_color=” color=”]
- Binding: Position value (must be a field of the type DEC or CURR or QUAN, that is, no field of type CHAR)
[/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Subtotal-3.png’ attachment=’16090′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_textblock size=” font_color=” color=”]
Interface
[/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Übertrag-3.png’ attachment=’16091′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_hr class=’invisible’ height=’-50′ shadow=’no-shadow’ position=’center’ custom_border=’av-border-thin’ custom_width=’50px’ custom_border_color=” custom_margin_top=’30px’ custom_margin_bottom=’30px’ icon_select=’yes’ custom_icon_color=” icon=’ue808′ font=’entypo-fontello’]
[av_heading tag=’h3′ padding=’0′ heading=’Step 2) Create a line to print the carry over at the end of each page’ color=” style=” custom_font=” size=” subheading_active=” subheading_size=’15’ custom_class=”][/av_heading]
[av_textblock size=” font_color=” color=”]
- At the end of the DATA area, a subform CARRY_OVER is created to print the carry over at the end of each page.
[/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Übertrag-4.png’ attachment=’16096′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_textblock size=” font_color=” color=”]
On the “Pagination” tab in the DATA subform, enter “CARRY_OVER” in the “overflow area”.
[/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Übertrag-5.png’ attachment=’16097′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_textblock size=” font_color=” color=”][/av_textblock]
[av_image src=’http://solidforms.de/solid_wp_2014/wp-content/uploads/2016/04/SAP-Adobe-Form-Übertrag-6.png’ attachment=’16098′ attachment_size=’full’ align=’center’ styling=” hover=” link=” target=” caption=” font_size=” appearance=” overlay_opacity=’0.4′ overlay_color=’#000000′ overlay_text_color=’#ffffff’ animation=’no-animation’][/av_image]
[av_textblock size=” font_color=” color=”]
A KWERT_CARRY_OVER field is inserted in the CARRY_OVER subform with the following properties.
- Type: numeric field
- Display pattern: 2 decimal places
- Binding: no data binding
In the KWERT_CARRY_OVER element, the following scripting type JAVASCRIPT is placed at the time CALCULATE:
var fields = xfa.layout.pageContent(xfa.layout.page(this), „field“, 0);
var total = 0;
for (var i=0; i <= fields.length-1; i++)
{
if (fields.item(i).name == „KWERT_CO“)
{
total = total + fields.item(i).rawValue;
}
}
this.rawValue = total;
Now the Adobe Form can be activated and tested for the output of the subtotals per page / carry over.
[/av_textblock]
[av_textblock size=” font_color=” color=”]
Further information
SAP form development
[/av_textblock]
