• 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…
  • 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 stock…
  • 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…
  • Open PO Report

    I run an open PO report each week. My problem is that it shows PO's that items have been received but just not invoiced. For example, the part shows ordered and received but because it hasn't been invoiced yet, the PO is still open. I am okay with that…
  • 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…
  • 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…
  • Job Profitability Reporting

    Using 2013 ERP 100 Advanced SP 4 . We're in the Job Service Industry (we repair Balers, compactors, etc). We are trying to do a dashboard/report where we can tie in PO's and SO's together. We will issue PO's to 3rd party contractors to actually…