SI.WRITEBACK

Overview

The SI.WRITEBACK function sends one or more lines of values to the ERP. The function uses the fields specified in a pre-defined Object in the ERP.

Syntax

CODE

=SI.WRITEBACK(ConnectionName, ObjectName, Settings, RecordNo, FieldName, ParentRecordReference, ParentRecordGroupName, OutputFieldNames, OutputRange, RangeOrDataItem1, ..., RangeOrDataItemN, ...)

Arguments

The SI.WRITEBACK function uses the following arguments:

Argument

Required/Optional

Description

ConnectionName

Required

The name of the connection as configured in the Connection Manager.

ObjectName

Required

The name of the Sage Intacct object
(this is *not* case sensitive)

Settings

Optional

A 2-column array with three rows:

Mode

Any of the below values

"create"
"update"
"create-or-update" (default)
"recreate"
"delete"

(This argument is ignored if ParentRecordReference is specified)

BatchSize

A number (optional)

To avoid ERP timeouts on large writebacks and to improve responsiveness of the application, data is broken up in batches of 100 records (default). If you are processing large batches of writebacks and using screens with auto-numbered keys, you can adjust the batch size to ensure your data is not broken up in multiple records.

WritebackLocation

Expects a LocationId (optional)

Set this setting to a Location Id only for entity-scoped objects (or objects' records marked as Private, in other words that are not available at the Top Level).

Considering the below example, you may reference cells: $P$6:$Q$8

or use a formula instead:

CODE

=HSTACK( {"Mode";"BatchSize";"WritebackLocation"}, VSTACK("update",100,"") )

OR just: $P$6:$Q$7 for an object record available at the Top Level:

or use this formula instead:

CODE

=HSTACK( {"Mode";"BatchSize"}, VSTACK("update",100) )

RecordNo

Required when the Mode argument is set to create, update, or recreate

Indicates the record number to be used for creating, updating, or recreating a record within the ERP.

FieldNames

Required

A comma-separated string OR an Excel range containing the names of the fields for writeback.

ParentRecordReference

Optional

A reference to a cell containing another SI.WRITEBACK function to indicate that the current record has a child → parent relationship with the other record.

ParentRecordGroupName

Optional

The name of the XML grouping element for the child entries under the parent.

This argument is ignored if ParentRecordReference is not specified

OutputFieldNames

Required

An Excel cell range (or a comma-separated string) containing the field names to retrieve from the resulting object.

This argument is ignored when in "delete" mode

OutputRange

Optional

The Excel range which will receive the fields of a created/updated record.

This argument is ignored when in "delete" mode

RangeOrDataItem1

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 OutputFieldNames argument.

...

RangeOrDataItemN

Required

An additional (or last) set of data to be sent to the ERP.

Tips

As an alternative to using the Platform Services → Object screen in Sage Intacct, you may also use the SI.QUERYand/or SI.OBJECTDEFINITION functions for determining the exact column names of a given Object to use in the Writeback function.
The WRITEBACKCOMMIT function should be used for creating/updating/recreating parent child records (such as: Projects), so that the OutputRange value returned by the SI.WRITEBACK function can be used by subsequent SI.WRITEBACK in the same batch.
WRITEBACK cannot be used to update existing journal transactions within Intacct.

Examples

Example 1 - Creating a new Vendor record

CODE

=SI.WRITEBACK($B$4,$B$6,$D$4:$E$5,,Table1[[#Headers],[Name]:[Status]],,,$H$4,$E13,Table1[@[Name]:[Status]])

Example 2 - Updating an attribute of an existing Project

CODE

=SI.WRITEBACK($B$4,$B$6,$D$4:$E$5,[@RecordNo],Table2[[#Headers],[ProjectID]:[ProjectType]],,,,,Table2[@[ProjectID]:[ProjectType]])

Updating records requires specifying the RecordNo of the record to update. The SI.QUERY function can be used to query the same object to retrieve the RecordNo of the specific item you wish to update.

Example 3 - Creating a record in a Private object (Cost Code Observed Percent Completed Entry scenario)

CODE

=SI.WRITEBACK($K$4,$K$6,$O$4:$P$6,,Table137[[#Headers],[TYPE]:[NOTE]],,,$P$7,P10,Table137[@[TYPE]:[NOTE]])

In this example, the WritebackLocation Setting is used in the 2-column Array: $O$4:$P$6, as the OBSPCTCOMPLETED object is a private object (meaning its records are "private" to a specific entity), and a specific Locationid must be referenced.

Due to a limitation within Sage Intacct, Velixo is unable to provide a specific error message to inform that the WritebackLocation argument needs to be used.

Instead, the following error message may be displayed:

Except from the message: BL01001973 Could not create obspctcompleted record

Example 4 - Update the detail data of an object without updating the header data

(using the APBILL and APBILLITEM objects)

There is a documented example of creating both header and detail information for an object. Let's look at updating only the detail portion.

Here we have both header data (from the APBILL object) and detail data (from the APBILLITEM object):

In this example, we want to change the DEPARTMENTID field at the detail-level from OPERATIONS to FINANCE.

Although we do not want to change the header data, we do need a reference to that header. So, the first thing we are going to is create a header writeback (cell I13) that does nothing except ensure that we have that reference:

All that function does is update the header with the same RECORDNO field that we already retrieved (cell A8) using the SI.QUERY function.

Now, we can create a WRITEBACK function (cell I14) that references the results of the first function (in the ParentRecordReference argument) and uses Update mode to replace the DEPARTMENTID field with the new value (cell J14) while maintaining the existing other field values (cells A14, B14, C14, D14, and F14):

After performing a Full Refresh (to clear any cached SI.QUERY data in our report), we see the updated detail data with no changes to the header: