Adding substring of z76-budget-number form acq-full-inv-info.xsl

Question

Is it possible to add substring of z76-budget-number to form acq-full-inv-info.xsl to split the information into 2 lines?

Trying to add field Z76_BUDGET_NUMBER results in:
The following XML.XSL parse error messages are received:

Error at xsl:with-param on line 119 of file:/C:/AL500/alephcom/files/XXX50/PrintTemplates/eng/acq-full-inv-info.xsl:
XPST0017: XPath syntax error at char 31 on line 119 in {./substr(Z76_BUDGET_NUMBER,1,6...}:
Unknown system function substr()
Error at xsl:with-param on line 124 of file:/C:/AL500/alephcom/files/XXX50/PrintTemplates/eng/acq-full-inv-info.xsl:
XPST0017: XPath syntax error at char 31 on line 124 in {./substr(Z76_BUDGET_NUMBER,7,7...}:
Unknown system function substr()
Failed to compile stylesheet. 2 errors detected.

Answer

In general you are able to use the 'substring' command to extract information from a field. For detailed description consult XSL manual.

In this particular case information from table z76 is not available for form acq-full-inv-info.xsl.

You can find out about the available fields using the 'View Raw XML' display output (right click on the printer symbol and choose 'View Raw XML'.) for printing.

For acq-full-inv-info.xsl fields from z70 (vendor), z72 (vendor address) and z77 (invoice header), z75 (invoice line item), z68 (order), z13/z13u (bibliographic information) are available.

Additional Information

The correct field name would be z76-budget-number instead of Z76_BUDGET_NUMBER.

Category: Acquisitions (500)

Subject: Invoices (500)

• Article last edited: 10/8/2013