• 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…
  • How can I get Customer Memos to pop-up in Invoice History Inquiry?

    Hi, I have several customers with special requests regarding the sending of their invoices (mail, fax, e-mail to specific parties, etc). We created memos that pop up during Sales Order Entry. Unfortunately, that department doesn't always remember to…
  • What are the steps for the Sales Order process to Posting to AR? How is the AR PDF log created?

    Hi What are the steps to post a sales order through to AR? How is the AR pdf log created?
  • Accounts Receivable OPEN BALANCES INVOICE REPORT BY COSTUMERS WITH AN EXCEL SINGLE COLUMN FOR EACH FIELD NEEDED.

    I want to Download in Excel (from Sage 100) an Accounts Receivable Open Invoice Report. The problem is that the reports that I found in the AR module shares excel columns, for example, the AR aging will share the customer name with the invoice number…
  • 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…
  • AR Payment term due 15th or 30th of the following month

    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!
  • A/R e-invoicing attachments

    Hi there, We're trying to get Sage 100 Advanced set up to send our A/R invoices to customers via e-mail or FAX. The basics are up and running. However, it's common to need to include supporting documentation when sending an invoice. I can attach a file…
  • Why I can't delete the sales invoice

    Hi All, Could you help check this issue. I use the sample company 'ABC' to testing sales invoice creation. But when I delete the invoice '0100057,the invoice still appears in the invoice list. And then try to select this deleted invoice to delete again…