Skip to content

Import Export PowerTool

Excel and Journal Entries — Import Export Power Tool

Viewing 2 posts – 1 through 2 (of 2 total)
  • Author
    Posts
  • #8320
    John E.

    I have used the Import Export tool, before.  It worked wonderfully.

    Not only that, I read just this morning that the Import Export tool can be scheduled to run after-hours.  Business Central’s Configuration Packages cannot.

    But, I have found that (a) you can’t import data into journal entries (General Journals) using an Excel spreadsheet and (b) importing into Table 81 for journal entries does not recognize the batch name that you need to put the entries in.

    Why is that?  Thanks!  🙂

    #9639
    Melonie W.
    Insight Works

    Hi John, the Import Export PowerTool does work well with journal imports. It’s possibly that the file you’re using does not have the fields set up properly. Below is sample text that you can copy and paste into Excel to see the details and will properly import into a General Journal batch called “EXAMPLE” in a Cronus database with the accounts listed in the file. Hope this helps!

     

    tableid:81
    Journal Template Name Journal Batch Name Line No. Posting Date Document Type Document No. Account Type *Account No. Currency Code Tax Group Code *Amount Bal. Account Type *Bal. Account No.
    GENERAL EXAMPLE 10000 8/22/2022 Invoice G00001 Customer 01454545 USD 1,234.56 G/L Account 13100
    GENERAL EXAMPLE 20000 8/22/2022 G00001 G/L Account 11200 TAXABLE 9,876.54 Bank Account CHECKING

Viewing 2 posts – 1 through 2 (of 2 total)
  • Sign in below to reply.