Applies to
⚠️ Velixo NX only
ERP: Sage Intacct
The SI.JOURNALWRITEBACK function defines a single journal transaction line to be uploaded to Sage Intacct.
Syntax
SI.JOURNALWRITEBACK(ConnectionName, Journal, PostingDate, ReverseDate,
JournalDescription, ReferenceNumber, ShouldPost,
AdditionalBatchSettings, AccountCode, Debit, Credit,
LineCurrencySettings, Memo, Location, LineAllocationSettings,
Dimensions,UserDefinedDimensions, Billable, TaxEntry, BatchNumberOutput, ShouldOpenAfterUpload)
Parameters
The SI. JOURNALWRITEBACK function uses the following parameters:
Header Info
Parameter | Required/Optional | Description |
ConnectionName | Required | The name of the connection as configured in the Connection Manager |
Journal | Required | GL journal symbol. This determines the type of journal entry as visible in the UI, for example, Regular, Adjustment, User-defined, Statistical, GAAP, Tax, and so forth |
PostingDate | Required | The transaction date in format mm/dd/yyy |
ReverseDate | Optional | Reverse date in format mm/dd/yyyy. Must be greater than PostingDate |
JournalDescription | Optional | Journal description for the transaction |
ReferenceNumber | Optional | Reference number of the transaction |
ShouldPost | Optional | True or False (default). Determines whether or not the transaction should be automatically posted once it is created |
AdditionalBatchSettings | Optional |
|
Line Info
AccountCode | Optional | The GL account number for the transaction |
Debit | Optional | The Debit amount to be sent to the GL Account |
Credit | Optional | The Credit amount to be sent to the GL Account |
LineCurrencySettings | Optional | The currency code to be used for the transaction |
Memo | Optional | A memo to be included in the transaction |
Location | Optional (Required if muti-entity is enabled) | ID code for the Sage Intacct location to be used for the transaction |
LineAllocationSettings | Optional |
|
Optional | A two-column Excel range, where the first column contains the name of a predefined analytical dimension (e.g. department, customer, project etc.), and the second column contains the semicolon-separated list of values or that dimension. For user-defined dimensions, use the UserDefinedDimensions argument | |
UserDefinedDimensions | Optional | A two-column Excel range, where the first column contains the name of a user-defined analytical dimension, and the second column contains the respective value (or a semicolon-separated list of values) for that dimension. For predefined analytical dimensions like customer, project etc., use the Dimensions argument |
Billable | Optional |
|
TaxEntry | Required for AU, GB, ZA only | True or False (default). Indicates whether or not the transaction is a TaxEntry |
BatchNumberOuput | Optional | The Excel cell to receive the batch code number of the batch that is created |
ShouldOpenAfterUpload | Optional | True or False (default). Indicates whether or Sage Intacct should be opened to the batch following its creation |
Example
=SI.JOURNALWRITEBACK("Sage",
"GJ",
"12/31/2019",
,
"Liability Insurance Accrual for December 2019",
,
False,
,
"60330",
,
"1322.41",
"USD",
,
"100",
,
,
,
,
,
I9,
TRUE)
Description
Creates a transaction in the "GJ" journal. The transaction:
will be dated "12/31/2019"
does not have a reversal date
has the description of "Liability Insurance Accrual for December 2019"
should not be automatically posted
will be created for GL account #60330
will have the credit amount of 1,322.41 US dollars
will be created in location 100
In addition:
the number for the created batch number will be recorded in cell I9
Sage Intacct will automatically be opened to the batch immediately after it is created
using cell references:
=SI.JOURNALWRITEBACK($E$2,"GJ",$E$5,$I$11,$E$6,,IF($I$10="Yes",TRUE,FALSE),,$E$12,,J17,$I$4,,$B17,,,,,,I9,TRUE)
Here you can see an example where the cells contain the data for the function in cell K16:
