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) / Error: "The G/L -...
Microsoft Dynamics NAV (Archived)

Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

Hi Dynamics Community:

Our customer is having an issue:

Background Info

Dynamics NAV 2016 Cumulative Update 2, Australia. There have been some customizations done to database.

Error Screenshot

clip_5F00_image002.jpg

Description of Issue

This error is happening when trying to post a sales order, sales invoice, purchase order, purchase invoice, positive or negative adjustment from item journal, a service order. It happens any time when posting an item related transaction.

After clicking OK on the error, then if the user waits a few minutes, they are able to post the transaction with no issue. 

Steps Already Taken to Try to Troubleshoot

I have already researched everything I could about this issue and we have tried the following steps as suggested in articles/forum posts:

  • Run table G/L - Item Ledger Relation and check whether there is any record in table as shown in error message (we did not find any record matching one in error message)
  • Run Value Entry table and see whether there is entry number '47281' as shown in error message (we checked and there was not)

Additionally, it is my understanding that we had a fresh database before deploying to customer.

Does anyone have any ideas? 

*This post is locked for comments

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Guys, Try Cumulative 27.

    The funny thing is, this issue (in Cu2) won't come all the time. So don't get surprised if it automatically resolved.  

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    We also having this problem. Seems there is something to do with the unit cost.

    This error only popup for items with unit cost. We are investigating this issue as we speak.

    Do let us know if any of you come across any type of solution.

    Trying the new cumulative update, too early to say if it fix this issue

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Hi , I'm having the same issue. 

    I tried to replicate in my computer. I did a backup and restored in my laptop. Magically the error disappear. So it may depends on some corrupted key. I will backup and restore in the live database and see if still error after this

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Hi,

    I have the same problem with a customer. Runing NAV 2016 W1 build 9.0.44974

    In this case the customer run Warehouse Management with around 1000-2000 sales order a day.

    We have "Automatic Cost Adjustment" set to Always.

    I have a theory that the problem occurs when posting a purchase invoice with and meanwhile the Cost adjustments is running and posting the adjustments to G/L a shipment and sales invoice are posted. The sales and invoices "steals" the preliminary Value Entry No that the Cost Adjustment function have reserved.

    I think that there is some locking of tables that are not working in this case.

    /Henrik

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Hi, Have you come across for a solution with this concern?

    Thanks,

    Jan

  • Suggested answer
    Alex A Profile Picture
    Alex A 2,348 on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Have your Database person check all 4 of the following tables
    WHERE [Value Entry No_] = 47281
    OR
    WHERE [G_L Entry No_] = 0

    [G_L Entry]

    [G_L - Item Ledger Relation]

    [Value Entry]

    [Item Ledger Entry]

  • Suggested answer
    Maneesha Profile Picture
    Maneesha 5,889 on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Dear Theodore Gemmer ,

    Go to "chart of account" check whether you have made it properly

  • Suggested answer
    Amol Salvi Profile Picture
    Amol Salvi 18,694 on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    By looking at the error it seems you are using database in which somebody purged the transactions and kept only master but they might forgot to delete these additional linkage created during posting of transactions. Kindly check in these tables for the records and purge these tables also

    Or

    Create another company and copy all master from company to company and then start transactions.

  • mmv Profile Picture
    mmv 11,467 on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Hi,

    Could you try with the latest cumulative update?

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error: "The G/L - Item Ledger Relation already exists." - When posting any transactions to item ledger

    Please check G/L - Item Ledger Relation table if there is any data in the system?

    Yes it the error occur in one user the rest of the user are affected because they cant create another transaction in ledger entry.

    Thanks

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

Announcing Our 2025 Season 1 Super Users!

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

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,305 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans