• Downloading/exporting General Ledger Detail Reports - so slow

    It takes longer than I consider normal to run the GLDR, print to PDF, and export to .xls. Does everyone have a slow export? I miss my last job's accounting software that had instant GL downloads (smart lists in Great Plains). Is there a way to speed it…
  • Add On the Fly Ship to in SO Entry in V2022

    We just upgraded from Sage 100C V2019 in that version and all the others before we have been able to add on the fly ship to addresses. In 2022 it looks like someone thought it would be a great idea to remove that permission able item, either that or they…
  • Duplicate imported payments

    We imported manual check entry payments via the Visual Integrator module. Accidentally uploaded twice, and now have duplicate payments posted. They're exactly the same, down to the same check number. Can I delete the duplicate? Or will I have to void…
  • General Journal Posting - duplicating

    Has anyone run into an issue with a general journal posting that occurred months earlier now showing a different result if you were to run the report today? In January we had one entry, and if we run the report today, it shows 3 of the same entry. For…
  • Anyone needing to set up Penny Test processes in Sage 100?

    We need to have the ability to use Penny Test to verify bank accounts for a vendor instead of Pre-Notes. There are too many ways that fraud can occur by just using Pre-Notes. I created the following idea. If you agree, please vote for this. www5…
  • How to record a wire transfer in AR

    How do you record a wire transfer from a customer in AR? In AP there is the selection drop down for Wire Transfer, but not in AR. I read if we use ACH/Credit Card, it doesn't post to BR. So do we use Cash and if so, how/where do we enter the long 15 digits…
  • error #47 substring reference out of string in Sales Order

    we are attempting to delete a SO. we have successfully done so to other SO but this one item gives us an error #47 Substring reference out of string and we are unable to do anything.
  • ERROR " This batch will be retained because deleted entries exist" in General Ledger

    Hello, I tried to delete a batch in General Ledger, but I received this error "This batch will be retained because deleted entries exist". Has anyone had this error before? How to fix it. Thanks a lot! Jun
  • Moving an overpayment from one customer to another

    I have a customer that has about 10 different divisions in different states. I received a few checks today , and while applying payments i accidentally over received in one account. So now that account shows -$239.40 , however i need that to be transferred…
  • Check Printing Setup Stub Check Stub Sage 100

    How do I change the Check Print Set Up in SAGE 100? It is currently set for Check, Stub. I need to Change to Stub, Check, Stub and retain that setting for the future. Currently have to change it every time check is prepared. Thanks - DJS
  • Accounts Payable Question: Invoice of $10.00 but we paid 11.00. How do I enter this to show the credit?

    Our accounts payable person is asking how to resolve an issue that should be simple, but I'm not sure how to resolve it. In simplistic form, we entered an invoice for $10.00. We paid $11.00. Sage won't let us enter a payment of 11.00. How do I pay…
  • Custom Report Printing

    Apologies if this is not the correct category. From time to time we receive the following error when attempting to do custom report printing. The temp file is there. The only fix seems to be rebooting the server and deleting the file. Sage 100 will then…
  • 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…
  • Vendor file access

    Is there a way to classify vendors in the AP module to customize access to certain vendors? We handle some employee compensation through the AP module, and would like to restrict access to those "vendors" while allowing the necessary access to all other…
  • Looking for a Sage100 table for General Ledger with invoices history data.

    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…
  • Closing multiple periods at a time.

    Hello, I am newly working as the administrator for SAGE, and have a question about closing multiple periods at a time. Our company currently has the current period set to a time two years ago, and I am currently in the process of helping them catch…
  • Delete Budget Code with Activity

    We have revamped our naming convention for "budgets". I want to delete the old budget codes. I went into General Ledger, Setup, GL Options, "Budget" tab. When I click on the old budget name I want to delete, I get a message that states I cannot delete…
  • Pay AP Invoices with Bank Purchase Card through an upload to the bank

    have a client that wants to do the following... "Process AP invoices just like we currently do, but the vendor set-up will reflect it being a credit card payment (i.e. rather than live check or ACH). When we process the weekly AP batches, we will…
  • Report vendor payments by specific vendor and date range? How do I do this easily?

    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…
  • Sales Report by Ship To State

    We need to create a sales report by Ship To Address that shows the State we shipped to and dollar amounts shipped, to deal with the the hot mess that is the current sales tax situation. Thanks!
  • Upgrading

    Has anyone upgraded their Sage 100 to Sage 100c? (not the cloud version) We have been approached to do so but are always reluctant to jump on a new version that is untried.
  • Change password on initial sign on

    Can there be a requirement for users to change the password after initial sign on? The password can only be created by someone with access to User Maintenance and I know the user has the ability to change their own password after logging in, but there…
  • Aging Categories not being updated before invoice printing (random occurrences)

    We are having an issue where the latest payment of a customer is not being reflected in a printed invoice. This issue only happens on very rare occasions, and we do not receive any errors or notifications before it happens. Below are a few observations…