SI.WRITEBACK function
Created by Harry Lewis, Modified on Tue, 3 Dec at 2:43 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
- Plan: Premium
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.
TABLE OF CONTENTS
Syntax
=SI.WRITEBACK(ConnectionName, ObjectName, Settings, RecordNo, FieldName, ParentRecordReference, ParentRecordGroupName, OutputFieldNames, OutputRange, RangeOrDataItem1, ..., RangeOrDataItemN, ...)
Parameters
The SI.WRITEBACK function uses the following parameters:
Parameter | 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:
Considering the below example, you may reference cells: $P$6:$Q$8 or use a formula instead: 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: HSTACK( {"Mode";"BatchSize"}, VSTACK("update",100) ) | ||||||
RecordNo | Required when the Mode parameter 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 parameter 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. (Note: this parameter is ignored when in "delete" mode) | ||||||
OutputRange | Optional | The Excel range which will receive the fields of a created/updated record. (Note: this parameter 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 parameter. | ||||||
... | ||||||||
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.QUERY and/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.
Examples
Example 1 - Creating a new Vendor record=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=SI.WRITEBACK($B$4,$B$6,$D$4:$E$5,[@RecordNo],Table2[[#Headers],[ProjectID]:[ProjectType]],,,,,Table2[@[ProjectID]:[ProjectType]]) Note: 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)=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.
|
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 parameter) 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: |
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