Sage 100

I recently acquired a business . They are using SAGE100 . I have to get a Balance Sheet As At September 19th to finalize the closing entries . The only option I can see is Month end.

Hello all, I'm not sure where to look and my google search doesn't help much so I'm asking the community. Is there a way in Sage 100 Standard to get a report or some type of list of all open batches across all modules? Or do I have to check each module…

The Customer Sales History by Period >> Dollar Sold does not match our income statement revenue. I tried reverse-engineering the data and it appears that any values that touch the customer A/R account are included in Dollars Sold, regardless of which…

Is Sage intelligence able to access the PR module? previously answered We had some issues bringing Custom Financials from 2018 to 2020. Does anyone know if this (antique) hidden module is supported in 2021 or 2022. (I know) I am trying to move the…

Our customer wants to see the GL Account(s) and the respective dollar(s) for the invoices that appear on the Payment History Report and also to have the report sort by GL account. I haven't had great success using the AP_TransactionPaymentHistory and…

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…

I am on Sage 100, 2020, Premium (SQL) version 6.20.0.1 I have customized the Purchase Order report and it works fine from purchase order printing until in crysal reports I link the inventory memo table to the purchase order wrks table. As soon as I…

Sage-100 Premium (SQL) When we print the auto reorder listing prior to accepting the suggested reorder, the text is very small and there are fields that we do not need. We also would like to have it print Landscape so that it is easier to read. I can…

Sage 100 6.20.1 Premium GL Reports Financial Reports, the balance sheet report is repeating the Retained Earnings Account. The Sage KB 26049 fix is to create a new Balance Sheet report and with Print GL Accounts off. That did not work. Has anyone…

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…

(Customer is asking for an audit request). Are additions / changes to ACH settings (AP_VendorElectronicPayment) logged anywhere? It's not recorded in the audit report (AP_Audit), and I'm wondering if there is something I'm missing?

Has anyone had an issue with invoices remaining in the Invoice Selection after checks have been printed? It keeps happening for us and we can't figure out how to stop it.

We recently upgraded from SAGE 2017 to SAGE 2020 payroll. In 2017 our direct deposit stubs were exactly like the Check--Stub--Stub Check. This is how we would like them in SAGE 2020, but I can not figure out how to accomplish this. Any suggestions are…

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

Hello all. I hope this is the correct place to post this. I have been tasked to find out a) where does Sage get the dates for the reporting periods in AP_Analysis.M4L and in AR_Analysis.M4L because the dates we're seeing do not make any sense and b) what…

v2018.8 Standard with Job Cost, IIG POS/CCP and Century Business Solutions Credit Card Processing. Error occurs when running the Monthly Sales Report. Sage KB article 103227 does not provide a resolution for this situation. The error occurs when the invoice…

We have a client who needs to file this monthly, so unfortunately the quarterly report in Aatrix (Federal and State eFiling) won't work. This was fairly easy in the legacy system but in the new Payroll module this is seeming to be fairly tricky. I…

How can you have invoices in a batch within the Sales Order module print/sort by customer code? Thank you, Sal

Hello, I am trying to get an Inventory Valuation Report for our Fiscal Year End which is October 31. I tried to print the inventory valuation report by period and that only show the inventory for the month of October. The Inventory Valuation Report…

I want to rollup an Inventory Allowance (1075-000) account into my Inventory Account (1070-999) on my blaance sheet. Can someone help walk me through? I am not sure I have the permissions becasue I don't see where to change it.

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

hello Can someone provide documentation on how to connect Sage 100 to Power BI. When I click on prior conversations about Power BI the links no longer work. thank you

We have a business that has two locations, so we use a UDT when entering transactions to split them accordingly. In order to show separate income statements, we have been manually creating them in Excel each month. This is tedious and leaves room for…