Microsoft Dynamics NAV (Archived)

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

(0) Share

Report

Posted on by Community Member

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

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

I have the same question (0)

All responses (12)

Answers (0)

Community Member on at

Like (0)

Report

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

Additionally, this error is happening for multiple users and we have tried debugging with no success to date.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

we experienced the same problem before. all we need to do is delete all Item Ledger relation. Yes You need to have a fresh database and deleted all transaction in that database. if this error occurs in other database maybe you need to check your transaction clearing and update it and add the table that need to be deleted.

But before we delete all item ledge relation we tried it to the backup database before we delete in in the main database

Note: You must aware if you delete item relation and value entry the other transaction are connected in ledger entries

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
mmv 11,471 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Suggested answer

Alex A 2,677 on at

Like (0)

Report

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]

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No