Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Intercompany Transaction Completion issue

(0) ShareShare
ReportReport
Posted on by 20

When user try to complete IC transaction following error message appearing.

Microsoft Dynamics NAV
---------------------------

The field Unit of Measure Code of table Sales Line contains a value (NOS) that cannot be found in the related table (Item Unit of Measure).
---------------------------
OK
---------------------------

Even though all the cross reference are correct from item side & company side above error appearing.

This is occurred due to UOM conversion error in another transaction.

To overcome this issue. User have to filter required transaction number (IC transaction Number) from complete line transaction action. 

2308.solution.png

Then user can process required transaction without issue

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Intercompany Transaction Completion issue

    Prabath,

    Yes, agreed. When I train my customers using IC I tell them whomever is working the Inbox or Outbox make sure it is processed completely leaving nothing open.

    Thanks,

    Steve

  • RE: Intercompany Transaction Completion issue

    Steven,

    Agree with you, If we are not processing transactions we should cancel to delete from inbox.

    I think we should maintain blank IC inbox as much as we can.   

    Thank you,

    Prabath

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Intercompany Transaction Completion issue

    Prabath,

    Are you saying that the list of IC Transactions in the image are false and need to be removed? I see Posting Dates that should not be there from years ago. You can Return to IC Partner if you will not process them or Cancel to delete from Inbox.

    Thanks,

    Steve

  • RE: Intercompany Transaction Completion issue

    Hi Steven,

    All the item cross reference including base UOM also set up NOS, that the only UOM.

    even though that was correctly setup, above error has been occurred. 

    In this scenario what has happened is Intercompany IC inbox consist with serval transactions. 

    Like below,

    2474.PNG

    So, what I've done is select required transaction number from the filter as explained above. Then execute it.

    I think this was occurred due to conversion error of another IC transaction. However, if we are not filter transaction number then system might consider all the IC transaction instead of required transaction.

    Thanks,

    Prabath

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Intercompany Transaction Completion issue

    Prabeth,

    So the Item being sold on the Sales Lines that has a UOM = NOS, that Items Base UOM is what and is their an Item UOM conversion from NOS to Base UOM?

    Thanks,

    Steve

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

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans