Sage 100

I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid), I got an error during month end close about an open invoice in the system…

I am new to Sage and need to delete a couple JE's that were in the previous (March) period-I have figured out how to reopen the period- however only 1 or 2 have deleted-the others tell me that they can't be deleted until all information is removed from…

We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog: When I click More…

Hopefully there is a way to do this. We are currently in a major backorder situation due to material shortages and have many orders that are partially shipping. For example, We enter an order containing pages of items (100-300 parts) We are able…

We have started the process of implementation of Sage 100c Premium. My support portal is still not connected to our account and am in need of getting the Minimum System Requirements for the servers and workstations. I will be grateful if someone can forward…

Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines? Here's a sample of the output file Sample data transmission payee positive pay Input format 908123456700002000720312070000029375…

We are on Sage 100c Advanced v2019.2 We electronically paid 2 AP Invoices with 1 E-payment. The second invoice should not have been paid against this vendor. When we go to reverse payment, the total amount can't be changed to reflect only the 1 incorrect…

The Customer Sales History by Period >> Dollar Sold does not match our income statement revenue. I tried reverse-engineering the data and it appears that any values that touch the customer A/R account are included in Dollars Sold, regardless of which…

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 all, I hope everybody is doing well. I apologize in advance if I post this in the wrong section. I recently discovered the Visual Integrator module for Sage 100 and have been trying to learn how to create a job that imports an Excel spreadsheet…

Hi, I run a net sales report from AR explore=>customer history invoices view. I use the invoice total minus sales tax, which gives me the net sales for that period. However, this number does not tie my income statement number. My June net sales total…

Hello, We began using the Auto Check Reconciliation utility in Sage 100. We imported a list of cleared checks from our bank, with the account number, cleared date, and amount. We proceeded with the auto reconciliation, and now we need to completely…

I have discovered that I have some invoices that have been paid, but the invoice is no longer showing up in transactions or history. The payment is there though. I'm not sure what happened but it puts my expense GLs out of balance. What could have happened…

I have several clients that have this issue and found an updated KB article on Sage's website. The article was originally created in 2015, but it was updated in 2020. Is Sage still working on the issue? When will it be resolved? Cannot prevent posting…

I'm using Sage 100 version 2020. I wanted to use Aatrix this year to submit my 1099's. I went through all of the steps in Sage, logged in to Aatrix, paid for e-filing. Between closing the Aatrix finish pop-up, and it going back to Sage, my internet cut…

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.

We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account. To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…

Looking for a definition of what happens during period in all modules. Which files are purged, what files are changed, etc. Where can I find that? I looked on Sage's KB and found it for AP, but no other modules. Thank you!

Hello, Nobody use below t ransaction (#A000815 N ). But Sage100 said 'Record(A000815 N) is in use by another user' as shown below. I would be grateful if someone let me know. Thanks!

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…

Hi Everyone , i just installed sage100 with 2012 express,will have this error when open the .mae please help and advise.

I have an administrator account and I do all of my work in a regular user account that I set permissions with, which tend to be the same as other people in my company, so others can use my account without any concerns. There's a new error in Sage as…

Is it possible to get a Active Vendor List? Lets say vendors that have been paid in the last 3 years?

How to enter a deposit payment without applying an invoice?

Hi, I'm trying to find a way to remove the price overrides someone created for a single customer, which has over 3,000 price overrides. It's too much to delete manually. I'm wondering if there's an easy way to simply delete all of the price overrides…