News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) Can't run HITB Res...

Microsoft Dynamics GP (Archived)

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

(0) Share

Report

Report

Posted on by Rob Klaproth

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

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mahmoud Saadi 32,738 on at

Like (1)

Report

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,

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans