• 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…
  • 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…
  • Accounts Receivable, Utilities Menu, Global Customer Field Change

    I am trying to make a change to all of our customers and have found the instructions on Sage Knowledge. However, I can't get past the first step because I can't find Utilities Menu under Accounts Receivable. Thank you for your help
  • 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…
  • Payments collected During time of Sales order not hitting GL Account

    I have noticed that for the month of March, no credit card payment that was ran at the time of the sales order has hit the GL code. This is odd because it only happened for the month of March. Any ideas on what could have happened and how to fix it…
  • Sage100 - Cash Receipts Entry - Deposit Remaining - Out of Balance

    AR Clerk entered a deposit and distributed all the checks to proper accounts and invoices. On the Deposit Header tab the "Cash Amount Remaining" and "Deposit Remaining" fields each have the amount of the last check distributed. When I click on the…
  • A/R Repetitive Invoice - Change Reference?

    Is there a way to revise/change the reference code listed for a repetitive invoice? Or, do I have to delete and re-create a new one? Thank you!!
  • Re-opening a closed fiscal year

    I need to reopen a closed fiscal year, but I can't find any instructions on how to accomplish this.
  • 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…
  • 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…
  • Age AR accounts from Command Line

    Anyone know what the program is to run the AR Aging process? I know it can be done by running an aging, and by rebuilding sort files. But I need to schedule this to be done daily. And the Task Scheduler is not working for this client. Support has not…
  • Utility to clear $0 invoices off all AR customer accounts...affecting data in alerts & reporting

    We have numerous $0 invoices in each customer AR account for items like samples, literature, etc. This is our way of tracking these materials. Recently, we began using bolt on programs for alerts and reporting. One report will send an alert for each customer…
  • search by AR contact

    We have a customer with a lot of entities and locations with the same bill to. Within these locations, there are many contacts. So we have customers calling, stating they are with XYZ and we don't know which ship to location is related to which bill to…
  • AR Reports

    Question, I need to run a report showing what I billed our customers for the month of December 2016. But I need to choose customers who only purchased certain products. Which report do I need to run? I'm starting to confuse myself. Help!! Thanks.
  • Customer contact panel font problem

    SAGE Advanced 2016 (Version 5.30.1.0) We recently upgraded from 2014 to 2016 and have noticed a problem with some of the data entry panels. The fonts are extra large and bold on some and normal on others. I have managed to fix most of them simply…
  • Commission edit register update and a salesperson link didn't update. What do I do?

    All the amounts were correct and when I printed and updated the commission register I saw 1 salesperson whose vendor link was not updated. Will is transfer to AP ? How can I correct this? I manually updated his link in salesperson maintenance, but how…
  • 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…
  • Cash Receipts Entry with Sales Tax

    Hello - Our company does a significant amount of AR work and currently we are entering all cash receipts as an invoice first then have to go and credit the invoice off in order for the sales tax to report correctly - is there a way around this so we…