News and Announcements icon

Dynamics 365 CommunityForums 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) Share

Report

Report

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?

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Jun Wang 7,443 Super User 2024 Season 2 on at

Like (1)

Report

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 12,338 Most Valuable Professional on at

Like (0)

Report

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

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