• 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…
  • Supressed Entries leave large blank spaces on Picking Sheets after Sage 2021 update

    Ever since we update to Sage 2021, the suppression in on our forms doesn't work correctly. It will leave large blank areas for al the supressed values. Supress blank sections is already selected in the group and details. It was working perfectly before…
  • Adding a button to Sales Order Entry to print a specific picking sheet form type

    We have different types of picking sheets that we use and print multiple types per sales order. Everyone always forgets to change the form code so we waste a ton of paper. Is there a way to add another button to the Sales Order Entry page to open up a…
  • Surpress Blank Space when inserting images using OLE objects onto Picking Sheets

    I figured out how to add images to our picking sheets, but not all items have images and those that don't leave a huge blank space where the image is supposed to be. Is there a way to "collapse" this space if there is no image associated with the product…
  • Adding Form Codes to Picking Sheet Printing

    I am modifying our picking sheet and want to save a "test" version. When I am in Crystal Reports and I go to "Save As", I create a new folder in the "SO_PICKINGSHEETPRINTING" Folder. It doesn't show up as a form code when we go to print a picking sheet…
  • Picking Sheet Printing - pritning orders that contain a specific item

    I'd like to edit the Picking Sheet printing Crystal report to only print orders containing a specific item. So if it contains that item, it prints a picking sheet with that item and any additional items ordered. Does anyone have a formula for that?…
  • Crystal Reports - Sales Order Picking Sheet - Adding User Name Generates Blank Pick Sheet

    Hello, I'm trying to modify my picking sheet so it shows which Sage user created the sales order. I'm using Sage 100 ERP 2013 and Crystal Reports 2011. I have "SO_SalesOrderDefaults" added in Crystal Reports under Database Fields, but when I add …
  • 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…
  • SAGE 100 : Picking Sheet: Multi-Bin - Scanco

    We recently turned on Scanco Multi-Bin in SAGE 100. Sales Order -> Picking Sheet Printing allows the ability to add a Form Code MB_Rows and select Multi Bin Rows picking sheet. This works fine. My question is how do I ability to print that .rpt…
  • Warehouse Transfer and Picking Sheets

    Is there really no other way to transfer inventory from one warehouse to the other than by using the transaction entry utility? Our issue is that we need a "picking sheet" or some form that has the bin locations to help workers pick the necessary items…
  • Picking Sheet Item Ordering when Kits are exploded

    We have an issue where when we have kits exploded, the picking sheets (which are sorted by bin location) will seperate the kit item code and then the kit components all over the picking sheet. This is very confusing. Is there anyway to have the picking…
  • Adding a "Reprint" flag to pick sheets

    Hi all, We're looking for ways to better manage/track pick tickets in the warehouse and we'd like to tweak the form a little bit too.... The SO_SalesOrderHeader.PickSheetPrinted flag is set to " Y " after the initial printing of the pick ticket. …
  • Get Credit Card Authorization No into Picking Sheet report (SO_PickingSheetWrk)

    Hello We are planning our upgrade from MAS 200 to Sage 100 and our Crystal Report for the Picking sheet used to print out the CreditCardAuthorizationNo but that data is now in a new table called SO_SalesOrderPayment. I looked into the Custom Office…
  • Picking Sheet Printing

    Was wondering if there was a way to add ShipVia to the selection (Select Field) when entering a range of sales orders in Picking Sheet Printing i have an order range, and some of the orders are say FedEx and some UPS. I would like to enter the Order…
  • Running a script when a field changes

    I have a UDF that tracks the sum of the Quantity Shipped, I would like to reset the picking sheet print flags when this field changes... My current script is: sPPS = "Y" sPSP = "N" retval = obusobj.setvalue("PrintPickingSheets$",sPPS) retval = obusobj…
  • How to show all warehouses on a single picking sheet

    We currently have 1 warehouse were told that we could use different warehouse codes for multiple bins instead of using the multi-bin enhancement. This works well, but when we print the picking sheets it separates it by warehouse code. So if we have 3…