Table of Contents

General Journal Import Feature - Setup & Processing Guide

Overview

The General Journal Import feature in the Linc Third Party Transactions extension enables automatic creation of Business Central General Journal Lines from imported transaction data. This system supports complex financial entries with dual account structures, comprehensive posting group management, multi-currency processing, VAT handling, and complete dimension integration for financial accounting processes.

Key Components

  • Application Area: Financial
  • Transaction Types: General Journal
  • Supported Account Types: G/L Account, Customer, Vendor
  • Document Types: All standard General Journal document types
  • Currency Support: Multi-currency with exchange rate handling
  • Recurring Options: Full recurring method and frequency support
  • Output: Business Central General Journal Lines

Prerequisites

1. Basic Business Central Setup

  • General Ledger Setup configured
  • Chart of Accounts properly set up with posting groups
  • General Journal Templates and Batches configured
  • General Posting Groups (Business and Product) configured
  • VAT Posting Groups (Business and Product) set up
  • Currencies configured (if using multi-currency transactions)
  • Payment Terms codes (if calculating due dates)
  • Dimensions configured (if using dimension tracking)

2. Extension Setup

  • Linc Third Party Transactions extension installed
  • Appropriate user permissions configured
  • General Journal Templates and Batches ready for processing
  • Customer/Vendor mappings (if using account mappings)

Step-by-Step Setup Instructions

Step 1: Configure Third Party Setup for General Journal

  1. Navigate to Third Party Setup List (Page 71112700)
  2. Create or modify setup record with the following configuration:

General Settings

  • Third Party Code: Unique identifier for your general journal setup
  • Application Area: Set to Financial
  • XMLPort ID: Select appropriate import XMLPort for file imports
  • No. of Header Rows: Number of header rows to skip in import files

Journal Configuration

  • Gen. Journal Template: Default template for general journal processing
  • Gen. Journal Batch: Default batch for general journal processing
  • Use Def. Post. setup Gen Jnl: Use Business Central default posting setup
  • Use Default Journal Dimensions: Use BC default journal dimensions vs imported dimensions
  • Use Import Journal Description: Use imported description vs default description

Processing Options

  • Use Mapping: Enable Third Party Mappings for account/dimension translation
  • Attempt Direct Mapping: Try direct value resolution when mapping not found
  • Automatically Validate: Auto-validate imported transactions
  • Automatically Create Trans.: Auto-create journal lines after validation
  • Automatically Post Trans.: Auto-post journal lines after creation

Step 2: Configure General Journal Templates & Batches

  1. Navigate to General Journal Templates

  2. Set up or verify existing templates:

    • Template Type: Must be "General"
    • Name: Template code to use in Third Party Setup
    • Description: Descriptive name
    • Source Code: Appropriate source code for tracking
    • No. Series: Number series for document numbering (optional)

  3. Navigate to General Journal Batches

  4. Set up or verify batches for your template:

    • Journal Template Name: Link to your general journal template
    • Name: Batch code to use in Third Party Setup
    • Description: Descriptive name
    • No. Series: Number series for document numbers
    • Posting No. Series: Number series for posted documents

Step 3: Configure Account Mappings (if using mappings)

If Use Mapping is enabled:

  1. Navigate to Third Party Mappings (Page 71112706)
  2. Create account mapping records:

G/L Account Mappings

  • Third Party Code: Same as setup record
  • Mapping Type: G/L Account
  • Third Party Reference No.: External G/L account identifier
  • Mapping No.: Internal BC G/L Account No.

Customer Mappings

  • Third Party Code: Same as setup record
  • Mapping Type: Customer
  • Third Party Reference No.: External customer identifier
  • Mapping No.: Internal BC Customer No.

Vendor Mappings

  • Third Party Code: Same as setup record
  • Mapping Type: Vendor
  • Third Party Reference No.: External vendor identifier
  • Mapping No.: Internal BC Vendor No.

Dimension Mappings (if using dimensions)

  • Mapping Type: Shortcut Dimension 1 Code through Shortcut Dimension 8 Code
  • Third Party Reference No.: External dimension value
  • Mapping No.: Internal BC Dimension Value Code

Step 4: Configure Excel Import Mapping (For Excel Files)

If importing from Excel files:

  1. Navigate to Third Party Excel Import Mapping (Page 71112709)
  2. Create field mappings:
    • Third Party Code: Same as setup record
    • Mapping Type: Field (column reference) or Fixed Value
    • Third Party Reference No.: Column name or fixed value
    • Third Party Trans. Field ID: Target field in transaction table

Required Data Fields for General Journal

Mandatory Fields

  • Application Area: Must be "Financial"
  • Transaction Type: Must be "General Journal"
  • Gen. Jnl Account Type: G/L Account, Customer, or Vendor
  • Gen. Jnl Account No.: Account number (external or BC format)
  • Line Amount: Transaction amount (required)
  • Transaction Date: Posting date

Optional Main Account Fields

  • Gen. Jnl Doc Type: Document type (Payment, Invoice, Credit Memo, etc.)
  • Document No.: Document number
  • Ext. Document No.: External document reference
  • Gen. Posting Type: Sale, Purchase, Settlement
  • Gen. Bus. Posting Group: General Business Posting Group
  • Gen. Prod. Posting Group: General Product Posting Group
  • VAT Bus. Posting Group: VAT Business Posting Group
  • VAT Prod. Posting Group: VAT Product Posting Group

Optional Balancing Account Fields

  • Bal. Account Type: G/L Account, Customer, or Vendor
  • Bal. Account No.: Balancing account number
  • Bal. Gen. Posting Type: Balancing account posting type
  • Bal. Gen. Bus. Posting Group: Balancing account business posting group
  • Bal. Gen. Prod. Posting Group: Balancing account product posting group
  • Bal. VAT Bus. Posting Group: Balancing account VAT business posting group
  • Bal. VAT Prod. Posting Group: Balancing account VAT product posting group

Currency & Financial Fields

  • Currency Code: Currency for foreign currency transactions
  • Exch. Rate Factor: Exchange rate factor
  • Journal Amount (LCY): Local currency amount
  • VAT Amount: VAT component amount
  • Payment Terms Code: Payment terms
  • Transaction Due Date: Due date
  • Gen Jnl VAT Date: VAT reporting date
  • Document Date: Document date

Recurring Journal Fields

  • Journal Template: Override default template
  • Journal Batch: Override default batch
  • Journal Recurring Method: Fixed, Variable, Balance, Reversing Variable, etc.
  • Journal Recurring Frequency: DateFormula for frequency

Dimension Fields

  • Shortcut Dimension 1-8 Code: Dimension values
  • Description: Journal line description

Processing Workflow

Step 1: Import Transaction Data

Choose your import method:

Method A: File Import (XML/Excel)

  1. Navigate to Third Party Transactions (Page 71112707)
  2. Filter to Financial application area
  3. Click Import Transactions
  4. Select your configured Third Party Setup
  5. Choose file to import

Method B: Direct API/Integration

  • Use Business Central APIs to insert records into ThirdPartyTransact_THI_LINC table

Step 2: Validate Imported Data

  1. In Third Party Transactions page
  2. Select transactions to validate (or use Ctrl+A for all)
  3. Click Validate action

Validation Process

The system validates:

  • Setup Existence: Third Party Setup record exists
  • Transaction Type: Must be "General Journal"
  • Account Resolution: Main and balancing accounts via mapping or direct lookup
  • Posting Groups: General and VAT posting group validation
  • Dimension Validation: All shortcut dimensions (1-8)
  • Financial Data: Amounts, currencies, dates, VAT amounts
  • Journal Setup: Template and batch validation
  • Currency Validation: Currency codes and exchange rates

Validation Results

  • Status = Checked: Transaction passed all validations
  • Status = Error: Issues found (check Error Message field)
  • Status = Ignore: Manually ignored transactions

Step 3: Create General Journal Lines

  1. Filter to show validated transactions (Validation Status = "Checked")
  2. Select transactions to process
  3. Click Create General Journal Lines action
  4. Confirm creation dialog

Journal Line Creation Logic

The system creates General Journal lines with comprehensive account and posting group handling:

