Example: Journal Entry

This example builds a Journal Entry workbook from scratch, covering the header fields, the transaction grid, and the button that pushes the entry to Acumatica. A Journal Entry writeback uses a header table for the fields shared by every transaction line, the financial period, transaction date, description, ledger, branch, and currency, and a transaction grid for the individual debit and credit lines. The Writeback Wizard maps each of these cells to the corresponding Journal Transaction fields in Acumatica and generates the NECWRITEBACK formula that creates the entry.

The finished template includes three buttons: one that pushes the journal entry to Acumatica, one that releases it, and one that resets the template for the next entry.

important

To follow along, you need a data source connected to Acumatica with the endpoints configured, and permission to create writebacks in SEI.

01

Create the journal entry template

Before the writeback can run, the workbook needs a functional Journal Entry template, built from three components: a header table, a ledger table, and the transaction grid.

1. Select Workbooks in the navigation panel.
2. Right click and select New Workbook.
3. Name the workbook Journal Entry and click Save.
4. Create a five row, two column table for the fields shared by every transaction line:
   • Financial Period (B5)
   • Transaction Date (B6)
   • Description (B7)
   • Batch (B8)
   • Posted (B9)
5. Next to it, create a three row, two column table for the ledger fields:
   • Ledger (F5)
   • Branch (F6)
   • Currency (F7)
6. Create the transaction grid from B12 to J12 with these headers, in order: Branch, Account, Sub Account, Project, Task, Ref. Number, Quantity, Debit, Credit.
7. Apply formatting to the tables and grid, such as fill colors, borders, or header styles.
8. Click Save on the toolbar.

02

Select the fields for the writeback

With the tables in place, the Writeback Wizard connects to the Journal Transaction entity in Acumatica. Selecting fields here, from both the entry header and its detail lines, determines exactly what gets written back and where.

1. Select the Analysis tab, then click WRITEBACK Wizard.
2. Select the environment and the Acumatica data source you want to connect to.
3. Select the Journal Transaction entity.
4. Under Journal Transaction, select these header fields: BranchID, CurrencyID, Description, LedgerID, Module, PostPeriod, and TransactionDate.
5. Expand Journal Transaction and select the Details table.
6. Select these detail fields: Account, CreditAmount, DebitAmount, Project, ProjectTask, Qty, ReferenceNbr, and Subaccount.
7. Click Next.

03

Map each field to the table

Header fields map to individual cells, since there's only one of each per entry. Detail fields map to columns instead, since the Details table can hold any number of transaction lines.

1. Under Journal Transaction, map each field to its cell. Click the cell directly in the workbook, or type the reference:
   • BranchID: G6
   • CurrencyID: G7
   • Description: C7
   • LedgerID: G5
   • PostPeriod: C5
   • TransactionDate: C6
2. For Module, enter the literal value GL instead of a cell reference.
3. Under Details, select Existing table, then select GLEntry from the dropdown.
4. Map each field to its column:
   • CreditAmount: Credit
   • DebitAmount: Debit
   • Project: Project
   • ProjectTask: Task
   • Subaccount: Sub Account
   • Qty: Quantity
   • Account: Account
   • ReferenceNbr: Ref. Number

04

Create the writeback button

The writeback button is what sends the completed entry to Acumatica. Configuring it here sets where it appears on the sheet, what it's called, and how it looks.

1. Under Options, expand Writeback Button.
2. Toggle Create Button on.
3. In Target Button, enter or select the cell where the button will appear, for example I5.
4. In Label, enter Push to Acumatica.
5. Select a color for the button, for example #253342.
6. Review the Preview to confirm the button's appearance.

05

Enable output results

Output Results shows the result of the writeback directly on the sheet, so you know whether it succeeded without checking Acumatica.

1. Under Options, expand Output Results and toggle it on.
2. In Cell Reference, enter or select the cell where the result will appear, for example C8.
3. Click Save.

06

Create the release button

Releasing posts the journal entry in Acumatica once it's been created. Selection Type tells the button which values identify the record to release, in this case the batch number and the module returned after the writeback.

1. Select the Analysis tab, then click Action Button Wizard.
2. Under Type, select Acumatica Action.
3. Under Button, select Release Journal.
4. Select the same environment and data source used for the writeback button.
5. In Selection Type, select BatchNbr, Module.
6. In BatchNbr, enter or select B8.
7. In Module, enter GL.
8. In Target Cell, enter or select I7.
9. In Label, enter Release.
10. Select a color for the button, for example #D0DFE7.
11. Click Save.

07

Create the reset button

Resetting clears the entered values so the template is ready for another entry.

1. Select the Analysis tab, then click Action Button Wizard.
2. Under Type, select Nectari Action.
3. Under Button, select Reset.
4. In Target Cell, enter or select I9.
5. In Label, enter Reset.
6. Select a color for the button, for example #D0DFE7.
7. Select Clear cache before release.
8. Click Save.

08

Enter transaction lines

With the template built, filling in the entry description and a two line transaction shows how the finished workbook works in practice: one branch debited, another credited.

1. Enter Reallocate sales revenue between branches in Description.
2. In the first row, enter PRODRETAIL for Branch, 40000 - Sales Revenue for Account, and 000FIN for Sub Account.
3. In Debit, enter 6,430.00.
4. In the second row, enter PRODWHOLE for Branch, 10300 - Company Savings Account for Account, and 000PUR for Sub Account.
5. In Credit, enter 4,825.50.

09

Push and release

Each button now runs the action it was configured for: writing the entry to Acumatica, releasing it, or resetting the template.

1. Click Push to Acumatica to create the journal entry in Acumatica.
2. Click Release to release the entry.
3. Click Reset to clear the template and start over.