
We have an un-posted invoice that has a invalid DocStatus.
What tables in SQL would this be located?
Hi TMG,
From your screenshot it looks like you have GPPT installed in your Dynamics GP environment..
I'd make use of the DEXSQL trace capability on-the-go to help you tackle down this error.
Simply press <CTRL-SHFT-9> before clicking on the Save button, and then when the pop-up showed up, click OK, and then <CTRL-SHFT-10> to stop the DEXSQL trace.
The trace log file can then be found in the folder where GPPT saves the debugging information (by default this would be under the Data folder in the local GP program folder, but it can be configured to save files on the network too).
The header information for the Sales orders is stored in SOP10100, but it's likely that some other task is interfering with your entry, since this is a very unusual error message.
Do you know if there are any customizations attached to this form, like VBA code or else ? any integration from the back-door ?
PS: press CTRL-D to open the GPPT control center and click on the blue link "Manual Logging Mode" to open directly the folder where the DEXSQL trace file was saved.