SI.WRITEBACKJOURNAL
Created by Damien Zwillinger, Modified on Tue, 23 Jul at 1:26 PM by Harry Lewis
Applies to:
- Velixo NX
- Sage Intacct
The SI.WRITEBACKJOURNAL function defines a single journal transaction line to be uploaded to Sage Intacct.
For a short overview of the Journal Writeback process see: Journal Writeback (Sage Intacct).
IMPORTANT: Performing writeback (i.e., Creating or Updating entities through the Sage Intacct application programming interface) requires the access rights associated with a Full User. Employee-type users in Sage Intacct would not be able to successfully perform a writeback.
TABLE OF CONTENTS
Syntax
SI.WRITEBACKJOURNAL(ConnectionName, Journal, PostingDate, ReverseDate, JournalDescription, ReferenceNumber, ShouldPost, AdditionalBatchSettings, AccountCode, Debit, Credit, LineCurrencySettings, Memo, Location, LineAllocationSettings, Dimensions, UserDefinedDimensions, Billable, TaxEntry, BatchNumberOutput, ShouldOpenAfterUpload)
Parameters
The SI. WRITEBACKJOURNAL function uses the following Header and Line 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 | Required | Journal description for the transaction |
ReferenceNumber | Optional | Reference number of the transaction |
ShouldPost | Required | True or False. Determines whether or not the transaction should be automatically posted once it is created |
AdditionalBatchSettings | Optional | A two-column array of key and value pairs for defining the settings* |
* The AdditionalBatchSettings parameter is a two-column array of key+value pairs, where the "key" is a forgiving name of the respective setting from the API description:
[BaseLocationId]
[TaxImplications]
[TaxSolutionId]
[VatVendorId]
[VatCustomerId]
[VatContactId]
[HistoryComment]
[TransactionSource]
[CustomFieldName1]
[CustomFieldName2]
...
Note that anything that is not recognized as a predefined field, is treated as the "Custom field name" from the API description.
Example:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000108484/original/5vhaD8dMWU2MxwtxDiKWSzGrijmj99YXrA.png?1693455161)
(this example sets values for VatVendorID, VatCustomerID, and VatContactID)
Line Info
AccountCode | Required | The GL account number for the transaction |
Debit | Optional (must be left blank if Credit amount is specified) | The Debit amount to be sent to the GL Account |
Credit | Optional (must be left blank if Debit amount is specified) | 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 | Allocation ID** All other dimension elements are ignored if Allocation is specified. |
Optional | A two-column (or two-row) Excel range, where the first column/row contains the name of a predefined analytical dimension (e.g. department, customer, project etc.), and the second column/row contains the semicolon-separated list of values or that dimension. For user-defined dimensions, use the UserDefinedDimensions argument | |
UserDefinedDimensions | Optional | A two-column (or two-row) Excel range, where the first column/row contains the name of a user-defined analytical dimension, and the second column/row 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 | True or False (default)
Applies to project-related transactions and sets whether or not the transaction is billable. |
TaxEntry | Required for AU, GB, ZA only | A two-column Excel range, where the first column contains text specifying the tax rate (as specified via the unique ID of a tax detail) and the second column contains a currency value denoting the value of the tax. |
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 |
** The LineAllocationSettings parameter can be:
The Allocation ID or
A two-dimensional Excel range where the first row contains the name of a predefined analytical dimension (e.g. department, customer, project) and the following rows contain the respective values for that dimension. The last value must be the split transaction amount, and all split transactions amounts must sum up to either the credit or debit value.
When the Allocation parameter is used (either via Allocation ID or a a two-dimensional array), the PredefinedDimensions parameter cannot be used. When using allocation, predefined dimension values must be part of the allocation.
Examples
Example 1
=SI.WRITEBACKJOURNAL("Sage","GJ","12/31/2019",,"Liability Insurance Accrual for December 2019",,False,,"60330",,"1322.41","USD",,"100",,,,,, I9,TRUE)
Expanded:
=SI.WRITEBACKJOURNAL("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.WRITEBACKJOURNAL($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:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000108485/original/BheLAGorxmvnDmHIfGlNeRCG5scR8qWe7A.png?1693455162)
Example 2
Using the TaxEntry and AdditionalBatchSettings parameters:
For Credit transactions:
=SI.WRITEBACKJOURNAL("Sage, "GJ", "12/31/2019", , "Liability Insurance Accrual for November 2019", , FALSE, {"TaxImplications","Outbound";"TaxSolutionID","United Kingdom - VAT";"VatCustomerID","10052"}, "60330", , 467.75, "USD", , "500", , , , , , I9, TRUE)
Expanded:
=SI.WRITEBACKJOURNAL("Sage, "GJ", "12/31/2019", , "Liability Insurance Accrual for November 2019", , FALSE, {"TaxImplications","Outbound";"TaxSolutionID","United Kingdom - VAT";"VatCustomerID","10052"}, "60330", , 467.75, "USD", , "500", , , , , , I9, TRUE)
For Debit transactions:
=SI.WRITEBACKJOURNAL("Sage, "GJ", "12/31/2019", , "Liability Insurance Accrual for November 2019", , FALSE, {"TaxImplications","Outbound";"TaxSolutionID","United Kingdom - VAT";"VatCustomerID","10052"}, "20330", 1,403.25, , "USD", , "500", , , , , {"UK Sale Goods Reduced Rate","89.2"}, I9, TRUE)
Expanded:
=SI.WRITEBACKJOURNAL("Sage, "GJ", "12/31/2019", , "Liability Insurance Accrual for November 2019", , FALSE, {"TaxImplications","Outbound";"TaxSolutionID","United Kingdom - VAT";"VatCustomerID","10052"}, "20330", 1,403.25, , "USD", , "500", , , , , {"UK Sale Goods Reduced Rate","89.2"}, 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
with Tax implications = Outbound taxes for sales, Customer = 10052, Tax solution = United Kingdom - VAT.
60330 GL account will be credited with the amount of 467.75 USD
20330 GL account will be debited with the amount of 1,403.25 USD, including tax entry with "UK Sale Goods Reduced Rate" description and 89.20 USD amount
will be created in location 500
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
Here is the created journal entry in Sage Intacct:
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000108486/original/6z7ENUq0KoVd7TNXXVkHZVNQSRe49fRCGw.png?1693455162)
![](https://s3.amazonaws.com/cdn.freshdesk.com/data/helpdesk/attachments/production/153000108483/original/51rslkjbcjocyMebzM_FB99ttrbDKlGEYA.png?1693455161)
In Excel, the transaction number from the journal entry has been recorded in cell I9 and the line status has been updated to Line uploaded:
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