• 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…
  • Payments collected During time of Sales order not hitting GL Account

    I have noticed that for the month of March, no credit card payment that was ran at the time of the sales order has hit the GL code. This is odd because it only happened for the month of March. Any ideas on what could have happened and how to fix it…
  • Need support for quarterly and year end closings. Sage 100 with Job Cost

    We are network cabling contractors using Sage 100 with Job Cost and lost our Sage 100 support person. We have a CPA, but need someone for quarterly/year end closings. Located in Orange County, CA near John Wayne Airport. Any referrals would be appreciated…
  • Sage100 - Cash Receipts Entry - Deposit Remaining - Out of Balance

    AR Clerk entered a deposit and distributed all the checks to proper accounts and invoices. On the Deposit Header tab the "Cash Amount Remaining" and "Deposit Remaining" fields each have the amount of the last check distributed. When I click on the…
  • Reverse posted prepayment and credit memos

    We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account. To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…
  • Why can not see bank balance?

    There is only one bank code on my Sage 100. Cash receivables and payables have been recorded on the system and I did bank reconciliation. But I do not see any balance of cash receivables on the GL balance sheet. I would be grateful if someone…
  • AR Cash receipts Detail is being used by another task and cannot be opened

    Good morning, I just enter some payments from customers payments but when I was updating a message comes " any idea how to fix this. (I have sage 100 adv. 2019 6.10) Thank you for your help
  • Create Repetitive AR Invoice Batch

    Would like to get instructions on how to create a repetitive AR invoice batch.
  • Service Invoice Discounts with Service Contracts

    Hi, Wondering if anyone knows how to automatically calculate the the discount that a customer receives when they are on a service contract plan through the assembly 9-3 screen? Some background I currently have all my service technicians on Sage Service…
  • Bank Reconciliation/Auto Check Reconciliation

    Hi We are looking into switching banks from Wells Fargo to a smaller institution that is aligned with our values. The bank we are looking at does not provide custom designed files for use with Sage 100's Auto Check Reconciliation. Can someone tell…
  • What are the steps for the Sales Order process to Posting to AR? How is the AR PDF log created?

    Hi What are the steps to post a sales order through to AR? How is the AR pdf log created?
  • AR Invoices with different customer names

    I have a customer who used to be set up as a different name. On the old name, there are outstanding invoices. On the new name, those exact same invoices are marked as a prepaid. How can I clean this up and get all invoices under both names to a zero balance…
  • Credit Memo to fix Tax payable?

    We have an invoice that was created for a customer with sales tax included. However, the customer is tax exempt and I'd like to know what the easiest way would be to fix this? Would it be to create a credit memo and then create a new invoice?
  • Check, Deposit, and Adjustment Entry

    Good morning! I work at an equipment rental company with seven locations (two more being added within the next few months). The company uses Point of Rental software for the daily business, and each day I download the previous day's journal entries into…
  • How to print a posted sales journal batch if knowing A/R batch number?

    Hi, Monthly I have a task to import data (all Credit memos, Debit memos & Invoices) into our Sage 100 & post them. Usually while proceed my batch in Sales Journal module, Sage 100 let me Print (or Preview) two reports: one summary & one for details…
  • AR Payment term due 15th or 30th of the following month

    I need some help wrapping my head around creating this AR Terms Code. This is what I need: Invoice dated 1st - 15th payable 15th following month Invoices 16th-31st payable 30th following month Thanks for any suggestion!
  • Sub ledgers don't match financial statements

    I am new to Sage. I am reviewing books for a client and find that none of their sub ledgers (A/R, A/P or Inventory) match the financial statements. In QuickBooks I know how to trouble shoot these; but not so in Sage. Can someone point out the common mistakes…
  • AR correct posting dates

    AR - created a CM and dated it one date (1/18/17) and posted in to another GL period (2/8/17) thus throwing my recon for January off. I know it clears out in February but would like to correct in January. Can someone please help me? Thanks
  • AR - Need to use an overpayment on one invoice to pay off another, same customer

    A customer overpaid and then next month ran a schedule for same amount. Need to take the overpayment from first invoice and pay off second invoice
  • CR error

    CR error - posted a deposit and it did not update correctly. Shows posted in CR but not in AR. Its like the deposit is hung out there. How to fix? I can't delete the deposit because it is gone. I did update and its just caught up! I need to rebuild or…
  • monthly invoice statement

    We have customers who require us to send them a monthly statement of invoice's during that month. We do not want a cumulative Aging statement. Is this something I have to create using a custom solution or does MAS200 5.1.5 2014 have a canned report…
  • Commission edit register update and a salesperson link didn't update. What do I do?

    All the amounts were correct and when I printed and updated the commission register I saw 1 salesperson whose vendor link was not updated. Will is transfer to AP ? How can I correct this? I manually updated his link in salesperson maintenance, but how…
  • Sales tax collected discrepancies

    We have recently noticed a negative amount (overpayment) on our Sales Tax Payable general account. We have been submitting sales tax based on the "sales tax collected" amount in the Sales Tax Summary Report. We have had large projects going thru SAGE…
  • Cash Receipts Entry with Sales Tax

    Hello - Our company does a significant amount of AR work and currently we are entering all cash receipts as an invoice first then have to go and credit the invoice off in order for the sales tax to report correctly - is there a way around this so we…
  • setup a new customer for new warehouse under sage 100 Adv erp 5.008.0

    I have already customer like 10-adv. and also under 20- sec and so. when I try to use 50- does not work. under customer maintenance. it say 50 is not on file. how to add the new 50 series for customers in AR/ Thank you for your help.