Home › Forums › Import Export PowerTool › Importing G/L Registers

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • Danni HansenDanni Hansen
      June 5, 2026 at 4:09 am
      Post count: 8
      #15424

      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.

      Danni HansenDanni Hansen
        June 5, 2026 at 4:24 am
        Post count: 8
        #15426
        Upvote
        Up
        0
        Down
        Not Helpful
        ::

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

        Travis PlettTravis Plett
          June 5, 2026 at 8:03 am
          Post count: 325
          #15431
          Upvote
          Up
          0
          Down
          Not Helpful
          ::

          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.

          Danni HansenDanni Hansen
            June 9, 2026 at 7:49 am
            Post count: 8
            #15444
            Upvote
            Up
            0
            Down
            Not Helpful
            ::

            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.

            Danni HansenDanni Hansen
              June 9, 2026 at 7:52 am
              Post count: 8
              #15446
              Upvote
              Up
              0
              Down
              Not Helpful
              ::

              Post moved to Feature Requests Importing G/L Registers – Insight Works Knowledge Base

            • Author
              Posts
            Viewing 5 posts - 1 through 5 (of 5 total)
            • You must be logged in to reply to this topic.