• 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…
  • Is the a way to summarize the invoice totals to a customer or suppress the detail from the view?

    I am a new controller to the company, and I have very little experience with Sage 100. We need a solution to send a customer one invoice (containing multiple jobs), and only show a summary as if it were one job. Our business is in manufacturing, and…
  • How to find the cause of variance between invoice total and the number on income statement ?

    Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…
  • Moving an overpayment from one customer to another

    I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…
  • EDIT SO INVOICE AFTER "BATCH IS CLOSED"

    Hello , We are new to using Sage 100 and have a few questions . After our sales people process a sales order we then go into Shipping data entry and then print the invoice. At the end of the day , we then update the register. My question is , how…
  • Prepaid Invoice Requests

    Our developers have written an interface to pull and push AR customer data. Invoices (IN) are not a problem, but prepaid invoices (PP) produce no results and no errors. I'm pasting the code below. Any ideas? using System; using System.Collections.Generic;…
  • 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…
  • Help AR Deposit given me a PP out of nowhere.

    I go to cash receipts entry and I double click. I created a new batch I click accept, then I created a new deposit number I type the total deposit amount and click accept, then I look for the customer number hit tab then I type check# then I type the…