Skip to main content
Submitted by Suzanne Scanlan on 26 March 2021

ArcherPoint Dynamics NAV / Business Central Developer Digest - Vol 337

In this edition of Developer Digest, we share cumulative updates for NAV and Business Central, the return of the Complex return type in C/AL and AL, the availability of SQL 2019 Report Builder, and updating per-tenant and AppSource extensions.

The Dynamics NAV and Business Central community, including the ArcherPoint technical staff, is made up of developers, project managers, and consultants who are constantly communicating, with the common goal of  sharing helpful information with one another to help customers be more successful.

As they run into issues and questions, find the answers, and make new discoveries, they post them on blogs, forums, social media...so everyone can benefit. We in Marketing watch these interactions and never cease to be amazed by the creativity, dedication, and brainpower we’re so fortunate to have in this community—so we thought, wouldn’t it be great to share this great information with everyone who might not have the time to check out the multitude of resources out there? So, the ArcherPoint Microsoft Dynamics NAV Developer Digest was born. Each week, we present a collection of thoughts and findings from NAV/BC experts and devotees around the world. We hope these insights will benefit you, too.


Cumulative Updates for Microsoft Dynamics NAV and 365 Business Central – March 2021

Here are links for the March 2021 cumulative updates:

Dynamics NAV:

⦁    Dynamics NAV 2016 (Build 52121)
⦁    Dynamics NAV 2017 (Build 30477)
⦁    Dynamics NAV 2018 (Build 46609)

Business Central:

⦁    Business Central 2019 Wave 2 (Update 15.16)
⦁    Business Central 2020 Wave 1 (Update 16.11)
⦁    Business Central 2020 Wave 2 on-premises (Update 17.5)

The Return of the Complex Type

Saurav informs: “From Github: Return of the Complex Type: C/AL and AL have always had a limited set of possible return types for procedures. Only simple types could be returned, but this is now changing. From Business Central 2021 Wave 1, most types can be returned from procedures—both user-defined types and most built-in types.”

SQL 2019 Report Builder Now Available

Kyle says: “A SQL 2019 version of Report Builder is now available. It executes an in-place upgrade of the 2016 version that comes with Business Central. So far, I can't tell any difference at all, which is a little disappointing since I was hoping for some new features like Copy Formatting from one cell to another."

BCInsider Key Expires April 1

No joke - the Microsoft Dynamics 365 Business Central insider key expires April 1 - as shared by Freddy Kristiansen on Twitter - get your new key on the Microsoft PartnerSource website.

It’s Time to Update Your Per-Tenant and AppSource Extensions

Saurav shares: “It is time to update per-tenant (PTE) and AppSource extensions, but only if you are allowing warnings in your extensions. There are two measured changes to look at: 

  • Did you use the TempBlob Record in your extension?
  • Is your customer using the ID field for API Calls?

