Search this site

Microsoft Business Central How To Create A New Customer TO CREATE A NEW CUSTOMER 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 “CUSTOMERS”. 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 customer card and spaces with the red indicator on the page. Modify the fields as appropriate on the customer card. Click on the reverse arrow at the top left corner and the customer is created and saved. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Microsoft Business Central How To Run Calculate & Post VAT Settlement To determine how much has to be sent to tax authorities, we execute the Calc-post VAT settlement batch job in Business Central. It identifies all VAT entries in the VAT entry window for each VAT posting group combination specified in the batch job filters. It calculates the VAT settlement of open VAT entries from prior accounting periods. Follow the steps below to run the batch job. Join On Point Academy to view all content Join the academy → Log in → STEP 1 : Click on the search icon at the top right and type in “CALCULATE AND POST VAT SETTLEMENT”. Select the related link. STEP 2: An Options window pops up, then fill in the spaces provided as required. OPTIONS Period Date Type Starting Date and Ending Date : Provide the date range of the VAT entries to be settled. Posting Date : Specify the settlement posting date. Document No. : Enter a unique number for the settlement. This field must be filled to run the batch job. Settlement Account : Select the G/L account where the net of the sales and purchase VAT entries will be recorded. Usually, a balance sheet account is selected. Show VAT Entries : Select the check box to display all VAT entries used to calculate the settlement amount for every VAT posting group. Not selecting the check box will display the total settlement for each group. Post : Select the check box to post the VAT settlement. The batch job will only print a test report if the check box is not selected. Show Amounts in Add. Reporting Currency : Check the box to instruct the report to display amounts in previously specified Additional Reporting Currencies. VAT Bus. Posting Group & VAT Prod. Posting Group : Specify the VAT Business and Product posting group in the batch job. STEP 3 : Review or print the VAT settlement by selecting Preview or Print at the bottom of the Options window. STEP 4 : If the Post check box is selected, you will receive a notice enquiring if the VAT Settlement must be calculated and posted. Select YES , then exit the print preview window. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Jet Reports VAT Entries Report A VAT report is a financial document that summarizes a company’s VAT Transactions over a specific accounting period, helping a company complete its VAT return. In this report, we show you how to create a VAT Report that shows sale and purchase documents. The report is created from the following information. 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 the names as shown. Step 2 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 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. When all these are done, your report should look just as shown below Step 3 Running your report. When you run your report, it should look something like this. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Jet Reports Using Report Wizard to Create a Trial Balance Report This report shows a trial balance for each no. and also the total for all. Open your excel report and go to the Jet tab. Join On Point Academy to view all content Join the academy → Log in → You should be able to see all the features. some of the features we will be using are (Design, Run, Jfx, Report options, and Report Wizard). Navigate to Report Wizard. On the pop-out, fill: Data Source (your choice) Company (name of the company you are creating the report for) Table (On the report you’ll like to create) 2. On filling in the necessary data, click on next and select the fields you’ll be using. 3. Apply Filter if necessary 4. You can group by any column order you want 5. You can sort by any column order you want. e.g. (sort by 'Balance' and choose either Ascending or Descending). 6. Always select mark Balance in Total. It allows you to see the Ground Total. 7. On Format, make sure you mark 'Add basic Excel formatting to the report'. 8. Click on Review to recheck and make sure everything has been selected correctly. Then click Finish. 9. After you click finish, this should pop up. 10. Run the report, and then your report is ready If you encounter any problems, please contact habib@onpointserv.com Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

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 →

Retail Electronics Point of Sale (POS) A holistic POS software solution integrating your entire electronics retail business. Know what your customers want and give them what they need Our special ordering management solution increases customer satisfaction. Members of staff can order products which are not in stock right from the POS, which will then be shipped to your location from the warehouse or directly from the manufacturer. Orders can also be quickly and simply done through as per customers' preferences. Easy search and checkout via mobile Sales staff can easily use stationary and mobile POS devices to search for technical and other product information. This provides for a personalized and satisfactory service as your clients truly deserve, making electronics retailers more efficient and cost-effective. No need for warranty receipts Trace your products by using barcodes, general product descriptions, or alternate descriptive identifiers. Your inventory management can be improved permitting your staff to track serial numbers of electronics goods. Returns and warranty lookups are simplified through the use of serial numbers. Effective inventory management Real time data allows retailers to have detailed insight of their stock, helping them make informed inventory decisions. LS Retail’s predictive analytic tools help to increase precise sales and profits and ensure efficiency. Marketing and loyalty app Knowledge is power and it is very much the same with your customers. With LS Retail your sales staff can have quick and easy access to customer purchasing history to provide a personalized service experience. Connect with your customers through meaningful recommendations to help you increase upselling and cross-selling opportunities. Concurrently, LS Omni mobile loyalty solution can help you target customers with tailored offers and promotions and deliver a personal and highly engaging mobile experience directly at their finger tips. Let stock-outs and overstock be a thing of the past LS Retail has the ideal replenishment system for electronics stores. Reach out to discover them and let us assist you through with making the most of of them depending on your particular needs. 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.

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 →

