WRITEBACKREFRESHDATA function
Created by Harry Lewis, Modified on Mon, 26 Aug at 5:58 PM by Harry Lewis
Applies to:
- Velixo NX
- Velixo Classic
- Acumatica, MYOB Acumatica, Cegid XRP Flex
Description
The WRITEBACKREFRESHDATA function refreshes the data contained in the writeback caches. This allows the writeback functions in the workbook to use the most recent data available in Acumatica.
In complex one-click writeback scenarios where subsequent writebacks depend on the result of a previous one (e.g. a project forecast writeback writes to a project that's created by a preceding universal/generic writeback), the most recent cache must be available to dependent writeback formulas for successful data processing.
There is a predefined order of execution for all writeback functions located on the same worksheet: line by line - top to bottom, left to right.
Thus, the WRITEBACKREFRESHDATA call placed in a cell prior to the dependent writeback formula forces Velixo caches to reset. This ensures that the following writebacks don't complain about non-existing items when those have in fact been already created.
TABLE OF CONTENTS
Syntax
WRITEBACKREFRESHDATA(Connection)
Parameters
The WRITEBACKREFRESHDATA function uses the following parameters:
Parameter | Required/Optional | Description |
Connection | Required | The name of the connection as configured in the Connection Manager |
Status
A cell containing a WRITEBACKREFRESHDATA function displays a Pending status:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000158619/original/3xYPqLuT2PL65U_A9Np2txeo2sFpuldbAA.png?1694127985)
The refresh can be accomplished through either, selecting cells containing WRITEBACKREFRESHDATA and any type of WRITEBACK functions with the subsequent clicking (on the Acumatica ribbon) Perform Writeback -> Selected Cells or Worksheets:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000158620/original/yK8KLjtaClWNAtZ3JN50XGgmzMXNE8Nolg.png?1694127985)
Or the WRITEBACKREFRESHDATA function will also be automatically activated when a writeback is done for the entire worksheet using Perform Writeback -> Current Worksheet:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000158618/original/N8CqfNd8Gdn6lvSmu8p7jd0jpnxuvGnP3Q.png?1694127984)
Once a writeback has been performed, the status of the cell containing the WRITEBACKREFRESHDATA function will change to "Data refreshed during writeback".
Example
After the writeback is performed with this function...
=WRITEBACKREFRESHDATA("Demo")
... the cell will display the "Data refreshed during writeback" status message:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000158621/original/FswYnB8FdRsCIqTvW4JTpfDSipJTlBA62w.png?1694127985)
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article