Question

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

  • 26 August 2021
  • 6 replies
  • 74 views

Userlevel 2
Badge
  • Jr Varsity II
  • 100 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

 


6 replies

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.

Userlevel 2
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,

which version are you on?

Userlevel 2
Badge

Erin,

which version are you on?

2021

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

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!

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 — 2022  Acumatica, Inc. All rights reserved