A conditional requisite in an XML format is a requisite whose value is selected from the cell area where the value was initially set up. The requisite for the tax amount due in the property tax declaration form is an example of this requisite type. You can set up the value of a conditional requisite by using the Microsoft Office Excel template in line with code 030, or in line with code 040 on the appropriate sheet.

In this procedure, you set up two conditional requisites with the same attribute names. The requisite value is taken from the specified cells. If the value is not specified in the cell, the value is taken from the Defaultfield for the requisite.

  1. Click General ledger> Setup> Financial reports generator> Document templatesto open the Document templatesform.

  2. Click Setup, and then click Yesto open the Requisites setupform. The specified Microsoft Office Excel sheet opens in the lower section of the form.

  3. On the Requisitestab, in the Sectionfield, select the section code that the conditional requisite refers to.

    Note Note

    You can select the section code on either the Overviewor Treetab.

  4. In the left section of the form, press CTRL+N to create a new line.

  5. In the Requisite typefield, select Cell.

  6. In the Requisitefield, enter the requisite code.

    Note Note

    The Attributefield is updated with the XML attribute name. You can modify the attribute name.

  7. In the lower section of the form, select cells in the first value line. Click Selectin the left section of the form, and then click Yesto change the area of the requisite.

  8. In the Output typefield, select Optional.

  9. In the left section of the form, press CTRL+N to create a new line.

  10. In the Requisitefield, enter a unique name for the new requisite.

  11. In the Attributefield, specify the attribute name that matches the name in the Attributefield of the original requisite.

  12. In the Requisite typefield, select Cell.

  13. In the Output typefield, select Optional.

  14. In the lower section of the form, select cells in the second line. Click Selectin the right section of the form, and then click Yesto change the area of the requisite.

  15. In the right section of the form, in the Prefixfield, enter the value to be added before the requisite.

  16. In the Postfixfield, enter the value to be added after the requisite.

  17. In the Defaultfield, specify the default value for both requisites that will appear in the Office Excel file if the cells are empty.

  18. Press CTRL+S or close the form.

See Also