Sage 100

Looking to see how big AR Invoice History Header and Detail files can get before there is a performance hit or a file size limit. We are looking at importing AR invoice details going forward in 2024, instead of a 1 line summary per invoice (actually…

Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…

What are the differences between 'Time Created' and 'Time Updated' fields in the invoice history? Assuming they are my local times and that it is based on a 24 hour clock with decimals as fractions of the hour (e.g. 15.5 = 3:30 PM)?

I am running a VI import to import AR invoices into AR Invoice Data entry to post Invoice to Customer accounts. The import works I am using an assigned Misc Item code that contains a GL Account number for Sales. But when I try to post the invoice I get…

i am trying to update a UDF in line level using script on a button click Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…

I need some help wrapping my head around creating this AR Terms Code. This is what I need: Invoice dated 1st - 15th payable 15th following month Invoices 16th-31st payable 30th following month Thanks for any suggestion!

Hello Everyone, I am attempting to put together this ODBC query against the Sage database, and I am trying to return values from the past year, specifically using this parameter: WHERE AR_InvoiceHistoryHeader.InvoiceDate > DATE_SUB(now(), INTERVAL…

Hello, I am creating AR_Invoice via BOI. We have Account Receivable Division check box unchecked. I assume ARDivisionNo$ is optional. Here is my code //Set the A/P Invoice Header record retVal = oARInvoice.nSetValue("InvoiceDate$", _invoiceDate…