Skip to content

Import Export PowerTool

Incomplete import

Viewing 2 posts – 1 through 2 (of 2 total)
  • Author
    Posts
  • #8381
    Elina K.

    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.

    #9733
    Travis P.
    Insight Works
    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)
  • Sign in below to reply.