Restrict Data Accessibility using Generic Inquries

Hi Everyone, In this article I want share with you one more idea of how can you use Acumatica Generic Inquires. Generic Inquires in Acumatica is key part of reporting and have plenty of usage examples: Notifications Using GI Environment Related Parameters Integration with OData Consolidation Reports And many others. Today I would like to add here scenario with restricting access right to data based on custom filtering conditions in the Generic Inquiry.   Lets assume we have two departments who is using opportunities for Products and Services. But we would like to disallow them see opportunities of each other.   Acumatica does not have data level security for opportunities,… Read more

Mirror Mobile Screen on Computer

Hi Everyone, Today want to share with you some tips on how to share your mobile screen with Acumatica to PC. That is really useful when you want to share great Acumatica mobile application with your customers. Mobizen  URL: https://www.mobizen.com Type: Free Platform: Android Internet connection is required. Free application that uses internet connection to share Android screen to your PC. Internet conenction is required. Here you can read how to configure local Acumatica instance to use it with mobile   TeamViewer QuickSupport  URL: https://www.teamviewer.com/en/download/android/ Mobile App: https://play.google.com/store/apps/details?id=com.teamviewer.quicksupport.market Free for non commercial use Platform: Android Internet connection is required TeamViewer Quick Support allows you to connect from your PC to mobile and control… Read more

SQL In <> Operator in BQL

Hi There, Today want to show you example of amazing and very new BQL Operator – In<>. This operator was added just recently with Acumatica version 2017R2, so now you can pass there an array of values and Acumatica core will convert it to SQL IN ( … ) statement. Here is a code example: Object[] values = new String[] { “AC”, “IN” }; InventoryItem item = PXSelect<InventoryItem,        Where<InventoryItem.itemStatus, In<Required<InventoryItem.itemStatus>>>>.Select(Base, values); Console.WriteLine(item.Descr); This will be converted to following SQL Select * from InventoryItem InventoryItem Where InventoryItem.Status In (‘AC’, ‘IN’) Order by InventoryItem.InventoryCD Please note that In<> operator is available only with Required<> parameter and you need to pass array of possible values manually to Select(…) method parameters. Have… Read more

Acumatica Framework API Reference Guide has been Published

Dear Developer, I’m are happy to announce that Acumatica team has updated descriptions of all Acumatica Framework core classes and methods as part of new Acumatica Development Reference Library. All of them are located in one place now: Acumatica xRP Reference Guide The content is collected directly from the Acumatica code and presented in a clear and concise way. You can easily find the needed information and code examples, which you can use in your customization and custom solutions. Please let me know if you have any questions or other suggestions!