Basic Line Information
  • Template/Batch: Uses setup defaults or transaction-specific values
  • Line Number: Sequential numbering (10000 increments)
  • Document Type: From imported document type
  • Posting Date: From transaction date
  • VAT Reporting Date: From Gen Jnl VAT Date field
  • Document Date: From Document Date field
  • Document No.: From import data or batch number series
  • External Document No.: From import data
Account Assignment
  • Main Account: Account Type and Account No. from validation/mapping
  • Balancing Account: Bal. Account Type and Bal. Account No. (if specified)
Posting Group Handling
When "Use Def. Post. setup Gen Jnl" is Disabled:
  • Applies all imported posting groups directly
  • Gen. Posting Type, Gen. Bus. Posting Group, Gen. Prod. Posting Group
  • VAT Bus. Posting Group, VAT Prod. Posting Group
  • All balancing account posting groups
When "Use Def. Post. setup Gen Jnl" is Enabled:
  • Uses Business Central account default posting groups
  • Validates and applies account numbers only
  • Minimal posting group data required in import
Financial Data Assignment
  • Amount: From Line Amount field
  • Currency Processing: Currency Code, Currency Factor
  • VAT Amount: From VAT Amount field (if specified)
  • LCY Amount: From Journal Amount (LCY) field
  • Payment Terms: From Payment Terms Code
  • Due Date: From Transaction Due Date
Recurring Journal Support
  • Recurring Method: From Journal Recurring Method field
  • Recurring Frequency: From Journal Recurring Frequency field
Dimension Processing
Default Dimensions Option:
  • Use Default Journal Dimensions = True: Uses account default dimensions
  • Use Default Journal Dimensions = False: Uses imported dimension values

Step 4: Review and Post Journal Lines

  1. Navigate to General Journals
  2. Select appropriate Journal Template and Batch
  3. Review created journal lines:
    • Verify account assignments and amounts
    • Check posting group assignments
    • Validate dimension assignments
    • Confirm currency processing
    • Review VAT calculations
  4. Post journal when ready

Advanced Features

Multi-Currency Processing

  • Exchange Rate Handling: Supports Currency Factor method and LCY Amount method
  • Automatic Calculation: Uses current exchange rates when not specified
  • Currency Validation: Validates currency codes and exchange rates

Approval Workflow Integration

  • Pre-Processing Checks: Validates no open approval entries on journal batch
  • Approval Conflict Handling: Stops processing if approvals pending
  • Error Messaging: Clear error messages for approval conflicts

Flexible Journal Assignment

  • Transaction-Level Override: Specify different journal template/batch per transaction
  • Setup-Level Default: Use setup defaults when transaction fields are blank
  • Validation: System ensures journal template and batch exist and are compatible

Document Numbering Management

  • Automatic Numbering: Uses journal batch number series
  • Manual Numbering: Uses imported document numbers
  • Continuity Management: Maintains sequential numbering within batch

Comprehensive Posting Group Management

  • Full Control Mode: Import specifies all posting groups
  • Automatic Mode: Uses Business Central default posting groups
  • Validation: Cross-validates posting group combinations

Validation Rules & Error Messages

Critical Errors (Will prevent processing)

  • "Third Party Setup for %1 was not found"
  • "General Journal Template and Batch must have a default value in Third Party Setup"
  • "General Journal Template X and Batch Y has open Approval Entries"
  • "Value not found for field: Gen. Bus. Posting Group"
  • "Value not found for field: VAT Prod. Posting Group"

Mapping Errors (May have fallback options)

  • "No Mapped Gen. Jnl. Account Found"
  • "No Mapped Bal. Account Found"
  • "No Mapped Shortcut Dimension Found"

Account Resolution Errors

  • Invalid account type for main or balancing account
  • Account does not exist in respective master table (G/L, Customer, Vendor)
  • Posting group combinations are invalid
  • Currency code does not exist or has no exchange rates

Troubleshooting Guide

Common Issues & Solutions

1. "No Mapped Gen. Jnl. Account Found"

Solutions:

  • Create account mapping in Third Party Mappings
  • Enable "Attempt Direct Mapping" if account codes match BC
  • Verify accounts exist in appropriate master tables (G/L, Customer, Vendor)
  • Check account number format and length

