Sage 100

Hello, I ran the AP trial balance report for January and compared it to the January GL. I discovered it didn't match. I found out that someone had entered a January invoice into February. Then to correct it, they adjusted the invoice to 0 in February…

Hi all, We do most of our customer reports based off the GL_DetailPostings table. I have a few reports filtered to only show "SO" module transactions and I pull in some additional data from the InvoiceHistoryHeader table but now am being asked to…

I'm trying to find out how many invoices are being entered by month/period. The generic report JAccounts Payable Analysis Report shows this information, but it is showing me data from year 2022, May through October. How do I change the date range? Or…

I entered AP Payment Processing in Company "A," created a new Form Code, and used Designer to create a new custom Check. I have 10 other companies and would like to copy the custom Check to all of those companies. I think I'm supposed to use Report Manager…

If customer is running Sage 100 2014,2015,or 2017, will IRS accept Box 3 Other Income for Non-employee compensation because 1099-NEC is not an option?

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…

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

Is there an AR report to show/compare the Customer Sales History by Fiscal Period and Fiscal Year for more than 2 years?

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…

We have 3 company codes in our system. The operational efficiency ratio data on the general ledger analysis report populates for one of our companies but not the other. Has anyone experienced this issue before?

We just updated crytal reports from 2011 to 2016 version. Do we have to convert any reports that we changed with crystal reports to work with the new version?

The Visual Integrator "Job Log Report" is cutting off the information on the errors that occur. For example, a recent report looked like this: You can see that the error description is being cut off and so I can't see which batch or invoice I need…

We've always wished that we could export or print the transaction detail that we see under the Transaction tab in G/L Account Maintenance and Account Inquiry. Yet that's not possible. What's most frustrating is that a Print button is staring you in the…

Just a heads up - in v2019 an additional header was added to AP Aging Report. There are now 2 headers. Page header f and Group Header 2 If you do NOT have divisions and run the report sorted by the default Vendor Number, both headers are suppressed…

Good morning! I need a hero to save me today. I need to give the assets for the 2008 year to the CPA. I need to generate a query in Excell but I do not know what table or fields to pull so it gives me GL Account Number, description, Date, Journal…

Hi. I am having an issue with electronic delivery or PDF storage of remittance advice for paperless office. It saves and delivers by email BLANK page for PDF instead of the data. When printing to a printer it prints just fine but when saving to PDF…

our bank is asking us to supply information from our master vendor file. one of the fields they ask for, per vendor, is annual payment count. Is there any way to extract this data into a report or somehow using explorer? thank you

Here's the scenario ... we have an A/P invoice posted in our system with a 4/30 date. A wire transfer was made, dated 4/15, as payment of this A/P invoice. Logically, I would think that if an aged payable report was run any time between 4/15 and 4/29…

Hello, I have taken over at a small non-profit association and was given zero information by the previous accountant. I have never used this software. I am trying to simply look at all of the journal entries from the previous month so I can see what…