• Prevent a Customer from ordering a specific product

    Currently, we ship selected items to Canada but there has been a recent change with Canada FDA that we are now not allowed to ship selected products. Is there a way in Customer Maintenance module to not allow the selected items to be entered in the Sales…
  • Automatic Sales Order Entry

    What are the best options for getting automatic entries for new Sales Orders? Looking to integrate orders placed through online sales and have them directly entered into Sage. Currently on 2020, but looking to update.
  • Expanded Price Levels (DSD IMXL)

    I have an end user that is considering DSD's Expanded Price Levels enhancement. I am a little nervous adding an enhancement that will have such a large impact on Sage 100. Just wondering if anyone has any experience with this enhancement. If so, are you…
  • Retainage

    Good afternoon, I need help coming up with a way to correctly track Retainage and if Sage 100 can do so? Retainage is sitting in our A/R and skewing our A/R Turnover numbers. Is there a way to invoice retainage separately or track separately? Any help…
  • Sales order entry - unit price goes down to 0$ after changing quantity

    Unit price drops down to 0 when changing the quantity of "ordered" on the same line item. Is this normal behavior, or was this intentionally implemented at some point? Can anyone point me in the direction of an article to reverse this? Thanks!
  • Duplicate SO (PO's) being imported via True Commerce EDI in Citrix environment

    Upgraded from Sage 100c Advanced v2019.2 to v2022.1 on new Win2022 ERP server and separate Win2019 Citrix server. When we import EDI PO's from True Commerce Transaction Manager v2 integration into Sage 100 which become SO, of course, we get duplicate…
  • Sales Order - Stock Status on Sales Order Quantity and Sales Order by Item Report Quantity are Different

    For one item / warehouse (that we know of so far), the On Sales Order quantity listed on the Stock Status report and the quantity on the Open Sales Order Report by Item report do not match. Actually a difference of 4300. Can't seem to find a reason. I…
  • 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…
  • 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…
  • Tracking Deleted Sales Order w/SKU detail

    We have numerous SKUs with a reorder point of 0 and most are treated as special order product. We often find that special ordered material arrives from the vendor only to find out the customer cancelled, the SO was deleted and no way to look back at transaction…
  • Void credit card authorization on sales order

    Several versions ago we were able to void a credit card authorization on a sales order but haven't been able to get it to work on Sage100cloud Advanced 2019 Version 6.10.2.0. We are using Paya. I have confirmed that the Library Master, Security settings…
  • generating a PO from a sales order

    I would like to know if it is possible to only create Po's from a sales order for items we don't have in inventory? If I create a sales order that has lets say three items two that I can pull from our inventory and one that I don't have any in stock…
  • Automatically print backorder pick tickets?

    With raw materials and shortages we have found that we are shipping more shipments leaving a backorder in our system than ever before. Historically, shipping would go in and print a new ticket with the backorder and keep it until it could be filled. Our…
  • 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…
  • Shipping data entry sending items in multiple packages with packing list for each package

    We have a client who has a customer who wants a packing list for the items that are in each box shipped for the order and not the whole order on the packing list. Does anyone have a similar issue?
  • Sales UOM Pricing - SO using the Standard UOM

    We have some items where the Sales UOM is EACH and standard is KG. When adding these items to a sales order, the sales quantity shows as EACH however the price is coming over as the standard price x the KGs per EACH. This only occurs for a handful of…
  • 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,…
  • Bug re default forms if perpetual - Any movement on this?

    Solution ID: 111860 dated 8/24 - would love to see a hot fix on this SOON......
  • 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…
  • 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…
  • Order Total on Sales Order Totals Tab is Zero

    We are running 2019 100c Advanced. From time to time when entering a new SO the Order Total on the Totals tab is zero, while the total on the Lines tab is correct. Oddly, the system allows the SO to be saved in this condition! To correct the imbalance…
  • How do I split incoming EDI sales orders into appropriate warehouses while also considering stock status?

    I am currently using Sage 100 and Trucommerce Transaction Manager. Our current setup is incomplete. Transaction Manager sees what state the sales order is shipping to and then assigns the appropriate warehouse code so that the order will ship from the…
  • SAGE100 Premium VS. 2020 HEADLESS ORDERS !!

    A SAGE100 Premium VS. 2020 has occasional missing S/O order header records. The order lines are still there. The order is completely there in order history. The order has NOT been invoiced. Anyone seen this?
  • Extension Amount on System-Generated, Partially Shipped Backorder Lines, is Incorrectly calculated on Order Qty not Backorder Qty

    Most but not all Backorder lines are incorrectly calculated based on the Order Qty but should be Backorder Qty. As a test, I copied the Live company into a test company at the end of our shipping day just before running Daily Sales Reports and Updates…
  • How to turn off message about printing invoices when posting Sales Journal?

    We just upgraded from 2017 to 2019 Sage 100cloud. Now when we post invoices using S/O Daily Sales Reports and Updates, we get a message "Not all invoices have been printed". We didn't use to get that. I poured over Role Maintenance and S/O settings…