What is the purpose of DYNAMICS.DBO.gpCustomerPOSetup?

(0) Share

Report

Posted on by Richard Wheeler

75,730

What is the purpose of DYNAMICS.DBO.gpCustomerPOSetup? I just completed a GP 2013 to GP 2018 R2 upgrade and I watched as a user was sitting on the SOP Transaction Entry screen and went to the Sales Customer Detail Entry screen. As soon as the user entered a PO number and tried to move off this field they would get a message about this table not existing. Upon checking in SSMS it was indeed missing so I created and populated it. The bigger question is what is the purpose of this table? They would not get this message if they entered a PO number on the SOP Transaction Entry screen.

*This post is locked for comments

All responses (2)

Answers (0)

Richard Wheeler 75,730 on at

Like (0)

Report

RE: What is the purpose of DYNAMICS.DBO.gpCustomerPOSetup?

Thank you, Derek. I always include PSTL as part of every GP installation. Somehow it did not get created in this case.
Derek Albaugh on at

Like (0)

Report

RE: What is the purpose of DYNAMICS.DBO.gpCustomerPOSetup?

It is a system table for the Professional Services Tools Library (PSTL).

'gpCustomerPOSetup' is the physical, display and technical name of that table.

If you have PSTL installed, it could be a procedure is running and making a check of this table, but not finding it, thus the error.

Thanks