• What 1099 forms are supported in Sage 300?

    Currently, only the 1099-MISC and 1099-NEC forms are support Sage 300 in both paper and electronic formats.

    These are the current 1099 Codes/Boxes supported:

    Additional support for new Code/Box 11 (Fish purchased for resale) in the 1099 MISC has been added by 2022 PU2, 2021 PU5 and 2020 PU8.

    Filing Dates:

    1099-NEC – Paper or Electronic – Filed on or before January 31.

    1099-MISC –       Paper – Filed by February…

  • Good news for PJC Web Screens users!

    With Product Update 2 for Sage 2022, users can now enter job-related documents in Accounts Payable on all A/P Transactions ( AP Invoice Entry, A/P Payment Entry and A/P Adjustment Entry) in Web Screens.  The 'job-related' button is now available for A/P Transactions in Web Screens. 

    If you want to find out more information about other new features included in this product update, please refer to the Release Note…

  • User passwords can be forced to be more complex now

    Overview

    This enhancement is added by 2022 Product Update 2 (PU2), but PU1 is required prior to installing PU2, so all the new tables are properly installed. 

    An advanced option is available for passwords. This feature will require Sage 300 users to create stronger and more complex passwords. This function will require users to create a password that is a minimum of 8 characters and with at least one of each of the following…

  • Sage 300c – How to Use Debug Mode to Troubleshoot a Sage Intelligence Report

    • Sage Intelligence Report Manager has an additional tool that can be used to assist in debugging the output of a Sage Intelligence Report. Here are the steps to switch to output mode.
    • Open Sage Intelligence Report Manager.  Highlight the Home menu, then either click “Output Mode” from the Tools Menu, or right-click on the Home menu and select “Switch Output Mode”.

    • Ensure “Screen (SQL Debug) option…
  • Do you know you can reserve inventory to ensure the required inventory will be available during shipment?

    Sometimes, an order was created but users may not ship the order right away. In the case that we don’t allow “negative inventory”, we need to make there are enough on hand for the order to ship at a later time. In O/E options in O/E Setup, there is an option called “Default Quantity Committed”. This option allows Order Entry automatically copies the number you enter in the Quantity Ordere…

  • Additional COVID-19 related paid sick leave available for California in 2022

    Recently, Governor Gavin Newsom has signed the legislation to extend the COVID-19 Supplemental Paid Sick Leave through September 30, 2022. This means employees in California can take up to another 80 hours paid sick leave mainly in 2 scenarios.

    More information can be found in the following websites.

    https://www.dir.ca.gov/dlse/COVID19resources/2022-COVID-19-SPSL-Poster.pdf

    https://www.gov.ca.gov/2022/02/09/governor-newsom…

  • Sage 300c – Understanding FIFO Costing (FIFO Buckets, Offset Buckets)

    • First-In, First-Out (FIFO) costing method.Under this method of cost calculation, Inventory Control assumes that the first units to arrive at a location are the first units shipped. Consequently, the units on hand in the closing inventory are assumed to be from the most recent purchases, and current revenues are matched to oldest costs.
      • To determine if your is setup as a FIFO item, you can see this in the Item Master…
  • What is CPRS in Sage 300?

    CPRS is system design for reporting payments made to Canadian construction subcontractors to the CRA. A construction business is required to report any payment to a vendor over $500 to the CRA. A business is deemed to be a construction business when more than 50% of a business' income-earning activities are from construction. Any vendor can be setup to track CPRS related payments in Sage 300.

    Refer to the CRA web…

  • Differences between Bills of Material and Kitting items

    What is a Bills of Material item (BOM)?

    • A Bills of Material item is an item that can be assembled or repackaged inventory items to create a supply of "master item" to sell.

     What is a Kitting item?

    • A Kitting item is an item that can be set up as collections of items that are priced and sold as a single item.

     Both a Bill of Material item and a Kitting item can be setup in I/C Items and Price Lists.

    This is an…

  • Why is Company Name not populated when promoting to Sage 300, as well why is Opportunity number missing when selecting New quote.

    During promotion as well as creating a new quote, required information is blank.  This is present when using Sage 300 CRM integration.

    This can occur as a result of an additional forward slash in the Sage 300 Server Name in CRM integration.

    To verify, in CRM Select Administration, Sage 300 Administration, Setup Integration, make sure Sage 300 Server Name does not have a trailing slash in url.

    For example, https://app06…

  • Log4j version 1.2.17

    Sage 300 Global Search module uses Log4j version 1.2.17, as this version is end of life, Sage 300 development will be updating to version 2 when product updates are released in March 2022. 

  • SMTP compliance for TLS 1.2 protocol

    As of product update 2020.7, 2021.4, and 2022.1 which was released in December 2021. Sage 300 is not compliant with TLS 1.2 for SMTP.

    Sage 300 development will release compliance with TLS 1.2 in March/April release, which will be product update 2020.8, 2021.4, and 2022.2.  

  • Having problems to efile Aatrix forms? Or having problems updating Aatrix?

    Firewall or antivirus softwares may block the updates from Aatrix, therefore, users cannot updating Aatrix or efile Aatrix forms. 

    Go to Aatrix.com/info/updates, then, go to Software Requirements at the top, try to download all the files ( Updater.exe.zip, Test1.xml, Test2.afm.zip, Test3.exe.zip, Test4.xml.zip, Test4.dll.zip and Test6.dat.zip) on the page to see if you are able to download each file successfully.  If you…

  • Mismatch between I/C quantity and Lot/Serial quantity of an item

    How to fix mismatch between I/C quantity and Lot/Serial quantity of an item if there is a variance on the I/C Serial/Lot Number Quantity on Hand Report?

    Below is an example in our sample data for this item, A1-405/0 at location 1. As you can see the Qty. on Hand for this item is 200 EA but the No. of Serials is only 10 EA.  There is a variance of 190 EA.

     In most cases/ businesses, the Quantity on Hand of an item should…

  • How to capture Microsoft SQL events for diagnosing, deadlocks and performance issues.

    Microsoft has deprecated SQL Profiler and now uses Extended Events for capturing and logging transactions.

    To setup Extended Events:

    1. In Microsoft SQL Server Management Studio, connect to SQL server.

    2. Expand Management, Extended Events.

    3. Right click on Sessions, and select New Session Wizard.

    4. Using the wizard, enter in a Session Name.

    5. Select a Template, most template are the same as Profiler templates.  For…

  • Security and Governance document available for Sage 300.

    A document is available, but can only be obtained through Sage 300 support with a support ticket number.

    Please reference KB108047

  • After upgrading Microsoft Excel to 64bit, Financial Reporter returns error with Excel Add-in.

    After installing Microsoft Office 64bit, for the purpose of using Financial Reporter, returns error.  Error occurs with Excel Add-ins and returns Runtime error 429.  This occurs when Microsoft Office still have 32bit related excel objects. 

    To fix the issue do the following.

    1. Uninstall Microsoft Office Access database engine 2007
    2. Uninstall Sage 300
    3. Using Microsoft scrubber tool to uninstall all occurrences of Office, use…
  • | Sage 300 -> Sage CRM integration troubleshooting guide | Tips & Guidance |

    An excellent series of posts from our colleague, Conrad Roux, which serves as a quick reference to all steps needed to help troubleshoot common problems in the integration related to incorrect or incomplete setup of the integration tools and processes.

    Sage 300 -> CRM integration troubleshooting guide - Sage CRM Hints, Tips and Tricks - Sage CRM - Sage City Community

  • Did you know? Sage 300 Platinum & Gold Business Care Customers get free unlimited access to anytime learning courses on Sage University.

    Sage is committed to your success. With Sage Business Care, you’ll gain increased value through add-on products and packaged services.

    One of those services is access to unlimited anytime learning courses via Sage University for our Sage 300 Platinum and Gold Business Care Customers.

    The attached PDF document will give you step-by-step instructions on how to access your training via Sage University.

    Want to upgrade…

  • New to Sage 300? Take advantage of our complimentary Getting Started and Introduction anytime learning courses

    New to the Sage 300 family? We have a range of training resources available to help you along your journey with Sage 300. All training resources can be found on our Sage University website (www.sageu.com). 

    What is Sage University?

    Sage University is the ultimate resource for all your Sage 300 training needs. It gives you the freedom to choose the courses that best suit your business. Our courses will help you…

  • Prepare to pass your Sage 300 certification exam

    With a Sage certification, you can stand out from the crowd and be officially recognized for your knowledge!

    Watch our video on how to prepare to pass your Sage 300 certification exam. 

    The video will explain the different Sage 300 certification options that are available to both our Customers and Partners.

    It will also give you valuable exam details and ideas to better prepare yourself to take the exam.

    Watch here >…

  • How to create your Sage University Profile

    What is Sage University?

    Sage University is the ultimate resource for all your Sage 300 training needs. It gives you the freedom to choose the courses that best suit your business. Our courses will help you master your application, maximize your software investment, and streamline your workflow, so you can deliver more value to your clients.

    Why create a Sage University Profile?

    • Identify the person with the course…
  • Complimentary Training & Assessments, plus Supplementary Training - Sage 300

    Sage wants to help our customers through this time by providing complimentary training. We've combed through our library of courses and have highlighted content we feel will be most relevant and beneficial.

    Complimentary Training: 

    Please find the current Anytime Learning / eLearning complimentary options below: 

    Getting started with Sage 300 Financials 

    This package will give you the knowledge and skills…

  • Sage 20% on selected Sage 300 anytime learning (ATL) courses - offer expires April 30, 2020

    Our anytime learning courses take you from learning the basics to mastering Sage 300 features. Plus save 20%!

    Anytime learning lessons are “bite-size,” instructor-narrated videos showing step-by-step how to perform tasks in your Sage 300 software. Available 24/7 for 1-full year so you can view these lessons as often and whenever you need – simply using a computer with an internet connection.

  • Sage 300 Customer Training Catalogue - Don't forget to book your Sage 300 training!

    Committed to developing the right training solutions for your needs.

    Sage product training solutions help you improve your proficiency in your accounting and payroll software. Whether you’re a professional, have experience with Sage products, or are just starting out, our courses will help you contribute not only to your company’s overall success but to the success of your career. Our professional training team…