Our latest articles are listed below
LATEST STORIES
-
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
-
Dynamics GP – Cannot insert the value NULL into column ‘ORTRXAMT’
When enquiring on a debtor account using the “Receivables Transaction Enquiry” window I was prompted with the error below: When I clicked OK I received the following error message: After clicking OK no transactions are displayed in the enquiry window? Hoping this was a one off I checked another debtor and received the exact same… Read more
-
Warehouse Shipment – The record you tried to open is not available. The page will close or show the next record
While testing the process of creating warehouse shipments I stumbled across an interesting issue. After creating the warehouse shipment from the sales order, I was presented with the message below: Success! I’ve created the warehouse shipment. I clicked OK but was then presented with the message below: Hmmm. Something isn’t right. I’ve created warehouse shipments… Read more
Subscribe
Sign up to be notified with any new blog posts.
thedynamicsexplorer.com 