bank accounts list

(0) Share

Report

Posted on by Neilh@q

Why can't I add bank account balances in either currency or local currency to the bank list when I try personalise:

Further to this, what table or query do I use for Power BI report to give the MD a daily bank balance list of all the bank accounts in the bank's currency and the local equivalent?

All responses (2)

Answers (0)

Suggested answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: bank accounts list

Neilh,

When I am implementing the Bank Account with my customers I will book an Entry as follows in the General Ledger:

I left the error message here on purpose. You need to make sure that Direct Posting is ON for this one entry, then turn off. This washes the GL Entry but leave the Bank Balance in the sub-ledger. If you need to post Outstanding Checks and Deposits, you do the same thing entering the Check Numbers as Document No. and correct Posting Date. Offset against the correct G/L Cash Account and allow for Direct Posting. After posted, turn the Direct Posting OFF.

Hope this helps.

Thanks,

Steve
Suggested answer

JAngle 33,159 on at

Like (0)

Report

RE: bank accounts list

The list will need a modification. For Power BI publish page 370 as a web service and use that instead. It’s the card page of the bank account. When used as a web service it will grab all the bank accounts.

Modification wise you can use “Design” in a sandbox and then have it added as an extension by a developer or your Microsoft partner “. Failing that search on appsource for simple object designer