Search this site

Download our free checklist to help you plan your migration. Download our free checklist to help you plan your migration. Submit Download Submitted! Now Click the Download Button

An interview with a financial analyst about the benefits and uses of Jira within the banking industry. Watch the full interview CASE STUDY Banking Industry An interview with a financial analyst about the benefits and uses of Jira within the banking industry.

How-to - Bank Balance Detailed Report Jet Reports Bank Balance Detailed Report A Bank balance report is a financial report that provides information on the cash balance of a customer, a company, or an organization's bank accounts. it typically includes all details on every transaction that has occurred in a bank account over a specified period, such as deposits, withdrawals, and fees. The report shows the total balance of all transactions that occurred during the period. The aim of creating this report is to give a clearer picture of transaction-by-transaction of the cash position of an organization’s bank accounts. This information can be used to make financial decisions about when to invest surplus funds or borrow to meet cash shortfalls. This report is also useful to reconcile any errors in bank transactions by tracking fund’s movement in and out of a bank. Join On Point Academy to view all content Join the academy → Log in → To create this Bank account analysis report, we need information from 2 different tables… Bank account Bank account ledger entries The following information as shown below will be retrieved from the table. Procedure Step 1 Know where to pull your data from The NL(Rows) will contain our source of data, which will be pulled from the table “Bank Account and Bank Account Ledger Entry“. The NF (Keys) will be a cell reference, which will be referencing cell $D%(Bank Account) and $J5(Bank Account Ledger Entry), and the fields will be pulled from the names as shown. Step 2 Creating Report Options I’m applying two filters to my report, “Date filter“ and “Company“ Click on the report options tab in the ribbon, and the pop-out, and fill in as shown. The Company filter is applied in case you want to run the report for a particular company. Note: When Filling in the Date range, you can separate it as “Period Start and Period End“. Each is on a separate line. E.G. Period Start = 1/1/2022 Period End = 12/31/2022. Or use as Date Range as shown here… I want my report to show all transactions from the first one to the selected end date, which speaks to why the formula is (=../02/28/2023) Step 3 Filling in the formulas Since we now know where to pull our table, keys, and fields from, I’ll show you how to do that here. Once you are done creating the functions, you can remove the names on the last row. They are just there to guide you on the name to put in the field when filling in the formulas. filling the formulas for the NL(Rows) Fill in as shown below for the NL for Bank Account, apply the filter for company… referencing to the report Option. Filling the formulas for NF fill in as shown below Note: use the same procedure to fill in for all NF, the only difference will be the field. Go to cell J5, Fill in for NL (Bank Account Ledger Entry) as shown below Apply the date filter and the company filter here also… all referencing the report option. Note that when applying the filter on “No.”, we refer to the No. on our report in cell E5. Fill in for the NF (Bank Account Ledger Entry) Note: use the same procedure to fill in for all NF, the only difference will be the field. When you are done filling in the formulas, your report should look as shown below. Step 4 Run your report. When you run your report, it should be like this. Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

How-to - Adding Dimension to Configuration Package Microsoft Business Central Adding Dimension to Configuration Package This is a step-by-step walkthrough how to add Dimension to your Business Central. Join On Point Academy to view all content Join the academy → Log in → Steps: 2. 3. 4. Activate Dimension as Columns 5. Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

