HI Great Plains Community!
I am working with Great Plains on the back end (SQL) trying to determine the GLs to pull for Days Cash on Hand. What I am using now is:
CASH [10XX+11XX] / Expenses [5XXXX+6XXX+7XXX] - Depreciation [68XX] then take this number and divide by number of days in the Period.
I know what the number should be based on calulation from Finance, but I can't get to that number. Does anyone have suggestions about how this would work? Are the views of any use in figuring out things like this?
Thanks!
*This post is locked for comments