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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

F&O - Standard report of Sales and Bookings for All Customers for a Given Time Period

(2) ShareShare
ReportReport
Posted on by 4
Hi all,
We have a new implementation of F&O and are wondering - is there a simple way to pull all Sales (Invoiced Orders) and/or Bookings (Orders not invoiced) in a report? We are being told we need this 'complex' PowerBI report - this would seem to be a simple report or extract that an ERP should have? 
I have the same question (0)
  • Tom_Gioielli Profile Picture
    3,040 Super User 2026 Season 1 on at
    Moving you out of the CRM Sales and service module forums for better visibility.
  • Suggested answer
    Paolo Cecchelli Profile Picture
    344 on at
    Hi Brian,
     
    to answer to you completely we would need to know the exact information and fields that you need. Also when you say "In a given time period" means that if a line at a certain date it was not invoiced yet, you want to see the status at that point in time? If that is the request, I am not aware of any out-of the box report that can do that, below I give you some suggestions to start with:
     
    a good starting point for that is the report "All Open sales order lines". When you open the form, it will be filtered by only the Open Sales Order lines (Sales and marketing --> sales orders --> Open Sales order lines) but you can add the "Line status" column and unfilter to see all lines in every status:
    Below the result, you can also add more columns from Sales Order header or lines: 
    By looking at the status, the deliver remainder (quantity to be delivered) and the Financial remainder (quantity delivered to be invoiced) you can see the fullfillment of all lines.
     
    If you are interested in the Packing slips not invoiced there is a report for that in "Sales and marketing --> Sales Orders --> Order shipping --> Packing slip not invoiced
     
    Another possibility is to look at the list of all transactions under "Inventory management --> Inquiries and repirts --> Transactions", but there you will only see the physical movements, not the service or sales category.
     
    Otherwise if you are interested in the financial bookings, you can look at the Voucher transactions on the accounts that are hit by the Packing slip and/or Customer balance, but there you do not have the reference to the Sales order. 
     
     
    Hope it helps
  • Raj Borad Profile Picture
    1,524 on at
    Hi,
     
    You don't need a complex Power Bi solution for this.
    Invoices sales are stored in CustInvoiceTrans / Jour tables and
    Open sales are stored in SalesLine / Table tables with Sales Status Open order.
     
    For reporting purpose, you can simply built a SSRS report or a data entity to export the data.
     
    If you want advances KPI, large data or want to do analysis based on the sales data, then Power Bi is required. 
     
    Thank you,
    Raj D Borad
  • Suggested answer
    Shubham Das Profile Picture
    29 on at
    Hi,
     
    I completely agree with the above proposed solutions. One recommendation can be to explore the possibility of having the same through Business Performance Analytics which helps you in generating some complex reports very easily using fact and dimension tables( i have not created the same report but have experience in creating some of similar nature). The only downside of this is that data will not reflect real time and is ideal for reporting if real time reporting is not needed. 

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 > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 577 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 309

#3
Diego Mancassola Profile Picture

Diego Mancassola 259

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans