• 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…
  • How can I add 'applies to invoice #' in Crystal Reports for customer credits?

    We had our system put in about a month ago(Sage 100 2021). When I go to make a customer credit in the Sales Order module, I can apply it to a specific invoice. But once I go to send the customer the credit, nowhere on the form is there a 'applies to invoice…
  • How to add Quantity Ordered and Back Order to Additional Packing List

    Is there a way to add the Quantity Ordered and Back Ordered fields from either the SO_InvoiceDetail or SO_PackingListWrk tables to the SO_AdditionalPackingListWrk table? I've tried creating an UDF via CM under SO Additional Picking List Work, but I…
  • Removing Extra Space on Form

    We're editing our picking form, but now when there is a comment on an item it will add a line of space before the next line item. Is there a way to get rid of this space? Is there a way to get rid of the extra space created when an item doesn't have a…
  • Purchase Order Form Prints Duplicate Lines

    We have products that we purchase from multiple vendors. We have the Vendor codes and descriptions set up as Vendor Alias' in Item maintenance. When we make a PO for a vendor and enter an item that has multiple Alias codes, it will actually print out…
  • Sage100 - Copy Custom AP Check Form to all company codes.

    I was trying to use Report Manager to copy the form from the company code that I created it in to all companies. It shows in the Report Manager and after I create the form code in the other company it is using the standard form. I have 250 companies that…
  • custom reports filter by time stamp

    Good morning, all! A couple of years ago I made a custom report that shows all our unpaid payables. I currently have one filter on it, the DateUpdated field, so I can narrow it down to a certain day(s). Since that is my only filter, I have to wait until…
  • Recurring Notes on purchase orders

    Is it possible to add a recurring note to the body of purchase orders? For example, to add company contact information if there is a question. We used to do this via the /C command on every order but I am sure there must be a more practical way to do…
  • Hide the payment information on the AR Statement

    My client does not want to show the payment and credit detail for each invoice on the AR Statement. He only wants to see a single line for the invoice and the balance owed for that invoice. How do I hide the payment detail in Crystal?
  • Sizing Micr Font on AP check form

    Does anyone use Wells Fargo Bank for Sage 100 check printing. They require a specific font layout size and spacing that we are unable to get. If anyone has a check form for Wells Fargo I would love to get the crystal file. Any other suggestions on fitting…
  • Can I print multiple forms when printing invoices from sales order?

    I have setup paperless office and it is working great, thank you all for your help. Is there anyway to also send the other forms requested by certain customers with the invoices such as the C of C's, BOL's or Packers? I'm not sure if there is a way to…
  • New Forms

    I did create a new form in sage 100, but how can I make it appear in the report setting list. I am using Sage 100 2013 V 5.008.00, ( We will upgrade soon the 2016) Thank you for your help. Joe
  • Crystal 11 Sales order form used as base for a Purchase order form

    Crystal VI, Sage 100 vs 4.5 I am recreating Crystal 10 reports from Mas90 vs. 4.3 up to the 4.5 for purchase order. I took a 4.5 sales order form and saved it over the new purchase order form. I wanted to preserve the layout and text areas of the…
  • Add a field to BOM Picking Sheet Crystal Report

    I am trying to add the Finished Product Bin Location to a Crystal Reports Picking Sheet form. Can anyone assist?
  • Change Company Logo on Invoice and PO forms

    I’m new to Sage 100. We’re running V 4.50.7.0. I am trying to find where I can change the logo on the invoices and PO’s. I’ve searched through Sage in “Setup”, “Paperless Office”, “AR” & “PO” and can’t find the forms anywhere. Can someone point this newby…