web
You’re offline. This is a read only version of the page.
close
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) / Unit of measure error ...
Microsoft Dynamics GP (Archived)

Unit of measure error creating a purchase order

(0) ShareShare
ReportReport
Posted on by Jo Ann Flaum 330

Our client changed the currency decimal places on one item from 2 to 0, using the GP utility. The unit of measure schedule is EA and there is an equivalency to EA of 1. On the price list screen, the default selling unit of measure is EA, as it should be. On the purchasing screen, there is no default unit of measure and nothing shows up in the list if we do a lookup on that field. If we try to type in EA, we get a message that EA isn't in the item's unit of measure schedule. We get the same message trying to put the item on a PO. What happened and what do we do to fix it?

*This post is locked for comments

I have the same question (0)
  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Go to Cards->Inventory->Item and pull up this item. The click on the GoTo button and choose Purchasing. You enter the purchasing U/M on that screen.

  • Jo Ann Flaum Profile Picture
    Jo Ann Flaum 330 on at

    There was no purchasing U/M to choose. We ended up changing the UMS to a new one, chainging the purchasing u/m and price list u/m to the one associated with the new ums. Then we changed it back to the old UMS and it worked. I still have no idea how that happened.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Then there is something wrong with the U/M Schedule ID for this item. If you go to Tools->Setup->Inventory->U/M Schedule and pull up the schedule what do you see there?

  • Jo Ann Flaum Profile Picture
    Jo Ann Flaum 330 on at

    ums EA shows 0 decimals, shows EA as a uom, equivalence = 1 EA. Looking up the uom on the price list screen showed EA, on the purchase screen showed nothing.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    The U/M on the item price list screen has nothing to do with the purchasing U/M. Are you saying when you go to the item purchasing screen there are no U/M available to be selected? If so, is a U/M Schedule ID assigned to this item?

  • Jo Ann Flaum Profile Picture
    Jo Ann Flaum 330 on at

    Yes, that's what I'm saying. Yes, there's a ums assigned to the item. That's why I mentioned the price list window - if I go to the default selling uom field and search, EA shows; but if I go to the default purchasing uom field on the purchase screen and search, nothing shows.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    What happens if you simply type EA in the Purchasing Unit of Measure field? Does it take it or say invalid unit of measure?

    If you run this in SQL

    select UOMSCHDL  from iv00101 WHERE ITEMNMBR='Your Part Number' do you see the correct U/M Schedule?

  • Jo Ann Flaum Profile Picture
    Jo Ann Flaum 330 on at

    It says invalid unit of measure.

    Since we've since corrected the problem by putting a different ums on the item and then switching it back to EA, the SQL query won't help now. However, if it were the wrong schedule there would be a problem on the price list window also. And I did try reselecting the ums schedule on the item, to make sure it was picking up the one I wanted.

  • Richard Wheeler Profile Picture
    Richard Wheeler 75,848 Moderator on at

    Please send me a private message and we can schedule a time for me to hook up and take a look a this. This just is not making any sense.

  • Lisa Dochstader Profile Picture
    Lisa Dochstader 5 on at

    I am seeing a similar issue - its as if the Item Purchasing window does not see the Unit of Measure schedule's units of measure - there are none to choose.

    The values exist in the IV40202 - but are just not available to select in the Item Purchasing window.

    Adding a new uofm to the Unit of Measure schedule appears to enable the unit of measures in the Item Purchasing window - problem is this re-occurs for every new item added - can't keep adding uofm's.

    Were you able to get this resolved - we're on version 10.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

#1
mtabor Profile Picture

mtabor 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans