Skip to main content

Notifications

Business Central forum
Answered

Confirmation of Purchase Order acceptance by Vendor

Posted on by 95

Hi there.

A basic process that i'm fairly sure most organisations using Business Central will go through when raising a purchase order on a Vendor is to confirm that the vendor has received the P/O and that it's been accepted.  There is a field in the purchase order [Vendor order number], but this field is not surfaced on the primary purchase order summary screen (showing all open purchase order), so there's no way of filtering or showing P/O's that have no Vendor Order Number.  

Anybody figured out a neat way of flagging when an order has been 'confirmed' by a vendor?  Entering a promised receipt date would be a start, but again - the field isn't available to include in the standard purchase order summary screen.  

For any company that has sent a P/O and it's (for whatever reason) failed to get to the vendor, and then found out 10 days later that the product/goods/services you ordered aren't going to show up when expected... that' can cause some serious headaches!!  I want to create a flow to email the vendor if we haven't received confirmation within 48 hours.

I'm interest to understand how other users manage this process.

Thanks
Chris.

Categories:
  • chris_7777au Profile Picture
    chris_7777au 95 on at
    RE: Confirmation of Purchase Order acceptance by Vendor

    Mah you got it.  I had " instead of ''

    Thanks everybody for your guidance.

  • Suggested answer
    MahGah Profile Picture
    MahGah 15,419 on at
    RE: Confirmation of Purchase Order acceptance by Vendor

    Just a quick note here that the " is not " it is two of ' which is like this''

  • Suggested answer
    S.Kawamura Profile Picture
    S.Kawamura 1,520 on at
    RE: Confirmation of Purchase Order acceptance by Vendor

    That's weird.. It filters correctly in my environment. 
    Could you try the following steps?

    "Vendor Order No." field can be added to this list page.
    pastedimage1649822255692v1.png

    Select a line whose "Vendor Order No." is not blank in this list page and choose "Filter to This value".
    pastedimage1649822460210v3.png

    The "Vendor Order No." will then appear in the filter pane.
    pastedimage1649822484558v4.png

    Then try copy-pasting the following values into the filter criteria
    <>''
    pastedimage1649822619579v5.png

    Would this still not work?

    I hope it works out well.

    S.Kawamura

  • chris_7777au Profile Picture
    chris_7777au 95 on at
    RE: Confirmation of Purchase Order acceptance by Vendor

    Hi there Shinichi.  

    Thanks for responding.  When I go into the purchase order summary page and apply the filter to the field Vendor Order Number as you have, the purchase orders WITH an assigned vendor order number are still appearing.  Given the field Vendor Order Number cannot be added to the columns, is there a possibility that the filter won't work (i.e. the available filter fields include fields that are not available to add to the page).  

    To be honest - I didn't think the field list that you could filter on would be different than the fields you could insert/apply to the page.

    Any ideas?

  • Verified answer
    S.Kawamura Profile Picture
    S.Kawamura 1,520 on at
    RE: Confirmation of Purchase Order acceptance by Vendor

    Hi,

    The easiest way to pick out purchase orders whose "Vendor Requisition Number" is not blank and display them on the Purchase Order List page is as follows.
    1. Press the Filter button in the upper right corner.
    2. Specify "Vendor Order No." as the filter field in the filter pane displayed on the left side, and specify "<>''" as the value of the filter condition.
    pastedimage1649820594997v1.png
    To verify that this filter is functioning properly, you can view the Page Inspection Pane. Press Ctrl+Alt+F1 and the page inspection pane will appear on right side. The value of the record selected on the list page is then displayed. This includes fields not shown on the list page.

    This filter condition can be saved by pressing the Save button in the Filter pane. You can then easily restore the filter condition at any time.
    pastedimage1649821283167v1.png

    I hope this helps you.

    S.Kawamura

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

Dynamics 365 Community Update – Sep 16th

Welcome to the next edition of the Community Platform Update. This is a weekly…

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,522 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,441 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans