Sage 100

As I slowly work my way through customizing our Sage 100 Advance instance, Sage City has been the greatest resource! Thank you all! I am working with the Open Sales Order Report now and stuck on suppressing some items in the report. The end goal…

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…

I have 20+ UDFs in ROG entry and they have been working fine over the past 2 years. Now managers want some of these UDF to be required. When I mark just 1 or several or all of the UDFs in ROG as Required, no Item code appears when I select 'Yes' to "Do…

Just discovering the power of Custom Office (I'm a newb). I am running into a wall with one particular item. I have worked my way through creating user defined fields and tables and can successfully customize panels in screens and modules, but I'm stuck…

We are on Sage 100c 2019 and I'm trying to find out a way, that when BOM Production Entry is launched and we go to the lines tab, that the line sequence is NOT alphabetical/numeric ascending (which appears to be the default), but based on the way the…

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…

I need the Cancel Reason Description to appear on Open S/O report. I added using Database Expert I added SO_CancelReasonCode database. Put the field into the repport. Not the report ONLY displays S/O that are = HOLD and shows the Cancel Reason. If I remove…

We are trying to figure out a way to make and print packing lists per box, as opposed to printing one packing list for the full order and placing it one of the boxes. How is this done with Sage100 Standard? We want our customers to know the contents…

We were told that Sage 100c could customize an item inquiry for Sales staff: Here's what the sales department is asking for: They want to inquiry on a part number to find out which customers purchased that part and for how much. They problem is…

Is there a way to have a Miscellaneous Item automatically appear on Sales Orders for specific customers. We want to use a Miscellaneous Item "charge" for our online retailers, sort of like a drop ship fee. If not what would the best route be? We want…

We need to track the DPAS (Defense Priorities and Allocations System) Ratings that are entered on Sales Orders and flow this information through to WO's that are generated from SO's, any PO's that are tied to SO's and onto any pack lists, invoice etc…

Hi, If I have UDFs in the SO Header and use the copy from SO feature in SO to create a new Sales Order, should the UDF values copy over as well? In the v2016 and v2017 installs I tested, these fields don't come over. But I think I read on here that…

HI, I would like to add bin/location to the inventory transaction screen to provide a one step solution for moving inventory from one warehouse to another. The fields are not available in customizer for me to add and I was wondering if anyone else has…

We're using MAS 200 4.4 (still). In any of the newer versions, does MAS display a running total of the items ordered in the SO Item Entry Panel? If there isn't one, any tips on how to create this using Custom Office? We get frequent orders where a customer…

We'd like the ability to track changes in sales orders such as when it changes from Quote > Order, line item additions/deletions and quantity changes, status changes (on/off hold), etc. I looked into Business Alerts and Sage Alerts but don't know if these…