Search this site

Jet Reports Conditional Hiding of Rows in Jet Reports In this tutorial, we will show you how to use conditional hiding of rows in Excel. This useful feature allows you to hide entire rows based on certain criteria. For example, you may want to hide rows where the balance is less than or equal to zero. By using conditional hiding, you can make your reports more concise and easier to read. We have created a simple report showing the following Customer No Customer Name Balance Join On Point Academy to view all content Join the academy → Log in → Here is a view of what our report looks like before we apply the conditional hiding We would like to apply conditional hiding to hide rows where the balance equals zero. Step 1: Create a Label in Cell B1 To get started, create a label in cell B1. This label should read "Hide+?" and will be used to identify the rows that you want to hide. Step 2 : Use a Formula to Hide Rows Based on Criteria Next, use a formula to return "Hide" in a row you want to hide. For example, if you want to hide any rows where the balance in cell F5 is less than or equal to zero, you can use the formula "=IF(F5<=0,"Hide","")". Step 4: Run the Report After applying the formula and hiding the appropriate rows, run the report to see the changes. Your report should now display only the rows meeting the specified criteria. In conclusion, conditional hiding of rows is a useful feature that can help you make your reports more concise and easier to read. By following the steps outlined in this tutorial, you can easily use conditional hiding to hide rows based on certain criteria in a professional and friendly manner. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Data Processing Addendum (DPA) General Last updated: April 2021 Note: this is not part of the DPA hereunder Some points on the importance of a DPA: Essentially, a DPA is a legally binding document to be entered into between the controller and the processor in writing or in electronic form. The GDPR requires data controllers to take measures to ensure the protection of the personal data they handle. If data controllers decide to outsource certain data processing activities, they must be able to demonstrate that their suppliers and sub-processors also provide sufficient guarantees to protect the data and act in a GDPR compliant manner. So, to say if one is a controller and as a result of outsourcing, you wish to transfer your data to a third-party, for example, a cloud provider you need to sign a DPA with that third party. The obligation is on both the Controller and the Processor. This Data Processing Addendum (“Processing Agreement”) governs the processing of personal data under Service Agreement between On Point Limited (“Company”), a limited liability company incorporated under the laws of Malta, bearing company registration C81670, with its registered office at: 8, 24 Church Street, Zebbug, Malta and the “Vendor”. The Processing Agreement has been pre-signed by the Vendor. This Processing Agreement is effective as of the date signed below by the parties (“Processing Agreement Effective Date”). This Processing Agreement shall be required, subject to the following conditions: i. You must have placed an order for an app on the Atlassian Marketplace and ii. You have not made any deletions to other revisions to this DPA. DEFINITIONS ‘Controller’ This shall mean a natural or legal person, public authority, agency or other body which, alone or jointly with others, determines the purposes and means of the Processing of Personal Data; where the purposes and means of such processing are determined by Union or Member State law, the controller or the specific criteria for its nomination may be provided for by Union or Member State law; ‘Data Protection Laws’ This shall mean the laws and regulations, applicable from time to time, in respect of processing of personal data, including but not limited to Regulation (EU) 2016/679 of the European Parliament and of the council on the protection of natural persons with regard to the processing of personal data and on the free movement of such data General Data Protection Regulation (the ‘GDPR’), as well as the supervisory authority’s binding decisions, regulations and recommendations and supplementary local adaptions and regulations in respect of data protection in Malta. ‘End Users’ This shall mean an individual you permit or invite to use the App(s), including: i. Individuals invited by your End User (s) ii. Individuals under managed accounts, and iii. Individuals interacting with an app as your customer or other relations. ‘Processor’ This shall mean a natural or legal person, public authority, agency or other body which processes personal data on behalf of the controller. ‘Sub-Processor’ This shall mean another processor engaged by the Vendor for carrying out specific processing activities on behalf of the Vendor (including but not limited to companies within the Vendor’s group of companies). The Sub-Processor will have access and will be able to process personal data from the Controller, always with the controllers written approval. ‘Third Country’ This shall mean a country outside the European Economic Area (EEA). Any other term used in capitalized letters in this Processing Agreement (such as ‘Data Subject’, ‘Processing’ and ‘Personal Data’) shall, unless otherwise stated, have the meaning provided for under the national Data Protection Act (“The Act”) and The General Data Protection Regulation (“GDPR”). LEGISLATION The Data Processor Agreement shall ensure that the Data Processor complies with the applicable data protection and privacy legislation (the “Applicable Law”), including in particular The General Data Protection Regulation (“GDPR”) (Regulation (EU) 2016/679), the national Data Protection Act (The “Act”) Chapter 586 of the Laws of Malta and any applicable national subsidiary legislation. GENERAL Under this Processing Agreement, the Vendor shall have the right to process data, including Personal Data, in connection with the use of the app and Vendor’s provision of services under the agreement. Vendor shall ensure that it and each of its sub-processors (if any) shall comply at all times with the applicable law and shall not perform their obligations in such a way as to cause such party or Company (or any of its affiliates) to breach any such laws. Vendor is the processor and Company is the Controller. Vendor may not otherwise use or modify the personal data, merge it with other data, commercially exploit it, disclose it, transfer it across international borders (in the case that the data is transferred outside the EU or the EEA), or do any other thing that may in any manner adversely affect the integrity, security or confidentiality of such personal data, other than as expressly specified herein or the Service Agreement referred above. PROCESSING SPECIFICATION Nature and purpose of the intended Processing of Data The Subject-matter of Processing of Personal Data by Processor is the provision of the services to the Controller that involves the Processing of Personal Data, Personal Data will be subject to those Processing activities as may be specified in the Processing Agreement and an Order. Types of Personal Data Categories of Data Subjects The type(s) of Personal Data to be Processed by the Vendor under this Processing Agreement, the purpose and duration of the Processing and categories of Data Subjects are set out in Appendix 1 (Instructions regarding the Processing of Personal Data). The Vendor shall only Process Personal Data on documented instructions from the Data Subject as set out in Appendix 1. As of the Effective date, additional Processing may also be performed provided that Union of Member State law to which the Vendor or a sub-processor is subject to requires such Processing. In such case of additional processing, the Vendor shall inform the Company of that legal requirement before Processing, unless that law prohibits such information on important grounds of public interest. The customer undertakes to fulfil its duties as Controller under the applicable Data Protection laws. The Customer undertakes to continuously inform the Vendor regarding any measures taken by third parties, including but not limited to supervisory authorities and Data Subjects, relating to the Processing by the Vendor hereunder. GENERAL OBLIGATIONS Vendor shall only process Personal Data to provide the services on Company’s written instructions and in accordance with the GDPR and any applicable national laws. Vendor shall not, without the prior written permission of Company, transfer or process any Personal data provided or made available by or on behalf of Company or its affiliates, outside of the European Economic Area (EEA). Must be taken into account that the EEA consists of the Member States of the European Union (EU) and three countries of the European Free Trade Association (EFTA) which are Iceland, Liechtenstein and Norway, excluding Switzerland. Vendor shall enter into any potential amendments to this Processing Agreement, or a new processing agreement as may be required by Company or necessitated by changes in applicable laws. Vendor shall inform Company immediately if it considers that an instruction violates data protection regulations. Vendor shall then be entitled to suspend the execution of the relevant instructions until Company changes them. COMMITMENT TO CONFIDENTIALITY The vendor shall ensure that persons authorised to process Personal Data (i.e., all employees, agents or contracts who process or access the Personal Data) are subject to contractual confidentiality obligations in respect of Personal Data and undergo regular training in relation to their data protection obligations and compliance with Vendor’s Measures. SECURITY OF PROCESSING The Vendor shall take all measures required pursuant to article 32 of the GDPR. The Vendor shall take into account the nature of Processing and the information available to the Vendor, assist the Company in ensuring compliance with the obligations pursuant to article 32 to 36 of the GDPR. SUB-PROCESSING Vendor shall not appoint (nor disclose any Personal Data under this Processing Agreement) to a Sub-processor, without the prior written consent of the Company. The processor must ensure that the same processing obligations the processor is subject to are made applicable to any sub-processor and confirm that the sub-processor is fully aware and agrees with such obligations. The processor remains responsible for any processing conducted by the sub-processor. The Vendor shall notify the Company of any intended changes concerning the addition or replacement of sub-processors, thereby giving the company the opportunity to object to such changes if to the extent the conditions set forth in the below paragraph are not fulfilled, within 14 days from being notified. In the event that the Company provides such an objection to a new Sub-processor and such objection in the Vendor’s opinion prevents effective provision of the Vendor’s services, the Vendor may terminate the Agreement without penalty or liability. The Vendor may engage Sub-processors, provided that the same data protection obligations as set out in this Processing Agreement as referred to in article 28(3) of the GDPR, are imposed on such Sub-processor by way of a written contract. The Vendor must ensure that only Sub-processors are engaged who provide sufficient guarantees to implement appropriate technical and organizational measures in such a manner that the Processing will meet the requirements of the Data Protection Laws. The Sub-processors listed in Appendix 2 have been approved by the Company to be used as Sub-processors by the Vendor under this Processing Agreement. Upon changes of Sub-processors, Appendix 2 will be updated. ASSISTANCE OF VENDOR Vendor shall assist Company by co-operating and implementing appropriate administrative, technical and organizational measures for responding to Data Subjects' requests relating to their rights of: (i) access; (ii) rectification; (iii) erasure; (iv) restriction of processing; (v) data portability; (vi) objection to processing; and (vii) avoiding automated individual decision making, including profiling. Vendor shall forward any such requests it receives from Company employees to Company without responding to the data subject. TECHNICAL AND ORGANISATIONAL MEASURES Taking into account the state of the art, the costs of implementation and the nature, scope, context and purposes of the processing as well as the risk of varying likelihood and severity for the rights and freedoms of natural persons, Vendor shall in relation to the Personal Data under this Processing Agreement implement and comply with appropriate technical and organizational measures to ensure a level of security appropriate to that risk and in compliance with GDPR Measures. Details of the actual technical and organizational measures are outlined in Appendix 3 . The Measures are subject to technical progress and further development and Vendor shall review the measures on a regular basis to ensure that they continue to provide adequate protection of the Personal Data. The overall protection afforded in the Measures must not be reduced. Substantial changes must be documented. BREACH OF MEASURES Vendor shall promptly notify the Company within 72 hours from detection in the event of any breaches of the Measures or if Vendor learns or has reason to believe that any person or entity has breached or attempted to breach Vendor’s security measures which are applicable to the Services or has gained unauthorized access to personal data or any confidential information provided or made available by Company or any of its affiliates. The processor shall assist the data controller in meeting its data protection obligations in relation to the security of processing and notifying the controller of personal data breaches and to conduct Data Protection Impact Assessments (DPIA). LIABILITY Subject to the below paragraph, the parties agree to indemnify and hold each other harmless from any claim of damages or loss suffered or incurred in connection with either party’s breach of its obligations under this Processing Agreement or the Data Protection Laws. The limitation of liability agreed under the Agreement, shall apply correspondingly with respect to this Processing Agreement. AUDIT RIGHTS AND INDEMNITY Vendor shall, at no additional cost, keep full and accurate records relating to all processing of Personal Data on behalf of Company. Company may, upon written notice to Vendor, audit Vendor's facilities, systems, records and supporting documentation to check Vendor's compliance with its obligations. Notwithstanding any other provision of the Agreement, Vendor hereby fully indemnifies and holds harmless the Company and its affiliates for all losses (including direct and indirect losses, fines, penalties, all legal and external professional fees and compensatory damages) in respect of all claims or actions resulting from Vendor’s failure to comply with this Processing Agreement (including relevant data protection legislation). RESPONSBILTY OF PROCESSOR Note that nothing within this agreement relieves the processor of its own direct responsibilities under the GDPR. TRANSFER OF PERSONAL DATA OUTSIDE OF THE EEA The Vendor shall only allow to transfer Personal Data to a third country or an international organisation with the Company’s written approval. Transfer of personal Data to a third country or an international organisation may also take place provided that Union or Member State law to which the Vendor or sub-processor is subject to requires such transfer. In such case of legal requirement for transfer to a third country, the Vendor shall inform Company of that legal requirement before transferring Personal Data to a third country, unless that law prohibits such information on important grounds of public interest. If Company has approved transfer of Personal Data to a third country or if transfer of Personal Data to a third country is necessary for the Vendor to provide its services to the Company under the Agreement, the Vendor and Customer shall take the necessary steps to ensure that the transfer is performed in accordance with the Data Protection Laws, for example by signing the EU Model Contracts for the transfer of Personal Data to third countries. DEMONSTRATION OF COMPLIANCE The Vendor shall make available to the Company all information necessary to demonstrate compliance with the obligations laid down in Article 28 of the GDPR and allow for, and contribute to audits, including inspections, conducted by an independent third-party auditor mandated by the Vendor. The Vendor shall inform the Company if, in the Vendor’s opinion, an instruction infringes the GDPR or other Union or Member State data protection provisions. COMPENSATION The Vendor shall have the right to invoice the Company for any work performed by the Vendor or a Sub-processor under the sections 4 (2nd paragraph), 6, 8 (1st paragraph) and 13 according to the Vendor’s or the Sub-processor’s applicable hourly fees. CHANGES If, during the Term, Data Protection Laws are changed, or new guidelines, rulings or regulations are published by the Supervisory Authority causing this Processing Agreement to be non-compliant with such law, guidelines, rulings or regulations, each of the parties shall have the right to request appropriate amendments to this Processing Agreement to satisfy the new requirements. Changes to this Processing Agreement shall, in order to be effective, be made in writing and signed by both Parties. MISCELLANEOUS With regard to the Processing of Personal Data, the provisions in the Processing Agreement shall have priority over conflicting provisions in any other agreement between the parties. This Processing Agreement shall be governed by the substantive laws of Malta. Any dispute, controversy or claim arising out of or in connection with this Processing Agreement shall be settled in accordance with the dispute regulations laid down in the Agreement. This Processing Agreement may be executed in two or more counterparts, each of which shall be deemed an original, but all of which shall together constitute one agreement. Signatures to this Processing Agreement delivered by email or other electronic means shall have the same force and effect as originals. TERM AND TERMINATION The Processing Agreement is authorized for an unlimited period and can be terminated by the Company immediately for breach or for convenience. Without prejudice to the foregoing, the Company may take any one or more of the following actions: (i) suspend the transfer of personal data to Vendor; (ii) require Vendor to cease processing personal data; (iii) demand the return or destruction of the personal data; or (iv) require the Vendor to take such measures as may reasonably be required to place Vendor in compliance with this Processing Agreement. Additionally, the processor must provide the controller with all the information it needs to ensure that they are both meeting their data protection obligations. The vendor must also inform the controller when, in its opinion, the controller’s instruction would breach Union or Member state law. This Processing Agreement enters into force on the Effective Date and remains in force for as long as the Vendor Processes Personal Data on behalf of the Company under the Agreement (the “Term”). Upon termination of this Processing Agreement or provision of the services, Vendor shall, subject to any legitimate business reason (including without limitation compliance with professional standards and document retention and IT system backup policies and protocols) or legal, no longer process all such Personal Data and upon Company’s written request securely purge, delete and destroy such Personal Data or return all the Personal Data to the Company and delete existing copies unless Union or Member State Law requires storage of the Personal Data. In addition, once the data is purged the Vendor must provide formal confirmation to a client confirming the data destruction. If Processor is unable to delete Personal Data for technical or other reasons, Processor will apply measures to ensure that the Personal Data is blocked from any further Processing. Appendix 1 – Instructions regarding the Processing of Personal Data The following instructions apply for the Processing of Personal Data for which the Company is responsible as Controller. In addition to what is already stated in this Processing Agreement, the Vendor shall adhere to the instructions below. Processing Purposes Please specify all the purposes for which the Personal Data will be Processed for by the Vendor The Provide Apps and the services in accordance with the Agreement. Types of Personal Data Please specify the categories/types of personal Data that will be Processed by the Vendor. To provide services in accordance with the Agreement, the Vendor will process any Personal Data supplied by users of the Apps, such as: Direct identifying information (e.g. name, email address, phone number) Indirect identifying information (e.g. place of work, title, address) Device identification data (e.g. IP addresses, logs) However, the Vendor does not knowingly collect (and Company shall not submit or upload) any special categories of data (as defined under the Data Protection Legislation). Categories of Data Subjects Please specify the Categories of Data Subjects whose Personal Data will be Processed by the Vendor. End Users and individuals whose Personal Data is supplied by End Users of the App(s). Retention time Please specify the time and requirements for retention of Personal Data that are being Processed by the Vendor. Personal Data is kept with the Vendor as long as the Categories of Data Subjects is deemed to be active (e.g. as long as there is a valid Agreement for the use of the App(s)). The Vendor erases Personal Data from operative data systems when the Customer does not have any business relationship with the Vendor. Personal Data stored in backup systems can be stored up to ten years due to the period of limitation according to the Maltese statute of limitation. Processing operations Please specify all processing activities to be conducted by the Vendor Data processing is done manually and automatically through data systems. The Vendor is collecting, storing and structuring data to fulfil the purpose of data processing. More specifically the processing includes: Sending emails regarding product or service updates Sending newsletters via email to Data Subjects who opted-in to receive newsletters Structuring data as a foundation for internal reporting Erasing or anonymizing personal data when appropriate Location of Processing Data is processed at the Vendor’s offices and on Approved Sub-processors data equipment. Appendix 2 – Approved Sub-processors Below are listed the Sub-processors that have been approved by the Customer for use by the Supplier to Process Personal Data under the Processing Agreement. Appendix 3 – Technical and Organisational measures The following technical and organizational measures have been implemented by the Vendor: Confidentiality (Article 32 Paragraph 1 Point b GDPR) Physical Access Control No unauthorised access to Data Processing Facilities, individual Smartcard access control, burglar alarm and recorded CCTV facilities at office entrance, locked entrance to server rooms. Electronic Access Control No unauthorised use of the Data Processing and Data Storage Systems, e.g.:(secure) passwords, automatic blocking/locking mechanisms, two-factor authentication, encryption of data carriers/storage media Internal Access Control (permissions for user rights of access to and amendment of data) No unauthorised Reading, Copying, Changes or Deletions of Data within the system, e.g. rights authorisation concept, need-based rights of access, logging of system access events; Encryption (Article 32 Paragraph 1 Point a GDPR; Article 25 Paragraph 1 GDPR) The processing of personal data in such a method/way, that the data cannot be associated with a specific Data Subject without the assistance of additional Information, provided that this additional information is stored separately, and is subject to appropriate technical and organisational measures. Integrity (Article 32 Paragraph 1 Point b GDPR) Data Transfer Control No unauthorised Reading, Copying, Changes or Deletions of Data with electronic transfer or transport, e.g.: Encryption, Virtual Private Networks (VPN), electronic signature; Data Entry Control Verification, whether and by whom personal data is entered into a Data Processing System, is changed or deleted, e.g.: Logging, Document Management Availability and Resilience (Article 32 Paragraph 1 Point b GDPR) Availability Control Prevention of accidental or wilful destruction or loss, e.g.: Backup Strategy (online/offline; on-site/off-site), UTM for threat management and access control including firewall, anti-malware, mail and web content filtering, reporting procedures and contingency planning. Rapid Recovery (Article 32 Paragraph 1 Point c GDPR) Procedures for regular testing, assessment and evaluation (Article 32 Paragraph 1 Point d GDPR; Article 25 Paragraph 1 GDPR) Data Protection Management; Incident Response Management; Data Protection by Design and Default (Article 25 Paragraph 2 GDPR); Order or Contract Control; No third-party data processing as per Article 28 GDPR without corresponding instructions from the Client, e.g.: clear and unambiguous contractual arrangements, formalised Order Management, strict controls on the selection of the Service Provider, duty of pre-evaluation, supervisory follow-up checks.