Register for On Point's monthly webinars and event tackling different software solutions, how-tos, best practices and more. Upcoming Events AI, ITSM & Adoption: Building Human-Centered IT Experiences for African Organizations Thu, 23 Jul Webinar More info Learn More Past Events Future Of Work Nigeria 2026 Fri, 17 Jul Lagos More info Details Cyber Security in 2026: Why Compliance Alone is No Longer Enough Thu, 05 Mar Streamyard More info Details Future Of Work Ghana Fri, 21 Nov Accra More info Details Future Of Work Nigeria Thu, 25 Sept Lagos More info Details Why Traditional ITAM Fails Wed, 17 Sept Streamyard More info Details Multiple Dates Transform Budgeting & Planning with Bizview Thu, 12 Dec StreamYard More info Details Al is reshaping the world of work. Is your team ready? Thu, 14 Nov Location is TBD More info Details Eliminate Clutter and Save Time with Attachment Viewer Thu, 31 Oct Streamyard More info Details ITSM Connect Boardroom Experience Fri, 20 Sept Accra More info Details Multiple Dates Why Estimation and Forecasting are Crucial in Agile Projects Wed, 11 Sept StreamYard More info Details Jira Essentials: Mastering Task Management for Teams Wed, 31 Jul StreamYard More info Details Dynamics 365 Business Central: What’s New & Next Thu, 27 Jun StreamYard More info Details Jira For Construction Tue, 04 Jun Stream Yard More info Details Let's talk Jira Fri, 22 Mar Zoom More info Details ITSM Connect Business Breakfast Edition Fri, 09 Feb Accra More info Details Planning & Budgeting in PowerBI using Aimplan Tue, 12 Dec Zoom More info Details Document Management Made Easy with BC Thu, 02 Nov Webinar (Zoom) More info Details ITSM Connect 23 - Lagos Fri, 06 Oct Lagos More info Details Load More

Work Future of Nigeria COPILOT & AI FOR NIGERIAN WORKPLACES REGISTER NOW THE ART HOTEL, LAGOS VENUE: 25TH SEPTEMBER 2025 DATE: 9AM PROMPT TIME: An exclusive boardroom forum where Nigeria’s leaders shape the AI-powered workplace of tomorrow. The workplace is evolving faster than ever. Globally, 70% of executives believe AI will be the most disruptive force of the next three years, yet fewer than 25% have a clear adoption strategy. In Nigeria, where the digital economy is projected to add over $150 billion by 2030, the moment to act is now. Future of Work Nigeria is an invite-only executive forum hosted by OnPoint (Microsoft Solutions Partner) and Cloudmania, in partnership with Microsoft. Designed exclusively for CEOs, CIOs, CTOs, and senior decision-makers, this closed-door dialogue will examine how Microsoft Copilot & AI can transform Nigerian enterprises in governance, productivity, compliance, and growth. This is not a technology showcase. It is a strategic boardroom dialogue where leaders present will help define the next decade of Nigerian business. Why You Should Attend? Exclusive Insights: Firsthand access to Microsoft’s latest Copilot and AI innovations, contextualized for Nigerian workplaces. Boardroom-Level Dialogue: Engage directly with a select circle of Nigeria’s most influential executives. Strategic Foresight: Understand how AI will reshape competitiveness, workforce productivity, and customer engagement. Peer Exchange: Connect with C-suite leaders tackling similar opportunities and challenges. Nation-Defining Impact: The strategies discussed in this room will shape how Nigeria’s digital economy matures. REGISTER NOW Who Should Attend? Attendance is strictly reserved for CEOs, CIOs, CTOs, COOs, Managing Directors, and other top decision-makers in Nigeria’s leading organizations. This forum is for leaders who: Set enterprise-wide strategy. Are exploring how AI can unlock efficiency, compliance, and growth. Recognize that Nigeria’s business future will be led by those who embrace digital adoption today.

How-to - Adding Exch. Rates manually in currency table Microsoft Business Central Adding Exch. Rates manually in currency table Join On Point Academy to view all content Join the academy → Log in → Go to search and type Currencies and click on link under Go to Pages and Tasks Select the required currency code and click on Process > Exch. Rates Click on New and populate the following fields in the line: Starting Date : date Exchange Rate Amount : rate for the day Relational Exchange Rate Amount : 1 Adjustment Exch. Rate Amount : same as Exchange Rate Amount Relational Adjmt. Exch Rate Amt : 1 Fix Exchange Rate Amount : Relational Currency Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

With Jira for Construction, Handle Complex Construction Projects through One Single System. Join the Hub, Enjoy Project Management better Digital scheduling, Collaboration & Communication Get started for free Your Agile World-Class Software for Digitising Project Construction Project Document Workflows Templates Versioning Notifications Ideate faster than ever Capture and prioritise ideas and align everyone with product roadmaps - all in one single Jira platform. Jump in on the best, ready-to-use templates Stay afloat of everything! Jira syncs with your product requirements, exactly how you want it. Assign workflows to teams, engage customers for efficiency An Interactive Roadmap Unlock collaboration and visualisation challenge Add Epics Map work items Manage Dependencies Let’s get your teams and stakeholders aligned and informed Enjoy work more, grid less! 1. Recruitment Jira and Confluence Accomplish more together. Confluence is your remote-friendly team workspace where knowledge and collaboration meet. Plan Plan and view work in one place. Map dependencies using Jira roadmap. Shared Focus Track the big pic within in the team. Stay in sync on progress and priorities. Communication Keep stake holders informed. Drive comments and Drive discussions on the go. 2. Onboarding Documentation Workflows Document Real-time editing Co-edit together in real-time and publish updates that highlight changes tracked with version history. Chat Commenting Make it a team effort with in-line and page comments, likes and visual elements, such as images, GIFs and emojis. Notification Notification Alert your team mates when you tag them or assign a task so everyone stays on top of progress. One Single Source of Documentation Templates Find templates from product requirement documents to marketing plans so you can jump in. Page Versioning Track and view the history of changes to each page, compare versions, and revert changes. Macros Add interactivity to Confluence pages with extra functionality or dynamic content. Thousands of thriving construction project managers do it the JIRA way! Trusted by over 40,000 companies worldwide Start your free trial now! Learn more about Jira for Construction Download free eBook → 3. Operations Jira Service Management Provide service and support without the cost and complexity of traditional ITSM solutions.

A holistic POS software solution integrating your entire fashion retail business. Retail Grocery Point of Sale (POS) A holistic POS software solution integrating your entire fashion retail business. Impeccable automated stock control Set up automatic replenishment of standard stock to save time and resources. Easily manage your inventory and find the right product combination to meet sales goals and maximize revenue for each one of your grocery stores. Our advanced inventory feature also includes blended wireless technology to facilitate mobility and productivity. In addition, head office can be confident that the stock databases are up-to-date. Enhanced checkout speed and flexibility Ensure a speedy and flexible checkout with our solutions. Each POS will include a copy of the database with maximum speed and resilience irrespective of the number of POS’s in use to ensure operations up to your customer’s satisfaction even during peak hours. Our solution also caters for self-checkouts. Mobile app for grocery customer Nurture customer loyalty with LS Retail mobile app to ensure returning customers. Let customers create shopping lists to invite them come to your stores by sending personalized offers, promotions and electronic vouchers directly on their mobile. Robust POS features Give your sales associates an abundance of information on their POS interface empowering them to provide a holistic and efficient service. Product related information can be provided on both stationary terminals and tablet devices. Enhance warehouse efficiency Minimize waste and reduce losses as you spend less time on managing warehouse processes and be in full control of your inventory. Manage promotions and coupons Keep control over coupons from head office as you prepare prices in advance to come up with the best match. All LS Central POS software solutions include Microsoft's industry leading ERP/accounting software, Dynamics 365 Business Central Learn more Why LS Central Point of Sale ? Thrive with LS Retail to facilitate all your business operations across all levels and platforms. Improve work and sales processes by benefiting from extensive automation capabilities. Discover more about LS Retail to benefit from increasing revenue and reduce costs for your business. POS terminals without limits A simple POS sales device and be extended to a useful sales assistant’s tool with up-to-date inventory, store and location data. Grows with you An easily customizable and centralised application, that enhances POS terminal flexibility and agility. Designed for you Customized to fit your business. Gain complete control of your business One encompassing solution to manage risks and gain complete control of your business. Combine online & offline shopping Ease the flow between the online and offline shopping experience across different channels within the fashion retailing environment through LS Fashion’s omni-channel feature. Provide accurate financial data Eliminate inconsistencies caused by unreliable financial data to enhance revenue and reduce operating costs. Provide real time data lookup Ensure real time data lookup for critical transactions, including loyalty discounts, gift cards, returns and refunds.

