• Fixed Assets

    Running Sage 100 Cloud 2019. I have not previously used Fixed Assets.  When I try to run it a message tells me it isn't installed but it is in the list of installed modules in Company Maintenance.  I can't find a phone number or website to get help…

  • Paperless Office Slow

    We are experiencing extreme lag when posting Journal and Daily Transaction Registry. This has slowed significantly in the last couple of months and would seem to be tied to Paperless / Adobe PDF. Our Test Company environment without paperless office is…

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

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

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

  • How to make new customers appear in drop-down menu?

    When we had Sage installed, all of our customers were imported into the system. When I start to type in the 'Customer No.' field, a drop-down menu appears with predictions of those customers. However, when I add a new customer, I have to click the magnifying…

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

  • Period End - multiple years need to be closed

    I have a situation where Period End Processing has NOT been done in over 10 years. I am trying to get things cleaned up. Is there a way to close multiple years without having to close out each module for each period for over 10 years? That would be 120…

  • WIP was turned off and it affected our GL postings. Is there a way to fix these without looking at each S/O Journal?

    Currently we use payroll for expensing the labor expense on our setup.  There was an automatic offsetting journal entry that would zero out the expense for the labor transactions added to an S/O.  When WIP got turned off the offsetting transaction for the…

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

  • I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid)

    I am getting an error message while trying to import AR_InvoiceHistoryDetail records into Sage 100 2021 from Sage 100 2018. Error #112 Keyed File Error (Record Key Size Invalid), I got an error during month end close about an open invoice in the system…

  • Delete or reverse a JE

    I am new to Sage and need to delete a couple JE's that were in the previous (March) period-I have figured out how to reopen the period- however only 1 or 2 have deleted-the others tell me that they can't be deleted until all information is removed from…

  • Item Valuation Change Selection: Phantom Connected Users

    We have had this problem since switching to Sage 100. When we try to change an item's valuation in the Item Valuation Change Selection task in Inventory Management, and all users are logged out of Sage, we get the below dialog:

    When I click More…

  • 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 to build…
  • Getting ready for On Site implementation and need Minimum System Requirements

    We have started the process of implementation of Sage 100c Premium.  My support portal is still not connected to our account and am in need of getting the Minimum System Requirements for the servers and workstations.  I will be grateful if someone can forward…

  • Positive Pay Export for Union Bank

    Has anyone created a Positive Pay Export for Union Bank or any bank that requires the detail record to be on two separate lines?  

    Here's a sample of the output file

    Sample data transmission
    payee positive pay Input format
    908123456700002000720312070000029375…

  • How to reverse AP check/electronic payment against 1 of 2 invoices

    We are on Sage 100c Advanced v2019.2

    We electronically paid 2 AP Invoices with 1 E-payment.  The second invoice should not have been paid against this vendor.  When we go to reverse payment, the total amount can't be changed to reflect only the 1 incorrect…

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

  • Looking to Customize Customer Statements Sage 100 2019

    I am looking to customize customer statements in the A/R Period End section. I can set up basic customizing by setting up a new form and going into design and making my changes, but I want to limit which customers are generated without having to enter…

  • Visual Integrator: Creating a job that imports invoices into AP Invoice Data Entry

    Hi all, 

    I hope everybody is doing well. I apologize in advance if I post this in the wrong section. 

    I recently discovered the Visual Integrator module for Sage 100 and have been trying to learn how to create a job that imports an Excel spreadsheet containing…

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

  • Reverse Auto Check Reconciliation

    Hello,

    We began using the Auto Check Reconciliation utility in Sage 100.  We imported a list of cleared checks from our bank, with the account number, cleared date, and amount.  We proceeded with the auto reconciliation, and now we need to completely reverse…

  • Paid invoice not showing in transactions or history

    I have discovered that I have some invoices that have been paid, but the invoice is no longer showing up in transactions or history. The payment is there though. I'm not sure what happened but it puts my expense GLs out of balance. What could have happened…

  • Cannot prevent posting to prior period in Subsidiary Modules if General Ledger is open for that period

    I have several clients that have this issue and found an updated KB article on Sage's website.  The article was originally created in 2015, but it was updated in 2020.  Is Sage still working on the issue?  When will it be resolved?  

    Cannot prevent posting…

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