Jet Reports How to Auto-Widen Columns in Jet Report When loading data into your worksheet, it's common to encounter data values of different lengths such as customer names, descriptions, and dates. If the columns are not wide enough to accommodate the data, Excel may display it in a truncated form, or worse, as a series of pound (#) signs. Join On Point Academy to view all content Join the academy → Log in → To address this issue, Jet Report offers an "Auto Widening" feature that automatically adjusts the column width based on the longest value in the column. Here's how to use it: 1. In the cells that display truncated or hashed data, enter the word "Fit" in row 1 of the corresponding column 2. When you run your report, Jet Report will automatically adjust the column width to fit the longest value in the column. For example, if you have a list of customer names, entering "Fit" in the cells will resize the column to fit the longest customer name. The same goes for the date column. With Auto Widening, your report will look cleaner and more professional. No more pesky truncated values or hashed cells! Give it a try and see the difference it makes. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Making sense of the Currency Exchange Rates Join On Point Academy to view all content Join the academy → Log in → To access the Currency Exchange Rate page you must first go to the Currencies page, highlight the currency in question, and then drill down on the Exchange Rate . Alternatively from the Currencies page, you can highlight the currency and click Process → Exch. Rates as per below. This will open the Currency Exchange Rates window which is shown below: The “Exchange Rate Amount” is the rate to use for the “Currency Code” selected on the line, and the “Relational Exch. Rate Amount” relates to the rate to use for the “Relational Currency Code”. (generally, it's left blank so it's the local currency – see further below for an example where this isn’t the case). Therefore using the Currency Exchange Rates window shown above, as we have 1.0 in the Relational Exch. Rate Amount (GBP) and 1.3 in the Exchange Rate Amount (EUR) this means 1.3 Euros is equal to 1 GBP. (The “Exchange Rate Amount” is acting as the exchange rate) Hence entering a transaction for €200.00 would equate to £153.85 (i.e. 200 / 1.3 = 153.85). I could also flip this by entering 1.0 in the “Exchange Rate Amount” and 0.76923 in the “Relational Exch. Rate Amount” as per below: This now means the “Relational Exch. Rate Amount” is acting as the Exchange Rate. In this example €1 (Exchange Rate Amount) is equal to £0.76923 (Relational Exch. Rate Amount). Therefore entering a transaction for €200.00 would also equate to £153.85 (i.e. 200 * 0.76923) Both would work exactly the same it's just a slightly different configuration. Adding a Relational Currency Code Currency Exchange Rates page has been changed for EUR to include USD as the Relational Currency Code as per below: Therefore if we were to raise a €200 Invoice the GBP will be calculated as follows: Step 1 Euros to USD :- €200 / 1.3 = $153.8462 Step 2 USD to GBP :- $153.8462 / 1.39 = £110.68 To confirm an Invoice has been added in Business Central and below is the statistics page confirming our calculations. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Watch the full interview CASE STUDY MTN An interview about the benefits and use of Jira within MTN in Ghana.