Spreadsheet Server integrates your ERP or accounting software to your Microsoft Excel. Such software helps companies create automated custom reporting according to business requirements. SPEADSHEET SERVER Live, drillable reports from any ERP/accounting sofware GET IN TOUCH Start in Excel, Stay in Excel Tired of manually copy and pasting data into Excel to create reports? Spreadsheet Server puts an end to tedious, error-prone, and manual reporting processes while still letting you work in the environment you’re most comfortable – Microsoft Excel. Connect Excel to your preferred ERP/accounting software and create complex reports with real-time data to ensure your entire organization has a clear and accurate view of exactly what is going on in finance and operations. Eliminate IT dependency Designed for everyday Excel users; you won’t need IT or super users to create or update Answer all your questions Full drill-down capability from summary to transaction inside Excel so you can identify and resolve issues No more data dumps Live access to all of your ERP data within Microsoft Excel Support all your reporting needs Build a range of reports from simple ad-hoc workbooks to complex dashboard views of critical business data Bring all your data into focus Create custom reports from any other databases within Excel with a simple click of a button. Safe & Simple Installation No server, staging area, or data warehouse required Spreadsheet Server integrates with 140+ ERP/Accounting Software

Live Webinar Dynamics 365 Business Central: What’s New & Next 27th June 1PM UTC Live on StreamYard About the Webinar Join us for an exclusive webinar as we dive into the exciting new upgrades for Microsoft Dynamics 365 Business Central. Discover how the latest features and enhancements can revolutionise your business operations, streamline workflows, and propel your organisation into the future. Why You Should Attend In this upcoming webinar, our speakers will discuss the latest developments and updates in Microsoft Dynamics 365 Business Central. Their in-depth knowledge and extensive experience with Business Central are what make this webinar truly exceptional, offering unparalleled insights into the future of business software solutions. Join us to learn from experts whose insights promise to make this event a one-of-a-kind experience. The Speakers Stephen Abela Director | Onpoint Focusing in Microsoft Dynamics NAV 365 BC, Atlassian and business reporting software, with a demonstrated history of working with many companies from SMEs to MNCs in different industries. Mark Bonnici Senior Consultant | Onpoint Boasting over ten years of hands-on experience with Microsoft Dynamics 365 Business Central. Throughout his career, Mark has cultivated a deep understanding of Business Central, making him a trusted expert in the field. Known for his exceptional client rapport and problem-solving acumen, Mark is the go-to expert when challenges arise. Key Takeaways Overview of Microsoft Dynamics 365 Business Central and its capabilities. Discover how the latest features and enhancements can revolutionise your business operations, Exciting new upgrades for Microsoft Dynamics 365 Business Central. Overview of Business Central's customisation capabilities, including personalisation of forms, fields, and workflows. CONNECT WITH US

On Point Tech Talks are a series of podcasts covering interesting topic vis-a-vis Microsoft Dynamics 365 Business Central, Atlassian Jira and Confluence, Jet Reports and other software solutions we offer. Sprint Podcast Trailer Sprint Podcast Sprints by onpoint - Trailer S1EP1 Sprint Podcast Why Sprints? S1EP2 Sprint Podcast Why Sprints? (Part 2) S1EP3 Sprint Podcast Boys Boys - Around the world (well Lagos) & beyond S1EP4 Sprint Podcast 1957 - Not the regular "independence" story! S1EP5 Sprint Podcast Developer's Lens | Agile? S1EP6 Sprint Podcast Developer's Lens | Agile?