web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Suggested Answer

Combining "duplicate requisitions" on req sheet for purchase \ transfer order

(1) ShareShare
ReportReport
Posted on by 4
We are experiencing and issue in which when requisition sheets are run from MRP there will be multiple lines of the same item being ordered in various quantities for the same location. Currently we are pulling these requisition sheets out of NAV and into Excel, combining the /duplicate/ lines and then reuploading the edited Excell workbook into NAV for the purchase and transfer orders. Is there a way to have NAV combine these duplicate lines for us, or is there a configuration we are missing in item // SKU // location? 
I have the same question (0)
  • Gerardo Rentería García Profile Picture
    25,213 Most Valuable Professional on at
    Hi
    By item, have you configured the SKUs?
    It is also indicated there, for example, transfers from one warehouse to another that could be different.
    Best regards
    Gerardo
  • Suggested answer
    Jun Wang Profile Picture
    8,200 Super User 2025 Season 2 on at
    it depends on your setup of the parameters for item planning. If no SKU is used, it means NAV treats each demand seperately. When SKU is used, user could set up a more centralized way of planning.
     
    for example: for item ABC
    location X: sku ABC x,       replenish: transfer from y
    location Y: sku ABC y,       replenish:  transfer from z
    location Z: sku ABC z,        replenish: purchase 
     
    let say there is no inventor of ABC and 2 is needed for X, 3 is needed for Y, 5 is needed for Z.
    when NAV finds item ABC is needed, it create a purchase order for Z with qty of 10
    then transfer order will be created to move items to X and Y per setup.
     
     
     
     

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…

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,143

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,694 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,067 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans