BC.WRITEBACKJOURNAL

Overview

The BC.WRITEBACKJOURNAL function enables you to write lines to a specified General Journal in Business Central.

Writing back to General Journals is not available to users with the MS Dynamics 365 Team Members license.

Syntax

=BC.WRITEBACKJOURNAL(
  ConnectionName,
  PostingDate,
  Journal,
  PostTransaction,
  GlRegisterNumberOutput,
  OpenAfterImport,
  AccountType,
  Account,
  Amount,
  DocumentNumber,
  ExternalDocumentNumber,
  BalancingAccountType,
  BalancingAccount,
  Description,
  Comment,
  Dimensions,
  LineNumber
)

Arguments

Header data

Argument	Required/Optional	Description
`ConnectionName`	Required	The name of the connection, as specified in the Connection Manager.
`PostingDate`	Required	The date of the transaction in the general ledger.
`Journal`	Required	The name of the General Journal.
`PostTransaction`	Required	Determines whether the transactions in the specified General journal should be posted. Possible values: `TRUE` and `FALSE` Affects all lines in the specified General Journal, not just the lines uploaded during writeback.
`GlRegisterNumberOutput`	Optional	Defines the address of the cell where the GL register number is returned after writeback is complete. Use only when `PostTransaction` is `TRUE`.
`OpenAfterImport`	Optional	Possible values: `TRUE` and `FALSE` When `TRUE` and `PostTransaction` is `FALSE`, opens the General Journals screen to the specified `Journal` in the browser. Does not filter records in the journal. When `TRUE` and `PostTransaction` is `TRUE`, open the GL register screen in the browser, filter GL entries by numbers to display the uploaded batch. Default value: `FALSE`

Line data

Argument	Required/Optional	Description
`AccountType`	Required	The type of the account to which the entry line will be posted. Valid values: `G/L Account`, `Customer`, `Vendor`, `Bank Account`, `Fixed Asset`, `IC Partner`, `Employee`, `Allocation Account`.
`Account`	Required	The number of the account to which the entry line will be posted.
`Amount`	Required	The total amount (including VAT) in the journal line.
`DocumentNumber`	Required	A document number for the journal line.
`ExternalDocumentNumber`	Optional	An external document number for the journal line.
`BalancingAccountType`	Optional	The type of balancing account. Valid values: `G/L Account`, `Customer`, `Vendor`, `Bank Account`, `Fixed Asset`, `IC Partner`, `Employee`, `Allocation Account`.
`BalancingAccount`	Optional	The balancing G/L Account or object ID.
`Description`	Optional	A description of the journal line.
`Comment`	Optional	A comment on the journal line.
`Dimensions`	Optional	A two-column (or two-row) Excel range, where the first column/row contains the name of a predefined dimension (e.g. department, customer, project etc.), and the second column/row contains the semicolon-separated list of values for that dimension.
`LineNumber`	Optional	The journal item line number.