CUSTOMER INVOICE FORM TEMPLATE

[seunabati]

Greetings, 

Please how do i edit out the unit of measure that shows on the net price of my customer invoice form template.

For example i want to edit out that / 1 EACH in the picture below.

Thank you.

[SteveB]

Dear,

I assume you want to remove the "/ 1 EACH" as you work with unit prices. Thus it is advised to rename your column to 'unit price' for clarity.

Default you get this:

- Column Net Price is filled up by the logic under Subform FrmPrice with its binding and scripting. It is the scripting that creates the concatenation of quantity / currency and base quantity with unit of measure. 

To adjust it and remove the base quantity with unit of measure you need to alter the scripting and remove the part in the concatenation (highlighted in red)

Scripting:

/ Concatenate the 'Net Price' value and currency if they are not initial
var content = "";

if (not this.decPrice.isNull)
then
content = Concat(content,this.decPrice.formattedValue);
if (not this.txtPriceCurrency.isNull)
then
content = Concat(content, " " , this.txtPriceCurrency.rawValue );
if ( not this.decBaseQuantity.isNull &
not this.txtBaseQuantityUnit.isNull )
then
content = Concat(content, " / " , this.decBaseQuantity.rawValue , " " , this.txtBaseQuantityUnit.rawValue);
endif
endif
endif
// Copy the concatenated value the visible field 'Net Price' of the table
if(content <> "")
then
FormInvoiceRequest.bdyMain.frmTableBlock.tblTable.rowItem.colPrice.rawValue = content;
endif

>>

Change the line in red to:

content = Concat(content);

That is an easy way to change it. But obviously you need to be certain that you do not have price definition other than unit pricing else you will show wrong pricing information.

KR,

Steve

[henrycai]

Dear Customer,

You can use string Upper() in Adobe LiveCycle Designer (ALD) to achieve this.

Please open your ByD system, go to work center Application and User Management, access view Download Center, find "Adobe LiveCycle Designer for SAP Business ByDesign" and click Download. After that, you can access view "Form Template Maintenance" in the same work center, find the form template that you want to adjust, click Download. Then, open the .xdp file with ADL, and try to use string Upper() for the field.

Regarding string Upper(), you can refer to this documentation from Adobe: https://help.adobe.com/en_US/livecycle/10.0/DesignerFormCalcRef/WS92d06802c76abadb-32254d55129f5ee7c...

Henry

SAP Support