• Crystal Report - Text not visible

    I am working customizing Quote Forms using crystal reports and we have a standard text on each specific quote. This standard text will not show up on the sage preview. It is like somewhere in the report its blocking a view in some of the groups. Any Ideas…
  • HOLD button in sales order entry

    We are trying to get our receivables under control and our IT department has helped so that our customers now go on automatic credit hold when they have invoices in 120 days. In our system, when a salesman attempts to open a sales order and the customer…
  • 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…
  • 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…
  • Item Bundles??

    Hi. we are currently on Sage100 Advanced 2021. We are a drop shipper which normally only sells the items it receives from overseas in the same box it is received in. We are looking at grouping items as bundles and trying to sell as a collection. …
  • Button Script to delete Sales order with cancel code

    Hello all, I wrote a script with the goal to delete sales orders with a specific condition. So I can delete sales orders just fine its just that when the orders are deleted the cancel reason code is not flowing to history it is staying blank. I am…
  • Phanton Users Sage 100 2019

    Hey All, Just received our upgrade from Mas90 4.3 to Sage 100 2019 a couple of weeks ago! Woohoo. One thing I'm trying to sort out is how to eradicate Phantom Users. I'll explain: We are having trouble fixing some valuations in Sales Order Entry…
  • Invoice Batching – Can't Set the Cost Account Key

    When invoicing RMA's, we use logic in a custom script to set the cost account key and the sales account key on the line items based on based on the customer division. When I go to the newly created invoice, the sales account key has the correct value…
  • Auto send email on entering / invoicing orders

    Is there any ways to enable Sage 100 auto send email notification to a certain group of recipients upon SO is entered / invoiced? I assume this has to involve scripting, right? Thanks, Haibo
  • SO Invoice Entry - Default qty ordered and shipped to 1

    I want to have all SO Invoice lines default to an order quantity of 1 and a ship quantity of 1 (currently the default is zero). This is Sage 100 2019. I wrote the following script and attached it as a post-validation event to the Item Code column, but…
  • 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…
  • Can't Add New Product Codes in Item Maintenance

    When we enter a new item code into "Item Maintenance," it used to create a new product in the system. However now when we enter a new product code, everything goes blank, but it says "NEW" right by the Description (as it would do before). Everything else…
  • Work Order creating additional steps such as 100-B-500 etc.

    Good morning. I have created some routings which have 5 key steps to them for 5 key phases of manufacture to improve visibility. I have made these steps standardized across routings. The step numbers are set off by 100s so there is a step 0100, 0200…
  • High Margin Warning

    Hello All, Current Sage 100 user V2018 6.00.4.0 Looking to see if anyone has found a way to initiate/trigger a warning when profit margin is too high? Reason I'm asking is because a salesman mistakenly sold items at 16.50 instead of 00.165 on an…
  • Profit Margin Display with set price for Customer

    Hi Guys We have our "Profit Margin Percent Display Warning" set to 15% on Sales order options but we have some customers who have items set to under 15% and when we add these items to a sales order we don't get an alert. Anyone know why this is and…
  • Purchase Order field in Sales Order Entry

    Hello all, I know that the "PO Number" field within Sales Order Entry is used for Auto-generating PO's from Sales Orders and creating drop ship PO's from a Sales Order, but I wanted to know if it has any other purpose? I wanted to use this field for…
  • Close Master Sales Order when Quantity is 0

    When the full quantity of an item is released from a Master Sales order, is there a way to have these master order deleted or completed? I know there is an expiration date, but customers release quantities in different time frames. I can not "standardize…
  • Seeing quantities on "ghost" sales orders after Make to Stock Closing Entry

    We are seeing a very strange thing happening in regard to our Manufacturing module. W/T Templates are being set up correct, in regard to scaling, but when we are completing our Make to Stock Closing entry, we are ending up with inventory showing quantities…
  • How to prevent a SO from being invoiced with negative quantities because the PO hasn't been received

    The Subject pretty much sums it up. We create a SO with a BO, we order the product. The product arrives but the PO isn't always received into Sage 100c before the SO is invoiced. Is there a setting that won't allow the SO to be invoiced or to prevent…
  • Unique Customer Pricing

    Hello, We have a handful of customer's that receive reduced pricing on a number of items, and we are currently using overrides to ensure that they get their discounted price. This is obviously a pain and is error prone, so I am trying to set up pricing…
  • Receiving "Drop Ship" PO to offset SO?

    FormerMember
    FormerMember
    I recently found the DROP SHIP PO and it is applicable in our business. However, we still recieve all PO's into our "inventory" which is then offset by a Sales Order. Once we invoice it then it is removed from inventory. We are unable to receive DROP…
  • Black out Dates

    Does sage have the ability to prevent shipping on certain dates like Christmas or plant closures?
  • Sales Order weight calculation?

    We have never used the automatic freight calculation before, but I'm testing it out. I have an item number set up as weight = 2. When I have qty 1 on my SO, the Ship Weight comes out to "00010", and if I change the qty to 20, the Ship Weight comes out…
  • Electronic Delivery Message Maintenance - Message not sending with emails

    FormerMember
    FormerMember
    So we finally set up our email feature and after some tweaking emails now send perfectly fine to our customers. Our issue is that in the EDMM module where we create a default email message, even though a message is saved when we send electronic invoices…