This feature requires Velixo Reports v6.1.2 or higher

Description

The WRITEBACK function sends one or more lines of values to the ERP (using the fields specified in a pre-defined Import Scenario for a specific screen in the ERP).

Syntax

WRITEBACK(Connection, ScreenID, ImportScenarioName, DataColumnNames, 
RangeOrDataItem, RangeOrDataItem1,
RangeOrDataItem2, ..., RangeOrDataItem250)

Parameters

The WRITEBACK function uses the following parameters:

Parameter

Required/Optional

Description

Connection

Required

The name of the connection as configured in the Connection Manager

ScreenID

Required

The ScreenID of the ERP screen containing the data that is being sent to the ERP.

ImportScenarioName

Required

The name of the pre-defined Import Scenario that is being used to send data to the ERP.

DataColumnNames

Required

The names of the fields to which data is being written. This is an Excel range reference to the row containing all import scenario names - in any order.

RangeOrDataItem

Required

The first set of data to be sent to the ERP. The values to be written must be specified in the same order as the column/field names specified in the DataColumnNames parameter

RangeOrDataItem1

Optional (depending on the amount of data being written to the ERP)

An additional set of data to be sent to the ERP

...

RangeOrDataItem250

Optional (depending on the amount of data being written to the ERP)

An additional set of data to be sent to the ERP

Example

Given this configuration:

We could create this function:

=WRITEBACK("Demo", "AR303000", "ACU Import Customers", B1:O1, B2:O2, B3:O3,
B4:O4, B5:O5)

Description

We will be writing data to the screen with the ID "AR303000" in the ERP defined in the Connection named "Demo".

That ERP contains an active, pre-defined Import Scenario (for ScreenID AR303000) named "ACU Import Customers":

To help us create our worksheet, we can use the WRITEBACKARGUMENTS function to list the name of the fields associated with that specific Import Scenario:

and then fill in the data we want to send to the specified ScreenID:

(note that we do *not* have to send data to every field contained in 
the Import Scenario)

Our WRITEBACK function...

=WRITEBACK("Demo", "AR303000", "ACU Import Customers", B1:O1, B2:O2, B3:O3, 
B4:O4, B5:O5)

... can then reference that data.

  • B1:O1 references the names of the fields to which we will be sending data

  • B2:O2 references the first line of data we are sending

  • B3:O3 references the second line of data we are sending.

  • etc.

note: that the WRITEBACK function does not require us to use cell references, we could
also type information directly into the function.

e.g.,
=WRITEBACK("Demo", "AR30300, "ACU Import Customers",{"TESTDEL1","First",
"[email protected]","79169224455","1-st Ave","23 bul.2","New York","US","NY",,
"LOCAL","","",""})

Result

Before the data is sent to the ERP...

...the status of the function is Pending:

Once we select Import Current Worksheet, the process will start:

Once the process is complete...

... the status of the WRITEBACK function will change to Line range uploaded...

... and, within our ERP, we can visit screen AR303000 and see that the data has been imported:

Did this answer your question?