NAV 2018 CU12 teardown - New Features

Cumulative Update 12 is a major CU realease from Microsoft.

It has a load of new features I will try to cover with this blog post.

VAT Reporting changes

OBJECT Table 740 VAT Report Header; new field 19;Return Period No.;Code20
OBJECT Table 743 VAT Report Setup; multiple new fields 20-29.
OBJECT Table 737 VAT Return Period; new table to hold VAT Return period information.
OBJECT Codeunit 737 VAT Report Mgt.; New codeunit to handle VAT Reporting helper functions.
OBJECT Page 736 VAT Return Period FactBox; new page.
OBJECT Page 737 VAT Return Period List; new page
OBJECT Page 738 VAT Return Period Card; new page

This is the first of the bigger changes in NAV, and very much expected feature, at least in EU area.

Now it is possible to define VAT Report calculation more finely manner, and also use CodeUnits for pre-calculation of VAT Report. This is a change very much needed in EU area. Currently I think every vendor has their own version of VAT calculation, since it is regulatory report required by the tax authorities in EU economy area.
VAT Return Periods have also been brought to menusuite.

Developer/Consultant additions

1) OBJECT Table 823 Name/Value Buffer; new field 4;Value BLOB;BLOB

This allows developers to save data in Blob with Name/Value buffer table. So far I have been forced to create a custome table of my own. Very handy!
This table also has functions to help Blob handling; GetValue and SetValue.

2) OBJECT Table 8613 Config. Package Table; new field 31;Delayed Insert;Boolean

This field is used to define that imported data is validated so it includes both key and non-key values. If this field is not checked, empty fields and/or records that have errors can be inserted.

3) OBJECT Table 9900 Web Service Aggregate

This table has new function "AssertUniquePublishedServiceName" to prevent creation of Web Services with same name.

4) OBJECT Codeunit 42 CaptionManagement

This codeunit has been made SingleInstance. It should make Dimension caption handling quite a lot faster in some environments. Nice addition!

5) OBJECT Table 222 Ship-to Address

This table has a new field 90;GLN;Code13 to enables using of GLN with Ship-to Addresses.
Useful when the customer has multi-site operations and each subsidiary/operation point has a GLN of its own.

6) A lot of new publisher functions, as expected. These will keep coming for some time!

Added Json/OAuth handling

OBJECT Codeunit 1297 Http Web Request Mgt.; This codeunit now has a new internal function InvokeJSONRequest.
OBJECT Table 1140 OAuth 2.0 Setup; This is a new table to hold OAuth related information, screenshot above
OBJECT Codeunit 1140 OAuth 2.0 Mgt.; New codeunit to handle OAuth helper functions.
OBJECT Page 1140 OAuth 2.0 Setup; new page.

This change is HUGE. Now we have a standard way to consume OAuth requests and use json packets as built-in. There is a bunch of json/OAuth related additions in multiple codeunits. It seems that the Setup page is not added to the MenuSuite yet, perhaps this is still functionality under development ?
Nevertheless, this is interesting indeed, I have to give this a better look when I have more time. Or perhaps one or more of the Web Service guru MVP's can have a look?

Performance

OBJECT Codeunit 42 CaptionManagement

This codeunit has been made SingleInstance. It should make Dimension caption handling quite a lot faster in some environments. Nice addition!
There is also some other performance related changes, for example discount calculation on Sales Header and Sales Lines have been moved from the pages to tables. This also makes the code more readable. Me gusto!

PEPPOL BIS 3.0 support

OBJECT Codeunit 1610 Exp. Sales Inv. PEPPOL BIS3.0
OBJECT Codeunit 1611 Exp. Sales CrM. PEPPOL BIS3.0
OBJECT Codeunit 1612 Exp. Serv.Inv. PEPPOL BIS3.0
OBJECT Codeunit 1613 Exp. Serv.CrM. PEPPOL BIS3.0
OBJECT XMLport 1610 Sales Invoice - PEPPOL BIS 3.0; This includes both Sales Invoice and Service Invoice
OBJECT XMLport 1611 Sales Cr.Memo - PEPPOL BIS 3.0; This includes both Sales Credit Memo and Service Credit Memo

Peppol now supports also BIS3.0 standard messages. Nice!

Prepayment auto-update setting

OBJECT Table 311 Sales & Receivables Setup; new field 33;Prepmt. Auto Update Frequency;Option[Never,Daily,Weekly]
OBJECT Table 312 Purchases & Payables Setup; new field 33;Prepmt. Auto Update Frequency;Option[Never,Daily,Weekly]
OBJECT Codeunit 383 Upd. Pending Prepmt. Sales
OBJECT Codeunit 384 Upd. Pending Prepmt. Purchase
OBJECT Codeunit 441 Prepayment Mgt.

These tables have new field: 33;Prepmt. Auto Update Frequency;Option[Never,Daily,Weekly]
Setting this to Daily/Weekly creates and starts a Job Queue entry Card that uses new codeunit and function in CU441 to update pending Prepayments.

Edit: Fix typos, remove duplicate texts

Comment List
Anonymous
Related
Recommended