PXSelect Vs PXSelectReadonly

Hello everybody,

today I want to share with you important difference between PXSelect  and PXSelectReadonly.

In my project I had the following situation. PXSelect of table name didn't give me what actually was in db. After a long research I found PXSelectReadonly and key difference is that PXSelectReadonly reads directly from db without usage of Acumatica Cache. 

Ready to optimize your Acumatica development projects? If you’ve ever faced challenges with data retrieval or caching, like the differences between PXSelect and PXSelectReadonly, it might be time to explore custom solutions tailored to your needs. Share your unique requirements with us, and let’s build the perfect customization to streamline your workflows. Leave a customization request today and take your Acumatica experience to the next level!