• Crystal Reports: Adding a UDF for each Item Number on a Picking Ticket.

    OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing.

    I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…

  • Looking to Customize Customer Statements Sage 100 2019

    I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

  • When trying to link item memo with purchase order wrk as soon as I link the tables and try to run the report i get The database login failed.

    I am on Sage 100, 2020, Premium (SQL) version 6.20.0.1

    I have customized the Purchase Order report and it works fine from purchase order printing until in crysal reports I link the inventory memo table to the purchase order wrks table.  As soon as I do…

  • Adding AP Check Forms to Multiple Companies

    I entered AP Payment Processing in Company "A," created a new Form Code, and used Designer to create a new custom Check. I have 10 other companies and would like to copy the custom Check to all of those companies. I think I'm supposed to use Report Manager…

  • Custom Crystal Report is showing multiple transactions for each customer

    Hello. I have created a custom Crystal report showing sales by Salesperson code. I realize there is a "standard" report in Sage already, but our director is wanting one that exports to a clean Excel format. A couple of issues...

    1. The custom…

  • 1.Instructions on how to create a label (4x6) in sage 100?

    1. Instructions on how to create a label (4x6)

     

    The two modules we could start to use this feature is in:

    1. Sales Order\Main\Shipping Label Printing

    2. Purchase Order\Main\Receipt of Goods Entry

  • Repeating Pages on Crystal Reports for Label Printing

    I am attempting to move some of our label printing to crystal reports. I can successfully print labels but, is there a way in Crystal Reports to have a group section repeat X amount of times based on an equation? For example, lets say I have 1 line item…

  • Paperless Office Output Different than Printed Invoice

    We are planning on beginning to email invoices and I have been testing this in a test company code. I have an invoice form that I have modified that we have been using without issue, when I print the form it looks perfectly fine. Some of the sections…

  • Printing User ID on Reports

    Is there a way to print the user ID of the person who printed a report on a report? We have a customer service team who prints all of the picking sheets for our different warehouses, occasionally mistakes are made and it would be very helpful if we could…