web
You’re offline. This is a read only version of the page.
close
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...
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
    95,329 Super User 2025 Season 2 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

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…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 3,229

#2
Jainam M. Kothari Profile Picture

Jainam M. Kothari 1,867 Super User 2025 Season 2

#3
YUN ZHU Profile Picture

YUN ZHU 1,153 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans