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 NAV (Archived) / Recommended reorder re...
Microsoft Dynamics NAV (Archived)

Recommended reorder report

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

Navision reporting off the shelf is less than stellar. 

Having said this, I have been searching for a 'Recommended Reorder Report (ROR)' which is typically a basic report in most accounting/inventory management softwares. 

The ROR would be simplistic mathematically:   On hand quantity + on order quantity - allocation (sales orders, WIP, etc.) = net available.  Once the net available falls at, or below, the predetermined 'reorder point' established in Navisions Planning module, the sku would then show up on the next report being ran.  Some sorting options would be beneficial i.e. by vendor, sku, etc. 

I do not see this report, or anything of the sort, in Navision 2017. ANY help would be greatly appreciated as this has quickly become extremely frustrating

*This post is locked for comments

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Recommended reorder report

    [quote user="tanders"]

    Thank you for the feedback. The Requisition Worksheet is utilized for something completely different i.e. tying a sku of a SO to a PO.

    [/quote]

    Hi,

    The Requisition Worksheet can be used for different occasions.
    For my current client, we did set up Stockkeeping Units to control a minimum Inventory for a certain location. The Requisition Worksheet is then used to calculate the gross requirement for a given period and to create the corresponding documents (e.g. Transfer Order, Purchase Order) to fill the Inventory up again.

    E.g. you could calculate the gross requirement for a specific period and let NAV fill in suggestions into the Requisition Worksheet. You are able to export the Requisition Worksheet to Excel for further calculations or presentations.

  • Community Member Profile Picture
    Community Member on at
    RE: Recommended reorder report

    Thank you for the feedback. The Requisition Worksheet is utilized for something completely different i.e. tying a sku of a SO to a PO.

    What I am looking for is what I indicated originally.  This report is SOP for most Accounting/IM softwares, and should be basic for Navision given its a Microsoft based software.  

  • Hannes Holst Profile Picture
    Hannes Holst 5,767 on at
    RE: Recommended reorder report

    Hi there,

    It looks like that that what you are looking for is called "Requisition Worksheet" in NAV.

    The implementation is different as you expect it (it's not a report, it's a editable Worksheet). Based on the Stockkeeping Units, you are able to generate suggestions based on the future gross requirement.

    Best for you would probably be to get in contact with your NAV-partner so that a profound analysis and training for your particular situation can be done.

    If you are keen on learning by yourself, you could start here:

    "How to: Run Full Planning, MPS or MRP": docs.microsoft.com/.../production-how-to-run-mps-and-mrp

    "How to: Set Up Stockkeeping Units": docs.microsoft.com/.../inventory-how-to-set-up-stockkeeping-units

    Calculate gross requirement: docs.microsoft.com/.../hh174806(v=nav.90)

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans