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

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

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

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

  • Get Value of Items in each Box using Shipping Data Entry When Shipment has multiple boxes

    Is there a way to get Sage 100 to Display the Value of the Items in each box when doing Shipping Date Entry? This would be for internal processing only. 

    We're able to print out a packing list per box and indicate its contents, but we still need to manually…

  • fundamental difference between open and backorders

    What is the fundamental logic difference MAS uses when entering line items to sales order that exceed available quantity?

    To be clear, suppose you're entering a sales order line item that has an available quantity of 5. If you enter quantity 6, you are…

  • Creating Job Cost record on the fly from Sales Order

    After Job Cost was updated to the Business Objects Interface Sage confirms but has not corrected two major problems (for us). When Sales Order is integrated with Job Cost there is the ability to create a new job from Sales Order Entry. When entering the…

  • File SO_OpenOrderWrk - Field QuantityOnHand

    Where does the QuantityOnHand value come from in the SO_OpenOrderWrk file? The field value is always zero when I try to use it in an Open Order Report. I would like to pull the QuantityOnHand from the IM_ItemWarehouse file based upon the WarehouseCode…

  • Attach PDF to Sales Order

    Has anyone found a way, including third-party enhancements, to attach and print a document associated with a sales order. We have a customer that wants to print a document with shipping instructions after the sales order prints.

    Any help is greatly appreciated…

  • delete

  • Item Maintenance Tab Orders Count

    Hello, 

    I am trying to come up with a counter for the number of orders (Standard or Backorders) that an item is on. So far I have tried a script that counts the line inside of SO_SalesOrderDetail but it won't write to the two UDFs made in CI_ITEM. Has…