LS Central - Discount Offer Priority

 Lowest numbers are highest priority

LS Central - Qty sold not Posted Report

 There is no report available, however, the field QtySold(POS) can be added to the item page using design or an extension

Dynamics NAV – Message “Number of source documents posted: 0 out of a total of 1” when posting a Warehouse Receipt

 Go to warehouse setup, enable stop on first error

Introduction to Azure SQL Deployment and Configuration

https://microsoft.github.io/sqlworkshops/

• IaaS
• VM with SQL
• SSAS and SSIS require their own VM
• PaaS
• Backups are automatic full
• Just SQL Instance
• Includes SQL Agent
• Just SQL DB
• 8tb max size
• Hyperscale required for No maximum size
• Versionless, auto-patches
• Cannot restore a bak file, but can import or use bacpak
• Azure Data studio used to connect to db's instead of SSMS using web interface through azure
• Lift and Shift, can move VHD or import instance to cloud
• Tempdb can be put on local ssd
• General Purpose - General solution
• Business Critical - Local Redundancy
• Database Only - mainly useful for
• Business Apps, Ecommerce, Dev/Test
• Migration
• azure.com/AMP
• aka.ms/datamigration

Business Central - "We paused while you were away" happens too quickly

Nothing to do with timeout.

An Image is missing, images do not transfer via DD, you must import them locally to each POS database from the Retail Image List screen.

A menu button is invalid and setup pointing to an invalid function or image

 Set-NAVWebServerInstanceConfiguration -WebServerInstance BC150 -KeyName SessionTimeout -KeyValue "01:00:00"

Restart-NAVServerInstance [Instance Name]

Restart instance

Powershell script to generate certificate for ADC for 5 years

• Open powershell as administrator
• Run 

 $fqdn = [System.Net.Dns]::GetHostByName(($env:computerName))

New-SelfSignedCertificate -DnsName $fqdn.HostName -CertStoreLocation “cert:\LocalMachine\My”  -NotAfter (Get-Date).AddYears(5)

 

• Start>Manage Computer certificates
• Check for your new certificate in your Personal>Certificate Folder
• copy it to the Trusted Root Certification>Certificates folder
• Right Click>Export>No private key>Der Encoded Binary
• Install the exported certificate on all devices that need access
• Right click on certificate>Details>Copy thumbprint with no spaces
• In the NAV Server Instance>Edit>Paste the thumbprint into the thumbprint field>Save>Restart

Install this certificate on all mobile devices that will connect to BC in the Trusted Root Authority folder 

NAV/BC - Invalid Object Name master.dbo.$ndo.$rsvproperty

 This is because this table has no value in it. It usually stores the license.

If you cannot import a license into it, the best thing to do is reinstall a new instance of BC, or go to an existing BC Database