Our latest articles are listed below
LATEST STORIES
-
Dynamics GP – Identify who deleted a batch using the SQL transaction log
Introduction On occasion a batch can be accidentally deleted from the system, and for one reason or another it would be interesting to find out which user did this. In this post I aim to show how this might be possible using some SQL functions to query the SQL transaction log. (I appreciate there are… Read more
-
Dynamics NAV \ Business Central – Thoughts on the Direct Costs Applied and Purchases Accounts
Background One thing I’ve noticed when posting Purchase Invoices with Inventory items in Dynamics NAV \ Business Central are the additional distributions to the Direct Cost Applied and Purchases accounts? I’ve never been quite sure what the Direct Cost Applied account is, and when I’ve looked into it, I can’t find much information out there… Read more
-
Dynamics GP – Letter Writing Assistant – Letter Templates missing following upgrade to Dynamics GP 2018 R2
Following a recent client upgrade of Dynamics GP to version 2018 R2 I found that when selecting “Write Letters > Print Debtors” the window was blank: I opened the C:\Program files (x86)\Microsoft Dynamics\GP2018R2\Data\DEX.INI file to find the Letters Directory location and when I checked each sub folder in this shared folder the word documents (.DOC… Read more
-
Dynamics NAV \ Business Central – An observation with G\L Registers, Source Codes and Inventory Transactions.
Background As I’ve mentioned previously I mainly come from a Dynamics GP background. Recently I’ve been posting transactions in Dynamics NAV \ Dynamics 365 Business Central and trying to follow things through to the General Ledger entries as I try and piece together how the system works. Why two G\L Registers? When you post a… Read more
-
Dynamics GP – Your login failed because of a database error. Contact your system administrator for assistance
Recently I 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: On this occasion I found to fix the issue I had to remove the users login from the ACTIVITY and SY00800 tables in the… Read more
-
Dynamics GP – 4 Steps to help reconcile General Ledger to Receivables or Payables
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 to… Read more
Subscribe
Sign up to be notified with any new blog posts.
thedynamicsexplorer.com 