x Want to participate? Join the group to interact

  • Quantity Available

    Hello trying to find what table the Available qty is located... Can't find in CI_Item or IM_itemwarehouse

  • Automated Emails sent out from SAGE 100

    Hoping for any assistance in this issue. For some reason, Past Due invoice after 60 days, are getting automatically emailed out to customers on random days. I do not know where/how it is doing this. There is nothing in Task Scheduler or in our Sage…

  • Controls on Purchase Orders

    Is there a way to set controls where a user is only allowed to create a PO and not have the capability of editing or deleting a PO?

  • IL Paid Time Off for All Workers Act

    Has anyone set up a time-off code to track the new Illinois Paid Time Off for All Workers Act that took effect on 01/01/2024? Hoping to avoid manual tracking. Thanks, Suzanne.

  • Pop-Up message when starting SAGE 100

    I get the following pop-up message when clicking on the windows 10 desktop icon for SAGE 100 2023 advanced: "User Account Control Do you want to allow this app to make changes to your device PvxBootstrap" Is there a way to prevent this message from…

  • Transaction Entry Partial Lookup Not Working Sage 100 2023

    When making a transaction entry in inventory management, the F2/Look-up feature doesn't work if we put the beginning of the model number in and then hit F2. The look-up table is empty. If we try with an empty item code box, it lists all of the items…

  • Demand in IRP

    Why doesn't the Demand in IRP Generation process take into consideration the units SOLD for items? It only accounts for the Projected demand - SO Quantity on open Sales Orders.

  • Sage 100 2020 - Email settings Errors

    Sage 100 2020, running on Server 2019 RDS session Getting error. tried all email options / settings but no luck, need some help. Error : Email service is not installed Anyone have a tip to resolve. We have other email utilities running on…

  • Question on Sage 100 Salesperson

    I have an account on customer maintenance in Account receivable module and the division starts with 00. 1. Does the salesperson have to start with 00 as well for me to assign it? 2. Can I assign a different division for the salesperson 01-AAAA to…

  • Sales Order Entry / Customer PO # Question

    Is it possible to limit the entry of this field to 15 characters? If so, how? Thanks

  • Disable the Customer Memo Pop-up in Shipping Data Entry

    When scanning out products in Sales Order > Shipping > Shipping Data Entry we keep getting all the Customer Memo Pop-ups. Is there a way to turn this off for certain roles? We have Sage 100.

  • Change AR Aging from Invoice Date to Due Date

    Our company has decided they want to change the AR Aging Invoice by Invoice Date to Due Date. Is there anything I should be aware of or need to run after I change the option? I would assume there is some utility I need to run that will recalculate the…

  • Sage 100 in Azure

    I am in the process of migrating Sage 100 on prem to Azure. I see this a a multi step process... In Azure: Will upgrade my on-prem Sage instance to latest version. Install Sage 100 on Azure Server (latest version) Overlay the new installation…

  • Changing Warehouse in RMA Entry

    I am attempting to change warehouse for an item in RMA Entry > Lines, but I am unable to change the warehouse of the item. Any Solutions?

  • Enabling Return for Items?

    We are testing items to return in RMA, but we are getting the notification that the item isn't setup for returns. Where can we enable this?

  • Sales Order Invoice Discount GL setup

    Hello, Is there a way to assign a GL to the discounts in Sales Order based on the Customer instead of the division? Thank you

  • General Ledger Accounts

    I want an account to start requiring job numbers when paying per-diem. Can I not change an established general ledger account to start requiring that?

  • RMA

    I am having issues with receiving an RMA. I am selecting item action "Stock" and customer action "Credit" but no inventory transaction takes place when I update the transaction. My theory is the setup is incorrect but not sure what those should be. Any…

  • Alias Items

    I have several items with more than one vendor and with different alias item numbers and descriptions for each vendor. My purchase orders are printing the correct alias item number, but not the correct alias description. Thank you in advance for your…

  • Paperless Office

    Hello... if we preview an invoice before printing the PDF the invoice file doesn't get created and saved into the defined folder for paperless office. Is there a setting to change this or work around.. Thanks

  • how to change subsidiary type in existing GL account

    I forgot to select "departments" as the subsidiary type in a GL direct cost GL account. There has already been activity so it won't let me change the subsidiary type. How to I fix?

  • GL Account Structure

    We are wanting to change our GL account structure, making the second segment 4 characters instead of 2. I am assuming everyone needs to be out the system when this is performed because we get the warning, "This task is in use...". Before we wait until…

  • QR Barcodes Length

    Hello, Our manufacturer recently changed our old barcodes to the QR barcodes, however, when we are trying to scan the products into SAGE 100 it is not taking the full serial number length. Is there a way I can update the serial length within SAGE…

  • Cant create Fiscal year 2024

    Hello, We are getting ready to import our 2024 budget however I can't seem to create the new Fiscal Year in Fiscal Year Maintenance. The instructions state to enter in new fiscal year however the field and spyglass are greyed out so I can't. I originally…

  • Decimal Points

    How do we go about increasing the decimal points when creating a bill of materials in SAGE 100? For example, we want to enter 0.5 LBS. or 24.5 in?

*Community Hub is the new name for Sage City