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…

ZILLIONe is the Silver Sponsor of D365 SRI LANKA

Dynamics 365 Saturday is a free Technical & Strategy Event Organised by the Microsoft Dynamics Community MVP’s For CRM and ERP professionals, technical consultants & developers. Learn & share new skills whilst promoting best practices, helping organisations overcome the challenges of implementing a successful digital transformation strategy with Microsoft Dynamics 365.

ZILLIONe Launches Advanced SAGE Security Modules

Technology based enterprise-wide business applications and systems solutions provider, ZILLIONe recently launched their latest version of SAGE 300 ERP 2018 (v6.5) and SAGE advanced security modules. Equipped with the latest ERP and enhanced capabilities to boost productivity and profitability with sophisticated workflow features and flexible personalization, SAGE 300 2018 is a fully fledged ERP which can cater to almost any business domain.

ZILLIONe Technologies Hosts Partner Awards Night

ZILLIONe Technologies (Pvt) Ltd., exclusive distributer of Jabra Products in Sri Lanka, hosted it’s first ever partner awards night recently at the Kingsbury Hotel, Colombo. Which brought together all valued partners under one roof to appreciate their esteemed contribution with regards to product positioning and dealings in the market. Peter Jayaseelan Managing Director – India and SAARC addressed the gathering and the set the tone on the 2018 focus plan. Along with CEO of ZILLIONe Technologies (Pvt) Ltd, Kanchana Silva.

ZILLIONe Launches Latest Sage 300 ERP

Technology based enterprise-wide business application and systems solutions provider ZILLIONe recently launched SAGE 300 ERP V6.4 as a part of its annual introduction of the latest versions of SAGE ERP. The launch took place at the Movenpick Hotel, Colombo and saw the presence of some of the organisation’s key corporate clients, IT heads, finance heads and other key decision makers at each business areas.

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