Sage 100

Good morning. Does anyone know of utilities to purge records from the pl_journalPDFlog or to rebuild these files? Over time this file gets fairly large. Can the log be purged without deleting the PDF files? Thanks so much.

In Vendor Maintenance we see a vendor with 2 balances due. But in the check printing invoice payment section the invoices have $0 balances. We need to pay these bills, but are unable to. The payTodayFlags are set to no, because the payments got backed…

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…

Currently we use payroll for expensing the labor expense on our setup. There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O. When WIP got turned off the offsetting transaction for the…

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…

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…

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…

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 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…

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…

Can't find the issue ... is it a bug with the new version v7. Sales documents: error message when I click on the invoice to validate it and after invoice initialisation toggle message... Error message is "Path not found" Result: invoice cannot be…

H ow do you reopen a sales order that was closed during the invoicing process

Hello, We are in the process of switching from Sage 50 to Sage 100. I'm trying to record our 401k Payment but I'm not sure how to do it so that it integrates with Bank Rec. The Payment was made electronically through our bank and not through Sage…

I need to delete/reverse an entry as it is a duplicate but I can't find where to view it to see the other side of the accounting. I see it on the GL Detail report for the bank account and it's a GJ but I can't find it when I go into GJ and try to search…

Our client enters their AP Invoices by batch. They also want to Select and Print their checks by batch. When I go to Invoice Payment Selection, by batch is not one of the choices. Is this possible? I cannot seem to find this option and am wondering what…

I am trying to check the box under GL Options for Integrate with Bank Reconciliation and I get this message: You cannot enable or disable integration to Bank Reconciliation while Transaction Journal Entry is in progress. I do not have any TJE in progress…

I am brand new to Sage and my client has entered checks and customer payments throughout the year but when I look at the GL, I'm not seeing them anywhere. What's missing?

I am brand new to Sage and trying to get a first reconciliation done. I am trying to mark the box under General Ledger Options for Integrate with Bank Reconciliation. When I check the box and click save, I get this error, how can I get it to save? I…

Hello, Our accounting department recently brought to my attention that entering data inside of Cash Receipts Entry only posts to the sub-ledger. They must then go into the daily transaction register in order for this to process to the General Ledger…

I have a customer who used to be set up as a different name. On the old name, there are outstanding invoices. On the new name, those exact same invoices are marked as a prepaid. How can I clean this up and get all invoices under both names to a zero balance…

I'm running Sage 100 Premium, 2017. I am not using PO's. A vendor wanted us to forward a payment to them before we have invoices. Also, the advance will end up being less than the total we pay to the vendor. (Example: we prepay 1,000, but the invoices…