• AP invoice and the AP Trial Balance Report compared to the GL

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

    I tried to copy last year's budget to the next year. But I keep getting No Budgets Selected. Is there a trick to this?
  • Daily Sales Report

    I am trying to update my day but every time I click on the daily sales report in SO, it will not launch and crashes pvxwin32. The links file has been renamed to break our 3rd party connections with zero impact on the launch. Everything else in Sage run…
  • Print cash receipts

    My company recently bought another company who has sage 100 for their accounting software. Before we close out their books we need to enter a few AR cash receipts. I have a basic knowledge of Sage 100 but am not proficient. I have entered the payments…
  • Is there a report that distinguishes between credit card customers and Net 30 customers who pay by credit card?

    Hi, I'm doing an analysis of credit card fees, with the intent of beginning to charge my Net 30 customers a fee for using a credit card to pay their invoice. I doubt it's possible, but is there some sort of report, or series of reports, I could run that…
  • Inventory Label printer

    Any suggestions on a label printer for inventory receipt of goods? I'd like the label to be about 2 x 3 - most printers are either 1 x 2 1/8 or 4 x 6 - to small or too large. I need a printer and of course the labels, compatible with Sage 100. Thanks…
  • Crystal Reports: Adding a UDF for each Item Number on a Picking Ticket.

    OK. My lack of knowledge is really going to show here. For reference, we use Sage 100 2019 Manufacturing . I have a highly customized Picking Ticket created in Crystal Reports. We are a manufacturer, and when a customer orders from us, the Picking Ticket…
  • Upgraded to Sage 100 2021 No Paperless Button in Customer Maintenance screen

    Upgraded to Sage 100 2021, I am not seeing paperless options in my Customer Maintenance screen, is there a new right I need to activate to get that back??
  • Pick Sheets - Only Print Items that are Shipping

    Hopefully there is a way to do this. We are currently in a major backorder situation due to material shortages and have many orders that are partially shipping. For example, We enter an order containing pages of items (100-300 parts) We are able…
  • Source Data for Customer Sales History by Period Report

    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…
  • How to find the cause of variance between invoice total and the number on income statement ?

    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…
  • Sage 1099 Tax Reporting did not update after submitting to Aatrix - internet disconnected

    I'm using Sage 100 version 2020. I wanted to use Aatrix this year to submit my 1099's. I went through all of the steps in Sage, logged in to Aatrix, paid for e-filing. Between closing the Aatrix finish pop-up, and it going back to Sage, my internet cut…
  • Active Vendor List

    Is it possible to get a Active Vendor List? Lets say vendors that have been paid in the last 3 years?
  • Suggestions on how to separate Year end aje's? We do not have a 13th period, and I'm not sure we can add one.

    As the title says, we'd like to separate our year end aje's. We'd like to have an unadjusted trial balance, aje's, then the final trial balance. Sage was not setup with a period 13, and I'm not sure if that can be added at this point. Our Sage guru…
  • WE WANT TO PRINT/EXPORT TRANSACTION DETAIL FROM ACCOUNT MGMT/INQUIRY

    FormerMember
    FormerMember
    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…
  • Upgraded from 2017 to 2018. No AR Rep Code in Statement Printing.

    Hello, Our company recently upgraded from SAGE 100 2017 to 2018, and we have an employee who is trying to do Statement Printing. He reported that the field "AR Rep Code" is no longer under the Selections area on the Statement Printing panel, while it…
  • to link AP INVOICE HISTORY to a General ledger Detail Report...tables names?

    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…
  • paperless office

    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…
  • Cash flow report

    When I run the cash flow report I get the message "No data was selected for the following financial report(s)". I have assigned cash flow types to the accounts and the groups.
  • Historical Inventory Quantities

    Hello Sage 100 Community. I was wondering if any of you know a way to view an inventory snapshot of a particular date in history (historical inventory quantity). I'm just trying to see the quantities for all items at a particular date in the past. …
  • Creating a new tax class in Sage 100 does not work, has anyone done this?

    Creating a New Tax Class does not Work. I created a tax class "NL" for Nontaxable Labor so that we can report on this separately from Nontaxable. The system does not allow this to be added to the Tax code Nontaxable. I can add it to all my other tax codes…
  • MAS90 and Excel 2013

    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!