All the RM Statement reports have been included in the Advanced Credit Control dictionary so that they can be modified in Report Writer to show the Credit Status of each transaction. Putting the status on the report is accomplished through a Report Writer function.
First, the Microsoft Dynamics GP security must be set to use the RM Statement reports in the Credit Control dictionary. Make sure security is set for the Alternate Microsoft Dynamics GP Reports in the Sales series.
Next, modify the statement report to show the status by adding a calculated field. In the field, add the user-defined report writer function called RW_NC_GetStatusString. Pass the function the ‘Document Number’ and ‘RM Document Type-All’ fields from the ‘RM Statements Transactions Temp’ table.#
The expression should then look like this:
FUNCTION_SCRIPT( RW_NC_GetStatusString RM_Statements_TRX_TEMP.Document Number RM_Statement_TRX_TEMP.RM Document Type-All )
The new calculated field can now be placed on the report in the Body section.
Lastly, the Microsoft Dynamics GP security must be set to use the modified report. Make sure security is set for the Modified Alternate Microsoft Dynamics GP Reports in the Sales series.
