web
You’re offline. This is a read only version of the page.
close
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

I have the same question (0)
  • Suggested answer
    Suresh Kulla Profile Picture
    Suresh Kulla 50,245 Super User 2025 Season 2 on at

    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

  • Suggested answer
    Teddy Herryanto (That NAV Guy) Profile Picture
    Teddy Herryanto (Th... 14,284 Super User 2025 Season 2 on at

    Do not comment out the locking.

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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1
HoangNam Profile Picture

HoangNam 7

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans