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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Unanswered

Purchase Order Details

(0) ShareShare
ReportReport
Posted on by 2
Hi All,
 
      I want to create a custom report for a purchase order, that report should show all the purchase order details for all companies how can we create this report, any base reports are there like this, if anyone knows, help me regarding creating this report, thanks for your advices
 
 
Thanks & Regards,
Satish.
I have the same question (0)
  • HVGEEL Profile Picture
    308 on at
    Hi Satish,
     
    please elaborate on your business case: what is this exaclty that you need contained in the report?
    - Purchase Header ( limited to type::Order?) details: Vendor | Exp Receipt Date | Location | Payment Terms | Approvals | Analyticals?
    AND/OR
    - Purchase Lines ( limited to type::Order?) Qty | Rem Qty? | Direct Unit Cost | Discounts | Analyticals...
     
    the standard Page Purchase Lines will do most of the work for you, even though it will only show the Purchase Lines for the current company.
    And it will require a filter on type::Order
     
    Given the fact that your requirement states the need to get Purchase data for all companies, please consider doing this in BI.
    Out-of-the box, BC reports never cross-company borders.
     
  • Satish Profile Picture
    2 on at
    Hi HVGEEL
        
                      In the puchase header i want the details like po  no, status, currencycode, ship to name, invoice date, shipment date and in the purchase lines i want qty and unitprice, for these things i have created a custom report and filtered with order, now i want the details of purchase orders of all companies, can you tell me this can be achieved through reports or not, if not give me suggestions how can i do it, thanks for your advice.
     
    Thnaks & Regards,
    Satish.
  • YUN ZHU Profile Picture
    97,970 Super User 2026 Season 1 on at
    Hi, hope the following helps.
    Collect data from different companies and Drilldown into the data of another company
    Creating Report with temporary table
     
     
    Thanks.
    ZHU

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,161 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,046 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 932 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans