• Lookup

    Can the ship method lookup be modified?
  • Custom Lookup Views

    I followed the How To Article in this Sage 500 forum ( https://www.sagecity.com/us/sage500_erp/b/sage_500_erp_blog/posts/how-to-create-a-custom-lookup-in-sage-500 ) to create a custom lookup for users to see . I set them up in Maintain Lookup Views, then…
  • Explanation of differences between MaterReqPer and MatReqPc?

    FormerMember
    FormerMember
    We use Sage and write software that integrates our book information system with Sage for inventory and finance functionality. The information in Sage about Mat Req Pc is clear, but I can't seem to find information about MaterReqPer and how it relates…
  • Calling code in external DLL through Event VBScript

    I am an experienced developer (mostly C#/.NET, some VBScript, Java, C, ...) and have gotten my hands dirty in Sage 500, but not too much. I've been tasked with a bit more customization here. I would like to call APIs from an external (.NET) DLL via…
  • Explore Invoices - Adding Customer Reference number column

    I want to be able to download a listing of all invoices within a date range to include the customer reference number. I have tried numerous times to add the column to the explore invoices view; it's not there. Is this possible? Am I missing something…
  • Customer Contact Records

    Hello. We need to update a number of customer records each with new contact records. I figure it's a simple insert query into tciContact. To get the next CntctKey number I use: declare @contctkey int exec spGetNextSurrogateKey 'tciContact',@cntctkey…
  • Knowledgesync - Custom Crystal Reports - Date Ranges

    I'm having trouble getting Knowledgesync to generate reports for date ranges. The date range parameter is hard coded in the crytal report but I need to have the parameters coded in knowledgesync. I need the date range to be for a month timeframe. I tried…