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…

It appears that the beginning balance for period 1 is coming into the reports without regard to the beginning period selected. The subordinate transactions come into the report correctly, but the balances are all off because of the incorrect beginning…

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 delete a job. I'm getting a message that there is Ledger Activity but no job cost or committed cost. Is there a way to run a Ledger report by job number?

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…

An auditor is asking for a report from G/L that lists all General Journal Entries from 2020 and includes the User Name that created the Entry and the User Name that posted the Entry. Obviously I can link SY_User to GL_DetailPosting and pull a report…

How can I change my settings in the GL Module to only show Active accounts on my Trial Balance? Currently it is showing deleted and inactive accounts along with the active? Thank you

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 there an AR report to show/compare the Customer Sales History by Fiscal Period and Fiscal Year for more than 2 years?

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…

Dear experts Using Excel need to pull the data that the general ledger detail report displays but I need to add invoices number, invoice date, comments... what tables in Sage 100 gives me: GL Account Number, description, Date, Journal Comments…

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…

I need to run an Income Statement for an odd time period for an insurance audit (Mid -Month to Mid- month) for a 6 month time period. Is this possible?