btamulis 3/4/2024 11:35:46 AM

Navigation List SQL Error - troubleshoot

Okay - 

Does anybody know what SQL Table could be causing this SQL Error when we click on the Receivable Transactions Navigation List?

It's the middle of business day and month end so I can't easily create a dex log or perform a SQL trace. 

I checked all the obvious RM tables - RM00101 - RM20101 and RM30101 and have no records with a NULL Customer Number. 

Has anybody seen this before and have some advice for me to troubleshoot it? GP seems to be doing some query and trying to populate a tempTable with the data from the query(?)

 

Version: All
Section: Dynamics GP, SQL Scripts


Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3