• Prevent item from being added to an invoice

    Is there a way to prevent an item being invoiced from a sales order?

    For example, the item is still under Q&A testing, and the item should not ship until testing has been completed.

  • Sales Kits not exploding on order imports

    We are testing sales kits and placed an order originating from our e-commerce site. The first batch of orders failed because the explode kit items field was set to 'Never'. I thought this was my issue, but the kits still have not exploded after altering…

  • Default Warehouse Precedence

    We want the default warehouse for specific customer ship-to locations to carry over to sales order line items. I have successfully set it up so that the warehouse is set correctly on the sales order header based on the ship-to location.

    However, the warehouse…

  • Disable Auto Increment for Lot/Serial Number Distribution in Shipping Data Entry

    Upgraded to Sage 100c Advanced v2022.1 with OM PU1 from v2019.2

    Shipping Setup Options has Auto Increment disabled, but when distributing Lot Numbers in in Shipping Data Entry, the Auto Increment in the Lot/Serial Number Distribution window is enabled…

  • Lot/Serial Inquiry no longer shows complete list of transactions.

    In 2019 the Lot/Serial Inquiry listed all the transactions in the grid when a Lot/Serial Number was selected.

    Now, since 2020.1, with the addition of Lot/Serial Traceability, Lot/Serial Inquiry only gives a list of the Item Codes. If you want to see transactions…

  • Work order release

    Does anyone know of a system setting that will allow me to have work orders be automatically released when I create them in Work Order Entry?  Thus, eliminating the need to go into Work Order Transaction Entry to Release them after i create them.

  • Currency Conversion

    Does SAGE 100 have Canadian/USD conversion (have an A/R in Canadian dollars for Canadian customers and an A/R in USD for US customers)

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

  • Item Maintenance, Orders tab, Sales Order... click to sort by date: does not work properly

    Customer complained with v2021.2 Advanced.  Verified in v2022.1 Standard with ABC data.

    In the above example, sorted by the Promise Date column, the 2nd line should be listed first... but the order list seems to be sorted by day of the month (not properly…

  • Closing work orders

    We just created our work order template in our new company. We were able to get the work orders placed and printing but when we tried to close the work order we got an error, Logical end of  record reached. How do we fix this?

  • Customer Pricing/Item Pricing

    In our current system, we assign an alphanumeric price level/discount to each customer.  Each item also has the same alphanumeric price level

    A = no discount

    B = 25% discount

    C= 30% discount

    D = 20% discount

    E = 15% discount

    We would like to add another…

  • Sales order ship date

    On a sales order if Quote is selected the Expire date is automatically changes to 30 days later - great

    is there a way to make the ship date automatically default to two weeks later then the order date when a Standard order is selected?  If so where would…

  • Sage 100c 2021.2 - Production Management -> Mobility -> Manufacturing EZ Import

    How is this EZ Import UI launched from CLI / task scheduler instead of having to run an instance of SAGE to access the command and locking the desktop?

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

  • Multiple Boxes for One Item

    We have a user that has an inventory item that comes in three boxes.  When they print a Pick Sheet they want to be able to show the three boxes on the sheet so that the Picker doesn't accidentally only ship one box.   We were thinking of using Inventory…

  • Not able to add G/L account in Purchase Order


    I am trying to create purchase order in sage100c v2021 using PO script but getting error "G/L account is required" while adding item line
    this is my script in c# and i am referring the table "PO_PurchaseOrder_bus" for PO fields


  • Warehouse option is not showing in sage100c while creating SO/SI


    I am using sage100c 2021 version and i want to add location in SO/SI but i am not able find an option

    i tried to search on this but didn't get any solution

    So anyone can suggest me how we can add warehouse option SO/SI?

    Thank You

  • Error #65 Window element does not exist or already exists CI_AuditTracking.pvc

    We just upgraded to Sage 100 2021 from 4.3.  2 users were receiving error when trying to update inventory items in Inventory module/item maintenance. Reset panels, no customized panels. This fixed the error for 1 user but not the other. The inventory item…

  • Phantom part numbers

    Is there a way to take a inventory part number and convert it to a phantom part number?

  • Next Automatic RMA Number


    A user's "Next" button when creating RMA's doesn't do anything.   Security is correct - was copied from a user for which this is working There are no scripts.     

    Any suggestions on where to look for the cause?

    Thank you

  • Item Maintenance - History tab decimals

    I have a client that just upgraded from 2018 to 2021.

    In 2018, the Item Maintenance - History tab shows quantities with no decimals.

    In 2021, the same screen shows quantities with 4 decimals which makes it difficult to view the actual numbers.

    Does anyone…

  • Can users be prevented from creating "On The Fly" units of measure in Item Maintenance?

    For example, we have "EA"  setup in our Units Of Measure Conversion Maintenance and the users should be selecting it from the UOM lookup but that doesn't always happen.

    Over the years, inventory managers at different locations have entered…

  • Inventory search by product line

    why can I not lock that and scroll through the list from item to item but just the one product line?

  • Sales Order not printing at one workstation

    Good afternoon. We are using Sage 100 Advanced 2018 (Version and on yesterday our Sage partner installed a new computer for our billing clerk.  Today we cannot get the sales order module to print orders when we click on the "Print Order" button…

  • Landed Cost Not Allocating to All Items on a Receipt

    We did a goods receipt and entered freight via landed cost.  However, the entire amount of the freight was allocated to only one of the 3 items on the receipt.  We are set up to allocate based on weight.  All three items have a weight set up in the item…