Home › Forums › Import Export PowerTool › Importing into Posted Tables

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • John EllisJohn Ellis
      October 3, 2025 at 7:55 am
      Post count: 5
      #13980

      Hi:

      I imported journal entries directly into Business Central’s table 81, in a test environment.

      These entries are, now, displaying in the “General Ledger Entries” screen.

      Does this mean that the Import Export PowerTool can import data into posted tables?

      I ask, because “General Ledger Entries” to me has always represented the posted General Ledger data of Business Central.

      Thanks!

      John

      Travis PlettTravis Plett
        October 3, 2025 at 8:34 am
        Post count: 325
        #13984
        Upvote
        Up
        0
        Down
        Not Helpful
        ::

        The Import Export PowerTool does not do any data analysis other than applying any filters that you set. The data needs to follow all the same rules as with a configuration package. If you have any questions about table import restrictions, you would need to talk to Microsoft.

        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.

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