Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Combining "duplicate r...
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 Community member 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? 
  • Suggested answer
    Jun Wang Profile Picture
    Jun Wang 7,443 Super User 2024 Season 2 on at
    Combining "duplicate requisitions" on req sheet for purchase \ transfer order
    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.
     
     
     
     
  • gdrenteria Profile Picture
    gdrenteria 12,181 Most Valuable Professional on at
    Combining "duplicate requisitions" on req sheet for purchase \ transfer order
    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

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