Search this site

How-to - VAT Entries in Microsoft Dynamics 365 Business Central Microsoft Business Central VAT Entries in Microsoft Dynamics 365 Business Central Aim The aim of this report is to have a breakdown of the total VAT entered and the base grouped by grouped by the VAT Calculation Type, VAT Business Posting Group, and VAT Product Posting Group respectively. Join On Point Academy to view all content Join the academy → Log in → Options Available The user may choose from the following options Posting Date Company Notes It’s very important to bear in mind that the report is to be cross-checked against Business Central through the VAT Entries. VAT Entries .xlsx Download XLSX • 18KB Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

How-to - How To Create A New Vendor Microsoft Business Central How To Create A New Vendor TO CREATE A NEW VENDOR FOLLOW THESE STEPS; Join On Point Academy to view all content Join the academy → Log in → How it's done STEP 1 : Click on the search icon at the top right and type in “VENDORS”. A list drops down then select the related link. STEP 2: Among the options available select "NEW" STEP 3: Fill in the spaces provided for "NAME" and "ADDRESS" on the vendor card and areas with the red indicator on the page. Modify the fields as appropriate on the vendor card. Click on the reverse arrow at the top left corner and the vendor is created and saved. Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

3a153257-3f9b-42a1-9555-7d521c8354b5 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.

A holistic POS software solution integrating your entire fashion retail business. Retail Apparel and Fashion Point of Sale (POS) A holistic POS software solution integrating your entire fashion retail business. Seamless shopping experience To ensure a smooth customer experience, you need a solution that covers you at every stage of your operations, from the front-end POS sales to accounting and inventory management. LS Fashion is that solution covering for size accuracy, facilitating item returns or exchanges, item quality validation, and limited inventory. LS Fashion helps you address these pain points to provide a seamless shopping experience. Personalized experience across all channels Through LS Fashion’s omni-channel options, customers can flexibly browse within the store, then purchase online and vice versa. They can also choose whether to pick up or have their products shipped. Members of staff equipped with mobile POS devices, can easily process payments and assist shoppers with selecting sizes, styles and availability, as well as placing orders online if an item is unavailable in-store. Unified software solution Allow your fashion retail business to embark on a new level by becoming more competitive through a cost-effective POS and fully integrated back office system. Manage complexities which the fashion retail industry can offer with an easy-to-use and swift technology. Based on Microsoft Dynamics NAV, LS Fashion is an all-encompassing complete solution integrating the entire business from POS operation to accounting and inventory management. Know your customers Knowing your customer habits and behavior is crucial to provide an indispensable customer experience. Customer’s purchase history and information is a click away. LS Fashion can facilitate the process of creating tailored offers and promotions to call your customers to action. Customer loyalty can also be tracked and linked to customized rewards that incorporate social information, shopping behavior and more. Informed decisions to plan ahead LS Fashion helps retailers improve demand forecast accuracy and suggest better allocation and replenishment strategies through incorporated predictive analytic tools. Retailers can experience improved accuracy on the store floor coupled with decreased time spent with order processing. Stock Control The possibility of loosing a sale as your customer struggles to find an item on your website or in store, is an unnecessary risk. LS Fashion’s powerful inventory management capabilities allow retailers to keep tabs on their stock in real time, and receive sales-data analysis so they can make more informed inventory purchase. 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.

Paladin HR is a Human Resources add-on for Microsoft Dynamics NAV / Business Central 365. Enhance your accounting / ERP software solution with automated contracts, leave/absence management, jobs and more. Microsoft Dynamics 365 Business Central Payroll & HR Management Solution Cost-Effective Software - We don't tie people into long term contracts and allow you to cancel at any time. We like to think that, if the software is good, then it's worth paying for. An all-in-one HR Solution for Microsoft Dynamics 365 Business Central Paladin HR is an add-on for Microsoft Dynamics 365 Business Central . We've designed Paladin HR to be as dynamic as possible, which will allow you to customize the system to suit your needs. A cost effective HR system that saves business owners, finance and HR professionals time and money. Dashboard All you need to know on one screen. Paladin HR comes with a pre-configured dashboard to allow you to quickly and easily determine what your HR priorities are eSignature Support Electronic signatures are fully supported, enabling you and your users to sign contracts through the self- service portal Built to Last Paladin HR has been built on the latest Microsoft Dynamics 365 Business Central platform meaning upgrades are quick and easy Benefits of Paladin HR Solution Transform your business with Paladin HR for Microsoft Dynamics 365 Business Central. Manage, maintain and optimize your Human Resources. Easy to Setup HR Portal Overtime Tracking Absence Registration Secure Document Tracking Appraisals HR Contract Management

How-to - Revaluation of Exchange Rates Microsoft Business Central Revaluation of Exchange Rates These adjustments are done to revalue all the customer ledger entries, vendor ledger entries and bank ledger entries. Join On Point Academy to view all content Join the academy → Log in → To perform Revaluation an end of month revaluation of currency. 1. Choose the Search icon, Currencies , and then choose the related link. 2. On the Currencies page, click on Process and Select Adjust Exchange Rate page . 3. On the Adjust Exchange Rate page , Starting Date : Specifies the beginning of the period for which entries are adjusted. This field is usually left blank, but you can enter a date. Note: Best practice is to leave it blank so any adjustments you missed previously can be captured. Ending Date : Specifies the last date for which entries are adjusted. This date is usually the same as the posting date in the Posting Date field. Posting Date: Specifies the date on which the general ledger entries are posted. The posted entries appears at the Exchange Rate Adjustments Registers . This date is usually the same as the ending date in the Ending Date field. Document No: Specifies the document number that will appear on the general ledger entries that are created by the batch job. For example ADJUST MAY EX. Adjust Customer, Vendor and Bank Accounts: Specifies if you want to adjust customer, vendor, and bank accounts for currency fluctuations. Adjust G/L Accounts for Add.-Reporting Currency: Specifies if you want to post in an additional reporting currency and adjust general ledger accounts for currency fluctuations between LCY and the additional reporting currency. 4. Click on OK. Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

How-to - Customer Open Invoice Report Jet Reports Customer Open Invoice Report In this report, we will demonstrate how to create a customer invoice report using Jet. This report contains documents that record the service or product delivered to a customer, the amount paid, and the payment method. A customer invoice report is just a record that shows a transaction between a buyer and a seller. The invoice always specifies and provides valuable information, even if the products are bought on credit. We also show how to add a Report Options page. in this case, (the Date filter) to a report. Our Report will be created from the following tables as shown. Join On Point Academy to view all content Join the academy → Log in → Step 1 Grouping the Report This report will be grouped by the customer no and name (Primary list). To do that, we separate our primary list from our secondary list by moving our secondary list to the next row under our primary list, as shown below. Step 2 Adding Report Options to the report. Navigate to the Ribbon tools and click on Report Options. when you do that, a new Report Option Page will pop up. on the pop-out, you can fill in as shown below. Note: If you want to know more about Report Options, Kindly check our Article on that. Step 3(a) Fill in the formulas for the primary list. I’ll show you how to fill in the formulas for the Primary list and also the secondary list. Filling in for the Primary list Go to cell E9, click on the NL function, and fill in as shown below. Go to cell F9, Click on the NL function, and fill in as shown below. Note: the No. the referencing to cell E9. Step 3(b) Filling in the formulas for the secondary list for the NL (Rows) Note: we only what the report to show an Open invoice. There is an open column on the Cust Ledger Entry, apply the filter here and select true. That’s what determines receivables. (Open invoice). For the NF(s) Fill in for each NF with the same Key as shown in the table above and also with the respective fields. Step 4 Applying a filter to the report I included just the Date as a filter on the Report Options page in this report. Feel free to use as many filters based on the criteria of the report. Note: The NL Rows(primary list) must be filtered to the posting Date from the report options. The NL First Customer name must also be Filtered to the customer no on the report. Cell E9. The NL Rows (secondary list) must be filtered to the Customer no on the report, and also the posting date From the report options. in this case, cell E9. Example: To filter for the “posting date“, make sure your cursor is on the filter box, then click on Insert Report Option. A new page pops out when you do so, click on Date range then click on add. This will add the date to the filter. Filter applied to NL (Rows) Primary list Filter applied to NL(rows) Secondary list Step 5 Adding Subtotal and Grand Total to the report. This empty row is typically selected so that the report can automatically adjust and expand as new data is added to the data range When you run your report, it should look as shown below. Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

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 →

How-to - Changing Dimensions Of A Posted Transaction Microsoft Business Central Changing Dimensions Of A Posted Transaction Overview A new feature released recently in Microsoft Dynamics 365 Business Central now allows users to correct the Dimension Value of already-posted transactions rather than reversing the whole transaction and re-posting. Join On Point Academy to view all content Join the academy → Log in → How it's done? Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

How-to - Posted Purchase Invoice Jet Reports Posted Purchase Invoice A purchase invoice can be any receipt or record of a supplier invoice for goods or services, which also include rent and utility bills. The invoice details are entered manually and the invoice lines are matched to outstanding purchase orders. To create this report, you need to pull out information from the following table. Join On Point Academy to view all content Join the academy → Log in → Procedure Step 1 Know where you are pulling your data from Just as shown below, the NL(Rows) will contain our source of data, which will be pulled from the table “VAT Entry“. The NF (Keys) will be a cell reference, which will be referencing cell $D7, and the fields will be pulled from below the “$D&“ names as shown. 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 function. Fill in as shown below Filling the formulas for the NF function Fill in as shown below. Note: use the same procedure to fill in all the NF functions. the key will be the same, just the field will be different. Filling in the NL Formula for Purch. inv Line. Fill in as shown below. Note that we apply a filter (Document No) here, referencing no. pull from Purch. inv. Header. Filling the formulas for the NF function. After filling in the formulas, it should look like this. Step 3 Running your report. When you run your report, it should look beautiful as shown below. Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

How-to - How-to-Use NL (Columns) Jet Reports How-to-Use NL (Columns) NL is a useful function in Jet Reports that help you create custom reports quickly and easily. The NL function can be used in conjunction with (“Columns”) to insert a copy of the entire column of each value that meets the Filter criteria, allowing your report to display the values on the column from left to right. Here are the steps to create a report that shows the customer names on each column Open your Excel report and navigate to the Jet tab. Click on the NL function under the Tools section. Join On Point Academy to view all content Join the academy → Log in → 3. Fill in the fields as follows: What tab: Column Table tab: Customer Field tab: Name 4. Click on OK. 5. Once that is done, you should see a display of the customer names. 6. Give your column a title. 7. When you run your report, you should see the customer names displayed from left to right. By following these simple steps, you can effectively use the NL function with (“Columns”) to create a report that displays the desired values on each column Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →

How-to - How To Remove A Column Microsoft Business Central How To Remove A Column The Personalization mode in Business Central offers the average user a variety of customizing options. Fields can be added, moved, or removed to fit the user's preferences. To delete a column, open any page. For the purposes of this illustration, we will use the purchase invoices page. Join On Point Academy to view all content Join the academy → Log in → To add a column or field; STEP 1 : Select the Settings symbol, marked red at the top right corner and then select Personalise . STEP 2 : For the purposes of this illustration, the Status column will be removed. Move the mouse pointer to Status and click on it. A list of options drops down then select Remove . Select Done at the top right corner to confirm the action. Get trained the On Point way From self paced online courses to private training sessions . Become industry ready. View courses →