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 / Finance | Project Operations, Human Resources, ... / Best Report to View Ou...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Best Report to View Outstanding Balances on Balance Sheet Account per a Specific Date

(4) ShareShare
ReportReport
Posted on by CU19020705-0 22

Hi everyone,

I'm looking for a report in D365 FO that can provide a clear overview of outstanding balances on balance sheet account X as of a specific date.

What We Have Tried So Far:

  • A deferral was manually posted via the General journal, and the revenue recognition was processed manually for two out of three months—this worked fine.
  • We tested the Unsettled transactions report for April and account X, but this only displays transactions from April.
  • Running the same report for the full range (January 25 – April 30, 2024) gives more transactions. When manually summing debits and credits, the total balance matches the general ledger, but the report does not provide an overall total.
  • This report also does not clearly show which invoices/vendors contribute to the remaining balance.

What We Need:

Is there a better report that can:

  1. Show the outstanding balance for account X as of a given date.
  2. Include vendor and invoice details to make it easier to track the source of the balance.

Any suggestions on standard reports or workarounds would be greatly appreciated!

Thanks in advance. 😊

Categories:
Dynamics 365 Finance
I have the same question (0)
  • Suggested answer
    Abhilash Warrier Profile Picture
    Abhilash Warrier 5,426 Super User 2025 Season 2 on at
    Hi there,
    To get a clear overview of outstanding balances on a specific balance sheet account as of a given date in Dynamics 365 Finance & Operations (D365FO), you can use the Trial Balance report or the Financial Dimension Statement report. Here’s how you can approach this:
    Trial Balance Report:
    1. Navigate to the Trial Balance Report:
      • Go to General ledger > Inquiries and reports > Trial balance.
    2. Configure the Report:
      • Set the From date and To date to the specific date range you need.
      • Filter by the specific balance sheet account (account X).
      • Run the report to get the outstanding balance as of the specified date.
    Financial Dimension Statement Report:
    1. Navigate to the Financial Dimension Statement Report:
      • Go to General ledger > Inquiries and reports > Financial dimension statement.
    2. Configure the Report:
      • Set the From date and To date to the specific date range.
      • Filter by the specific balance sheet account and dimensions.
      • Run the report to get detailed information, including vendor and invoice details.
    Workarounds:
    • Custom Reports: If the standard reports do not meet your needs, consider creating custom reports using Management Reporter or Power BI to include specific details like vendor and invoice information.
    • Advanced Filtering: Use advanced filtering options in the Trial Balance or Financial Dimension Statement reports to drill down into specific transactions and sources of the balance.
    By using these reports and workarounds, you should be able to get a comprehensive view of outstanding balances and track the source of the balance more effectively.
  • Raj Borad Profile Picture
    Raj Borad 1,428 on at
    Hi,
     
    As per my suggestion, you need should use the data management framework and create an PowerBI report or directly exports to Excel.
    Join them with Voucher, Journal No. etc. for traceability.

    Required Tables are: VendTrans, GeneralJournalEntry, GeneralJournalAccountEntry. LedgerJournalTrans and many more as per required.
     
    Thanks,
    Raj

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

#1
Martin Dráb Profile Picture

Martin Dráb 451 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 428 Super User 2025 Season 2

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 239 Most Valuable Professional

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans