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 / Microsoft Dynamics SL (Archived) / daily cash balance rep...
Microsoft Dynamics SL (Archived)

daily cash balance report data flow

(0) ShareShare
ReportReport
Posted on by dnlchristanto 45

Hello.. Please your help..

Anybody know how is the data flow of the daily cash balance report? I have some problem with daily cash balance report.. I have some records that doesn't posted in Daily Cash Balance rpt, but in GL does.. I need table information that involved in this flow.. Please help me,anybody..

And 1 more thing, can I post AR Doc with different bank acct?

e.q:

Rec 1 with bankacct 110310

Rec 2 with bankacct 110320

Thank you.

Regards.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    Hi

    This report used to obtain an up-to-date review of your company’s total cash position. It displays each of your company’s cash accounts and its current balance (the value at Currency ID specifies the currency used to denominate each account balance). For each account displayed, its balance is as current as the last transaction batch released in these modules: Accounts Payable, Accounts Receivable, and Cash Manager.

    The report format specifies the type of report to generate. Report format options are:

    •         Summary — Generate the report in an encapsulated format that includes only selected cash account balance information: transaction date, beginning balance, receipts, disbursements, ending balance.

    •         Detail — Generate the report in an in depth format that includes all account summary information plus the transaction-level information that produced the current balance displayed: transaction date, reference number, journal type, transaction description, period posted, etc. Information on this report is available for review or editing in the Accounts Payable and Accounts Receivable modules, as well as the Cash Manager module.

    On the detail version, note the following for each cash account:

    –         Jl Tp identifies the module (Accounts Payable, Accounts Receivable, or Cash Manager for example) where each cash account transaction originated.

    –         Tn Tp specifies each transaction’s transaction type (for example, TR for transfer, SC for service charge).

    –         Payee ID lists the ID of vendors to whom checks/electronic payments  listed are issued.

    Hope this helps

    Thanks & Regards

  • dnlchristanto Profile Picture
    dnlchristanto 45 on at

    Dear Mr.Santhosh,

    Thank you for your help,it was very useful.

    But do you know what the tables (database) that involved in that process in module AP,AR,CM.

    I want to trace the data,because i have a problem with my daily cash manager report which that some record doesn't posted in that report..

    And 1 more thing, can I post AR Doc with different bank acct?

    e.q:

    Rec 1 with bankacct 110310

    Rec 2 with bankacct 110320

    Thank you very much for the help..

    Regards,

    Daniel

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 > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans