• 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…

  • SO Shipping Batch No. missing on Invoice

    Occasionally we get an Invoice that is missing the Batch No. from when it was created via Shipping Data Entry.  We have multiple batches a day, usually separated out between EDI and Non-EDI orders and/or AM vs. PM shipments; totally anywhere between 2…

  • Integration with Sage 100

    Hello Team,

    Could you please help me with the following questions?

    1) Is it possible to integrate data from Sage 100 via web API?
    2) Does Sage 100 have a cloud version? or it is just an On-Premise version?

  • Sage 100 - Station Name in Master Console

    Experts,

    I am trying to find out how Sage 100 (in my case Premium) obtains the (Work-)Station name shown in the Master Console. Sage "remembers" some of its settings based on that station name.

    We tried setting the Windows environment varia…

  • Windows Server 2019 Essential

    We have a Sage 100 prospect that would like to use Windows Server 2019 Essential.  It is NOT on the Supported Platform Matrix.   Is anyone using this?  I explained to him that if the server software is not on the Matrix then his install would be unsupported…

  • Bulk delete empty Sales Order batches

    We have a process synchronization from our online store into Sage using the SData API. We had a glitch that caused a large number of empty Sales Order batches to be created. There are no invoices on these batches, so I was wondering if there was a way…

  • VI *.SQL Files Are Not Being Migrated To 2021

    I have seen two different upgrades affected by the *.SQL files under MAS90\VI failing to be migrated to the 2021 MAS90\VI folder during upgrades.

    Anyone else encountering this?

    The manual solution is to just copy them but I don't recall having to do this…

  • Sage 100 Application Server Startup

    Within the application server startup, what method or argument can be used to have Sage 100 application server "Start" when it launches. 

  • Sage 100 2021 premium slow performance

    Setting up my testing environment (test => prod) and performance is unberably slow. Typing in an item code in inquiry has a multiple-second delay between key presses and seeing letters. Search-while-typing is enabled, as it is in  in my live 2018 installation…

  • VI import into payroll doesn't stop, have to click "cancel". All records are imported, though.

    PR header and detail are chained. Same problem with each.

  • create new Sales Order form where lines print in correct order

    I need to create a sales order form for KnowledgeSync. I can't get the lines to print in the correct order.

    The standard sales order form created from the sales order work table has a "Group" that I'm assuming is what gets order lines to print as…

  • Sage 100 2020 VI for JT Tables

    Hi, I am attempting to export the JT_Template table to turn around and import the file in another company.  The only field not coming through the export is the Text field from tab 6 of WT Template Maintenance.  The field in the Data tab of the export says…

  • Visual Integrator Import Sales Orders Referencing a Master Order

    I use VI to regularly import sales orders. In this case, I would like to reference an existing master order, as the only data that needs to change per order is the header comment. As I have several master orders to reference, it would be nice to populate…

  • Crystal Report Page Layout not previewing any width greater than 8.5"

    I created a Sales Report in Crystal Reports 2016 that has 20 columns of Summary and then those 20 columns have sub-reports that I have linked to provide the Details by simply clicking on the hyper-link of the Sub_Report name.  I added the Sales Report…

  • Cancel and Reason Code Issues

    Hi Everyone. 

    We have decided to setup Cancel and Reason Codes for all Sales orders and Quotes.

    On Sales Order Options I have changed "Retain Deleted Orders/Quotes" to Prompt.

    Now when I go to delete and Order/Quote I get a prompt asking do I…

  • VI for Transaction Entry

    Hello,

    I setup a VI import Job for Transaction Journal Entry and it was working fine until recently. It is taking the offset account number and using it for the line account number as well. I am telling it to get the number from column, but it ignores…

  • Print to Tray 1 or 2 Based on Criteria in Order

    Hi, 

    I found a thread about a somewhat related customization, but it wasn't quite similar enough and I wasn't able to learn enough to be able to use the information there. 

    I'm trying to setup my sales orders to print to different trays based on…

  • AR Customer Statements Issue

    AR Customer Statements are printing / pdf / paperless delivering blank pages.  

    There is a documented "work around" for printing to do a crystal suppression formula... but that does not stop the "pdf all" or other paperless output options from doing blank…