Home › Forums › Import Export PowerTool › No permissions to update or modify table 17 – General Ledger Entries

Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • Albert SubiranaAlbert Subirana
      January 7, 2025 at 8:32 am
      Post count: 4
      #12520

      Hello, trying to update a custom field on the G/L Entries table and getting a permission error:

      Sorry, the current permissions prevented the action. (TableData 17 G/L Entry Modify: Import Export PowerTool)

      I have SUPER without company restriction.

      IEPT Setup is also set with Update Access = Allow and Protected Tables = Allow Access.

      Is it possible to do this?

       

      Travis PlettTravis Plett
        January 7, 2025 at 11:39 am
        Post count: 325
        #12542
        Upvote
        Up
        0
        Down
        Not Helpful
        ::

        There are a lot of protected ledger tables that 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 General Ledger Entries, Job Ledger Entries, Bank Ledger Entry tables, Physical Inventory Ledger Entry.

        Albert SubiranaAlbert Subirana
          January 7, 2025 at 12:28 pm
          Post count: 4
          #12543
          Upvote
          Up
          0
          Down
          Not Helpful
          ::

          Thanks for the information!

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