Skip to main content

Notifications

Announcements

No record found.

Small and medium business | Business Central, N...
Suggested answer

Entering Duplicate Purchase Orders

Posted on by 17

I work at a wholesale distribution company.  We order 200 truckloads of the same product on a single day.  For tracking and accounting purposes, we need each truckload to have it's own Purchase Order #. 

What is the best way to create 200 PO's at a single time?  Currently I create a single PO and then select "Copy Document" 199 times.  There has to be a better way.

Thanks,

Michael

  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Entering Duplicate Purchase Orders

    Michael,

    On the Item Card, for the Item in Question, set the Order Multiple = 200. Then using the Requisition Worksheet you can generate the demand and the Purchase Order suggestions will be in increments of 200.

    Note that the demand would come from Sales Orders or a Forecast, which would create the Requisition requests for the Purchase Orders.

    Thanks,

    Steve

  • Suggested answer
    JAngle Profile Picture
    JAngle 33,159 on at
    RE: Entering Duplicate Purchase Orders

    Requisition worksheet. You can import to it and only create 1 row of data which will cater for the item/gl account and the header for the vendor.

    if this works for you then setup a recurring requisition worksheet and never key in the data again

  • Suggested answer
    Synergy-IT Profile Picture
    Synergy-IT 25 on at
    RE: Entering Duplicate Purchase Orders

    Use Configuration Package, if you know about it,  to create 200 orders, otherwise it will be time consuming to enter lines each time.

  • Suggested answer
    Andy Sather Profile Picture
    Andy Sather on at
    RE: Entering Duplicate Purchase Orders

    Hello Michael - You could import these in through Excel using a Configuration Package.

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