Skip to main content

Notifications

Microsoft Dynamics GP (Archived)

Can't run HITB Reset - 'item is on open PO Return'

Posted on by 1,730

I am trying to create the HITB report for the first time, and getting this error on several items.  Reviewing the returns, these are all really old ones from several years ago, and they are all closed out as far as we can see.  I suspect some sort of doctoring will need to be done in SQL to fix this, but I am not sure what table to edit or what field needs to be changed to flag a PO Return as closed.  The PO's are all closed in the system, nothing further can be entered on the front end, so I'm not sure what else to do to clear these so we can create the HITB report.

*This post is locked for comments

  • Suggested answer
    Mahmoud Saadi Profile Picture
    Mahmoud Saadi 32,738 on at
    RE: Can't run HITB Reset - 'item is on open PO Return'

    Hello Rob,

    This error is due to records in POP10300, look for POPTYPE (4,5,6,7)

    I have previously written some stuff about the HITB, and such special cases:

    HITB Essentials series - SEE Table

    HITB Essentials series - Tool Deployment

    Your feedback is highly appreciated,

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans
Liquid error: parsing "/globalsearch/?q=enitative+for+Resa+(II)+e++s+rIian+nnvator" - Nested quantifier +.