Universal Writeback for Sage Intacct - example

Applies to:

• Velixo NX
• Sage Intacct

TABLE OF CONTENTS

• Overview
• Example - Create an AR Invoice
  • Invoice Header
  • Invoice Line Items
• Perform Writeback

Overview

Universal Writeback (using the SI.WRITEBACK function) is a licensed feature available in Velixo NX for those clients needing to send data from Excel to Sage Intacct. 

Universal Writeback utilizes the pre-defined Sage Intacct objects and can write data to the fields within an object.

Example - Create an AR Invoice

As a basic example, we are going to create an AR Invoice using two of Sage Intacct's objects: ARINVOICE and ARINVOICEITEMS

Invoice Header

A convenient way of using the SI.WRITEBACK function is with an Excel table.

This table defines the "header" level information for our invoice:

This information includes:

The table also includes the SI.WRITEBACK function with its parameters referencing the values within the table and their appropriate field names within Sage Intacct's ARINVOICE object.

The OutputFieldnames and OutputRange parameters of our writeback function are configured to place the RecordID and Record_URL of our resulting invoice in cells H5 and I5 (respectively):

=SI.WRITEBACK("Sage","ARINVOICE",,,"CUSTOMERID,WHENCREATED,WHENDUE,DESCRIPTION,CURRENCY,BASECURR",,,"RECORDID,RECORD_URL",H5:I5,[@[Customer ID]],[@[Transaction Date]],[@[Due Date]],[@Description],[@Currency],[@Currency])

Note that we have given a name to our table:  Table13456 (as is listed in Excel's Name Box):

Invoice Line Items

In addition to the header information, we also need the individual line items for our invoice.  For that, we need a separate table:

This table also includes an SI.WRITEBACK function and also contains the data we need for each line of our invoice (Account Number and Amount along with two of Sage Intacct's pre-defined dimensions: Project and Location).

Note that the ParentRecordReference parameter of the writeback function contains a reference to the Writeback Status column in the previous table.  This parameter is a reference to a cell containing the prior SI.WRITEBACK function to indicate that the lines in this table have a child-parent relationship with the ARINVOICE record being created in the first table.

Perform Writeback

To create the invoice defined by our two tables, we click on Perform Writeback (in the Velixo NX ribbon)...

... and select to activate all of the writeback functions on the Current Sheet.

Once all of the SI.WRITEBACK functions are processed, they each display the Line uploaded message:

and our invoice number and URL are displayed in the cells that were specified in the header-level writeback function.

We can navigate to that URL or to the Accounts Receivable Invoices list in Sage Intacct...

... where we see our new invoice and can view it...

... and see all the information that we specified on our Excel worksheet.