Include FlowFields and BLOBs in Synchronization Packages

During first log-in of an Anveo User (called Initialization), Anveo sends all data to the mobile device. This includes FlowFields and BLOBs that are selected as fields in a Synchronization Package. Microsoft Dynamics NAV 2017 calculates the values because the Anveo Delta Server cannot access this data via SQL directly. FlowFields are calculated once and are stored on the mobile device in normal, static fields. The calculation formular is not available on the mobile device due to too many records that could be required for calculation. Furthermore, the calculation itself could take too long on a mobile device.

Photos and pictures should be stored in JPG format only using a low resolution. We recommend to create a new BLOB field in Microsoft Dynamics NAV 2017 with reduced resolution just for Anveo Mobile App, like 500×500 pixel in maximum. Resolution of new photos taken with Anveo Mobile App can be reduced before storing in local database and before sending to Microsoft Dynamics NAV 2017.

Charset in Text Fields

BLOB fields may contain files like pictures and text in Microsoft Dynamics NAV 2017. If you use a BLOB field for a (long) text, its data must be converted between Microsoft Dynamics NAV 2017 and Anveo Mobile App due to different charsets. Please set the property Contains Text in your field to Yes. It is not possible and not required to use this property for normal Code and Text fields. If you use a BLOB field for files like pictures, do not set this property to Yes.

Resend FlowFields

A FlowField will be recalculated and resent to the mobile device by modifying the main record or by marking that record to be resent (without changing the record). For example: the field Inventory will be resent after modifying the Item record or marking that record with an Anveo Management function RECALCFIELDS. But it will not be resent by adding new Item Ledger Entries. This automatic recalculation is not possible due to too many updates for the mobile device that causes in long synchronizations.

Item.SETRANGE("No.",'10000');
ItemRecRef.GETTABLE(Item);
ACFManagement.RECALCFIELDS(ItemRecRef);

The data will be sent to all Anveo App Users that have the records within the data filter of their sync. packages.

The function RECALCFIELDS requires Anveo AddIns.