x Want to participate? Join the group to interact

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

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

  • Identify Back Oder Sales Orders in SO_SalesOrderHistoryHeader table

    Hello, We are trying to run some basic metrics surrounding Back Ordered Sales Orders, i.e. "How many Sales Orders had back ordered items last month". Problem is, I can't seem to find any data fields in the SO_SalesOrderHistoryHeader table that would…

  • Open Purchase Order Report - Backorders

    When the Open Purchase Order Report is run, the report shows backorders on lines that have future dates. This occurs on multiple line PO's with deliveries over a period of time. The required quantity shows up as a backordered quantity even though it has…

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

  • Customs reports in sales, back orders happen last year.

    Hello I have Sage 100 version 5.008.0 I am looking for a report that could shows me many back orders were produced last year. I want to improve my inventory and I was trying to see what products cause my back orders. and how many times a year. is…

*Community Hub is the new name for Sage City