Retail Travel and Duty free Point of Sale (POS) A holistic POS software solution integrating your travel retail business. Strengthen your operations and increase sales and revenue Get a whole overview of your inventory so you never end up caught without stock. You don’t have to try hard with LS retail to provide a fast and accurate service, so let our software assist you with having happy customers. From online orders on all devices, to in store or gate pick up, you can be equipped to cater for all your customer’s needs and demands. All of this is included in one encompassing system tending to all tasks from back office to front service. Tailored for Duty Free We know that a duty free retail shop is like no other and that’s why our software includes specific functions especially catering for these needs. As soon as the boarding card and passport data is scanned, the system will automatically fetch the relevant date based on flight information regarding, taxes, refunds, pricing and discounts, grants and limitations as per stipulated criteria, as well as security tamper-evident bags. Our solution also caters for multi-leg boarding cards for in-transit passengers for which rules can be set basing on final destination instead of next-leg destination. Sell fast and sell well Acquire and retain satisfied customers by being to the point and with impeccable delivery. Be it a store or a restaurant, our software solution provides you with: Providing a swift service Suggesting the right product to your customers with the cross-selling assistance tool Complete product information at each POS Facilitating the process of application of offers and promotions The ability to carry payments, balances and price checks in various currencies Additional features and criteria can be set to reduce human error, such as setting fast keys for regularly used destinations and setting up caution triggers such as if a customer is exceeding their limits. Absolute command of your business Our comprehensive software solution provides you with total visibility over all your business operations through: Personnel administration Inventory management for optimization Leading reports for business planning according to real-time data Enhanced workflow through warehouse modules A system which scales up with your needs as your business grows Restaurant Tools for Managers Handle your food court and eatery services with the appropriate tools. Our system enables your diner outlet to: Reduce costs and eliminate waste by ordering the right amount of ingredients Delivering food at a faster pace as orders are directly sent from POS to kitchen personnel Administer bookings and service requests efficiently Alter sales items easily and fast by adding or excluding ingredients at POS Split bills, manage tips and complex payments in different currencies let customers order and pay at the table with mobile POS Benefits of our software solution: Effectively manage security tamper-evident bags Appropriate administration of offers and promotions Endorsement of different currencies Determine product limitations Provide customers with flexibility and convenience to shop Amplify sales and revenue 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.

Full Time/Part Time Marketing Specialist We are looking for a marketing specialist to join our young and dynamic team in Ghana. The position will be administrative, carrying out marketing tasks to help the marketing team implement marketing campaigns using different digital channels. APPLY FOR VACANCY Are you a creative candidate with a flair for marketing? Main responsibilities Managing social media pages, scheduling of posts, content and artwork for such pages Assisting with content creation such as blogs and artwork for websites, social media etc. Helping with marketing research, analysis and discussions of marketing campaigns Completing weekly related tasks such as coordinating with outside agencies, art services, printers, etc. Ideal Skill-sets Proactive and representative Fluent in English Excellent administrative & creative skills Positive attitude to work, and willingness to learn new things Education and Experience Strong verbal communication skills in English Basic knowledge in digital marketing tools and strategy Advanced computer literacy in Microsoft Office (Excel / Word / Powerpoint) Experiences with Wix and WordPress Familiarity with social media channels What do we offer? A pleasant working environment in a young and dynamic team. Varied work, including possibilities of travelling and working from your home. Full support in any kind of education or self-improvement. Flexible working hours 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.

Microsoft Business Central How To Add A Column The Personalization mode in Business Central provides various customization options to the typical user. Fields can be added, moved or hidden to suit the user's preference. You can open any page to add a column. 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 : A tab drop downs, select + Field then an Add Field to Page screen appears on the right with a list of columns to select from. Drag the desired field from the Add Field to Page section and drop at the fields heading section to add. STEP 3 : In this illustration, the Due Date column is added. It is dragged and dropped between the Status and On Hold fields. Select Done at the top right corner to confirm the action and it is done. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

Jet Reports Conditional hiding of Columns Welcome to this tutorial, where we will guide you through using conditional hiding of columns in Jet Reports. This feature is extremely useful and can save you time and effort when managing large amounts of data. With conditional hiding, you can hide entire columns based on certain criteria, making your reports more concise and easier to read. Let's get started! We have created a simple report with three rows: Customer No Customer Name Balance Join On Point Academy to view all content Join the academy → Log in → Before we apply conditional hiding, here is what our report looks like: Our goal is to hide columns where the balance equals zero. Step 1: Create a Label in Cell A2 The first step is to create a label in cell A2. This label should read "Hide+?" and will be used to identify the columns that you want to hide. Step 2 : Use a Formula to Hide Columns Based on Criteria Next, use a formula to return "Hide" in a column you want to hide. For example, if you want to hide any rows where the balance in cell D8 is equal to zero, you can use the formula "=IF(D8=0,"Hide","")". Step 3: 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 columns is a valuable feature that can 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 columns professionally based on certain criteria. Get trained the On Point way ​ From self paced online courses to private training sessions . Become industry ready. View courses →

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.