• Inventory transfer form out of MAS

    Has anyone ever created an inventory transfer form that can be generated out of MAS that a shipping department can complete. I am looking for a picking sheet type of form but the item is simply being transferred from one warehouse to another (therefore…
  • Product Line in Open Sales Order Report

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

    We have a ton of components that are set to INACTIVE, that still show up on the WHERE-USED Inquiry lookup and the WHERE-USED Report. How can we get them to not show up? We tested an item and set it to Discontinued and set it to Inactive but it still shows…
  • ROG - Answering Yes to "Do you want to receive the complete purchase order?" blanks out Item Code with UDFs

    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…
  • Custom Office for Work Ticket Templates

    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…
  • Match BOM Production Entry Line Sequence to BOM Maintenance detail line entry

    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…
  • Ability to set minimum order quantities (MOQ) by vendor for items.

    Does Sage 100 (v. 2019) provide a method for specifying minimum order quantities by vendor for inventory items? We know how to set minimum order quantities for an item at the warehouse level using "Reorder Maintenance," but we have not found a facility…
  • Can I get a report that shows the date that inventory items were created?

    A customer wants to get a report of new inventory to publish on a web site and wants to know if he can get an inventory list by dates created?
  • Reports

    We are trying to find an easier way to show what is on hand for a costed bill of material inquiry. The report obviously shows what the components are but we want to show the quanitityy of those components on hand. I tried checking all the reports that…
  • Crystal report formula to show zero on base "im_transaction history" issued

    I was wondering if any one has done this type report I did a custom crystal report that i'm able to see specific item code, but for some reason when i'm running the report those item codes that doesn't have any transaction history is not showing and…
  • Sales/Customer item inquiry

    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…
  • Script to modify Sales Order detail unit cost

    Sage 2016 I have a client that has a User-defined Cost field that they used to use when they had an enhancement for converting Sales Orders to Purchase Orders. Since this is now included in the software, I need to modify the Unit Cost field in the…
  • Bin/Location on Inventory Transaction Screen

    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…
  • General Alias lookup for inventory

    We want to create a general alias for some of our raw material inventory items. I would like to create a custom lookup in inventory inquiry that will sort by the general alias number, how do I set that up? I can't seem to find the field for that when…