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…

  • Table for "Promoted to Order On", VI and Making Excel Reports

    I am trying to make an excel sheet (ideally a custom report), which shows the amount we invoiced every day, and the amount that was promoted from quote to sales order every day. Grouped bar graphs is what I'm trying to achieve. I figure the easiest…

  • Custom Report Printing

    Apologies if this is not the correct category. From time to time we receive the following error when attempting to do custom report printing. The temp file is there. The only fix seems to be rebooting the server and deleting the file. Sage 100 will then…

  • Is is possible to add folds under the Custom Reports menus?

    We have 10 active Company Codes. Each one has a set of core sales reports that are exactly the same except they pull the sales reps, customers & products from the specific company code. Due do performance issues I can't use dynamic parameters in the CR…

  • New to Sage 100, need to customize some defaults and to access Crystal Reports

    I won't go into great detail but I am not getting the training I need from my employer and joined here to find answers to questions that I should be able to find myself in a normal working environment. I would like to fix the alignment for check printing…

  • add a selection to customer sales history report

    I would like to add some fields to the selections for the SO Customer Sales History report. It has been a while since I've done this and don't remember where to do this. I am looking to add Division, Country, State. Thanks for any help.

  • PO Options - Days to Retain Completed PO's

    Hi, I was trying to write a crystal report, where it would show all PO's open or closed, and allow the user to enter a PO date range and item number and then get detail list of all PO's open or closed for that item that included qty and dollars. it…

  • Custom Report - set default printer

    I have a custom crystal report to print labels out of MAS. I want to set a different printer as default just for this report. I believe that any custom report should save the printing information from the last time it was printed. But in this case it…

  • Bill Revision Number Blank in Copied Sales Order

    We have a custom Crystal Reports sales order form which prints the bill of materials option category descriptions for each line item - which is pulled from the BM_BillOptionCategory table. In order to grab this information, I need to link the SO_SalesOrderWrk…

*Community Hub is the new name for Sage City