Sage 100

How do I stop a script from triggering during the Sales Journal update on the Sales Order header pre-write?

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…

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?

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…

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…

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".

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…

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,…

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…

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…

Is there a way to print out a report that shows a list of Invoices paid to each individual Vendor?

I can pull a report of the GL detail but this does not allow me to click back through to a record that affected the GL. We have been using this system for 2 months and I am trying to figure out if this is an option of the system or just something that…

The knowledge base is down. Does anyone know why? Any ideas on this error message? Thanks, Michael

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…

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…

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?

Hi BOI-Experts, I need some help with a BOI script that I use to print Sales Orders. It works properly in two of my test environments (Sage 100 v2017 Standard, Sage 100 v2018 Advanced). But I am not able to run it in he Sage 100 v2018 Standard target…

My customer wants to alter the Accounts Receivable Aged Invoice Report to sort on the Salesperson number listed in the AR_CUSTOMER (name sp?) table rather than the salesperson number in the AR_AgedInvoiceRportWrk table which is the same number that is…

My accounting team are all working remotely, and now when they attempt to print through Remote Desktop or Citrix, they encounter the above error. Any thoughts? Thanks!

I created a button on the Vendor Maintenance screen that runs the AP Aging report. I pass in the AP Division and Vendor numbers, but I can't get the report to filter by those values. (Want to run the Aging for the Vendor displayed, like the Sage button…

When using the /c for a written text to the supplier It doesn't allow our orders to close they stay hanging out as open and/or backorders

How do I get access to view reports in paperless office? My boss has tried to grant me access but my View reports screen is still blank

Hello, I just recently upgraded to 2017 Sage 100 Advanced and I noticed that when I print out the Inventory Transaction Register in this version, there is a lot of white space between transaction which is causing my print outs to be WAY longer than…

I have a client on 2016C update 3. The Description on the Sales Order Recap report, Report Setting = STANDARD was changed from Sales Order Recap to SALESTEST. I entered Sales Order Recap in the Description and saved with no luck. No matter what I try…

To anyone out there who can help with this...I would be most grateful! Our boss needs a very specific Item Sales History report for Fiscal Year '2016' that should include the following as COLUMNS ( if possible ): Item Code, Item Description, Qty Sold…