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

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

  3. In the Sectionfield, select the section code to which the requisite is to be added.

    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. The attribute name can be modified.

  7. In the Descriptionfield, enter a description for the requisite.

  8. In the Data typefield, select Conditional.

    Note Note

    The value of this type of requisite depends on the value that is displayed in the cells when the requisite is imported. If the cell is not empty, the value is taken from the Valuefield in the right section of the Requisite setupform. Otherwise, the value is taken from the Defaultfield.

  9. In the Output typefield, select the requisite output type.

  10. In the Extended data typefield, select the extended data type to verify the value of the imported requisite.

  11. In the lower section of the form, select the source for first the requisite value.

  12. In the right section of the form, click Add, and then click Yes. A new line is created in the right section of the form and the Cellfield is updated.

  13. In the Prefixfield, enter the value to be added to before the requisite.

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

  15. In the Valuefield, enter the value that this requisite should have if this cell is not empty.

    Note Note

    Repeat steps 10 and 11 to add more requisites.

  16. Click Go To. Ensure that the selected cells in the lower section of the form contain the correct values to be used to create the requisite.

    Note Note

    If some of the selected cells are not empty when data is imported, the values in the lines will be linked together. For example, if line one shows value 1, and line two shows value 2, and if the cells for lines one and two are not empty, then the value of the requisite will be 12.

  17. Press CTRL+S or close the form.

See Also