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 GP (Archived) / UOM in IV00107 & I...
Microsoft Dynamics GP (Archived)

UOM in IV00107 & IV00108

(0) ShareShare
ReportReport
Posted on by Community Member

Dears,

Please note that we are using GP 10 SV5, we are facing a problem in UOM of the item. The default selling UOM of the item was removed from the table IV00107 & IV00108 without knowing the reason. Reference to this at SOP screen the system is bringing a wrong UOM at the SOP level that will affect the quantity and the cost related.

In addition of this upon posting any PO receiving, the transaction will hang if it contains any item having this problem.

Can anybody help in this?

Thank you.

N.B. We are using the extended price in GP

*This post is locked for comments

  • Community Member Profile Picture
    Community Member on at
    Re: UOM in IV00107 & IV00108

    Dear Mohamed,

    Please note that we have created the following trigger on IV00107 & IV00108

    USE [AFDCO]

    GO

    /****** Object:  Trigger [DI_UOMCHECK108]    Script Date: 07/11/2012 18:09:14 ******/

    SET ANSI_NULLS ON

    GO

    SET QUOTED_IDENTIFIER ON

    GO

    -- =============================================

    -- Author: <Author,,Name>

    -- Create date: <Create Date,,>

    -- Description: <Description,,>

    -- =============================================

    CREATE TRIGGER [DI_UOMCHECK108]

      ON  [dbo].[IV00108]

      FOR DELETE

    AS

    BEGIN

    EXEC sys.sp_addmessage 66668, 16, 'This is a Major Error, Check with the IT.';

    RAISERROR(66668, 16, 1);

    END

    After the creation we noticed that this message was appearing upon posting the Sales Returns and the batches related went to Batch Recovery and some of the Receiving POs were hanged as well.

    Please advise.

  • Community Member Profile Picture
    Community Member on at
    Re: UOM in IV00107 & IV00108

    Hi Mohamed,

    Reference to our investigation with you, we have put  the following query in a job that will trigger an email in case the system will find any item without UOM. For sometime this trigger will return a true result but when we check which item we do not find it. I run it several time upon the pick time so it show a record then it will disappear. The users are working mainly on SOP, Inventory transations & POP.

    What do you advise? Is this related to anything in extended price? Somthing should be done at the Basic price level? This is only brainstorming ideas.

    This will be the select

    select * from iv00101 where selnguom not in (select uofm from iv00107 where itemnmbr = iv00101.itemnmbr)

    Thank you for your help  

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: UOM in IV00107 & IV00108

    Charles,

    As I have worked with you on this, I think this is not a well known issue with GP and will require to be invistigated in your database, I would suggest adding triggers on your database to monitor when this being removed and get the exact behavior that causes this operation.

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

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

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

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans