Adding substring of z76-budget-number form acq-full-inv-info.xsl
- Article Type: Q&A
- Product: Aleph
- Product Version: 20
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