Quick CRM Tip: How to Modify a Form Using Microsoft Power App

A business’ success is highly dependent on its ability to act proactively and make critical decisions in a timely manner. Businesses are more complex than ever and as organization’s grow, so too does their data. This data is not only massive in volume but may also reside in a multitude of different sources. In addition to the core ERP, data is commonly housed in legacy systems and third-party applications i.e., CRMs, Payroll solutions. For this reason, organizations cannot continue to solely depend on the raw data derived from their ERP software for enterprise-wide insight. In addition, accessing and processing raw data from various sources is a time-consuming endeavor and one which can only be managed by someone with technical skills and extensive knowledge of these systems. Lastly, an organization is typically comprised of multiple departments and employees who require access to data at different levels in order to do their jobs effectively. An inability to quickly access and share information with colleagues and/or key stakeholders often results in a lack of collaboration and a siloed work environment. The importance of Business Intelligence In our data-driven world, data itself is no longer a business’ most valuable asset. The value is found in the actionable insights obtained from that data. Operating with legacy “reporting tools” or none at all results in time consuming manual work with room for error. Organizations are spending inordinate amounts of time gathering and managing their data limiting their productivity and time spent on other important tasks. Many businesses have access to their data, but do not have the tools required to actually leverage it. Business Intelligence delivers that “missing link” and is an essential proponent of an organization’s success. Winning businesses are those with the ability to easily and quickly turn enterprise-wide data- into actionable insights. Business Intelligence solutions provide users of any level, self-service access to data in a way that makes sense and facilitates decision making. But doesn’t my ERP have reporting tools? An ERP software helps organizations manage key business processes. It houses critical data but falls short with providing users an easy way to access, analyze and report on that data. Without an integrated Business Intelligence software, organizations must spend time and effort gathering and making sense of their data and are consequently missing opportunities. The ability to quickly access information through a BI’s reports and dashboards, enables businesses to act proactively and maintain a competitive edge.
Do you need to have IT expertise? Business Intelligence solutions are commonly developed with the end user in mind. Many BI softwares provide users with an intuitive, easy-to-use interface allowing them to interact with data regardless of their technical level. BI provides flexibility and empowers users significantly reducing reliance on IT. So, what is the key benefit of BI? Business Intelligence provides many benefits to an organization. It reduces time spent on gathering data, eliminates manual reporting and reduces reliance on IT. The right BI solution provides a full, clear picture of an organization’s financials, operations, and overall health. It enables employees and key stakeholders to quickly react when important changes occur and base decisions on reliable information.  avoiding missed opportunities and remain proactive. Business Intelligence is no longer a “nice to have” and is a necessity for businesses who are striving for success and growth. For more information about how Business Intelligence tools can help your business, please join our Business Intelligence Bootcamp webinar series or contact us. Note: Content for this blog post was originally written by Nectari Software, Inc.

You were in the middle of doing your Bank Reconciliation (BANREC) and you got up to answer the door. You return to your computer and panic sets in because in those brief seconds you were gone, your cat walked across the keyboard making random transactions cleared and closing the bank reconciliation. Unfortunately, the cat didn’t clear the correct transactions and you were left with a Variance. The Reopen option in the right box is grayed out. How are you going to reverse this mess? Relax and let’s see what we can do. The first temptation is to use Reconciliation Reversal (DEPOINTAGE). However, the DEPOINTAGE function only works with the functions RAPBAN (Bank Statement Reconciliation) and POINTAGE (Reconciliation). If you accidentally use DEPOINTAGE with BANREC, the Mark will be removed from the transaction line(s). However, if you attempt to clear the transaction in the future, you will receive a “Transaction already exists error,” referencing the Key which is the id number for the line and the Table BANKRECD. The scope of DEPOINTAGE is stated in the Online help center. If you did use DEPOINTAGE, you may have to contact your Net at Work Account Manager for assistance correcting this situation. The BANREC has to be manually reversed. To start the correction process, the statement must be reopened. If the Reopen option is grayed out, head over to Setup, Users, Users (GESAUS) and call up the User code for the person who will be authorized to reopen the BANREC statements. Under the Parameters tab, Chapter TRS/ Group AUZ, change the Value for Parameter REOPENREC to “Yes.” Click OK and Save. Logout of X3 before returning to the Bank Reconciliation. You might consider returning the parameter to “No” when you are finished for internal control purposes. Reopening prior statements will impact those statements which followed potentially changing balances and cleared items. The Reopen option in the right box will now be available. Click Reopen and the statement Status will be changed to “Open.” Now you can proceed to the Details grid to continue reconciling. There is no need to dread removing the Mark from each line. Instead. go to the Action icon (3 vertical dots) to the left of the Mark column. Once you click, note the drop down menu gives you the option of selecting “Yes to all the rest” or “No to all the rest.” This allows you to clear large chunks of transactions or all of them depending on where you start. Hopefully with this information, you will be able to forgive your cat for her journey across your keyboard and finish your bank reconciliation. Trivia: The Bank Reconciliation (BANREC) function was introduced in v6p17.             If this blog has sparked your interest in learning more about the different ways to perform a bank reconciliation, check out the Sage University instructor led session: X3 – Sage X3 – Introduction to Bank Reconciliation.  After taking the class, you will: Understand the different options available for performing a bank reconciliation. Understand how to clear transactions and manually enter missing transactions. Understand how to import bank transactions as well as match and reconcile the imported transactions. Understand bank formats and segments with a focus on the BAI2 format. For more information about reversing the bank reconciliation in Sage X3, or for any other Sage X3 questions, please contact us. NOTE: Content for this blog post was originally posted on Sage City, July 31, 2023.

January 31st is not far off and we all know what that means – it is almost time to process 1099’s. Sage MAS 500 supports paper and electronic filing and the following forms: 1099-DIV, 1099-INT, and 1099-MISC. Before processing 1099’s you must apply the 1099 update provided by Sage for the current year. Please refer to the files below for required pre-requisites before installing the 1099 update for your current version of MAS 500 and the update itself: » Release notes (MAS500730_1099Update2010.pdf)
» Server update (730_2010_1099_UpdateS.exe)
» Client Update (730_2010_1099_UpdateC.exe) If you would like to take advantage of electronic filing you will need to apply to file electronically with the IRS. Use Form 4419 provided by the IRS. Click below to access the application for filing returns electronically: Electronic Filing Application Once the application has completed you will receive a Transmitter Control Code (TCC). This code will be used when submitting your 1099’s electronically. If this will be your first time processing 1099’s in MAS 500 or if you need to refresh your skills on common 1099 procedures for entering and editing 1099 data, creating 1099 beginning balances and submitting forms, do not hesitate to contact our Helpdesk at 1-888-494-9479 or helpdesk@netatwork.com and any of our MAS 500 consultants will be happy to assist you.