Full Time Solution Consultant We are looking for a passionate Senior Software Engineer to design, develop add-ons to be used within the Atlassian Jira Software infrastructure. APPLY FOR VACANCY Job Description We are looking for a Solutions Consultant to implement, develop and work with Atlassian. The responsibilities include gathering user requirements, defining system functionality and . Our ideal candidates are familiar with the software development life cycle from preliminary system analysis to tests and deployment and the Atlassian Infrastructure. Ultimately, the role of the Software Engineer is to build high-quality, innovative and fully performing software that complies with coding standards and technical design. Responsibilities Execute the software development life cycle Develop flowcharts, layouts and documentation to identify requirements and solutions Write well-designed, testable code Produce specifications and determine operational feasibility Integrate software components into a fully functional software system Document and maintain software functionality Troubleshoot, debug and upgrade existing systems Deploy programs and evaluate user feedback Comply with project plans and industry standards Ensure software is updated with the latest features Requirements Proven work experience as a Software Engineer or Software Developer Experience designing interactive applications Ability to develop software in Java Previous experience with Bitbucket software Apply for Vacancy Select Position Upload CV Upload PDF or Word Document (Max 15MB) Apply for vacancy → Thank you for submitting. We will be in contact with you shortly.

Jet Reports Unveiling the Power of the "FORMULATEXT" Function in Excel Excel is a powerful tool that offers a wide range of functions to enhance data analysis and manipulation. One such function is FORMULATEXT, which often remains hidden in the depths of spreadsheets. Have you ever come across an Excel spreadsheet filled with complex formulas, but struggled to understand how they work? Hidden formulas can be a source of frustration and confusion, making it difficult to troubleshoot errors or make updates. FORMULATEXT is a useful function that allows you to unveil the mysteries of hidden formulas and gain a deeper understanding of how calculations are performed in Excel. In this article, we will explore the power of FORMULATEXT and its applications in spreadsheet management, troubleshooting, and formula manipulation. Join us as we uncover the secrets of FORMULATEXT and learn how it can revolutionize your Excel experience What can FORMULATEXT be used to track : Understanding complex formulas: By using FORMULATEXT, you can easily reveal the formulas in otherwise hidden cells. This allows you to comprehend the logic and structure behind complex calculations, making it easier to understand and modify them if necessary. Error troubleshooting: When encountering errors in your spreadsheet, FORMULATEXT can be a valuable tool for pinpointing the source of the issue. By revealing the formulas in error-prone cells, you can identify any discrepancies or mistakes and take corrective action. Formula auditing: FORMULATEXT enables you to perform thorough formula audits by extracting and analyzing formulas across multiple cells or ranges. This can be particularly useful when reviewing large datasets or when working on collaborative projects. Updating and modifying formulas: With FORMULATEXT, you can quickly identify cells containing specific formulas, allowing for targeted updates or modifications. Whether you need to add new formulas, replace existing ones, or make adjustments, FORMULATEXT helps streamline the process and ensures accuracy. Documentation and sharing: The ability to extract formulas using FORMULATEXT makes it easier to document and share your spreadsheet models. You can capture and preserve the underlying formulas, ensuring that the logic and calculations are well-documented for future reference or when collaborating with others. How does it work? let’s say we want to use the FORMULATEXT with one of our Financial reports, the Cashflow report, and we want to show the formula used in each cell. in this case, we want to be able to identify where we use the Jet report formula to the Excel formula. Step 1 Add a title for the new column . Leaving just a column as a space, we give the new column that will contain the formulas a title as shown below. Step 2 Adding the formula we will now use FORMULATEXT to show the formula used in each row on column H. To do that, go to cell J10, click the sign “=“ and fill in as shown. when the filling-in is done, click enter and the formula will display as shown below. Step 3 Adding text to the formula Let’s modify the formula by adding text to it. e.g., we want to say something like the formula used in this cell is … Go back to cell J10 and hit the equal to sign “=“ again. then fill in as shown below. When you click ok or enter, you should have it as shown below. We can now drag to copy the formula throughout the Excel work. Step 4 Specifying formula for each cell. We might want to make the report a little bit better by saying “The formula used for each cell is“! Though we can just type the formula in each cell instead of dragging to copy the formula to other cells, this will take longer. Here is an example of a modified formula you can use so that when you drag the formulas, the cell referencing changes also. we want to show this now… “The formula used in cell H10 is“, “The formula used in cell H11 is“ etc … To achieve this, fill in Cell K10 as shown below. When you click enter, you should be able to see the formula as shown below. When you drag your formula down, the cell will change automatically. Enjoy Join On Point Academy to view all content Join the academy → Log in → Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Jet Reports Using NP ("Date Filter") Function Creating date ranges for filtering data in Jet Reports can be a time-consuming and intricate task. However, the NP function, also known as the "Date Filter," can significantly simplify the process of generating date ranges for filtering purposes. This function employs start and end dates to produce a range of dates that can also be utilized in Excel. To utilize the NP function in Jet Reports, the following steps can be taken: Join On Point Academy to view all content Join the academy → Log in → Step 1 Open an existing report that includes a Report Options page with a Date filter and a report page. We have our Date filter on our Options page here We have our report on the report page here Step 2 Use the NP function to reference the date range in the Report Options page by ensuring that the balance formula box on cell F5 is selected. Then, navigate to the Jet Function Wizard by clicking on "Tools" and "NL function." On the drop-down, you should see the list of all the functions. we now use our NP Date Filter in our report. this will be done under the filter. Scroll down to the filter section, and on the box by the left, search date as shown below We now input the date range in the box on the right side. we need to include two dates in the box. on the drop-down, we will only be able to select a single date, so we navigate to Nested Jet Function. on the drop-down, we select NP Function The Last Date Modified requires a value which is where the NP Filter comes in i.e. we want the vendor balance whose last date modified falls between a period (e.g. 01/01/2023 to 03/03/2023). To do this, go to the top right and select Nested Jet Functions > Insert NP On clicking the NP function, the pop up below comes up Fill in the details below What - “Date Filter“ Start Date - Use report options to get your start date End Date - Use report options to get your end date On the start date, click on “Insert Options Page“. when you do that, the Report Option, which contains our Start and End date, should pop up. we then select Start Date and then click on add. Do the same for End Date also, then what you have should be as seen below Once that is done, click on back which takes you to the previous tab. you should be able to see the formula in the box as shown below. Click ok to close it, the NP Date Filter has been applied to the report successfully. Once the report is run, the user can utilize the Report Options page to filter the data based on the specified date range and select a particular date to display in the report. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Privacy Policy General Last updated: April 2021 GENERAL On point (“On point” or “we” or “us”) respects your privacy. In light of this, we constantly strive to protect your personal data in the best possible way and to comply with all applicable laws and regulations for the protection of personal data. The EU General Data Protection Regulation 2016/679 (“GDPR”), which came into force on 25th May 2018, provides rights to individuals and requires organisations to provide information about their processing in a clear and transparent way. In this respect, we have published this Privacy Policy to take into account these requirements and to explain how we collect, store and use the personal data we obtain through this website, in accordance with the standing legislation. Any personal data provided by you voluntarily through our website http://www.onpointserv.com/contact-us or through your communications via email with us will be processed in accordance with the Data Protection Act (Chapter 586 of the Laws of Malta), the GDPR and any other relevant data protection legislation, as may be amended from time to time. DEFINITIONS ‘Personal Data’ refers to any information relating to an identified or identifiable natural person (‘data subject’). This includes any identifiable material relating to their physical, physiological, mental, economic, cultural or social identity and includes but are not limited to physical files, identification numbers, location data and images or records of individuals. ‘Processing’ makes reference to any operation or set of operations which is performed on personal data or on sets of personal data, whether or not by automated means, such as collection, recording, organisation, structuring, storage, adaptation or alteration, retrieval, consultation, use, disclosure by transmission, dissemination or otherwise making available, alignment or combination, restriction, erasure or destruction. ‘Controller’ means the natural or legal person, public authority, agency or other body which, alone or jointly with others, determines the purposes and means of the processing of personal data. ‘Processor’ refers to a natural or legal person, public authority, agency or other body which processes personal data on behalf of the controller. ‘Consent’ of the data subject means any freely given, specific, informed and unambiguous indication of the data subject’s wishes by which he or she, by a statement or by a clear affirmative action, signifies agreement to the processing of personal data relating to him or her. ‘Third party’ makes reference to a natural or legal person, public authority, agency or body other than the data subject, controller, processor and persons who, under the direct authority of the controller or processor, are authorised to process personal data. ‘Personal data breach’ means a breach of security leading to the accidental or unlawful destruction, loss, alteration, unauthorised disclosure of, or access to, personal data transmitted, stored or otherwise processed. DATA CONTROLLER On Point Ltd., reg. no. C81670, is a software company in terms of the Maltese law. For the purpose of the GDPR, On Point is the Data Controller. Should you wish to contact us with regards to the processing of your personal data, please do so on info@onpointserv.com . Our postal address is: 8, 24 Church Street, Zebbug, Malta. INFORMATION WE COLLECT The data that we may collect about you includes: Your name and surname Mobile/Phone number Company name Your email address Your IP addresses Any personal data that you may provide to us through our website Any personal data that you may provide to us through your communication with us (through meetings, calls and emails). Registering with an account BASIS OF PROCESSING We will process personal data on the basis of: Necessity in order to take steps at your request prior to entering into a contract (for example to provide you with a quote); Necessity for the performance of a contract which we have agreed to enter into at your request (for example to provide a specific software); Our legitimate interests (for example, to ensure we are providing you with the best possible service, to manage our customer database efficiently and for debt collection). Additional basis HOW IS YOUR DATA PROCESSED AND STORED Through a Data Processing Agreement (DPA) the terms of the processing and management of the personal information will be established. With the main purpose of ensuring the protection of customer’s personal data and the compliance of the GDPR laws, your personal data will be stored on our website. In baser of that DPA, the customer acknowledges and agrees the process of their personal data on their behalf. The site-visitors’ data may be stored in different locations, but the laws of the jurisdictions on which it operates in case must always be respected. WHO HAS ACCESS TO YOUR PERSONAL DATA As site-owner, we will be considered the Controller of our site-visitors’ data, deciding the data that will be collected from the site-visitors and how it will be handled. We will ensure the maintenance of a clear and comprehensive privacy policy for our customers’ website in accordance with both GDPR and local privacy regulations. We will be responsible for notifying our site-visitors’ about the how their information is collected, processed and used, and they would also be informed whenever they information will be transferred. SHARING YOUR INFORMATION We will not share any of your personal data with third parties without your permission, except where this is strictly required for us to provide you with a service you have engaged us to provide. We may share your personal data with the following categories of entities as necessary: Internal staff (IT team/marketing from On Point Ltd.). Hosting and website maintenance (kindly refer to our Cookie Policy section below; and Upon your request to do so, we may divulge your information to other third parties and Authorities in Malta. If we ever have to share your personal data with an entity outside the EU, we will do so in accordance with the requirements of the GDPR and any other applicable law. TRANSFER OF PERSONAL DATA TO THIRD COUNTRIES On Point may process your personal data outside of the European Union (‘EU’) and the European Economic Area (EEA). Shall your personal data be processed outside the EU/EEA, then we will make sure that such processing is respecting appropriate safeguards that ensure that your rights are protected or based on another ground for such transfer in accordance with GDPR. YOUR RIGHTS RIGHT OF ACCESS You have the right to access all the personal data held and processed by the Company. You may also request a copy of this personal data. To exercise this right, you can contact us through our email address or postal address referred to above under the Data Controller clause. In order to process this request, we will require proof of your identity. We will do our best to process the request as soon as possible, and in no longer than 14 days from hearing from you. RIGHT TO RECTIFCATION You have the right to request modification of all the personal data held and processed by the Company. If you think we may hold details about you that are inaccurate or out of date, please contact us at the email or postal address referred to above under the Data Controller clause in order to amended or update this information. RIGHT TO ERASURE (‘RIGHT TO BE FORGOTTEN’) You have the right to request that we delete the personal data held and processed by the Company by contacting us at the email or postal address referred to above under the Data Controller clause. This right is not absolute, and we may be justified in keeping certain personal data, for instance when we are legally obliged to do so or if such data may be necessary for us to defend a legal claim. RIGHT TO LIMITAITON OF PROCESSING You have the right to request limitation of the processing of your personal data, with the exception for storage. Limitation of processing can be requested for example if you object to the accuracy of the personal data or if you consider the processing of your personal data to be unlawful. RIGHT TO OBJECT You have the right to object to the processing of your personal data, including where such processing takes place for the Company’s legitimate interests, and you may request to withdraw from all future activities and the removal of all personal data held and processed by us by contacting us at the email or postal address to above under the Data Controller clause. Where personal data is processed for direct marketing purposes, you have the right to object at any time to processing of personal data concerning such marketing, which includes profiling to the extent that is related to such direct marketing. RIGHT TO DATA PORTABILITY You have the right to move, copy or transfer your personal data from one controller to another, and you have the right to request from us a copy of your personal data in a structured, commonly used and machine-readable format, which we may provide to you or another controller at your request. This process shall be based on a consent or an agreement. Should you require our assistance with this, please contact us at the email or postal address referred to above under the Data Controller clause. RIGHT TO LODGE A COMPLAINT All Data Protection enquiries/complaints should be sent to info@onpointserv.com . You also have the right to lodge a complaint with the Information and Data Protection Commissioner in Malta as the data protection supervisory authority: Information and Data Protection Commissioner Floor 2, Airways House Triq il-Kbira, Sliema SLM 1549 Malta Tel: (+356) 2328 7100 Email: idpc.info@idpc.org.mt NO FEE USUALLY REQUIRED You will not be required to pay a fee to access your data or to exercise any of the other rights. However, we may charge a reasonable fee if your request is clearly unfounded, repetitive or excessive. Alternatively, we may refuse to comply with your request in these circumstances. WHAT WE MAY NEED FROM YOU We may need to request specific information from you to help us confirm your identity and ensure your right to access your personal data or to exercise any of your other rights referred to above. This is a security measure to ensure that personal data is not disclosed to any person who has no right to receive it. We may also contact you to ask you for further information in relation to your request to speed up our response. DATA SECURITY We take the security of your personal data very seriously and have put in place appropriate security measures to prevent your personal data from being accidentally lost, used or accessed in an unauthorised way, altered or disclosed, so as to safeguard its integrity and confidentiality. The security measures we have implemented to ensure safe transmission and storage of personal data include: Use of secure servers; Use of firewalls; Use of encryption; Physical access controls at data centres; Information access controls; Use of back-up systems; We also regularly review and, where practicable, improve upon these security measures. We have put in place procedures to deal with any suspected personal data breach and will notify you and any applicable regulator of a breach where we are legally required to do so. While we do our utmost to safeguard your personal data, no data transmission over the internet can be totally secure and therefore we cannot guarantee or warrant that no unauthorised access will occur. TIME LIMIT TO RESPOND We try to respond to all legitimate requests within one week. Occasionally it could take us longer than a week if your request is particularly complex or you have made a number of requests. In this case, we will notify you and keep you updated. RETENTION We will not store personal data for longer than is necessary keeping in mind the purpose/s for which we first collected that data. We may also need to keep some of your personal data where we are obliged to do so in terms of legal, regulatory, tax or accounting requirements, or in order to protect ourselves against legal claims usually for a specified amount of time as set out in the relevant law. As a general rule we will retain your personal data as long as you remain a client of ours, or until you ask us to stop communicating with you, unless we have a valid reason to keep the information for a longer time. For more information about our retention policy, please contact us at the postal or email address referred to above under the Data Controller clause. CHANGES TO THIS PRIVACY POLICY We reserve the right to amend and update this Policy at any time. This may be necessary in order to fulfil the requirements established in the applicable laws and regulations or due to changes set in OnPoint’s operations. It is your responsibility to access the ‘Privacy Policy’ page frequently in order to be aware of any changes that may be implemented by us from time to time. LAW AND JURISDICTION This Policy shall be governed by Maltese Law. Any dispute arising from, or related to, such Policy shall be subject to the exclusive jurisdiction of the courts of Malta.

