Our latest articles are listed below
LATEST STORIES
-
Dynamics GP – You cannot receive against unauthorized purchase orders
I’ve seen this error message crop up a few times. It occurs when you try to receive a Purchase Order in Receiving Transactions Entry and you are presented with the message below even though “Purchase Order Approvals” hasn’t been activated in the “Purchase Order Enhancement” module As mentioned in several articles online it can be… Read more
-
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
Subscribe
Sign up to be notified with any new blog posts.
thedynamicsexplorer.com 