Sage 100

If AR Options Apply Changes to Repetitive Invoices is set to prompt then when you enter a new customer in customer maintenance with a ship code you get a message "Do you want to update repetitive invoices?". Why would this message come up on a brand new…

We have a client that is being forced to use Ariba, Tungsten and Taulia to receive payment from their customers. They are manually entering their invoices. I asked if we could upload them but he told me that they have to be entered manually. Does anyone…

I have an invoice that shows to have a balance of $5,382.38. When I try to apply the payment in the cash receipts function, the balance shows as -$10. I don't get it. How can I fix this? I don't see any credit memos.

I have a dilemma with a client. Company has an a/r account with many outstanding invoices that have been "donated" to a particular client. However, the salesperson has done the donation and the owner has offset all of these "sales" by deducting them from…

I believe that in our old MAS 90 version 2017 you could search Customer Invoices by the comment field. If this was not a standard feature then I may have added it through Customizer. Now it has been awhile since I have done that and do not recall…

Hello everyone, I'd greatly appreciate help with generating a total revenue report for all customers within a certain date range. I've tried using the "Revenue by Customer" report and wasn't successful. I wasn't allowed to select all. I've tried…

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 produce an A/R Aging report that ONLY shows customers that are delinquent? Thanks!

We have a client that would like to pay commissions on Invoices based on teams. I have looked at Split Commissions but based on my initial testing I do not believe it will work. The situation is as follows: John Smith is the salesman and receives…

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…

Is it possible to change a customer name while their are S/O that have not been invoiced? I have blanket S/O for different customers and S/O that can't be invoiced until the product is shipped.. When going to AR>Utilities>Delete and Change Customers I…

I wanted to see if anyone else is having the same issue. We are running Sage 100 2018 Advance update 5. I just ran the AR Delete/Change Customer utility and deleted over 1800 customers. I had the utility set to delete "ALL FILES", which should have deleted…

Hello, Our company recently upgraded from SAGE 100 2017 to 2018, and we have an employee who is trying to do Statement Printing. He reported that the field "AR Rep Code" is no longer under the Selections area on the Statement Printing panel, while it…

What would cause our credit card receipts not to post to our bank reconciliation?

Hello I have a question regarding a prepayment that was entered under the wrong account and now the customer under the correct account was invoiced how do I apply that prepayment to the correct invoice?

Hey all, I'm a recent new Sage 100 user and have experience some problems with misc item charges in SO module. A client is worried that we are not charging the customer on fees in a timely manner. Whenever a product is approved we must charge them…

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.

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…

I have 1 customer but they have 2 accounts with us. One account shows a positive amount of $650 while the other is -$650. How do I journalize these to cancel each one out and take off my A/R aging?

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.

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…

We run a repetitive invoice which includes credit card information. When we run the sales journal we uncheck Perform Credit Card Processing. The sales journal errors out and indicates that an unauthorized credit card transaction was found. Any thoughts…

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…

I have one customer with an open balance and another balance with the offsetting credit balance. Is it possible to do a cash receipt and apply the two customer balances together so that both customers balances zero out like you can in SAP? This is a really…

How do I get a list of all customer ship to addresses?