• AR and collecting money before Order is shipped

    Good Morning, So have a bit of an issue that we're trying to solve and not 100% sure on the best way to go about this. We recently transitioned into Sage Intacct on Dec 1st and everything has been going great, however, our CFO now does not like the…
  • 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…
  • Is there a facility within Sage 100 A/R to document or log customer communications by past-due invoice?

    We desire to document customer contact/communications regarding specific past-due invoices in Accounts Receivable. Is there a facility to do this at the invoice level? Frequently, we receive verbal confirmation from a customer that a past-due invoice…
  • 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…
  • Printing an adjusted Invoice in AR

    I have an invoice that was posted without freight added, so an adjustment was successfully processed to the specific invoice. I'm trying to find a way to update paperless office with a new PDF that reflects the adjustment, or some sort of means of sending…
  • 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…
  • 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…
  • A/R INVOICE DATA ENTRY

    Hi All , I am trying to post a Invoice that is not related to a Sales Order using the A/R Module >Invoice Data Entry . However when I post I get the following errors : A Customer number was found that is not on file . ( Customer is clearly…
  • customer invoice credit

    How do I reverse an already posted invoice to a customer in Sage100? I believe I have to issue a credit memo but cannot seem to figure out how this is done.
  • Adjusting Credit Memo

    We handle all invoicing through the SO module. I recently generated a credit memo through the RMA module. However, the credit memo should not have been created. I know I can do a debit memo to offset but I also know that that invoices and credit memos…
  • How to setup Tax Districts where the Material % is different than the Labor %

    The contractor needs to charge the client sales tax but there is a percent for materials and a different percent for labor. I can create two different Tax Districts, but you can only choose one Tax District for an AR invoice and in addition to that, there…