Sage 100

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…

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 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…

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

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…

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…

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…

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!!

I need to reopen a closed fiscal year, but I can't find any instructions on how to accomplish this.

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…

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…

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…

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…

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…

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!

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.

Hello, I have create a UDF called Item code in Cash Receipt detail table and add it on the Grid. I want to create a Button script using the invokelookup which will fire off the item code list and can select the item code from the list, then set the…

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…

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…

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…

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…

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…

When I have AR Invoice History Inquiry open is there a button to click to find out payment information, date inv paid, check number, amount, etc? Besides going to AR Customer Maint or Inquiry, finding the invoice and clicking on it that way.

I am trying to add a custom panel onto the customer memo inquiry and maintenance screens so I can see both the create date and the auto display field (to quickly distinguish old notes from current notes). Currently in maintenance I only see the memo code…

I was trying to change a customer number, but when I went to Utilities and tried to use Delete/Change, I got the message that I was unable to proceed with unposted data in A/R Invoice Entry. When I looked at the A/R invoices, I was unable to select…