web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Search for purchase or...
Small and medium business | Business Central, N...
Answered

Search for purchase order in combined invoice

(0) ShareShare
ReportReport
Posted on by Frida_Admotion 387

Hi all!

We have just starting to use ExFlow (add-on) for scanning and combining purchases invoices. 

When we still posted one invoiced per purchase order, we was able to see the PO-number connected to each invoice in the list and at the invoice.

Now in the combined invoice, this numbers seems invisible. Also any attachment on the original POs are gone.

Any suggestion how I can search for a particular PO-number when using combined purchases invoices?

Is there a possibility to still have the attachment saved somehow?

I have select to archive old POs that will be removed manually, just for "the record". But they will not contain the attachments either.

I have the same question (0)
  • Verified answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

    Hi,

    I assume You are entering the ExFlow Import Journal lines.

    On the top part You can Leave the Order No. blank, and on the Lower part - the sub-lines, there add columns Order No. and Order Line No.

    In these 2 fields You can find all Purchase Orders from this Vendor and provide to which line the amount links. The Order Line No. can be left blank (I think).

    Please test this in TEST system to confirm it works as You need.

  • Frida_Admotion Profile Picture
    Frida_Admotion 387 on at

    Hi, my problem is not in Exflow. My problem is to find my old PO-numbers in the Posted purchase order list, when ExFlow has combined them.

  • Suggested answer
    KasparsSemjonovs Profile Picture
    KasparsSemjonovs 4,774 Super User 2025 Season 2 on at

    ouh, that is not impossible. You see these values until Approval is finished. After Posting there is no place to see those linked Order numbers.
    You would neeed to reach out to ExFlow provider to add Customization for that.

    UPDATED: Actually You might want to check the Purch. Inv. Line table (table ID 123) field: Order No. (Field ID 12013606). Might be the value You are looking for is there.

    If You would use Standard system functionality when creating Invoices, it would add description line reference to the linked Purchase Orders, and that would be seen also in the Posted Purchase Invoice lines.

  • Verified answer
    Frida_Admotion Profile Picture
    Frida_Admotion 387 on at
    We solved this issue by using the list of Posted Purchase receipts instead. There you can search for Order No. and also we enadbled a setting in Exflow "Copy Attachments from Order to Posted Receipt" for the attachement to follow the receipts instead.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,362

#2
YUN ZHU Profile Picture

YUN ZHU 867 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 607

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans