Home Forums Import Export PowerTool Incomplete import

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • Elina KalimElina Kalim
      Post count: 2

      Hi, I am new to this tool. I noticed a few issues:

      1. After importing general journals, it says the import completed with 80 records imported. However, only 1 line is imported and pending postings.
      2. When importing with “Allow records updates” turned off, it gives an error stating that such records already exist, when in fact the record does not exist.

      Example: The record in table Gen. Journal Line already exists. Identification fields and values: Journal Template Name=’GENERAL’,Journal Batch Name=’TEST-EXP’,Line No.=’0

      Please advise.

      Travis PlettTravis Plett
        Post count: 132
        Based on this message you almost certainly have not specified either the proper batch name and/or the proper journal template in the import file. The data will be in the table, just not visible in the journal/batch you are looking at.
        To see the data in the table, use the “Page Inspector” in Business Central (ctrl+alt+f1) on the journal and then click “view table” – that will show the imported data and what journal/batch values were imported.
        Your Business Central partner can assist you with the correct data layout required to import journals.
        Below is a sample for a general journal from Cronus sample data that shows the fields required.
        Before importing it, you would need a general journal batch called “example”, along with the same customer/account numbers.
        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)
      • You must be logged in to reply to this topic.