Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Book Image

Real-world Business Intelligence with Microsoft Dynamics GP

Overview of this book

Table of Contents (20 chapters)
Real-world Business Intelligence with Microsoft Dynamics GP
Credits
About the Author
Acknowledgments
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Ratio of AP to AR


Businesses need cash and cash flow to operate, so monitoring our accounts receivable (cash inflow) compared to our accounts payable (cash outflow) is critical.

Brief background of the company

We are still working with the company from the previous report. This company is a retail/distribution company that sells from their website, www.amazon.com, using an outside sales team (for bulk sales) and a brick and mortar store.

Pain or goal defined

To improve cash flow, this company needs to evaluate how many times the accounts receivable is being paid and regenerated during the course of a year, and how many times the accounts payable will be paid and regenerated during the course of a year.

Monitoring these numbers gives a more accurate depiction of what is happening with collections and cash flow than from simply looking at an AR or AP Aged Trial Balance. This review is more robust because it takes sales and purchases into consideration.

Having large profits on your profit and loss...