Dynamics GP - GP crashes when VBA mods are present when trying to send e-mail using Office 365 Outlook ProPlus after version 1808

https://community.dynamics.com/gp/b/dynamicsgp/posts/dynamics-gp-crashes-closes-when-emailing-after-office-update

Office ProPlus versions
https://www.msoutlook.info/question/200
https://docs.microsoft.com/en-us/officeupdates/update-history-office365-proplus-by-date

Version Numbers

Outlook 97	8.0
Outlook 98	8.5
Outlook 2000	9.0
Outlook XP/2002	10.0
Outlook 2003	11.0
Outlook 2007	12.0
Outlook 2010	14.0
Outlook 2013	15.0
Outlook 2016	16.0
Outlook 2019	16.0
Office 365	16.0

Original Method
https://superuser.com/questions/1380385/how-to-downgrade-office-365

• This will downgrade to Outlook ProPlus, version 1808, version and build 16.0.10730.20380
• Set account to Semi Annual channel
• https://docs.microsoft.com/en-us/office365/troubleshoot/administration/switch-channel-for-office-365

Download the Office Deployment Tool.

• Install and extract it to a ODT folder in Desktop. It contains two files: Setup.exe and Configuration.xml.
• Open Configuration.xml file, edit it with the following text, then save it as a new file RevertOffice.xml in the same folder of Setup.exe:
<Configuration> <Updates Enabled="TRUE" TargetVersion="16.0.10730.20380" /> </Configuration>
4. In Windows, click Start, search for cmd, right-click Command Prompt, click Run as Administrator.
5. Switch to the file location for the Setup.exe file. For example, type cd C:\Users\Administrator\Desktop\ODT
6. Run the following command: setup.exe /configure RevertOffice.xml
7. Start Word 2016, go to File > Account, under Product Information, click Update Options > Update Now.
8. Check if the Office is reverted to your targeted version.
9. Disable Office Update to avoid it update to higher version: In Word 2016, click File > Account, under Product Information, click Update Options > Disable Updates.

Note: Even after doing the downgrade, there will be no visible indication that outlook has been downgraded.

Simply try to send your e-mail from GP and see if that works.

NAV-"There is no value entry in the filter" after posting sales invoice or any inventory transaction

• Review Item Ledger Entries, 
• Confirm that each item ledger entry has a corresponding value entry
• If not, you must insert a value entry for the appropriate item ledger entry that is missing a line

GP - A get/change operation on table 'ivexceptiondays' failed accessing sql data. Conversion failed when converting date and/or time from character string.

SQL Profiler shows an error like this

exec TWO.dbo.zDP_IV41001SS_1 '-4714.11.25'

SELECT TOP 25 EXCEPTIONDATE,DATETYPE,DEX_ROW_ID FROM TWO.dbo.IV41001 WHERE EXCEPTIONDATE = '-4714.11.25' ORDER BY EXCEPTIONDATE ASC

Most likely this stock count was imported, or marked as verified using an sql script or some external method that did not set the Countdate and counttime on the stock count lines.

Run these scripts to set a proper date and time, update with the values you need. Add filters if you have a specific count only.

update iv10301 set countdate = '2019-09-23 00:00:00.000'
update iv10301 set counttime = '1900-01-01 06:51:16.000'

NAV - Service Orders vs Service Contracts

• Service Orders 
• Used to record costs, labor, parts, inventory, fees associated with repairing a Service Item
• Eg. Repairing a Photo Copier
• Can be connected to a service contract, but is informational only. Does not affect the Service Contract Cost or Value in any way.
• Posting a service order can occur in three stages, ship, invoice, consume
• An invoice appears on the customer's AR as any other invoice
• Service contracts
• Used to record the monthly cost and selling price of a Service Item to a customer
• Only Items with a type of "Inventory"
• You cannot use items with a type of service or non-inventory
• Can be for a specific Service Item with a serial number, or a generic item
• Eg. Monthly rental of a photo copier

NAV - Service Items vs Item Type Service

• Items with the item type "Service" do not track inventory and can be used on purchase and sales orders.
• They CANNOT be used one Service contracts
• They do not generate Item Ledger Entries
• Service Items represent a piece of equipment at a customer's location, or under contract for a customer
• It can also be a generic item not assigned to any specific customer

Dynamics GP SQL - Cannot connect ODBC on instance name, connects on IP address only

Reload the DNS

NAV / BC - How to copy a company

• Companies>Copy
• Copies entire company
• Companies>New
• Blank new company