2. "General Journal Template and Batch must have default value"

Solutions:

  • Configure Gen. Journal Template and Gen. Journal Batch in Third Party Setup
  • Ensure journal template type is "General"
  • Verify journal batch exists and is linked to correct template
  • Check template and batch names match exactly

3. Posting group validation errors

Solutions:

  • Verify all posting groups exist in BC master tables
  • Check posting group combinations are valid in General Posting Setup
  • Enable "Use Def. Post. setup Gen Jnl" to use account defaults
  • Validate VAT posting group combinations in VAT Posting Setup

4. "Open Approval Entries" error

Solutions:

  • Complete pending approval processes on the journal batch
  • Use a different journal batch for imports
  • Process approvals before running import
  • Configure dedicated import batch without approval workflow

5. Currency validation failures

Solutions:

  • Verify currency codes exist in Currency table
  • Check exchange rates are configured for posting date
  • Validate currency amounts and exchange rate factors
  • Set up Additional Reporting Currency if needed

6. Dimension validation errors

Solutions:

  • Check dimension values exist in BC dimension tables
  • Verify dimension mapping configuration
  • Ensure dimension values are valid for posting date
  • Consider enabling "Use Default Journal Dimensions"
  • Check dimension value restrictions and date ranges

7. Zero journal lines created

Solutions:

  • Verify transactions have "Checked" validation status
  • Check transaction type filter (must be "General Journal")
  • Ensure Line Amount is not zero
  • Review error messages on failed transactions
  • Verify journal template and batch configuration

8. Balancing account errors

Solutions:

  • Verify balancing account exists and is correct type
  • Check balancing account posting group configuration
  • Validate balancing account is not blocked
  • Ensure balancing account posting groups are compatible

9. VAT calculation issues

Solutions:

  • Verify VAT posting group combinations in VAT Posting Setup
  • Check VAT calculation methods and rates
  • Validate VAT amounts against calculated amounts
  • Review VAT reporting date configuration

10. Recurring journal setup errors

Solutions:

  • Verify recurring method is valid for journal template
  • Check recurring frequency formula format
  • Ensure recurring journal template allows recurring entries
  • Validate recurring allocation setup

Best Practices

  1. Test with Small Batches: Start with a few transactions to verify setup
  2. Use Dedicated Batches: Use separate journal batches for imports
  3. Configure Mappings: Better control and standardization than direct mapping
  4. Enable Fallbacks: Use "Attempt Direct Mapping" for flexibility
  5. Validate Before Processing: Run validation immediately after import
  6. Monitor Approvals: Avoid approval conflicts by using separate batches
  7. Document Numbering: Use number series for consistent document numbering
  8. Backup Before Processing: Take database backup before large imports
  9. Review Journal Lines: Always review before posting
  10. Currency Management: Validate exchange rates before importing foreign currency transactions
  11. Dimension Standards: Standardize dimension values across imports
  12. Posting Group Control: Choose appropriate posting group method (automatic vs. manual)

Performance Considerations

  • Batch Size: Process large imports in smaller batches for better performance
  • Journal Cleanup: System automatically removes blank lines before processing
  • Validation Timing: Run validation during off-peak hours for large datasets
  • Archive Management: System automatically archives processed transactions
  • Line Numbering: Uses standard 10000 increments for proper sequencing
  • Approval Processing: Consider approval workflow impact on processing time

Integration Events

The system provides integration events for customization:

  • OnBeforeValidateGenJournalLine: Add custom validation logic
  • OnAfterValidateGenJournalLine: Post-validation processing
  • OnBeforeCreateGenJournalLine: Pre-creation customization
  • OnAfterCreateGenJournalLine: Post-creation modifications
  • Custom validation and processing can be added through integration events

Security & Permissions

Required permissions for users:

  • Read/Write access to Third Party Transaction tables
  • Insert/Modify access to General Journal Line table
  • Execute permissions on processing codeunits
  • Access to setup and mapping pages
  • General journal posting permissions (if using auto-post feature)
  • Access to Chart of Accounts and posting group tables
  • Currency and dimension table read access