Microsoft Business Central Creating a Customer Customers are the source of your income. Customer cards hold the information that is required to sell products to the customer. Join On Point Academy to view all content Join the academy → Log in → To create a new customer card 1. Choose the search icon , enter Customers , and then choose the related link. 2. On the Customers page, click on the New action. If only one customer template exists, then a new customer card opens with some fields filled with information from the template. If more than one customer template exists, then a page opens from which you can select a customer template. In that case, follow the next two steps. 3. On the Select a template for a new customer page, choose the template that you want to use for the new customer card. 4. Choose the OK button. A new customer card opens with some fields filled with information from the template. 5. Proceed to fill or change fields on the customer card as necessary . Hover over a field to read a short description. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

​ Building your Dashboard with Jet Report Most of us are familiar with dashboards which help give visuals and insight into our Report for better understanding. Building a dashboard with Jet Report is entirely different from creating a dashboard from Excel Data. Creating a dashboard with Jet Report is done in design mode, this allows you to make any adjustment to your dashboard directly from the data. Any changes made to your report reflect directly on your dashboard. This tutorial shows you how to Build your Dashboard with Jet Report from an income statement. Join On Point Academy to view all content Join the academy → Log in → We will create our dashboard from one of the reports we’ve created. Step 1. Open the Report you’ll like to use in creating your dashboard. Open your Report and make sure to be in Design Mode, this is very important. just as the data are copied in Excel. In Jet, the data are copied in design mode. Note: any changes you want to make to your report should be done in the design mode. this way, it will affect your report. Step 2 Highlight the data you want to build your dashboard with. Select and highlight the data you want to build your report with just as shown below. you must be wondering why we select the empty rows beneath the report. that is necessary because we are in design mode and we still need to run the report to get our full data. selecting the empty rows (or columns if the report is based on “NL(column)”) automatically expands the data as the jet runs. Step 3: Get the data into your pivot table. Click on the “insert” in the ribbon, you should be able to see Pivot Table at the top left corner as shown below. Once you click on the “Pivot Table“, there will be a pop-out where it will ask you if you want to place the Pivot Table in a New Worksheet or Existing Worksheet. Select New Worksheet and click ok. Excel will automatically open a new Worksheet for you where we can have access to all the data in our report. the sheet should look like what is shown below. You can then double-tap on the name to change it. we changed our Pivot Table “sheet” to Data and Our “Report page” to Report. Step 5: inputting the data into the Pivot Table Before you input your data into the Pivot Table, ensure you’ve run our report to access the full data, as shown below. Now, navigate to the data sheet where we have our Pivot Table. we want to view our Monthly variance by account categories. we click or drag the “Account Categories“ to Rows we click or drag the Monthly Variance to Values as shown. Step 6 Building your Dashboard Now that we have our data in the Pivot Table, we select a pivot chart to help give better insight into our data. to do that, navigate to PivotTable Analyze Click on PivotChart on the page that pops out, select any chart of your choice. click on ok Step 6 Building your Dashboard Now that we have our data in the Pivot Table, we select a pivot chart to help give better insight into our data. to do that, navigate to PivotTable Analyze Click on PivotChart on the page that pops out, select any chart of your choice. click on ok When you click on ok, you will have your chart on the same sheet as your pivot table as shown below. Step 7: Create a new sheet for our Chart. Click on the positive icon to create a new sheet Rename the sheet to Dashboard Click on the chart to cut and paste it into the dashboard sheet. Navigate to “View” and click on it Un-select gridlines to have a plain sheet as shown Then cut and paste your Chart here. Anytime you run your report with a different filter, it will automatically reflect on your Dashboard. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central Sales Invoice & Copy Document You create a sales invoice or sales order to record your agreement with a customer to sell certain products on certain delivery and payment terms. Join On Point Academy to view all content Join the academy → Log in → There are a couple of scenarios where you must use a sales order instead of a sales invoice : If you need to ship only part of an order quantity , for example, because the full quantity is not on hand. If you ship products after you post the corresponding sales invoices . If you sell items that your vendor delivers directly to your customer , known as drop shipment . In all other aspects, sales orders and sales invoices work in the same way. You can negotiate with the customer by first creating a sales quote , which you can convert to a sales invoice when you agree on the sale. To create a sales invoice 1. Choose the search icon , enter Sales Invoices , and then choose the related link. 2. Click on New on the Sales Invoices page . 3. In the Customer field, enter the name of an existing customer. 4. Fill in the remaining fields on the Sales Invoice page as necessary. Hover over a field to read a short description. 5. On the Lines FastTab, in the Type field, select what type of product, charge, or transaction that you will post for the customer with the sales line. 6. In the No. field, select a record to post according to the value in the Type field. You leave the No. field empty in the following cases: If the line is for a comment. Write the comment in the Description field. If the line is for a catalog item. Choose the Select Catalog Items action. In the Quantity field, enter how many units of the product, charge, or transaction that the line will record for the customer. 7. In the Quantity field, enter how many units of the product, charge, or transaction that the line will record for the customer. The value in the Line Amount field is calculated as Unit Price x Quantity . The price and line amounts are with or without sales tax, depending on what you selected in the Prices Including Tax field on the customer card. 8. If you want to give a discount, enter a percentage in the Line Discount % field. The value in the Line Amount field updates accordingly. If special item prices are set up on the Sales Prices and Sales Line Discounts FastTab on the customer or item card, the price and amount on the sales line automatically update if the price criteria is met. 9. In the Invoice Discount Amount field, enter an amount that should be deducted from the value shown in the Total Incl. Tax field. If you have set up invoice discounts for the customer, then the specified percentage value is automatically inserted in the Invoice Discount % field if the criteria are met, and the related amount is inserted in the Inv. Discount Amount Excl. Tax field. 10. When the sales invoice lines are completed, choose the Post action. Copy Document It is used to copy document lines and header information from another sales document to your current document . You can copy a posted sales invoice into a new sales invoice to quickly create a similar document. To create Copy Document in Sales Invoice 1. On the Sales Invoice page , click on Prepare and Go to Copy Document . 2. Proceed to fill the necessary fields of the Sales Document you want to copy. 3. Click on OK . Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →