A composite requisite is a value that is generated from several cell groups that are not sequential.
-
Click General ledger> Setup> Financial reports generator> Document templatesto open the Document templatesform.
-
Click Setup, and then click Opento open the Requisites setupform. The specified Microsoft Office Excel file opens in the lower section of the form.
-
In the Sectionfield, select the section to which you are adding a requisite.
Note You can select the section code on either the Overviewor Treetab.
-
In the left section of the form, press CTRL+N to create a new line.
-
In the Requisite typefield, select Cell.
-
In the Requisitefield, enter the requisite code.
Note The Attributefield is updated with the XML attribute name. You can modify the attribute name.
-
In the Descriptionfield, enter a description for the requisite.
-
In the Data typefield, select the requisite data type.
-
In the Output typefield, select the requisite output type.
-
In the Extended data typefield, select the extended data type to verify that the value of the requisite was imported.
-
Select the source for the first requisite value in the lower section of the form.
-
Click Add, and then click Yes. A new line is created in the right section of the form.
-
In the Prefixfield, enter the value to be added to before the requisite.
-
In the Postfixfield, enter the value to be added to after the requisite.
Note Repeat steps 9 through 14 for each requisite that you add.
-
Click Go to, and ensure that the selected cells in the lower section of the form are the correct values to be used to create the requisite.
Note Click Upor Downin the right section of the form to organize the value lines.
-
Press CTRL+S or close the form.