Microsoft Dynamics NAV (Archived)

The Posted Document Dimension already exists.

(0) Share

Report

Posted on by santarzan

397

Hi All ,

while trying to post the credit memo i am getting the below msg.

---------------------------
Microsoft Dynamics NAV Classic
---------------------------
The Posted Document Dimension already exists. Identification fields and values: Table ID='6650',Document No.='PS106000',Line No.='0',Dimension Code='FUNCTION'
---------------------------
OK
---------------------------

As i know that it might be due to the user deleted the posted document from the system,

Pls suggest the fix to post the Credit memo.

*This post is locked for comments

All responses (8)

Answers (4)

Verified answer

Rabin 2,976 on at

Like (0)

Report

RE: The Posted Document Dimension already exists.

Hi Santosh,

The Posting Number for document is present in the Table, Just modify the Number and then try posting the document. It is assigned in automatically at the time of creating the document... [Use the Modified No.]
Verified answer

Ashwini Tripathi 4,624 on at

Like (0)

Report

RE: The Posted Document Dimension already exists.

The Posting No. for document is in the Table, you modify the No. and try posting the document. It is assigned in advance at the time of creating the document.

If Dimension yo feel is orphan and no existing document for same, you can delete the dimension from the posted table but be careful if you do so.

Try using the first approach.

Assign the Last no from the Series and update the Last no used in No. Series accordingly.
santarzan 397 on at

Like (0)

Report

RE: The Posted Document Dimension already exists.

Hi Alex,

Also i found that there are posted return shipment for the same number to which it's trying to post.

in the number series the last used no is different but while posting this document its taking the already posted no.
Suggested answer

Alexander Ermakov 28,094 on at

Like (1)

Report

RE: The Posted Document Dimension already exists.

Santosh,

This is also an option, but it requires manual correction of data tables in NAV. Generally, it is not recommended to do that. However, sometimes it is needed in order to maintain the data integrity of already partly corrected documents.
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: The Posted Document Dimension already exists.

to me this error it's all about orphan posted dimension, you say the source document was deleted, delete the whole dimension SET from the Posted Document Dimension table could be a way

also check Item Ledger entry -> Ledger Entry Dimension

edit NB: straight delete on dimension table it's "ok" only for NAV2009 or older version, in newest version 2013> it's totally diffent and painful.
santarzan 397 on at

Like (0)

Report

RE: The Posted Document Dimension already exists.

can i delete the data related to the that document from Document Dimension table and post the credit memo
Verified answer

Amol Salvi 18,694 on at

Like (0)

Report

RE: The Posted Document Dimension already exists.

Change the last no used in No series and try to post the document.
Verified answer

Alexander Ermakov 28,094 on at

Like (0)

Report

RE: The Posted Document Dimension already exists.

It looks like the posted return shipment with such number already exist. Try changing the last number used in the setup of the number of series for posted return shipments, changing that from PS106000 to the next number and post the document again.