Sage 100

Is there a way to select/identify customer(s) that have been merged in Sage? i.e. SQL table or any other method. Thanks.

Hey Sage gurus! Hoping there is a work-around. Our company has sister companies, and they all have their own Sage company codes with separate books, G/L accounts, etc. However, the three companies all use the same bank account. How can I go about…

I have run all of the daily transactions registers and any other update functions for ALL modules, not just inventory. I have looked at inventory transactions to see if there are any postings that are unusual. These are the only ones I see. Inventory…

Help! We sold a stock item on a sales order, and when I review the impact to the G/L, the sale did not record revenue for the inventory line item. Inventory item price to customer: $665, our item cost: $401.40. When I invoiced the entry looks like…

Hello I have a user who receives this error very often after invoices are printed. Any direction on how I might t-shoot

When we ran the Inventory Negative Tier Report it has items on there that have positive Quantity On Hand, 0.00 Tier Quantity and a Tier Value greater than 0. Cost Tier: FIFO How do we get rid of these positive on hand quantity items from the report…

Hi - I have some vendors who allow us to pay a third of the invoice every 30 days. Is there a way to post this to properly show the due dates in Sage 100?

We have been issuing checks for credit memos or overpayments on customer's accounts, just by creating a dummy invoice on the AP side. When it goes to zeroing out the credit memo or overpayment, we are struggling to apply this correctly. What is the correct…

Two separate clients contacted me yesterday concerning the "Cleared" information missing from a vendor when they had the proof that they had marked the checks as cleared in their last bank rec. Anyone else seen this?

We use an outside payroll company. Currently we enter our payroll journal entries as a 2-step process. Step 1 -- enter a transaction journal entry to credit checking and debit payroll clearing. (this hits the bank rec) Step 2 -- enter a general…

Hello we have a customer when you click on a recent invoice under the invoice tab it displays two entries Invoice and Adjustment they are exactly the same. The adjustment doubled the amount of the invoice, it doubled what came out of inventory, on the…

The new Reverse Check Run Utility is a good enhancement. But it falls short of a truly GREAT enhancement due to its limitations. You can ONLY reverse checks that were generated via AP check printing. If you issue manual checks (MC) you are out of luck…

Can you reverse a voided check?

In Invoice Payment Selection, is there a way to add the invoice comment field to the selection options? Perhaps via a UDF that is mapped to Invoice Payment Selection?

Unlike previous versions of Sage 100, I am not able to click on the column names to sort the invoice data. Sage 100 2023 PU2 (modifications installed and not able to install latest product update). This same client was previously running Sage 100…

Hello, I posted two checks directly to GL using AR Cash Receipts Entry, as I normally would for payments of this type, but they are not showing up in Bank Reconciliation. I've confirmed that they are showing in the GL and that I posted them to the correct…

I voided to checks through the manual check and payment entry. The invoices are still showing as paid. Thinking i just didn't update...all files are empty so I tried to void the checks again in check and payment entry. Pop-up states that the check is…

Hello, I am having an issue with the Accounts Payable Invoice Payment Selection function. When attempting to select the invoices to be paid I am only able to select a portion of them, the other invoices that I know are inputted and can be seen…

Looking for ideas on how users handle credit card statements in Sage 100. Purchase transfers can be very time consuming. Looking to avoid them and was thinking of doing a stacked VI import where we first import into AP_OpenInvoice to the vendor's account…

I'm trying to close out the month in the GL module and I'm getting the following: Warning: Transaction Journal Entry is in Progress. I have Sage 100 Standard.PVX 2023 (Version 7.20.1.0) Incidentally, I don't believe I have any JEs in progress.

Which Banks are accepting the NACHA file upload for Direct Deposit Payroll? Is there a certain type of Account needed? I opened a separate account with Wells Fargo (Business Acct) and there is no place on online banking to upload file. Calling for support…

Has anyone found a way to open a past entered invoice and copy it as a new entry where you can then change and update some data lines as needed? We have some repetitive billings with complex distributions that are the exact same month to month dollar…

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…

Is there a way to set up a General Ledger Allocation that will post to a Contra-Account rather than the Source Account. For example, we have a cost center set up for Maintenance Expenses. We want to allocate the Maintenance expenses to our Production…

I am setting up a new company and I am trying to enter the starting balance on some accounts so it should be just line entry because there isn't another account to applied it to. I have followed the instruction step by step several times but it says the…