• Sales order UOM is different than SO Invoice UOM

    Customer orders in cases but need to invoice in pounds. Cases may or may not be exact weight, each case may have a different weight. Similarly, order from Vendors is in cases but are invoiced by the vendor in pounds. Again, case may or may not be exact…
  • job number not showing up on the PO

    In SAGE 100 when we enter an order, and that order is for a job we enter the job number. We decide to drop ship some of the items and generate the PO while in the SO. At this point why does the job number and cost codes not get carried over to the PO…
  • How to make new customers appear in drop-down menu?

    When we had Sage installed, all of our customers were imported into the system. When I start to type in the 'Customer No.' field, a drop-down menu appears with predictions of those customers. However, when I add a new customer, I have to click the magnifying…
  • Sage 100 Premium 2021.3 company background colors stopped working

    I set the company background color last week and now they are all the same. In Company Maintenance on the Theme tab I tried to turn it back to standard, then change back to classic and choose a new color, but it still isn't showing the background or frame…
  • 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…
  • misc items

    Miscellaneous Codes: can a service item be entered into "inventory" since there is nothing to physically count so we can assign a vendor and costing. And just make it a drop ship only item. Thanks
  • Azure migration from MSP hosted 2019 VM

    Currently we have an MSP host a Server2019 VM where anywhere from 15-20 people log in to access Sage 100. I am looking to migrate it over to an Azure Instance. Are there any recommended instance types or configuration resources I can read into? Thanks…
  • Production Management - Work Ticket Template Maintenance -> new object creation with incorrect material posting on steps from copy process

    Using Production Management->Setup->Work Ticket Template Maintenance and creating a new object: 1) Input unique NEW template number that does not exist in the system 2) choose COPY (from Open Work Ticket) from the Message Box 3) Select existing…
  • Does Sage 100 2020 require MSXML 4.0?

    MSXML 4.0 had been installed on the server at some point during installation of Sage 100 2017. Does it still need to be installed after upgrading to Sage 100 2020? The issue is that the version is no longer supported and is a security risk.
  • Rebuild Sort Files using BOI?

    Has anyone been able to Rebuild Sort Files (and/or Key Files) using BOI? Last post on this topic from 12 years ago said no, but perhaps someone has figured it out since? I see the objects SY_Rebuild_bus in the Object Reference but am not certain if…
  • Log4j and Sage 100 vulnerability?

    Last week a proof of concept for a vulnerability around Log4j was distributed on the Internet. New zero-day exploit for Log4j Java library is an enterprise nightmare (bleepingcomputer.com) Almost immediately bad actors started trying to exploit the…
  • How to receive access to Account Receivables documents via API

    Hello Team, I have an application and want to integrate it with Sage 100 cloud. I found the following specification: help-sage100.na.sage.com/.../index.htm As I understood, this API allows receiving all Account Receivables documents from Sage 100…
  • Earmark part of a LOT Number not for sale

    Trying to figure out if there is a way to reserve a portion of a LOT Number for Make to Stock finished goods. For instance: The company I work for makes paint. If we make a batch of a particular color, give that batch a LOT Number and enter it into…
  • What CRM User to use during Sage Premium setup?

    During the Sage Premium setup, it asked for a SageCRM user and I have always used the sa user with no issues. Can I set up a different user and what rights does that new user need to have to work properly? Are there written instructions to do this?
  • Match BOM Production Entry Line Sequence to BOM Maintenance detail line entry

    We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…
  • Approval work flow

    Does Sage 100 have the functionality to incorporate invoice and PO approval work flow without 3rd party software or add-in?
  • I don't have the work order/production module. What is the best way to incorporate labor rates into Sage 100 BOMs?

    I don't have the work order/production module. What is the best way to incorporate labor rates into Sage 100 BOMs? Right now I'm set up using misc codes.
  • How to change default tax class on ci_item?

    Hello, We are making some changes regarding taxes at our company and are wanting to change the default tax class when adding new items. Currently, when a new item is added it is assigned 'NT' (non taxable) tax class, and we want it to default to …
  • Sage Migrations (MAS 200 / Sage 100)

    Fairly new to most of Sage. From what I've heard it's not possible to migrate MAS 200 into Sage 100 because of different tax structure setups. We run MAS 200 v4.40 (listed in install as C:\M200cs\V44\MAS90), Sage CRM 200, and Sage 100 2017 v5.40.0…
  • Max Characters in AR Invoice Number

    Does Sage intend to increase the max number of characters in the AR Invoice Number in an upcoming version of SAGE100? We are less than one year from needing more than 7 characters in our AR Invoice Number. I know that other users have been requesting…
  • Sage Alerts HTML email color coded table

    I am writing an html email alert for Sage Alerts and Workflow v9.0 for Sage 100 and I have a table in the email alert and I want the table to be shaded for every other row. I'm using the nth-child(even) method and I can't get it to work. If someone has…
  • Auto send email on entering / invoicing orders

    Is there any ways to enable Sage 100 auto send email notification to a certain group of recipients upon SO is entered / invoiced? I assume this has to involve scripting, right? Thanks, Haibo
  • Physical Count Worksheet Print Dialog - Print Quantity on Hand not displaying

    I've got two users that we need to be able to print out the Physical Count Worksheets with the Quantities on Hand. The print dialog panel does not show the checkbox to do this for those users. It does show for me. For the life of me, I can't find it…
  • run script without admin (COM exception failed to initialize provideX library)

    I see that there are lots of questions about this in the past, but I can't seem to find a concrete answer on how to move forward with it. I realize it has something to do with DCOM, registering the DLL, running client side verse server side.... But I…
  • Is there a way to view invoices in Customer Inquiry for the Sold To Customer when National Accounts is Enabled?

    Is there a way to view invoices in Customer Inquiry for the Sold To Customer when National Accounts is Enabled? Currently, I can only view the invoices in the Bill To Customer. When someone is inquiring on an Invoice on a Sold To Customer there does…