Solved

Dash Board - Cash Position - Cash by Period Figure not tally

  • 26 August 2021
  • 6 replies
  • 125 views

Userlevel 3
Badge
  • Jr Varsity II
  • 103 replies

Hi Everyone

I am encountered a problem in dash board - cash position .

Not sure why not all the cash account are capture and only certain cash account’s figure will reflected in the dashboard. Not sure if there is any setting wrongly.

Please refer to the attached file for details explanation.

 

Hope anyone can advise for me. thank you

 

icon

Best answer by alicezyks51 24 August 2022, 18:46

View original

6 replies

Userlevel 4
Badge +1

jkasprzyk98 - Our quick fix to the dashboard issue was to setup a recurring journal entry for the first day of every financial period which is a debit and credit of $.01 to the cash accounts which are not used daily. (ie. money market) Running this net zero entry gets all the accounts to appear without modifying the dashboard or underlying GI’s. This should work no matter what version you’re on. Hope this helps!

Badge

Same issue - 2022R1 - The cash on Hand report is just a reworked version of the Cash by Period report. If the Client looks at their cash position at the beginning of a month, they are off sometime in excess of 80%. Does anyone have a workaround for Daily cash vs Period cash. Needs a solution.

 

Userlevel 3
Badge

Erin,

which version are you on?

2021

Userlevel 3
Badge +1

Erin,

which version are you on?

Userlevel 3
Badge

Erin, 

The DB Cash By Period inquiry does not show the accounts without activity in the current period.

If you are on 2021R1, consider using the CA-CashOnHand (CA0001DB) inquiry based on which we have created the Cash on Hand scorecard . The Cash on Hand scorecard is a part of the preconfigured Controller (DB000038) dashboard.

Hi Olga

Thanks

We are based on this inquiry insert into dashboard, Do you know any idea that can show the actual Cash Balance? which existing inquiry we can use in order to reflect the exact Cash balance figure?

Userlevel 3
Badge +1

Erin, 

The DB Cash By Period inquiry does not show the accounts without activity in the current period.

If you are on 2021R1, consider using the CA-CashOnHand (CA0001DB) inquiry based on which we have created the Cash on Hand scorecard . The Cash on Hand scorecard is a part of the preconfigured Controller (DB000038) dashboard.

Reply


About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved