• work ticket printing

    current work ticket printing includes header for each step. would like all the steps under one header. attach files?
  • batch report creation

    Hi There, Is there a way to run a batch file to change all items entered into inventory with a none reorder method to reorderpoint? Thanks in advance, \\shane\
  • Invetory Labels - Extended Description

    I am trying to add the extended item description to the inventory labels. I am at a loss. I've added the CI_ExtendedDescription in the Database Expert and added the field to the report - but when I try to print the labels, they are blank. I'm not that…
  • 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…
  • SalesOrder Picking Sheet Denied Access

    Hello Everyone, Our CS dept have been reporting to use that they are receiving a popup message in SAGE when try to print a pick sheet from the Sales Order module. Please see below. I can't figure out what could be causing this. I have checked permissions…
  • Order Total Showing up on Last 2 Pages of Purchase Order Form

    When printing a Purchase Order with multiple pages, it will print the order total (which is in page footer b) for the last 2 pages. It usually only happens when there is 1 line item or part of a line item on the second page. Right now under Suppress…
  • Bug re default forms if perpetual - Any movement on this?

    Solution ID: 111860 dated 8/24 - would love to see a hot fix on this SOON......
  • 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…
  • 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…
  • Crystal Graph Sales History by Period

    I am working on a Crystal Report that shows a grid with sales history and would like to graph the history by sales period. For instance showing each period in 2018 as blue, 2019 as red, 2020 as green. So you will see each year clearly in each period.…
  • Costed Bill of materials report missing components

    When running the Costed Bill of Materials Report some items will print displaying all components. Others do not. Bills are all setup as Standard. BOM Options: Maximum number of levels is 10, but these are not levels, just components listed in the lines…
  • Work Order Traveler Printing Permissions

    I have a role that only prints blank work orders when ever WOT printing is processed. Header detail of the crystal report appears but all fields and details are blank. Im holding the Role Maintenance of a working role side by side with the non-working…
  • Reports

    We are trying to find an easier way to show what is on hand for a costed bill of material inquiry. The report obviously shows what the components are but we want to show the quanitityy of those components on hand. I tried checking all the reports that…
  • 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…
  • 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…
  • Crystal 2016: GS1-128 Symbology: FNC1

    Hello, I'm working on creating a barcode that needs to meet USPS requirements. Currently the formula I am using is: BarcodeUCC128("420" & "56901" & "92" & mid({SO_InvoiceHeader.UDF_TC_USER_8},3,24)) The font for the barcode Code128. …
  • Crystal Report Data from IM

    Trying to get a very simple report from IM. Item Number, Reorder Point, Quantity Sold YTD and PY along with a calculated field. The Reorder Point prints fine as do other fields such as Quantity On Hand and Quantity on Sales Order but I get nothing…
  • 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…
  • Set items to not print (show up) on SO, Invoice, Pick, and Packing Lists

    We want to know if there is a way to set certain line items in an sales order to not print on any forms. We want to do this to track packaging materials used to fullfill an order. We clearly do not want to have the packing used to show up on invoices…
  • SO Batch Description

    I'm creating a Crystal Report to show the invoices in SO Invoice Data entry by batch. I want to include the Batch Name/Description in the report, but I can't find the correct table that includes that information. I know it's probably obvious but I can…
  • Select Purchase Orders to Print by Purchase Order Date

    I'm looking for a way to delimit the purchase orders that print by Purchase Order date using something like a selection criteria & parameter. I thought a selection & parameter in Crystal on the Purchase Order Date would work, but it doesn't. Any ideas…
  • Picking Sheet using Exploded BOM with Exploded BOM Option

    I am trying to find a way of making a custom report in Crystal that I can use as a picking sheet. It needs to have the BOM for the Item exploded and the Option BOM exploded. I have found a few posts that were close but they had no resolutions. Any advice…
  • Editing Work Order Module Reports

    I am trying to find the RPT file to edit for my Operation Code Listing that I am accessing through Work Order>Setup>Operation Code Maintenance>Click on printer icon. I have had mixed luck being able to edit the reports from the work order module, some…
  • Historical Quantity On Hand for reporting purposes

    I am attempting to write a report that needs to list the on hand qty of an inventory item for a given closed period. The same information you see in the History tab of Item Maintenance/Inquiry. I need to be able to look back at period 1 of this year for…
  • PO Number Scans Prepended with a 'G'

    We have a client that is using Scanco scanners. We added the PurchaseOrderNo to a custom form code and assigned the Azalea Code128Wide font to the field. When the client scans the field, the PurchaseOrderNo is prepended with a G and the last character…