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

How to create a PO of inventory item automatically for a Job

(1) ShareShare
ReportReport
Posted on by

Hi everyone,

I would need some help or best practice how to generate a PO for specific job in Business Central.  Thank you.

We have a lot of inventory items on Job Planning lines and the request is how to create a PO for specific job automatically?  I tried Requisition Worksheet adding a filter 'Qty on Job Order' <>0, but not able to filter by job number.  Any suggestions or best practice how to do this?

Kind regards,

  • Suggested answer
    Ben Baxter Profile Picture
    5,653 Super User 2025 Season 1 on at
    RE: How to create a PO of inventory item automatically for a Job

    It is 100% possible out of the box!

    On your Item card (or SKU if using Locations), set the Reordering Policy to either Order (1:1 with forced reservation) or Lot-for-Lot (Many:1 with optional reservations).  With either of these options set the system will start making recommendations to purchase the Item based on Job demand.

    If you want the Job No. specified on the PO, you have to use the Order policy.  This creates a reservation, so you have to make sure you're warehouse staff is disciplined on receiving and staging the Items for the Job specified.

    If you are okay without the Job No., but knowing the system is planning the supply, use Lot-for-Lot policy.  This avoids the potential headaches associated with reservations.

    Reach out to your partner for additional information on how to fine tune these settings to get the Req. Worksheet giving you the best results for your business.

    (Edit) P.S. Make sure the "Apply Usage Link" is checked on the Job.  You can set this default to on in the Jobs Setup

  • Suggested answer
    MahGah Profile Picture
    15,437 on at
    RE: How to create a PO of inventory item automatically for a Job

    Hi

    I have been told this is not possible out of box. I can see the following idea "under review"

    experience.dynamics.com/.../

    Also, either you can use development or 3rd party app such as below

    amerdian.com/.../

    Also, you can reserve each line of PO by entering Job No. this is line by line base. 

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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,349 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 233,029 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans