• Posting speed slow on different companies

    I'm running Sage 100c Advanced 2020, Version 6.20.6.0 We have one primary company and another dozen or so secondary companies. My accountant told me today that when he posts something in AR/AP in the primary company it is very fast - almost instant…
  • Change AR Aging from Invoice Date to Due Date

    Our company has decided they want to change the AR Aging Invoice by Invoice Date to Due Date. Is there anything I should be aware of or need to run after I change the option? I would assume there is some utility I need to run that will recalculate the…
  • 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…
  • AR AND CREDITS

    Does SAGE have a feature that will automatically apply a customers credit towards open invoices? We have a customer that had a fairly large dollar value of credits on his account. We've been waiting to get direction from them on what to do with them and…
  • How to import Sales Forecast by Customer and Item

    We are on Sage 100 Advanced v2022.1 and I don't see anywhere a Sales Forecasting report or option to enter numbers or imported via VI. We have a new Sales Executive and he wants me to import sales forecast numbers, by Customer and Item to produce a…
  • lines in a sales order invoice doubling

    I have seen two unrelated instances of a single random line showing up on my invoice when generating one using the path sales order, main, invoice data entry the GL detail report that I printed early May for our April rebill, as well as the latest…
  • Cash receipts entry to AR leger not matching

    Every once in a while i will try to enter a payment through the path Accounts Receivable, cash receipts entry and the invoice I want to pay will show a zero balance. If i simultaneously pull the invoice up using the path Accounts Receivable, customer…
  • 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…
  • Daily Transaction Register Hangs

    I have two clients that are experiencing random issues with the DTR hanging. It shows the progress bar and the green bar just keeps going. If I kill the task, I can go to the Daily Transaction Register on the Main Menu and it runs fine with no error.…
  • How to record a wire transfer in AR

    How do you record a wire transfer from a customer in AR? In AP there is the selection drop down for Wire Transfer, but not in AR. I read if we use ACH/Credit Card, it doesn't post to BR. So do we use Cash and if so, how/where do we enter the long 15 digits…
  • Is there a report that distinguishes between credit card customers and Net 30 customers who pay by credit card?

    Hi, I'm doing an analysis of credit card fees, with the intent of beginning to charge my Net 30 customers a fee for using a credit card to pay their invoice. I doubt it's possible, but is there some sort of report, or series of reports, I could run that…
  • 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 make new customers appear in drop-down menu?

    When we had Sage installed, all of our customers were imported into the system. When I start to type in the 'Customer No.' field, a drop-down menu appears with predictions of those customers. However, when I add a new customer, I have to click the magnifying…
  • FINANCE CHARGES

    Can someone tell me how to remove finance charges from a customers account? I will say upfront that I have been in sales for many years and was recently given AR with no training so I am learning as I go here... I did go in and turn off finance charges…
  • Can I get more that 2 people into a Cash Reciepts batch for entering Credit Cards during the workday?

    I am running Sage 2021 and have managed to get two people into the same batch for doing Credit Card transactions with Paya. Any attempt to add a third person will not work. What is the preferred method for allowing users to run a stored card for a client…
  • I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid)

    I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid), I got an error during month end close about an open invoice in the system…
  • Auto allocation

    Is it possible to enable auto allocation of customer receipts to customer invoices in sage 100 v 7.00.209..
  • AR Invoice Adjustment not reflected in GL

    Hello, I posted an AR invoice to the wrong customer, so I went back in to Invoice Data Entry and adjusted the invoice to 0, using the same miscellaneous item codes. I then posted the invoice to the correct customer. The two GLs involved are only showing…
  • 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…
  • RMA for two shipments

    We have a customer who placed two orders. They used part of the materials in both orders and then returned some of the items. Both invoices have been fully paid. I also need to charge a restocking fee, which I have never done. - Return the material…
  • AR credit that needs to be paid out

    I have a customer that has a large credit on their account. They haven't been ordering very much, so they want me to pay out the credit. How do I cut a check for an AR Credit Memo? We are using Sage 2015.
  • Open Credit Memo

    Hi, An invoice was created, and a payment was made towards that invoice zeroing it out. On a later date, we do a Credit memo to the account as a refund, how do I get the account balance back to $0.00? as opposed to a credit on the account?
  • "Balance" in the invoice field when trying to apply a payment.

    When trying to apply a prepayment to an invoice, "Balance" is pre-entered on line 1 under Invoice NO. and will not allow me to apply the prepayment to the invoice. Can someone help with this?
  • Positive Prepayment

    When looking up a customer's invoices under customer inquiry, there is a positive pre-payment. How can I fix this, and if possible can anyone tell me how that happens,so I can prevent it from happening in the future?