Getting error on GL journal data import using LEDGERJOURNALENTITY

Like (0) Share

Report

Posted on 11 Jul 2022 20:57:01 by Vijay Yelmame VY

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.

All responses (10)

Answers (0)

Vijay Yelmame VY 442 on 12 Jul 2022 at 07:45:44

Like (0)

Report

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.
Alex Panait 170 on 12 Jul 2022 at 07:23:11

Like (0)

Report

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 17,153 Most Valuable Professional on 12 Jul 2022 at 05:13:19

Like (1)

Report

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 442 on 12 Jul 2022 at 05:07:38

Like (0)

Report

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 17,153 Most Valuable Professional on 12 Jul 2022 at 04:32:22

Like (1)

Report

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 17,153 Most Valuable Professional on 12 Jul 2022 at 04:31:13

Like (1)

Report

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 442 on 12 Jul 2022 at 04:26:57

Like (0)

Report

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 17,153 Most Valuable Professional on 12 Jul 2022 at 03:53:01

Like (1)

Report

RE: Getting error on GL journal data import using LEDGERJOURNALENTITY

Please check if there is more than one same line number.
Vijay Yelmame VY 442 on 12 Jul 2022 at 03:28:22

Like (0)

Report

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 15,033 Super User 2025 Season 1 on 12 Jul 2022 at 03:16:13

Like (0)

Report

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