Blogs

Hi PowerAppers! PowerApps Canvas Apps Components remain one of those features that seem to have endless possibilities. I have, for quite some time now, been working with the Google Maps API in many of my applications to return a static image pointing to a specific location on the map. As I moved from application to application, I noticed that I always ended up doing the same operations: format a label with a string representing…

Ian Grieve offers SQL to Add Company Access Back to sa User — Read on www.azurecurve.co.uk/2019/06/add-company-access-back-to-sa-user/ Read the full text.

Ian Grieve answers the tough questions like: Is there a POP Historical Received Not Invoiced Report Available? (hint: yes) — Read on www.azurecurve.co.uk/2019/05/is-there-a-pop-historical-received-not-invoiced-report-available/ Read the full text.

When upgrading to GP 2018 R2 you may have to add back the letter writing templates. — Read on thedynamicsexplorer.com/2019/05/20/dynamics-gp-letter-writing-assistant-letter-templates-missing-following-upgrade-to-dynamics-gp-2018-r2/ Read the full text.

I couldn’t resist. Here is the link to the original: https://dilbert.com/strip/2019-05-25 Read the full text.

From the ERP Software Blog, fix an already posted entry: www.erpsoftwareblog.com/2019/05/dynamics-gp-how-do-you-correct-an-entry-that-is-already-posted/ Read the full text.

So far, I have covered the process of setting up both the Microsoft Dynamics 365 BC containerized application components, along with the VS Code IDE and AL language extensions. We also built the "Hello World" extension on BC's Customer List page and deployed it to our container by following some simple debugging steps. You can read more about it in the following articles: #MSDYN365BC: Building a Development Environment…

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

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…

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/ Read the full text.

Ian Grieve has help to Find Table in All Microsoft Dynamics GP Databases Read more at: www.azurecurve.co.uk/2019/05/find-table-in-all-microsoft-dynamics-gp-databases/ Read the full text.

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…

Ian Grieve has a SQL Script to Delete Unused Segments at www.azurecurve.co.uk/2019/05/sql-script-to-delete-unused-segments/ Read the full text.

Jen Kuntz has a SmartList stuck on My Reports pane jenkuntz.ca/2019/05/smartlist-stuck-on-my-reports-pane/ Read the full text.

Ian gives us a SQL Script to Insert Vendors at www.azurecurve.co.uk/2019/05/sql-script-to-insert-vendors/ Read the full text.

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/ Read the full text.

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…

I’ve got long history with iSolutions on this blog so it’s cool to see their new product, Dynamics GP Credit card processing directly inside of your ERP system for simple, safe and secure, real-time electronic payment processing. Details at: www.isolutionspartners.com/2019/05/10/dynamics-gp-credit-card-processing-with-cardconnect/ Read the full text.

The GP team has help for dealing with Timeout errors in Microsoft Dynamics GP – Microsoft Dynamics GP Community at community.dynamics.com/gp/b/dynamicsgp/archive/2019/04/30/dealing-with-timeout-errors-during-year-end-closing-procedures Read the full text.

For those of you who don’t know, in addition to a pile of GP books, I’ve written a couple of novels. One of them, Woodbooger, is a bigfoot tale. Writing in Adventure Journal recently, Laura Kranz explains why  Why We Need Bigfoot, Even if it isn’t Real. It’s a nice read and great exploration of the importance of bigfoot on our collective psyche. Of course, what happens if bigfoot IS real? I mean, if you can’t believe…