(RUS) Assign a constant value for a cell in the Financial reports generator report [AX 2012]

Updated: January 7, 2013

Applies To: Microsoft Dynamics AX 2012 R3, Microsoft Dynamics AX 2012 R2

Use the Field setup form to assign a constant numeric or text value for a cell in the Financial reports generator (FRG) report that uses a Microsoft Excel template. In the lower pane of the Field setup form, when you create two consecutive lines with numeric values, an arithmetic operation is performed, and the value is displayed in the cell. If one of the lines has a string value, it is concatenated with the line with the numeric value.

Example

For the values in the table below, the following line is created: 2500Rubles500Rubles900Rubles.

Operator

Line type

Data

+

Constant

50

*

Constant

50

/

Constant

Rubles

+

Constant

500

+

Constant

Rubles

+

Constant

300

*

Constant

3

+

Constant

Rubles

Use the following procedure to assign a constant value for a cell.

  1. Click General ledger > Setup > Financial reports generator > Financial reports generator. Select a report line, and then click Setup.

    –or–

    Click General ledger > Setup > Financial reports generator > Document templates. Select a document template, and then click Report. Select a report line, and then click Setup.

  2. Select a report cell, and then in the lower pane, click Add to create a line.

  3. In the Operator field, select a mathematical operator that is applied to the cell value.

  4. In the Line type field, select Constant.

  5. In the Data field, enter the value that is used to calculate the cell value.


Announcements: To see known issues and recent fixes, use Issue search in Microsoft Dynamics Lifecycle Services (LCS).

Community Additions

ADD
Show: