Sage 100

Hello, We are using Sage 100 Advanced 2021, and recently noticed for some customer of ours (in customer maintenance) have invoices reflecting the same date for "Inv Date" and "Inv Due Date". It seems that this began May 2024 and not sure what exactly…

We are on Sage 100 Advanced v2022.2 and have been maintaining a list of AR CM numbers outside of Sage. This way when a CM is entered, there is a way to keep track of the numbers and not enter a duplicate, either in general or to the same customer. There…

Hi Everyone, I do not see the memo button on my customer maintenance screen. Where can I add the function for all of my users who will need to be able to see and change the memo when needed under the customer maintenance. I tried going into the AR Memo…

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…

My company has two departments, the main account dept are doing a process called Backdating. While they do this, another department is doing customer lookups for their current balances. The issue is when the main Account Dept is doing the backdating;…

Is there a report that will show a list of customer invoices and the payments + credit memos applied against it? We have a customer that is constantly trying to re-use credit memos. Thanks for your input!

We just upgraded from Sage 100C V2019 in that version and all the others before we have been able to add on the fly ship to addresses. In 2022 it looks like someone thought it would be a great idea to remove that permission able item, either that or they…

We are fairly new to Sage 100. We upgraded to Sage 100 in March 2023 due to corrupted data in Sage 50. When we reconciled our bank accounts for March and April, unfortunately we didnt print out the reconciliation and the staff member that completed the…

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…

Hi Folks, I am trying to add payment information to my A/R invoices. My test company has a formula field called "Payment" with the following formula "formula = {@NetInvoice} + {AR_InvoiceWrk.FreightAmt} + {AR_InvoiceWrk.SalesTaxAmt}" that does not seem…

How would I go about creating a popup for invoicing department when they are invoicing orders and some line items have a "0" for price? The goal is to eliminate giving things away for free by accident.

We would like to allow some customers to pay their invoice on a 6-month payment schedule. I see that we can use repetitive invoicing and set up up for a 6-month period but we want to take the sale upfront. Does the repetitive invoicing replace the traditional…

I would really like to start using the eInvoicing feature in Sage 100c. I have it all set up within Sage (the eInvoicing check box is available in Customer Maintenance and I've sent a few test invoices using the feature). But, I find the email that is…

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…

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…

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

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…

I have a client that bills once per month. I want to export the customers that have a checkbox I created that states yes, along with that month's invoice balance to auto-pay credit cards. 300+ customers need to be autopay a few days after the invoices…

We're piloting the use of Sales Order Quotes and all of a sudden we have customers getting flagged with credit limits. We want to keep open sales orders in the credit limit calculation but not open quotes. How can we do this? I saw the earlier post…

I need to clear multiple AR Invoices for loans. Payments against loan balances years ago changed to be offset by a GL account as loan software was utilized to track loan balances. At this point the loans are paid off and the invoices are sitting in the…

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…

Why doesn't the SO_SalesOrderHistoryHeader file get updated with the new customer number from the Customer Delete/Change utility? I've renumbered and merged several customer numbers and this is the one file that does not get updated. This file also is…

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…

I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

Hi there! We have a credit card customer who had a credit on their account. The next time they placed an order, we wanted to apply the open credit before we ran their card through Sales Order Entry. We couldn't figure out how to do it, so we did a work…