• Sales Journal update

    How do I stop a script from triggering during the Sales Journal update on the Sales Order header pre-write?
  • How to Stop "Do you want to print Sales Journal?" prompt from happening in my script?

    I have my script working to select invoice batches in S/O Invoice Printing. Once the batch is selected the invoices are electronically delivered. This all works fine. It needs to run unattended with no UI. How do I stop the Sales Journal prompt after…
  • Sales Order Invoice Printing with Batches Enabled

    Has anyone had any luck creating a BOI script to print and update invoices when batches are enabled? I keep getting a message stating that batching can't done in the current task. Here's a snippet of my code: retVal = oSS.nSetProgram(oSS.nLookupTask…
  • Printing a Crystal Report via Script without Previewing

    I am able to open and preview a report via scripting using the SY_ReportEngine. I need to streamline the experience for the end user and just print the report without Previewing it. I am Trying to use the Printout Method but can't get the syntax correct…
  • Script to print crystal report to designated printer

    Everything works on the script except for the line that calls for the print oRpt.Printout (I tried oRpt.Printout(FALSE) but then nothing happens at all) The line actually technically works, but instead of just printing the the default printer, the…
  • Does rebuild sort file affect Custom Report

    I try to run the Custom Report in inventory module as usual but it never comes out this time. The only thing I can think of is that consultant rebuilt the sort file for I/M earlier this month. Could this be the reason? and what can I do?
  • A Bizarre Crystal Phenomena with Grouping on DateUpdated

    I thought I had my head was on straight today. Maybe not. Below is a screen shot of a simple report of SO_SalesOrderHeader that is grouped by DateUpdated. The group header shows 8/21/2022, but the Date updated shows 8/22/2022. There are no suppressed…
  • Using BOI to print Quote

    Looking to use the BOI to retrieve a quote as a PDF. Can see topics here about generating sales orders as PDF's, example: https://www.sagecity.com/us/sage100_erp/f/sage-100-business-object-interface/159332/print-to-pdf-and-electronically-deliver-sales…
  • Found Crystal Reports uses Java Log4j too?

    Hi Forum, Will the patch work for the Crystal Repots Java Log4j too? Path : C:\Program Files (x86)\SAP BusinessObjects\SAP BusinessObjects Enterprise XI 4.0\java\lib\external\axis2\1.6.2\log4j-1.2.15.jar Installed version : 1.2.15 Fixed version…
  • Sage Paperless - Missing Credit Card Receipts Report

    Looking for a monthly report to run on previous month that will show missing receipts? The only report I can see regarding credit cards in Paperless is "AP Unattached Credit Card Receipts".
  • Sage 2014 button to call crystal report

    When I search the subject on the forum, there's too many fragmented responses. The goal is to run a Crystal report from the CI_it (Inventory Maint) panel. Hoping someone can share a bit of code that works on Sage 2014. Our Sage upgrade is around…
  • Invoice Report That Includes Main Invoice Customer PO and Comment

    Hello All, One of my Go-To sage reports is the Accounts Receivable Invoice Hist Report. My dilemma today is that I'm looking for info that is on the Main invoice and not line level detail. Here are two screen shots from the Invoice History Inquiry,…
  • Picking Sheet Printing: "Header plus Footer is too large for page" inconsistent error

    Hello all, So one of our employees is having an inconsistent but regular issue when printing and previewing the Picking Sheet in the Sales Order module. It's regular because it's been happening for days, however it's inconsistent because we can't reproduce…
  • Crystal Reports

    I am writing a report in Crystal used JC_JobBillingHistory. In SAGE 2017 this report used JC1???file and worked fine. In SAGE 2020 it will not give me the jobs if they have not had activity. I believe it has to do with the Fiscal Year and Fiscal Period…
  • Email customer invoices

    Is there a way email multiple customer invoices directly from sage?
  • AR_InvoiceHistoryPrinting with BOI

    Anyone ever done this? I have a list of non-consecutive historical invoices I need to export to a specified directory. I was going to use the 'QuickPrint' property before calling ProcessReport() for each necessary invoice, but I've only ever performed…
  • Accounts Payable

    Is there a way to print out a report that shows a list of Invoices paid to each individual Vendor?
  • unable to print ap_invoiceregister.rpt error in file ap_invoiceregister

    The knowledge base is down. Does anyone know why? Any ideas on this error message? Thanks, Michael
  • Covid Sick Leave Pay doesn't match on W2 box 14

    The amount of Covid Sick Leave Pay we paid employees does not match on the W2. The paycheck shows the actual amount paid to the employee, the quarterly tax report matches the final paycheck for 2020, but Box W2 shows a lesser amount. Should I correct…
  • Unable to print this report while a G/L update is in process

    I'm trying to run a report in one of my Sage companies and I'm getting the following error message "Unable to print this report while a G/L update is in process". I've been getting this error message for over one 24 hours. I also checked with my colleagues…
  • nProcessReport returns Nothing

    Hi, I have the code below for automatic registration/update of the inventory register transactions. In the nProcessReport part, my return is always Nothing. I'm encountering same issue on Sage 100 2018 and 2020 oSSRegister.nSetProgram(oSSRegister…
  • SO_ShippingHistoryReport_rpt - no results

    I'm trying to pull InvoiceNo's that shipped on a particular day. I'm using SO_ShippingHistoryReport_rpt but I'm not getting any results back for a day that has records. I need a fresh set of eyes and more experience to help me with what I'm missing…
  • Job Cost Module

    I have closed a job and also have printed my close out report and I am wondering if it is possible to re open the job?
  • Print to PDF and electronically deliver Sales Order via BOI

    I want to thank everyone in this forum in advance for the wealth of information you have posted and gathered here. With that information, I have been able to apply a script to automatically print Sales Orders once they are entered. The script below runs…
  • 1095-C

    Good Morning, Are we able to file 1095-C Corrections for 2018 and 2019 through Sage 100?