Navigation List Error: “Cannot insert the value NULL into column ‘VENDNAME'”

8 thoughts on “Navigation List Error: “Cannot insert the value NULL into column ‘VENDNAME'””

1. Pingback: Navigation List Error: “Cannot insert the value NULL into column ‘VENDNAME'” - Microsoft Dynamics GP Community
2. Pingback: DynamicAccounting.net | Navigation List Error: “Cannot insert the value NULL into column ‘VENDNAME’” | azurecurveNavigation List Error: “Cannot insert the value NULL into column ‘VENDNAME’” | azurecurve -
3. Pingback: Navigation List Error: “Cannot insert the value NULL into column ‘VENDNAME’” | azurecurve - Microsoft Dynamics GP Community
4. Pingback: Interesting Findings & Knowledge Sharing » Navigation List Error: “Cannot insert the value NULL … – azurecurve
5. Pingback: what essential oils are good for depression
6. Pingback: essential oils for dog anxiety
7. BBESS says:

   11th September 2018 at 19:22

   How do you “look for transactions which are not correctly linked to a record in PM Creditor MSTR (PM00200)”?

   Reply
8. Ian Grieve says:

   11th September 2018 at 21:01

   Hi BBESS,

   I’ve just written the below script and tested in the Fabrikam sample company:

   CREATE VIEW uv_AZRCRV_GetMissingVendors AS
   /*
   Created by Ian Grieve of azurecurve|Ramblings of a Dynamics GP Consultant (http://www.azurecurve.co.uk)
   This code is licensed under the Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0 Int).
   */
   SELECT
   	['Vendors'].*
   FROM
   	(
   	SELECT
   		['PM Key Master File'].VENDORID
   	FROM
   		PM00400 AS ['PM Key Master File'] WITH (NOLOCK)
   	UNION
   		SELECT
   			['PM Transaction WORK File'].VENDORID
   		FROM
   			PM10000 AS ['PM Transaction WORK File'] WITH (NOLOCK)
   		UNION
   			SELECT
   					['PM Transaction OPEN File'].VENDORID
   				FROM
   					PM20000 AS ['PM Transaction OPEN File'] WITH (NOLOCK)
   				UNION
   					SELECT
   							['PM Paid Transaction History File'].VENDORID
   						FROM
   							PM30200 AS ['PM Paid Transaction History File'] WITH (NOLOCK)
   	) AS ['Vendors']
   LEFT JOIN
   	PM00200 AS ['PM Vendor Master File'] WITH (NOLOCK)
   		ON
   			['Vendors'].VENDORID = ['PM Vendor Master File'].VENDORID
   		WHERE
   			['PM Vendor Master File'].VENDORID IS NULL
   GO
   GRANT SELECT ON uv_AZRCRV_GetMissingVendors TO DYNGRP
   GO
   

   Reply