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.