x Want to participate? Join the group to interact

  • Print Copies of Picking List According to Item Quantity Per Order

    Hello everyone, I created a picking sheet form to print out as a thermal label customized to a merchant's specification. The label has two unsuppressed sections (rest suppressed), Group Header SO_SalesHeader.SalesOrderNo and the Group Footer. The Group…

  • Can I combine data from SAGE 100 Job Cost's JobTransactionDetail table and data from Job Cost's JobHistory TransDetail table on the same Crystal Report?

    I would like to combine data from SAGE 100 Job Cost's JobTransactionDetail table and Job Cost's JobHistoryTransDetail table on the same Crystal Report. I need to create a summary report that includes data from both tables. I'm hoping that someone has…

  • Business Insights Explore

    In Business Insights Explore, is there a way for me to have the Data Field information and the Preview Field information on the same report? I've got all my fields the way I want them, but I don't want to just see the Invoice History, I want to see the…

  • SO Picking Sheet Formula Syntax to display {SO_PickingSheetWrk.QuantityBackOrdered}

    Been awhile since I've worked with Crystal and have what should be a simple formula. The Qty BO Column on the SO Picking Sheet just prints an Underscore. I'm trying to get it to print the Qty BO if not equal zero and a blank if equal zero. Keep…

  • How to add the Dollar Symbol to fields in custom Crystal Report

    I would like to add the $ to the beginning of sales numbers in a custom Crystal Report, however I can't seem to locate a place to add it when in Cyrstal Reports.

  • Modify report name on AR Custom Reports menu

    Is it possible to modify the name of a report that was added to our AR Custom Reports menu?

  • Custom Check History Payroll Report

    Can anyone tell me where I can find step by step directions on creating a custom check history payroll report? We have 3 departments and within the departments employee work within department numbers. I can print the payroll check history report and break…

  • AR Statements - Add "Days Delinquent"

    I really like the presentation of "Days Delinquent" on the AR Aged Invoice Report and would like to do the same on the AR Statements. My problem is trying to find a good field that equals the "Statement Date" (with cut-off ability). What I've done so…

  • Sage 100 Advanced 2018 Purchase Order customization to consolidate items after generating POs from SOs

    I need to be able to consolidate inventory items on the printed purchase order after generating multiple Purchase Orders from multiple Sales Orders. The system can consolidate the vendor POs automatically by selecting it in the PO setup options but it…

  • Creating a custom report incorporating Customer Maintenance and Item Maintenance info

    Hello, I am trying to create a custom report that would show customer details relating to items sold. I am looking to include: Customer Name and associated purchase history of a given item #, item description, standard cost, standard price,…

*Community Hub is the new name for Sage City