Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics RMS (Archived)

HQ WORSHEET 340 (PO PLANNER) QUERY ORDER METHOD USING RE-ORDER LEVELS

Posted on by 465

Hi,

 

I am using RMS HQ 2.0.166 on SQL 2005/2008

When generating a PO planner (worksheet 340) based on  re-order level at HQ , is there any way of of filtering out items which have a zero re-order information from being generated as items on the contents tab

 

Regards

 

Derek

 

 

*This post is locked for comments

  • Derek McGrath Profile Picture
    Derek McGrath 465 on at
    RE: HQ WORSHEET 340 (PO PLANNER) QUERY ORDER METHOD USING RE-ORDER LEVELS

    Hi SpencerM,

    Thanks for your help here.

    Derek

  • Spencer McCandless Profile Picture
    Spencer McCandless 2,085 on at
    RE: HQ WORSHEET 340 (PO PLANNER) QUERY ORDER METHOD USING RE-ORDER LEVELS

    Hi Derek,

    I'm not sure I understand the question. Are items with 0 as the restock level appearing when you attempt to create a purchase order based on reorder points? I believe this can happen if quantities of an item go into negative, as the columns that contain reorder information in the database are integers and contain a zero rather than a null when nothing is entered.

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!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans