Welcome to the Sage 500 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
I experienced my first run in with non-technical people believing they could save time and money using ChatGPT to write software to customize their ERP system. However, they found out quickly to their chagrin that not following basic software development…
We are starting to you use Project accounting, and find the explorer window great. However, the quantity invoiced in the vdvproject lines view, seems to be inaccurate. Infact, we would like to quantity from invoices lines view. I have tried a couple joins…
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…
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…
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…
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…
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…
It appears that we are hitting a limit on our user lookup records as we are getting error 6 overflow whenever a user saves a new lookup in customer, item, etc. In the past this has been the result of an integer variable in the code where the record count…
We have an Item that has stock in multiple bins (bin tracking is turn on).
Create Pick List shows which bin the stock for a shipment is to come from The Pick List shows the bin
Where is the bin assignment in the db? tsoShipLine has an InvtTrankey…
I've made a copy of vdvInventoryDistribution and I'm trying to add a column to it called say, to be descriptive, OldestTranDateForThisLotNo.
Suppose every record has a LotNo. Most LotNos appear in multiple records. I want to add a column that will indicate…
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…
Getting an error when launching Explorer - 'count' must be non-negative. Parameter name: count. I have rebuilt the view several times and am wondering if anyone has narrowed down what's going on with this error. I thought it might be bad data but maybe…
I created a new BIE and pulled in the following tables: tarcustomer, tarcustdoctrnsmit, tcitrantype. I then created a filter that pulled a list of all Customers that had an Email set to '1' and tcitrantype = '501'.
Instead of showing the "501" in my…
When we select a customer in AR Maintain Customers, right click on customer, select drill Into, Invoices is missing from list. It was there last week. What happened?
