Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Requisition Worksheet ...
Small and medium business | Business Central, N...
Suggested answer

Requisition Worksheet with transfer Order

(0) ShareShare
ReportReport
Posted on by Samer Baskhayroun 467

One of My customer has the following scnario 

1-Use the Requisition Work Sheet to Create transfer Order from Location X to Location Y 

2-The system Create the Lines Regardless the Inventroy On Hand Avilability 

3-So when the Transfer order created and try to Ship it he recive an error message for some items which has no Avilable on Hand on Location X 

My question is :Is thier a way to create Transfer order from the Requisition Worksheet for the Items which has Enough Inventroy On Hand on the Location X ?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Requisition Worksheet with transfer Order

    Thanks Ben for your detailed answer. I will investigate those options.

    We did not use warehouse because of one location. But more and more looks like we need to use it.

    Thanks again

  • Ben Baxter Profile Picture
    Ben Baxter 5,027 Super User 2024 Season 2 on at
    RE: Requisition Worksheet with transfer Order

    Inventory Picks won't work with Dynamic Ship, as it will mark the Order Shipped during the Pick process.

    You could modify the Pick Instruction report to only print products with QOH higher than line quantity, but if you have multiple orders for same item there is no inventory allocation.  There are ways to factor that in, but you have to really think through the scenario.

    Your next best option is adding the Warehouse Shipment and Pick, just understand their is more separation inside of BC.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Requisition Worksheet with transfer Order

    Thanks Ben for information. It was really helpful

    Yes we use Pick Instruction from sales order (modified version) and we use Dynamic Ship for shipping. I will test the pick based on your guideline.

    Thanks

  • Ben Baxter Profile Picture
    Ben Baxter 5,027 Super User 2024 Season 2 on at
    RE: Requisition Worksheet with transfer Order

    You can still use Picks without Bins.  You would want to utilize the Shelf No. field from the Item Card.

    You would need to turn on Require Pick, which will create Inventory Picks.  The biggest thing to note with Inventory Picks is that once the Pick is posted it also Ships the Sales Order.  If you wanted this to be two separate processes, then you are looking at Warehouse Shipments and Warehouse Picks, which is a bit more screens to work through in BC.

    In place of Inventory Picks, some companies simply print the Sales Order as a Pick/Pack Sheet.  This means no additional processing in BC, but wouldn't solve the original request on this thread.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Requisition Worksheet with transfer Order

    Hi Ben

    I always needed more info about Pick. We did not utilize warehouse module in BC. We only have one location and no bins or etc. Can we still use Pick here? if yes does requires any extra setup? Any help will be greatly appreciate it.

    Thanks

  • Suggested answer
    Ben Baxter Profile Picture
    Ben Baxter 5,027 Super User 2024 Season 2 on at
    RE: Requisition Worksheet with transfer Order

    You could also look into using Picks, which would only create the Pick if the inventory is available to Pick.  The transfer is needed regardless of inventory level, and will cause demand for however that location is replenished.  The pick will tell the warehouse what to pull based on what is available to transfer.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Requisition Worksheet with transfer Order

    Hi

    You can go to Item List then try Availability -> Item by Locations (or in each item card check that). Or in Item list go to report and try some of those reports. 

    The other method (which we use) is to have minor customization in requisition worksheet to show QTY on hand for each item and then generator can change transfer order QTY -> create transfer order. Then run again and create second transfer order for the difference to capture the full demand. 

    Or look into this free app 

    https://appsource.microsoft.com/en-us/product/dynamics-365-business-central/PUBID.nubetechspa%7CAID.nbt_availabilitydashboard%7CPAPPID.55a3034d-e839-45ed-8ea6-7941fb2e0c1f?tab=Overview

    pastedimage1648134381256v1.png

    pastedimage1648134391003v2.png

  • Samer Baskhayroun Profile Picture
    Samer Baskhayroun 467 on at
    RE: Requisition Worksheet with transfer Order

    Thanks a lot for your explanasion

    Do you know any report can give the customer at least what is avilable in the Transfer order ?

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,433 on at
    RE: Requisition Worksheet with transfer Order

    Hi

    We had the similar situation and the only option was development. But we avoid that for the following reason

    The transfer order creates demand for location X. By forcing transfer order to not consider full needed QTY for Location Y then we do not generate demand for Location X and it is a chance we do not order that part or do not order enough. This development could also create a loop. Location Y need certain QTY but since Location X is out no Transfer order created. Then Location X never aware of that demand.

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

Congratulations 2024 Spotlight Honorees

Kudos to all of our 2024 community stars! 🎉

Meet the Top 10 leaders for December

Congratulations to our December super stars! 🥳

Start Your Super User Journey

Join the ranks of our community heros! 🦹

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,433 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans