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) / Receivings transaction...
Microsoft Dynamics GP (Archived)

Receivings transaction entry error in GP2013

(0) ShareShare
ReportReport
Posted on by Community Member

We just updated to GP 2013 the other day and are running into an error when doing batches for receivings. According to the sales guy, this is how he can re-create the error

Entering Recievings transaction entry – create batch – saved – auto received – search for PO#

When he hit search, he got the error

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I was hoping to attach a picture, but I guess I can't.   Here's the error

    [Microsoft][SQL Server Native Client 10.0][SQL Server] Cannot insert the value NULL into column 'UseQtyOverageTolerance' table

    'tempdb.dbo#PODetailed___________________________________________

  • Community Member Profile Picture
    Community Member on at

    nudge

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    One of the upgrades is the ability to allow tolerances.  Perhaps during the upgrade, these fields did not get filled in correctly.  Go to Inventory and open the Class IDs one by one.  Set the tolerance option (near bottom on left) and allow GP to roll these down to the items.

  • Community Member Profile Picture
    Community Member on at

    That's what our partner suggested...these were his words:

    The column referenced is in the IV00101.  You could run a select statement for this item number and verify the digit in the IV00101.  Mine are set to not use the tolerances and the value is set to 0.  Yours might be blank or NULL and GP may not like this.  Maybe you will have to run an update statement against all items making this column and the Shortage one as well equal to 0.

    We ran a SQL query and got this:

    Short story, they’re all zeros.

    select

     UseQtyOverageTolerance,

     UseQtyShortageTolerance,

     QtyOverTolerancePercent,

     QtyShortTolerancePercent,

     count(*)

    from iv00101

    group by

     UseQtyOverageTolerance,

     UseQtyShortageTolerance,

     QtyOverTolerancePercent,

     QtyShortTolerancePercent

    UseQtyOverageTolerance UseQtyShortageTolerance QtyOverTolerancePercent QtyShortTolerancePercent COUNT(*)

    0 0 0 0 5569

    From the WEST (California) company:

    UseQtyOverageTolerance UseQtyShortageTolerance QtyOverTolerancePercent QtyShortTolerancePercent COUNT(*)

    0 0 0 0 5327

    So those columns are all zeros for all our SKUs.

  • Richard Whaley Profile Picture
    Richard Whaley 25,195 on at

    Were these POs created in the prior version?  If you create a PO in the 2013 version, does it work ok?  I looked but did not see anything that needed to be set in PO line items but who knows, there are a lot of fields and I could have missed one.

  • Community Member Profile Picture
    Community Member on at

    Some are, some aren't.

    It seems to be tied to one specific vendor.

    If we create a new PO for this vendor it does not work.

  • Community Member Profile Picture
    Community Member on at

    nudge

  • Community Member Profile Picture
    Community Member on at

    Hi, we have the same problem for one vendor.  Did this get resolved??  Thanks Robert

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    OK, just fixed this.  Run this script to identify items that have an incorrect NONINVEN status..

    select * from pop10110 where NONINVEN = 0 and ITEMNMBR not in (select ITEMNMBR from IV00101)

    Then update the status to NONINVEN status to 1 and the error will go away...

    update pop10110 set noninven = 1 where NONINVEN = 0 and ITEMNMBR not in (select ITEMNMBR from IV00101)

  • Community Member Profile Picture
    Community Member on at

    We opened a case with MS a few months ago so we could get the issue fixed.  What you wrote is about what they told is to do.

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