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
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.]
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.
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.
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.
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.
can i delete the data related to the that document from Document Dimension table and post the credit memo
Change the last no used in No series and try to post the document.
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,902 Super User 2024 Season 2
Martin Dráb 229,297 Most Valuable Professional
nmaenpaa 101,156