Sage 100

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…

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…

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…

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…

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…

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

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…

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…

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…

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

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

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…

Does sage have the ability to prevent shipping on certain dates like Christmas or plant closures?

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…

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…