Sage 300 CashView

Mar 4, 2020

Cash flow is vital in any business. Knowing whether you have enough cash to pay salary, rental, suppliers and the many other activities in your business has always been a challenge for businesses. Your investment in Sage 300 is a positive step to better managing your finances. An Accountant using Sage 300 would be able to tell if you have sufficient funds to run the business. For someone who does not have the time to scrutinize the numbers on a regular basis, you would wish for a better solution. A solution that looks at all the numbers and have them presented in an easily understood manner, with option to go into details, if so desired. CashView is a premier cash management tool designed with a dashboard approach that gives SMEs real-time view of their cashflow, timely alerts on cashflow shortages. By design, it’s a module that has an inbuilt cash flow Intelligence which will retrieve financial data, process them and determine if you are facing a cash flow crunch. This basically performs a forward-looking analysis so that the user is advised of a situation way ahead of time. It’s simple and uncluttered interface hides all the complexities necessary to determine if there is a potential problem, projected into the future. It is a great tool if you just need a heads-up indication of how your business is fairing and at the same time offers targeted details that you can immediately focus on.
Benefits of using CashView:  
  • Provides users with a smarter way to manage cashflow
  • Real time visibility of a company’s Cashflow, timely alerts on cashflow shortages.
  • View current & future cash balance positions
  • Know the business better with a simplified dashboard and reports showing the key financial metrics in the form of charts/widgets & statistical data
  • Allows senior management staff (CEO, CFO etc.) who do not access SAGE300 to stay on top of things by having this add-on informing them as soon as a cash flow problem is encountered.

Dashboard

This screen presents financial metrics in the form of charts and widgets. These are the available metrics and the detailed information about them.

Cash Flow Summary

The cash flow summary screen uses a layout that shows how your cash flow status looks like over time (days’ ranges). Beginning from top row, it shows your cash position (based on amounts in your cash and bank accounts configured for this) over each days’ range after accounting for any movements during the period.

A/R Summary

This screen shows ten customers with the highest outstanding balance. It has information on the credit amount you have extended to them (in customer currency) and also the highest balance they reached in the year. This information is shown in a tabular form as well as in a horizontal bar chart. It also has 2 types of reports that you can print.
It also has 2 types of reports that you can print.
  • Top 10 Customers by Outstanding Balance: This report shows the same information shown in the A/R Summary screen in the Inquiry function. It is useful if you need a copy of what you see in the screen. The information here is as at the last date and time when the cash flow data was refreshed. The Highest Balance in Functional Currency is not calculated in this module. It is the values maintained by the core A/R module. You can see this amount in the Customer Master.
  • Receivables Forecast
    1. It provides for up to 7 ranges – Due plus 6 user defined ranges.
    2. It shows the percentage of balances for each range against the total outstanding for the Customer.
    3. It shows the percentage of balances for each range for all customers against the total outstanding for all Customers.
    4. Where multi-receipts are used, the report shows them separately with their calculated Due Date instead of treating them as due based on the first receipt due date. This is a better reflection of the receivables due.

A/R Summary

This screen shows ten vendors with the highest outstanding balance. It has information on the credit amount extended to your company by them (in the currency that you transact with them) and also the highest balance that you have reached in the year. This information is shown in a tabular form as well as in a horizontal bar chart.
It also has 2 types of reports that you can print.
  • Top 10 Vendors by Outstanding Balance This report shows the same information shown in the A/P Summary screen in the Inquiry function. It is useful if you need a copy of what you see in the screen. The information here is as at the last date and time when the cash flow data was refreshed. The Highest Balance in Functional Currency is not calculated in this module. It is the values maintained by the core A/P module. You can see this amount in the Vendor Master.
  • Payables Forecast This report provides a detailed look at the cash requirements over the projected future days’ ranges. Unlike the standard A/P Cash Requirements report in the Accounts Payable module, this report differs in the following areas:
    1. It provides for up to 7 ranges – Due plus 6 user defined ranges.
    2. It shows the percentage of balances for each range against the total outstanding for the Vendor.
    3. It shows the percentage of balances for each range for all vendors against the total outstanding for all Vendors.
    4. Where multi-payments are used, the report shows them separately with their calculated Due Date instead of treating.

In the News…

More Blogs…

How Copilot in Dynamics 365 Business Central can revolutionise your business 

In today’s fast-paced business world, staying competitive means embracing the latest technological advancements. This is where the powerhouse partnership of Copilot in Dynamics 365 Business Central can help you stay ahead of the curve. This dynamic duo is here to...

Latest features and updates in the M365 mobile app 

Enhanced Productivity with Copilot Chat  The Microsoft 365 mobile app remains an indispensable tool for staying productive while on the move, offering access to Word, Excel, PowerPoint, and PDFs. Now, it's even more powerful with Microsoft Copilot Chat and...

Dynamics Nav Vs Dynamics 365 Business Central: Benefits of upgrading to Business Central 

In the fast-paced world of business technology, staying ahead is not just an advantage; it's a necessity. With data vulnerabilities on an upward trend, it is crucial to protect company information at all costs. Gartner estimates that over 85% of organisations will...

ZILLIONe Takes Center Stage at Regional Tech Summit to Empower Tech Industry and Youth in Galle

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

Empower Your Business with ZILLIONe´s Microsoft FastTrack Services: Protecting Data, and Boosting Productivity

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

Exclusive benefits by ZILLIONe’s FastTrack ready partners to Microsoft 365 subscribers

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

Let´s Celebrate! ZILLIONe is officially “Great Place to Work” certified.

Advance systems today allow for preservation of multiple versions of databases that may be restored from different points in time.

5 reasons why your company needs a cloud recovery and backup plan

Advance systems today allow for preservation of multiple versions of databases that may be restored from different points in time.

Seal deals seamlessly with Microsoft Dynamics 365 Customer Service Solutions.

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka

What’s new in Microsoft Teams – June 2022

Learn what’s new with MS Teams as of June 2022. Learn a range of tips and tricks. ZILLIONe is a Gold partner and the only fast track partner in Sri Lanka