You only have 2 months for SaaS and for on-premises; the next upgrade will fail the extension. Below is a list of every object in base Microsoft which will have something  converted to error starting in version BC 18." 

  • AccountEntitySetup.Table.al 
  • ApplicationAreaSetup.Table.al 
  • AzureMachineLearningUsage.Table.al 
  • BankAccount.Table.al 
  • BankAccountPostingGroup.Table.al 
  • BankDataConvBank.Table.al 
  • BankDataConversionPmtType.Table.al 
  • BankDataConvServiceSetup.Table.al 
  • BatchProcessingParameterMap.Table.al 
  • CashFlowSetup.Table.al 
  • CompanyInformation.Table.al 
  • Contact.Table.al 
  • CortanaIntelligence.Table.al 
  • CortanaIntelligenceUsage.Table.al 
  • CountryRegion.Table.al 
  • CRMConnectionSetup.Table.al 
  • Currency.Table.al 
  • Customer.Table.al 
  • DataClassNotifSetup.Table.al 
  • DeferralPostBuffer.Table.al 
  • Dimension.Table.al 
  • DimensionValue.Table.al 
  • EmailAttachment.Table.al 
  • Employee.Table.al 
  • EncryptedKeyValue.Table.al 
  • ExperienceTierSetup.Table.al 
  • ExtTxtIDIntegrationRecord.Table.al 
  • FixedAsset.Table.al 
  • GeneralLedgerSetup.Table.al 
  • GenJournalBatch.Table.al 
  • GenJournalLine.Table.al 
  • GLAccount.Table.al 
  • GraphMailSetup.Table.al 
  • ImageAnalysisSetup.Table.al 
  • IncomingDocument.Table.al 
  • IncomingDocumentAttachment.Table.al 
  • IntegrationRecord.Table.al 
  • IntegrationRecordArchive.Table.al 
  • IntegrationRecordManagement.Codeunit.al 
  • Item.Table.al 
  • ItemCategory.Table.al 
  • ItemJournalLine.Table.al 
  • ItemLedgerEntry.Table.al 
  • Job.Table.al 
  • JournalLinesEntitySetup.Table.al 
  • LotNumbersbyBinBuffer.Table.al 
  • MSEventEmitterEventCodes.Table.al 
  • MSPayPalStandardAccount.Table.al 
  • MSPayPalStandardTemplate.Table.al 
  • MSPayPalTransaction.Table.al 
  • MSQBOCustomer.Table.al 
  • MSQBOFailedSyncs.Table.al 
  • MSQBOInvoice.Table.al 
  • MSQBOItem.Table.al 
  • MSQBOModifiedFieldList.Table.al 
  • MSQBOSetup.Table.al 
  • MSQBOStartSyncService.Table.al 
  • MSQBOSyncBuffer.Table.al 
  • MSQBOSynchronizationError.Table.al 
  • MyAccount.Table.al 
  • NonstockItem.Table.al NotificationEntry.Table.al NotificationSetup.Table.al 
  • O365DeviceSetupInstructions.Table.al 
  • O365SalesDocument.Table.al 
  • OfficeContactAssociations.Table.al 
  • olddiotconcept.table.al 
  • olddiotconceptlink.table.al 
  • olddiotcountryregiondata.table.al 
  • olddiotreportbuffer.table.al 
  • olddiotreportvendorbuffer.table.al 
  • PACWebService.Table.al 
  • PaymentMethod.Table.al 
  • PaymentTerms.Table.al 
  • ProductGroup.Table.al 
  • ProfileResourceImportExport.Table.al 
  • PurchaseHeader.Table.al 
  • PurchaseLine.Table.al 
  • PurchaseLineArchive.Table.al 
  • PurchasesPayablesSetup.Table.al 
  • PurchCrMemoLine.Table.al 
  • PurchInvHeader.Table.al 
  • PurchInvLine.Table.al 
  • PurchRcptLine.Table.al 
  • RequisitionLine.Table.al 
  • Resource.Table.al 
  • ReturnReceiptLine.Table.al 
  • ReturnShipmentLine.Table.al 
  • SalesCrMemoHeader.Table.al 
  • SalesCrMemoLine.Table.al 
  • SalesHeader.Table.al 
  • SalesHeaderArchive.Table.al 
  • SalesInvoiceEntityAggregate.Table.al 
  • SalesInvoiceHeader.Table.al 
  • SalesInvoiceLine.Table.al 
  • SalesLine.Table.al 
  • SalesLineArchive.Table.al 
  • SalesQuoteEntityBuffer.Table.al 
  • SalesReceivablesSetup.Table.al 
  • SalesShipmentLine.Table.al 
  • SBOwnerCue.Table.al 
  • ServiceCrMemoLine.Table.al 
  • ServiceInvoiceLine.Table.al 
  • ServiceLine.Table.al 
  • ServicePassword.Table.al 
  • ServiceShipmentLine.Table.al 
  • ShipmentMethod.Table.al 
  • StandardItemJournalLine.Table.al 
  • TaxArea.Table.al 
  • TaxGroup.Table.al 
  • TempBlob.Table.al 
  • TimeSheetDetail.Table.al 
  • TransferLine.Table.al 
  • TransferReceiptLine.Table.al 
  • TransferShipmentLine.Table.al 
  • UnitofMeasure.Table.al 
  • UserSecurityStatus.Table.al 
  • VATBusinessPostingGroup.Table.al 
  • VATClause.Table.al 
  • VATEntry.Table.al 
  • VATPostingSetup.Table.al 
  • VATProductPostingGroup.Table.al 
  • VATReportSetup.Table.al 
  • Vendor.Table.al 
  • XMLBuffer.Table.al 
  • HeadlineRCAccountant.Table.al 
  • HeadlineRCAdministrator.Table.al 
  • HeadlineRCBusinessManager.Table.al 
  • HeadlineRCOrderProcessor.Table.al 
  • HeadlineRCProdPlanner.Table.al 
  • HeadlineRCProjectManager.Table.al 
  • HeadlineRCRelationshipMgt.Table.al 
  • HeadlineRCSecurityAdmin.Table.al 
  • HeadlineRCServDispatcher.Table.al 
  • HeadlineRCTeamMember.Table.al 
  • HeadlineRCWhseBasic.Table.al 
  • HeadlineRCWhseWMS.Table.al 
  • HeadlineRCWhseWorkerWMS.Table.al 
  • JobQueueEntry.Table.al 
  • JobQueueLogEntry.Table.al 
  • BusinessSetup.Table.al”

It might be time to get busy coding!

If you are interested in Dynamics NAV and Business Central development, be sure to see our collection of NAV/BC Development Blogs.

Read the "How To" blogs from ArcherPoint for practical advice on using Microsoft Dynamics NAV and Dynamics 365 Business Central.