Skip to content

Import Export PowerTool

Importing G/L Registers

Viewing 5 posts – 1 through 5 (of 5 total)
  • Author
    Posts
  • #8958
    Danni H.

    With the Import/Export tool it’s now possible to import records into protected tables like G/L Entries VAT Entries etc, but G/L Registers are not imported.

    Can support for G/L Registers be added?

    I’m using version 1.1.9587.1 of the Import Export PowerTool.

    #10836
    Danni H.

    Can you add support for table 253 “G/L Entry – VAT Entry Link” as well?

    #10837
    Travis P.
    Insight Works

    Most ledger tables are protected, so they are not editable in Business Central. Microsoft simply does not allow for them to be edited or deleted for audit purposes, so you cannot use the Import Export PowerTool (even with Protected Tables = Allow Access on the Import Export PowerTool Setup page). You will need to offset these values with journal entries. This includes tables like General Ledger Entries, Job Ledger Entries, Bank Ledger Entry tables, Physical Inventory Ledger Entry, Change Log Entries.

    #10843
    Danni H.

    The new version of the Import tool adds support for protected tables, including General Ledger entries and VAT Entries. I have tested this, and it works.

    #10844
    Danni H.
Viewing 5 posts – 1 through 5 (of 5 total)
  • Sign in below to reply.