Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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!
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…
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?
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…
Hi,
In Sage 50, I was able to pull a report showing me all the payments we made to a particular vendor quite easily, but in Sage 100 I'm not sure how to go about it. I would like for example to see what we've paid to Vendor XYZ from August 1, 2018 to…
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…
Can I use Excel 2013 with MAS90 version 4.5? We are upgrading to the current Sage 100 version, but I need to replace my computer before that is scheduled.
Thanks for your help!