Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Bulk import Issue.
Microsoft Dynamics NAV (Archived)

Bulk import Issue.

(0) ShareShare
ReportReport
Posted on by Sathish C 184

One of our client having a process where Navision 2016  will receive records from window service.

once inserting into staging table same entries are creating in gen Journal lines and posting through standard codeUnit(Bulk posting i.e. CodeUnit 13 Gen. Jnl.-Post Batch).

Inserting is happening Fast but bulk posting consuming so much time for 25k records (3.5 hrs) where client will have lakhs of records to be posted.

 

Table lock issue is happening in GL entry and Gen Jnl line, is there any way to solve this.(Avoid Table lock.) Or Can we just comment the table lock Code.

 

can anybody help me on bulk posting in fast way and quick.

*This post is locked for comments

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 13,637 Moderator on at
    RE: Bulk import Issue.

    Do not comment out the locking.

    Try to post the transaction outside of business hours so it does not lock other users.

  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 47,785 on at
    RE: Bulk import Issue.

    You cannot comment table lock it will create inconsistency issue, instead of posting all the lines at the same time, try to post the lines in blocks like 20 lines or 30 lines, which should help to resolve the table lock issue and Timing issue

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans