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 error?
After pondering for a while, I realized the clue was in the first error message. The column “ORTRXAMT” is mentioned in the error and I know this client doesn’t use multi-currency management. Therefore I assume at some point they have managed to toggle the currency view to “Originating”.
I therefore clicked “View > Currency” to see which currency display option was selected but the option is greyed out:
At this point I tried various key combinations while holding down CTRL and found CRL+U toggles back to the functional currency display and the transactions appeared!
For those interested CTRL+O toggles back to Originating currency and CTRL+R toggles to the Reporting currency.
Thanks for reading
The Dynamics Explorer 
2 thoughts on “Dynamics GP – Cannot insert the value NULL into column ‘ORTRXAMT’”