Sage 500

I am trying to do a crystal report that I need to pull the field that is"material Item"(SEE THE YELLOW HIGHLIGHED that is located in Maintain Router, Detail, then material. The Operation type is Outside Processing. Does anyone know the table or view…

I am interested in performing a Customer Explore and exporting the results to Excel. The problem I'm running into is that the field 'Commission Plan' doesn't seem to be a field that I can display or export from the Customer Explore function. I know that…

At Sage Intelligence, our goal is to make the running of your business easier, so that you have more time to do the things you want to do. One of the ways we do this is by providing you with additional reports that give you actionable business insights…

We are having issues lately where the error that comes up when the GL string used is active, but the segment is past it's effective end date does not produce an error report, and we can't find the detail of what's causing the error. I think the only times…

We want users to be able to check on PO Statuses, PO Expected Dates, Quantities, etc, but not see the Unit Costs of each item. I looked at all the Security Events and module options but I don't see a way to do this. Any ideas? A question involving Explorer…

We have some damaged goods for a transfer order. UPS wants an invoice to validate costs. Of course, this is a transfer, so no invoice available. I looked for any transfer document that has costs listed, but can't find one. Am I missing anything before…

I would like to add the PO Create User to the Blind Receiving Ticket. I've added tpoPurchOrder to the Crystal Report (pozri001.rpt) and have tried to add the CreateUserID field but have not had success. Maybe I just haven't found the proper linking in…

We recently upgraded from SAGE ERP 500 v7.4 to SAGE ERP 500 v7.7 (2016) and have noticed a change to the 'Print Edit List' report in AP. The Crystal Report file name is APZRY001.rpt. In v7.4 this report included the Vendor ID and Vendor Name for each…

Has anyone created a report showing historical qty-on-hand by item by month (the end of each month)? If so, please share the approach that you used. The Inventory Valuation Crystal report provides it, but it's not convenient as it must be re-run for…

In a couple of days, we'll be releasing our next installment of the Sally Series, this time focusing on the Connector module and how to define your own data sets for your reports. If you haven't yet checked out the first and second series then why not…

If you're looking for an easy introduction to Accounting and Financial statements, take a look at the following set of videos provided by Khan Academy: www.khanacademy.org/.../accounting-and-financial-stateme Then if you'd like to see how this is…

Hi, We have recently wanted to start using the Pack List With Contents for our shipments. The summary prints out fine, but the detail prints only the blank Crystal report. Once the shipment is committed, the details will print fine. This leads me to…

Hi all. Last week Sage Intelligence released a new Learning Portal, consolidating all of our learning material and providing you with clear and concise learning path for Intelligence Reporting desktop products specific to the level you're at. It includes…

I would like to change the scripting language in an event in a Form Script Editor, when when I change the Language pulldown menu from VBScript to JScript, I get an error dialog with the text Script language changed. Modify existing script's syntax to…

We have a user here who just upgraded to a Windows 10 laptop. She'd been getting random errors since then, which we thought were fixed by reinstalling and allowing Sage500 through Microsoft's builtin screening tools (and setting the SQL settings in ODBC…

Hello: We are running Sage 500 ERP 2014 January 2015 Update (Verson 7.60.5.0) - we recently closed a warehouse and transferred all inventory to another warehouse. Stock Status shows nothing in the old warehouse, I can't find any pending transactions…

I constantly get this error when trying to Register Post in Process Inventory Transactions. I will also get it in other modules such as MF (Bill of Material Cost Roll up). There are no customization anywhere. I've uninstalled / re-installed the client…

Both the GL Transaction Report and GL Activity Reports used to show the comment from the AP Voucher header in the "Posting Comment" field, along with the Invoice # and Vendor ID (when "Include Posting Comments" was checked in Options). After we upgraded…

What is the difference between the tran date in the timinvttran table and the trandate in the invttranlog table? Pete Gentile The Robbins Company

We are using Sage 500 ERP Intelligence Reporting 2015 with Sage 500 2016. From a Report Designer Add-in report, a user attempts to drill down to the transaction detail on an income statement account. But they encounter this error - The drilldown report…

I was following the instructions from this website: https://www.sageintelligence.com/tips-and-tricks/sage-intelligence-tips-tricks/2013/11/drill-values-view-deeper-level-data/ When trying to run the second drill down on the report, I get an error…

I am new to Sage, I would like to know how can I generate the Full User Access Right Report from Sage

I am not sure were to ask this question so maybe some can point me in the right direction ? Our CFO is looking for an audit report to check on payables electronically. When we normally audit payables, we start with a check amount larger than $ XXX. Than…

We own Sage Intelligence but no one here knows how to use it. I want to change that. Where should I start?

I posed a similar question many years ago but I would like to start a new discussion about this if anyone is interested or willing to share their ideas. I'm interested in finding a way to report the following: ACTUALSALES $ vs PLANNED SALES $, CURRENT…