• UDF PO ROI to AP_HistoryHeader & AP_TransactionPaymentHistory

    I created a Date UDF in PO Receipt of Invoice. it populates correctly. I'm trying to get this data into the AP_InvoiceHistoryHeader & AP_TransactionPaymentHistory.

    I've tried several links and can't seem to get the correct combination.

  • Rehired Employee Missing Check History

    We have an employee who has worked for us several times over the years. When we onboard a rehired employee, we use the same employee number. She has requested some older payroll data (2009-2013). I ran a Check History Report with a check date range from…


    I have created a "description" field to hold the description of the unit of measure as the 4 letter unit is often pretty cryptic.  I had no problem creating it, but when I go to add the field to the panel (Dmain), I cannot add my UDF.  The add…

  • outstanding receivables

    good morning:

    what report can i run for all outstanding receivables as of 12/31/2021 that have been collected in 2022 -to-date?

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

  • SalesOrder Picking Sheet Denied Access

    Hello Everyone,

    Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…

  • Looking for consultant to help in installation of Sage API into our sage 100 2020


    We are looking for consultant to help in installation of Sage API into our sage 100 2020 or someone who has worked on similar projects

     Please check below link for understanding:


  • Job Cost Retention Invoicing while using BT/ST

    We would like to use Job Cost Retention in Sage 100 Premium 2021, but currently Sage does not support the Bill-To/Sold-To (BT/ST) feature within Job Cost (which we need because all our jobs requiring Retention bill to a GC or third party). Adding Job…

  • AR Pre-payment



    A prepayment was applied to  the wromg customer in Sage and has been reconciled since December 2021. I was told to issue a debit memo for the amount that was misapplied. My big question is.... is it possible to apply prepayments to a debit…

  • Connection string for ODBC connection SOTAMAS90 with powerBi Gateway?

    I have seen some similar threads but none of them seem to work.

    Here is my situation, and bear with me I am very green with ODBC connections:

    I am wanting to connect to SOTAMAS90 through PowerBI gateway to get my data on a constant refresh. This would…

  • How to automatically create Work Ticket in Production Management from Sales Order using BOI

    I have built an order importer that automatically creates sales orders based off of an EDI file from our customers.  It works great.  We are currently upgrading Sage 100 to include Production Management Plus and I want to be able to add in the ability to…

  • Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll

    Anyone using Time Track for Job Costing, but exporting the time track entries for outside payroll service to process payroll? 

  • Automatically Distributing Lot Number in S/O Invoice Data Entry through Visual Integrator

    Hello All,

    I've been trying for the last two months to figure out a way to automatically distribute lot numbers by FIFO in S/O invoice data entry using visual integrator. We don't create a sales order before creating the invoice. Each of our inventory…

  • "This option cannot be changed while A/R Invoice Entry is in process"

    I received this error in Accounts Receivable module and I cannot seem to find any knowledgebase article that directs me on how to remedy this. Anyone else had this issue? In this instance, all batches are closed and none are outstanding in the Invoice…

  • Sage 100 2018 Customizer question PO Receipt of Goods Date UDF to post thru to IM Cost file

    Sage 100 2018 Customizer question

    All Inventory items are FIFO Valuation

    Client wants a Date UDF added to the PO Receipt of Good Lines

    I added the Date UDF to the PO Receipt of Good grid

    I need to know the steps on how to get this Date UDF to post thru to…

  • PickingSheetPrinted field didn't get updated after PickingSheet got printed

    There are several orders in our system, of which both the Sales Order Entry UI and table field of PickingSheetPrinted indicates that the picking sheet has not been printed. However, I do find the paper version of picking sheets of those orders in the folder…

  • Can an Inventory Depletion be Linked to the Receipt???

    First off, our ultimate goal is to look at an Invoice in AR_InvoiceHistoryHeader and Detail and know what the Landed Cost is.  The Purchase Order Module's History Files does a pretty good job of tracking Landed Cost History by Receipt Number.  However…

  • Import PO using Visual Integrator

    Trying to import POs with different Units of Measure in the lines. Inventory item is set up with Purchase UOM TON and Sales UOM LB. For some reason, the imported PO has a quality error (when UOM is different from the Purchase UOM, it multiply the conversion…

  • Changing Early-Pay Discount Description

    Is is possible to change the description of the Early pay discount? This would be the description that prints on customer statements and located within the customer's "Invoices" tab. It shows under "Payment Ref" within the details section…

  • Paperless Payroll Direct Deposit Stub Bulk Email not working properly with Office 365

    Our company needs to send 250 check stubs and direct deposit stubs to our employees, we do that process 1 day per week and send all un Bulk, we use Sage 100 Advanced 2018 (Version

    Each week at least 20 emails have not been sent, we checked…

  • 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 100 button link - pass variable to vbscript for shell call

    From Main Item Maint Panel

    I added a button link to run a vbscript, which runs a shell command.

    How can I pass the ItemCode to the vbscript.

    ' init vars

    Dim itemcode
    Dim oShell

    itemcode = "S-209220"        'hardcoded here works, but needs to change…

  • 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

  • Announcing Sage 100 Payroll 2.21.2 and 2.21.3 Program Fixes

    We have released program fixes PR6030T (PR 2.21.2) and PR6031T (PR 2.21.3) to correct an issue where Worker's Compensation wages and expense calculations are incorrect when using Adjusted Percentage and multiple earnings lines and a cafeteria or pension…

  • Sage 2020 Negative Issue of Materials


    In Sage 2018 and WOScan we could negative issue an item and create a new unique Lot or Serial Number on the fly.

    In Sage 2020 and MFG100, MFG100 will accept the scan, but Sage rejects the import because the number Lot/SN doesn't already exist.…