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