SQL Function to Remove Alphanumeric Characters – azurecurve

Ian Grieve gives us a SQL Function to Remove Alphanumeric Characters at www.azurecurve.co.uk/2019/05/sql-function-to-remove-alphanumeric-characters/

Advertisements

Dynamics GP – Your login failed because of a database error. Contact your system administrator for assistance – The Dynamics Explorer

Recently The Dynamics Explorer encountered an issue when a user was attempting to login to Dynamics GP. After entering their user name and password they were receiving the error below which prevented access: Your login failed because of a database error. Contact your system administrator for assistance. Learn more at:
thedynamicsexplorer.com/2019/05/15/dynamics-gp-your-login-failed-because-of-a-database-error-contact-your-system-administrator-for-assistance/

Microsoft Dynamics GP Payables Transaction Entry Distribution Template – iSolutions Partners

iSolutions has a cool customization for Microsoft Dynamics GP Payables Transaction Entry Distribution Template. Check out more at: www.isolutionspartners.com/2019/05/13/microsoft-dynamics-gp-payables-transaction-entry-distribution-template/

Dynamics GP – Cannot insert the value NULL into column ‘ORTRXAMT’ – The Dynamics Explorer

From Gavin Whittaker: When enquiring on a debtor account using the “Receivables Transaction Enquiry” window I was prompted with the error below: Cannot insert the value NULL into column ‘ORTRXAMT’ When I clicked OK I received the following error message: The stored procedure rmTransactionInquiry returned the following results: DBMS: 515, Microsoft Dynamics GP: 0
— Read on thedynamicsexplorer.com/2019/05/02/dynamics-gp-cannot-insert-the-value-null-into-column-ortrxamt/

This Workflow Is Locked By Another User And Cannot Be Edited – azurecurve

This Workflow Is Locked By Another User And Cannot Be Edited. Find out how Ian unlocked it at www.azurecurve.co.uk/2019/05/this-workflow-is-locked-by-another-user-and-cannot-be-edited/

Dynamics GP – 4 Steps to help reconcile General Ledger to Receivables or Payables – The Dynamics Explorer

Its month end and when you come to reconcile the General Ledger control accounts to Receivables or Payables there’s a difference! You check all the usual things like unposted General Ledger batches or manual journals that may have been inadvertently posted to a control account, but this proves fruitless. So where do you start from there? Checkout this post from Microsoft for details:
thedynamicsexplorer.com/2019/05/02/dynamics-gp-4-steps-to-help-reconcile-general-ledger-to-receivables-or-payables/