x Want to participate? Join the group to interact

  • Is there a way to build a Purchase Order Report to include the "Ship to" name?

    We need to retrieve Purchase Order details to include the PO # and "Ship to" name. Can this be done with canned reports in Sage 300? My searches have come up empty. We have intelligence but not Connector. The Purchases Master report doesn't appear to…

  • Is there any easy way to show the currency used on a purchase order

    I have a client entering purchase orders in different currencies, but when I print the purchase order, it does not display the currency being used on the order. Is there a simple way to add that information to an order?

  • Commitment Count - Total & Unique

    Is there a canned report (or a canned report that would require minimal manipulation) to determine the total count of commitments that were issued in any/all jobs over a given period of time? We're trying to determine: 1) How many commitments were…

  • Macro to print/save Open G/L batches at month end

    I'm trying to create a macro to print/save all my open G/L batches at the end of each month. I want the file name for each batch to be the G/L batch description and batch number. I'm having a problem getting the file name right - I'm not including the…

  • Formulas to pull out First name & Middle Initial separately

    I am looking for a formula (in Report Designer) to pull out the first name & another to pull out the middle initial. I know it's fairly easy to do in Crystal. However, I'm trying to avoid completely re-writing this report. Any & all help is greatly…

  • Reprint Purchase Order and Receiving Slips

    Hi, How do I reprint a completed Purchase Order (PO)? Every time I try to reprint PO from module Purchase Orders -> P/O Forms -> Purchase Orders, I get a blank page. I opened the .rpt from crystal report, the database is POPORN which is not an existing…

  • EXTRECEIVE field in table POPORH1

    EXTRECEIVE field in table POPORH1 - anyone know what the value actually represents? i am trying to find the value of accumulated receipts against a particular purchase order which I thought might be this field but sometimes the field contains a value…

  • Inserting a running total from a Formula field to OE Invoice report

    To all Sage300 Report and/or Crystal Report gurus: I have an item optional field that holds a number value that I need to use to compute a quantity for each line item for which I need a running total in the footer in the OE invoice report (OEINV01.rpt…

  • where did 'the report store' go?

    I'm looking for a canned Bill of Lading report and thought I'd try the report store folks. Not showing up any longer. Does anyone know where they went?

  • GL Trial balance

    Hi, Is there a way to print the GL trial balance as at a particular date in Sage 6.0.

*Community Hub is the new name for Sage City