Sage 500

I am able to generate a custom report to printer via Button Click using the following code dim CRApp dim Rept dim RptFile RptFile = "<ReportPath>" Set CRApp = CreateObject("CrystalRunTime.Application") Set Rept = CRApp.OpenReport(RptFile) With…

I need to update the logos on our invoices - how do I do this? Is there a specific size and pixel that needs to be uploaded? Thanks, Adrienne

During discussion today the question came up "Why do some Sage 500 report tasks have a .NET Configuration file and others do not?" Since the report task is still written in VB 6 and there seems to be a necessity to interact with .NET because of the configuration…

Changed a report to pick up 3 of our companies (A,P and C) (Created consolidated connector then exported and imported the report using the consolidated connection) The accounts union report (Accounts S500) is one of the many that are included in it…

The A/R trial balance within SAGE 500 is not flexible enough to easily sort the returned data by invoice number. We are hoping SI could provide greater flexibility.

I need a separate picking list form for each company. Where is this setup? I cannot find the picking list in business forms in Common Info.

We had the same issue with suppressing zero rows once the report is run out and wanted to share our solution. Background: The ZeroFill function is used to suppress rows which have zero value in a particular column in the Excel Workbook. If a parameter…

We have a customer group that is wholesale. In the Matrix Pricing GUI - the group is set to: Method - Discount Amt Base - List Price Amount - 0 The customers in this price group do not show up in the timCustItemPrice table at all. We have…

We want to customize our statement emails to include customer name, code, etc. Can Document Transmittal accept variables? if so, is there a list of variables? Thanks Joe

What is the best way to create an Income Statement that contains 2 columns, the first column is "Current Quarter" and the second column is YTD column? I am trying to figure out the best formula for the current quarter. Is there a way to input a range…

How do I adjust the rules for accounts payable check auto-signatures?

Is there a way to print blank stock checks in Sage 500? My AP person doesn't want to use pre-printed checks. Also, how do I add a signature to the AP check print form, Sage 500? I'm so used to having source code, I was a former developer, so I'm having…

We are trying to use SI as a replacement for FRx. It does not appear to have the concept of Trees or Rows. Anyone had this issue and if so how did you get around it?

We would like to create a process within Sage that will allow us to create a secondary run of the Check Printing process. The result of running the process is to create PDF files of each check, and at the same time, generate a file containing the data…

Have any of you found a way to put the customer payment terms on customer statements? I have 'played' with it for quite some time and can't seem to find a way to get it without impacting the data on the statement. Any insight would be most appreciated…

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…

I am trying to find documentation on what is in the oDM parameter ("data manager object") in the Form_Save subroutine in the Save Event, specifically in the Enter Receipt of Goods Form (PO Module). Can someone post info on what what I have available to…

I have a user whose standard setting in the Work Order Transactions Explorer is corrupted and will not open. The other settings work for the user. Is there a way through SQL or another task to remove the user's setting? I cannot delete it from the Explorer…

Has anyone out there been successful getting a signature to print using Troy Group's signature chip? With the Altec solution, the signature required the use of a text field ~&f131Y~&f3X that would trigger the printing of the signature from the chip…

Our AR department is asking IT for a way to calculate commissions by line item from the invoice. We cannot find a way to customize a report that pulls both Sales History and Invoice History. Is there anyone out there that has accomplished this or is it…

We have a bunch of accounts that need to be set to inactive. Some have items in common like a common location (segment 3). Others are spread throughout the entire chart. I was hoping there was a faster way than to maintain each one and choose Inactive…

I have a script that populates the Commission Plan on the Invoice detail line from what is selected on the header. The script is quite simple: Form.Controls("cboCommPlanDtl").text = Form.Controls("cboCommPlan").text and works perfectly as long as…

The subject line says it all. I don't see a way to link that table to that view. Any ideas? Thanks!

In Customizer, am scripting to allow user to click a button to print package labels at PO receiving. Works fine except I want the user to be able to specify the number of copies to print for each label (have that part done) and then pass that info to…

Is there a way to change the default naming convention on the PDF attachments when performing document transmittals in the AR module? MAS500 by default uses the customer number. We would like to use the customer's name so that the email looks more business…