Our latest articles are listed below
LATEST STORIES
-
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 