Sage 100

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 prepayment was incorrectly made, and due to some confusion was also entered in negatively so it shows up as a positive number in the aged invoice report. Is there a way to delete a PP or reverse it? This is on the A/R side. Thank you.

I need to print an Accounts Receivable Invoice History Report sorted by Customer type. I have created the UDF for Customer Type and added to all the work and history files. When I run the report just selecting invoice dates I get my report showing the…

Sage 100cloud Standard 2020 Ver. 6.20.0.1 (Zip Code in question 95037-Morgan Hill, Ca) When I attempt to change the zip code for a customer in the A/R Customer Maintenance module, I receive a message: Is this a new Zip Code? When I select No…

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…

How to enter a deposit payment without applying an invoice?

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…

Is there a way to view invoices in Customer Inquiry for the Sold To Customer when National Accounts is Enabled? Currently, I can only view the invoices in the Bill To Customer. When someone is inquiring on an Invoice on a Sold To Customer there does…

A Client overpaid and was asked to apply the overpayment on another job, done easy peasy. How do I apply an overpayment on a progress billing without having to adjust the original contract amount to get a $0.00 balance on contract result?

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…

I've run into this issue occasionally for at least the last couple of years. Say, for example, that I'm posting a batch of Invoices in Accounts Payable while my coworker is posting a batch of Cash Receipts Entries in Accounts Receivable. I post my batch…

Multiple end users have called to report that when they click the tracking button within Sage 100 they receive an error page: 404 - File or Directory Not Found Is this a known issue and if so is there any eta on a resolution? Is there any workaround…

I have a unique situation where Sage 100 was used 3 years ago and then they moved to another ERP. Now 3 years later they are moving back to Sage 100 and I have upgraded them to Sage 100 2019. I migrated their company that they used 3 years ago because…

Hello, I'm a Long time user of Sage100/Mas200 (1999), this is my first post. For the last 4-5 years we have not used the commissions reporting for accrual entry creation or payment to the sales team due to an previous controller created a process to…

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 know you can put multiple sales orders on one invoice for a customer but from what I can tell, if they have multiple shipping addresses, you cannot combine them on one invoice?

I understand how to associate the customers to the national accounts but when I try to invoice, I can only select sales orders that are under the same customer. I want to select multiple customer orders and place them on one invoice to the national company…

Hello, Our accounting department brought to my attention that for certain lines on the AR aged invoice report, the "Balance" field is showing exactly double what the "Current" field is. I went and looked in the database thinking there have been double…

Hi, I am hoping the SAGE community can help with this request. We have a standard wholesale price, say $10 for a SKU, and we have a range of price levels for our customers. If a customer has a price level of 20% off wholesale, the SKU would appear on…

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…

We do service work that in some instances calls for a "fixed" price per job. We will bill for the total cost of the project on one line item. We add additional items to the SO for costing purposes. Does anyone know of a way to suppress the print on the…