Sage 100

Hi there, I searched and couldn't quite find what I was looking for. I'm looking to create a report where I can select 60 or so specific customers from our database and be able to see the sales (to all or each of them) of 35 items from our catalogue…

Hi Community, We have just upgraded a customer from V2015 Standard to V2020.1 Advanced and I have noticed that the UDFs in the selection grid on reports are no longer in alphabetical order - we have a couple of UDFs (12) but in the selection grid without…

Hello, We are trying to set up an invoice report for a 3rd party company to help us manage our taxes. They require that we put taxable amounts on one row, and non taxable amounts on another row per invoice as we have some invoices that have both taxable…

We are trying to print a group of financial statements into only one Excel Workbook. Each statement should appear as an individual worksheet with in the workbook.

Hi everyone, When a need for reorganizing product lines occur, how are you dealing with that while reflecting the changes to the history files? For example, simply changing a product line of an inventory will not change any history files or update SO_RecapByProductLineWhse…

Is there a way to combine data from multiple companies using formulas like GLActual ? Currently, I have 4 companies, and I have the individual account data being sorted on a second excel page to combine their data in Total column. I've tried using a formula…

I am specifically looking for the field for the SO line items comments on the lines tab of the Sales Order Invoice screen. We print a pack-list form code and would like to be able to include comments from each line. I have tried all the fields in Crystal…

Hi Just wondering if anyone knows if there is a report to get Price List by Price Level by code?

Is there a specific field and/or table to use within Crystal Reports to determine when a G/L account was last used? This would be for the purpose of delete the obsolete account. Please advise and thanks! T. Helm

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…

Hi community, running sage 100 advanced version 2015. I've got a puzzling scenario. If i attempt to launch a rpt business object from a button script, i can leverage and send the document to paperless office. Yet if i run the same code formatted…

Under Reporting I would like a vendor list with company name, address, contact phone e-mail, fax. Why does a vendor list just list the vendor name, contact, phone and fax. Can't find the address information? Dave Coleman

We are wondering if there is a way to pull a report (or create a custom report) that would show who (which user) was logged in to Sage 100 at the time a specific Pick Sheet Printing session was performed? Any input would be greatly appreciated. Thanks…

I've searched through various posts and cannot seem to find an answer to a simple, specific question. Hopefully, someone can provide some input. I have created a very simple Crystal report, using the SO_SalesOrderPayment table. I want the report to…

Can someone please explain which table and corresponding date field, etc...that I would need to create in order to produce a report that shows all customers who have a CREDIT BALANCE that is FIVE (5) YEARS old or older? Please advise as soon as possible…

We are looking for a report that lists the SO, date, salesperson, sale amount and the profitability of the sale per month. I have tried to get it to work in Explore but can not get it to come up with the profitability portion. Anybody have any ideas…

I am trying to create a new report through the reporter. When I give the report a name and choose where it will be in the reports it puts me to the next screen where I should select a template (Landscape, Portrait, Shipping Label.) At this point no matter…

I'm trying to script against IM_PhysicalCountWrkst_rpt but keep getting "The Module Code is Required" when calling nSetKey(). Script sample is below. We are running 5.10.4.0. Anyone have any suggestions on what to try? Const HKEY_CURRENT_USER = &H80000001…

I need to design a * custom * version of the "Purchase History Report" that displays the same information included in the standard report, but with only the YEAR TO DATE totals...and...all column (field) headings/detail need to be on ONE line for export…

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…

We just upgraded to Sage 100 ERP from Mas 200 and I got this error this morning. I'm not familiar with it. I've looked through a few areas for help, but haven't found any solution thus far. I'm hopeful that someone has run across this issue before.