Skip to main content
Post a question

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id : CSTDQpci5f60X9Tl2CpAqa
Finance | Project Operations, Human Resources, ...
Suggested answer

Getting error on GL journal data import using LEDGERJOURNALENTITY

Like (0) ShareShare
ReportReport
Posted on 11 Jul 2022 20:57:01 by 442

Hi Experts,
I am getting below error while importing data using LEDGERJOURNALENTITY, I am assigning journalBatchNumber from excel file and in GL parameters i have set GL batch number sequence to manual. Also i tried approach of setting set based operation to false but nothing is working.

Please suggest me  the solution.

pastedimage1657572688234v1.png

  • Vijay Yelmame VY Profile Picture
    442 on 12 Jul 2022 at 07:45:44
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Hi Billur, Alex,

    I have tried many ways but it did not worked, whenever i am separating records according to my Account field values then i am able to import in same journal batch number. still i am not able to understand why it is throwing error when 2 different account has given. Please find below 2 screen shots of my files.
    pastedimage1657611875810v1.png

    pastedimage1657611925502v2.png

  • Alex Panait Profile Picture
    170 on 12 Jul 2022 at 07:23:11
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    You should check the vouchers as well since the system will try to reconcile them with the journal numbers probably.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    17,153 Most Valuable Professional on 12 Jul 2022 at 05:13:19
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Ok. Can you please delete all the lines in the Excel sheet that you see as blank/unfilled. Select all the lines after your data and delete.

  • Vijay Yelmame VY Profile Picture
    442 on 12 Jul 2022 at 05:07:38
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Hi Billur,

    There is no Posted journals.

    As suggested by you firstly I have imported 3 lines it got succeed, then i imported 14 it also got succeed. but when i am giving full length file then it is failing with same error for all records.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    17,153 Most Valuable Professional on 12 Jul 2022 at 04:32:22
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Also please check if there is this journal number already on a posted journal.

  • Suggested answer
    BillurSamdancioglu Profile Picture
    17,153 Most Valuable Professional on 12 Jul 2022 at 04:31:13
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Can you please try to import just one line first and then  if succeed try to upload 2 lines. Lets see if we still have the same error.

  • Vijay Yelmame VY Profile Picture
    442 on 12 Jul 2022 at 04:26:57
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Hi Billur,

    I have kept line number auto generated in view map on import projects. so there should not be the concerns about line num.

    Regards,

    Vijay Yelmame

  • Suggested answer
    BillurSamdancioglu Profile Picture
    17,153 Most Valuable Professional on 12 Jul 2022 at 03:53:01
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Please check if there is more than one same line number.

  • Vijay Yelmame VY Profile Picture
    442 on 12 Jul 2022 at 03:28:22
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    Hi Saurabh,

    Format is exactly same as number sequence. Even I tried to assign generated journalbatchnumber but not work.

  • Suggested answer
    saurabh bharti Profile Picture
    15,033 Super User 2025 Season 1 on 12 Jul 2022 at 03:16:13
    RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

    What is the format setup in on number sequence? though it is manual some times system try to validate the format.

    So just give same format on number sequence which you are using in file

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,884 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,760 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Product updates

Dynamics 365 release plans
Loading complete