Recommendations for the Data Queries

For optimal results, follow these recommendations when you create each data query for which you want to configure push notifications:

• Do not use aggregation and grouping in the query; MYOB Acumatica does not guarantee that push notifications will work correctly with such queries.
• Do not use joins of multiple detail tables in the query because this may cause the system to hang.
• If you need to join multiple tables, use a left join or an inner join in the data query. If you use an inner join, the query execution may be slower than for a left join.
• Use as simple a data query as possible.
• For a query defined by using a generic inquiry, do not use a formula on the Results Grid tab of the Generic Inquiry (SM208000) form.
• For a query defined by using a generic inquiry, do not use description fields of selectors on the Results Grid tab of the Generic Inquiry form. To track changes in the description value, in the generic inquiry, explicitly join the table that contains the description and add the field from this table in the results of the generic inquiry.