Skip to main content

Notifications

Small and medium business | Business Central, N...
Unanswered

Purchase Order Details

Posted on by 75
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.
Categories:
  • YUN ZHU Profile Picture
    YUN ZHU 73,333 Super User 2024 Season 2 on at
    Purchase Order Details
    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
  • Satish Profile Picture
    Satish 75 on at
    Purchase Order Details
    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.
  • HVGEEL Profile Picture
    HVGEEL 288 on at
    Purchase Order Details
    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.
     

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!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

New! Quick response templatesâš¡

Save time with the new custom templates!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,219 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,056 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans