What happens when a report runs

When a Report Runs,
When you initiate the report run, the OnInitReport trigger is called. This trigger performs any processing that is necessary before the report is run. It can also stop the report. If the OnInitReport does not end the processing of the report, the request form for the report is run, if it is defined. Here, you select the options that you want for this report. You can also decide to cancel the report run. If you decide to continue, the OnPreReport trigger is called. At this point, no data has yet been processed. When the OnPreReport trigger has been executed, the first data item is processed provided that the processing of the report was not ended in the OnPreReport trigger.
When the first data item has been processed, the next data item, if there is any, is processed in the same way. When there are no more data items, the OnPostReport trigger is called to do any necessary post processing, for example, removing temporary files.
How a Data Item is Processed
Before the first record is retrieved, the OnPreDataItem trigger is called, and after the last record has been processed, the OnPostDataItem trigger is called.
Between these two triggers, the data item records are processed. Processing a record means executing the record triggers and outputting sections. C/SIDE also determines whether the current record should cause the outputting of a special section, such as a header, footer, group header or group footer.
If there is an indented data item, a data item run is initiated for this data item (data items can be nested 10 levels deep).
When there are no more records to be processed in a data item, control returns to the point from which processing was initiated. For an indented data item, this means the next record of the data item on the next highest level. If the data item is already on the highest level indentation is zero control returns to the report.

issue while upgrading Navision 2013 to Navision 2015

We faced an issue while upgrading Navision 2013 to Navision 2015 with one of our client.

The issue with the fields Amount and Amount (LCY) in the Vendor Ledger Entry and Customer Ledger Entry and its value is not get updated after the upgrade process.

Hence, Issue reflects in the Customer Detailed Trail balance and Vendor Detailed Trail Balance Reports.    

Reason

In 2015, Microsoft includes a Boolean field named as Ledger Entry Amount in both Detailed Vendor Ledger Entry and Detailed Customer Ledger Entry and this field gets updated on every new record entry on both the tables except the record with the "Entry Type" as Application or Appln. Rounding. 

The flow field filters of the fields Amount and Amount (LCY) is based on the above Ledger Entry amount field in Navision 2015 (But not in Navision 2013, 2013 R2). So there is no way to update the values for the fields Amount and Amount (LCY) for the records which has upgraded from Navision 2013.              

Solution

To update the values for the field Ledger Entry Amount in both the tables, we should write a processing only report with the Data items as Detailed Customer Ledger Entry and Detailed Vender Ledger Entry with the Data Item filter as "Entry Type" with values

Initial Entry|Unrealized Loss|Unrealized Gain|Realized Loss|Realized Gain|Payment Discount|'Payment Discount (VAT Excl.)'|'Payment Discount (VAT Adjustment)'|Payment Tolerance|Payment Discount Tolerance|'Payment Tolerance (VAT Excl.)'|'Payment Tolerance (VAT Adjustment)'|'Payment Discount Tolerance (VAT Excl.)'|'Payment Discount Tolerance (VAT Adjustment)'|Correction of Remaining Amount.

Please aware of the above issue while upgrading lower versions of Navision into Navision 2015.

There is one more issue regarding the same on the Report 595 in Navision 2015 , but i hope it gets fixed in the Cumulative updates of Navision 2015.


Article Source: JayaMurugan.P, Technical Consultant, CETAS Information Technology, Chennai

How to Open the RoleTailored Client in Configuration Mode

To configure a profile, you must open the RoleTailored client in configuration mode. 

When you open the Role Tailored client in configuration mode, you can make changes to a Role Center. These changes then become part of the Role Tailored client for users assigned to the profile associated with the Role Center.

To open the Role Tailored client in configuration mode, follow the below steps:

Step 1: Open command prompt

Step 2: Navigate to the root folder of the Role Tailored client.

Example: CD C:\Program Files (x86)\Microsoft Dynamics NAV\80\RoleTailored Client

Step 3: Type the following command.

Microsoft.Dynamics.Nav.Client.exe -configure -profile:profile-id

Example:

Microsoft.Dynamics.Nav.Client.exe -configure -profile:"Accounting Manager"