• AR Invoice History file size limits or performance hits

    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…
  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    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…
  • Updating UDF in SO Line

    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…
  • Questions relative to invokelookup

    Hello, I am trying to write a script for lookup button in order to pull the salesperson data. I only want to pull the salesperson data whose division number is “00”. How can I pass ARDivisionNo as parameter? Here is the script which I am working on…
  • Setting default settings for statements printed on invoice data entry

    As it stands when I print statements entered on invoice data entry its automatically defaulted to "partial" comments, I want it defaulted to be "full" would anyone know how to do this? Thanks in advance.
  • AR Invoice History - Sage 100-v2014

    What is the purpose of the Invoice History button (up in MORE) ?? and why is it .. We had Customer A .. and we were trying to find out information as to how some invoices were paid. Normally I click on the binoculars, and click the box that states…