• What module would be best for new services?

    We currently use all the core modules (GL, AP, AR, BR, PR, IM, PO,  plus Job Cost and Time Card. I am looking for something, for example - we may have 1-3 jobs at a time (up to 90 days each), each job will have 2-3 work tickets, and each work ticket generates…

  • Can I get more that 2 people into a Cash Reciepts batch for entering Credit Cards during the workday?

    I am running Sage 2021 and have managed to get two people into the same batch for doing Credit Card transactions with Paya. Any attempt to add a third person will not work. What is the preferred method for allowing users to run a stored card for a client…

  • Windows 10/11 ARM processor and pdf converter

    Hope a community member can help here. I have a few machines that are running the ARM version of windows 11. 

    The sage pdf converter for paperless office does not include a arm version of the driver. 

    I have reached out to both sage and amyuni (the developer…

  • F9 can't read SY_Company.m4t file correctly

    We've been using F9 for a very long time, and sometime in the past couple of months it has been "working" in terms of allowing the F9 formulas in excel to work, but when one user (me) tried to do some additional F9 tasks (drill down), it only sees 2 of…

  • VI Import AP Credit Memos

    Have the following source file (CSV)

    2 questions:

    1 - I want to import the Invoice No and append "-CM".  Is this possible?

    2 - Importing the lines Distribution Amount from the Credit Column. How do I reverse the sign so it comes in as a negative…

  • Inventory Valuation Report and Available Quantity

    Hello! i'm hoping you can help me with something that i'm sure is a very simple fix. 

    We run small inventory counts usually to confirm and reconcile backorders or questions about shipments through the month. Usually, we run an inventory valuation…

  • How to share a silent ODBC Connection

    I've connected a single table from Sage 100c 2021 to Excel (data model) via a silent ODBC connection with saved username/password.  All works great for me, but if anyone else uses this excel workbook and tries to refresh the data it makes them log…

  • Creating a VI Job to delete old vendors

    Hello

    I am trying to create a VI Job that will delete a long list of vendors with whom we have not done business in over 7 years.

    I've "created" the job and imported the data from my list but get an error. Sage does not like my thinking.…

  • Experiencing FOMO? We have the cure. Upgrade to Sage 100 Version 2022.0 today!

    Sage 100 keeps getting better to continuously serve the needs of our valued customers.

    With the release of version 2022.0, Sage Production Management has been improved to offer you the features of our Work Order solution and so much more into a modern…

  • Sage 100 Premium migration failed...'KPRIMARY_SY_System' is already in the database.

    Test conversion from 5.40.3 to 7.0.1 Sage 100 Premium with multiple integrations. 5.40 instance and 7.0 instance are on same SQL server.  This is the 2nd test migration, so MAS_XXX and MAS_SYSTEM databases currently exist in the new SQL instance. During…

  • Getting ready for On Site implementation and need Minimum System Requirements

    We have started the process of implementation of Sage 100c Premium.  My support portal is still not connected to our account and am in need of getting the Minimum System Requirements for the servers and workstations.  I will be grateful if someone can forward…

  • Positive Pay Export for Union Bank

    Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines?  

    Here's a sample of the output file

    Sample data transmission
    payee positive pay Input format
    908123456700002000720312070000029375…

  • What is the newest SQL server version Sage 100c 2016 would run on

    Want to upgrade our Windows servers to 2019(from SBS 2011 and 2008 R2) and keep Sage 100 2016 for now.  I  have read that SQL 2008 will install but should not be used in a production environment.   Wondering what is the newest version of SQL that I could…

  • Customer Renumber using Delete/Change Utility does not renumber customer in SO_SalesOrderHistoryHeader

    Why doesn't the SO_SalesOrderHistoryHeader file get updated with the new customer number from the Customer Delete/Change utility?  I've renumbered and merged several customer numbers and this is the one file that does not get updated.  This file…

  • Automatically print backorder pick tickets?

    With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before.  Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled.  Our…

  • AR Invoice Adjustment not reflected in GL

    Hello,

    I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…

  • Basic Authentication with SMTP - any workarounds for Sage100 v2018 users?

    Has anyone found a workaround for the Microsoft and Google authentication changes?  We have Sage 100 v2018 and it looks like we will be forced to upgrade.

  • Expanded Customer Number

    We have a client that has one company that would like to use the Expanded Customer Number, but they have another company that doesn't need the Expanded Customer Number.  They set up the first company with the box checked.  Now they are trying to set…

  • Lot/Serial Number being populated on Random FIFO Item Codes during Physical Count Entry in Inventory Management Module

    Has anyone seen this before? The Lot/Serial Column, which is normally blank for a FIFO Inventory Item Code, shows a random serial number, from a random Serialized Item Code (in our case this serial number that's showing up really is a serial number of…

  • Sage 2021 PU2, PR 2.21.3 Upgrade - Have to re-add Payroll Custom Reports with PII Wrk table from 2018/2019?

    Howdy - I have had 3 separate upgrades where the client is upgrading from 2018/2019 with fairly recent Payroll updates (2.21.1 and greater) to Sage 2021 PU2 with PR 2.21.3, and after data conversion, if they have any Payroll custom reports from the previous…

  • Anyone know of any Performance issues with Sage 100c ADVANCED v2021 PU1

    I'm preparing my upgrade from v2019 to Sage 100c Advanced v2021 with PU1 (due to Scanco Operations Mgmt compatibility) and notice KB articles referring to slow performance issues with STANDARD and PREMIUM.  But nothing with ADVANCED.

    Does anyone know…

  • SAGE 2020 Warehouse Negative Inventory

    Hello everyone,

    Does SAGE have an option to not allow inventory for warehouses to go negative regardless of the transaction type? We are running into issues with multiple warehouses.

    Thank you

  • SAGE 100 2020 closes on login

    Hello everyone,

    We are running into an issue where at random 2-3 users a day are not able to login to SAGE. They enter their passwords and the screen flashes and the closes. I've noticed that the module date is somewhere in 2015 when I catch a glimpse…

  • Looking to Customize Customer Statements Sage 100 2019

    I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years.  Now managers want some of these UDF to be required.  When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…