Browse By Tags

  • Change AR Aging from Invoice Date to Due Date

    Our company has decided they want to change the AR Aging Invoice by Invoice Date to Due Date. Is there anything I should be aware of or need to run after I change the option? I would assume there is some utility I need to run that will recalculate the…
  • Purchase Journal not showing up

    Hi everyone! I'm taking a Computer Accounting course in our college and we are using Sage 50 the student version. I am currently working on a company that is given here in the book and when I attempt to create an invoice the purchase journal won't show…
  • A/R Reports for a selected time period, including closed and inactive clients

    Is there a way to generate an accounts receivable report for a time period that includes matters that are closed or inactive?
  • VI JOB Cash Receipts Import - How do you set up the job to validate INVOICE TYPE in the user's source column/field to be either IN or PP and never blank or null?

    Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
  • Sage 300 2014 AR Receipt Entry numbering

    Hi Everyone, I have a client running on Sage 300 2014 and is facing challenges on AR document numbering. The system's AR Receipt document auto-numbering sometimes skip the sequence by a random number hence distorting the trail. Can anyone assist on…
  • Sage 300 AR Credit Card Receipt - can't post

    I have an AR receipt entry with a cc charge that has been settled but the receipt entry will not post. The charge was applied to two invoices. Before the batch was posted, another entry was made to those two invoices with a credit note applied to them…
  • 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…
  • estimates sales contract invoice

    Is anyone else having problems getting their sales estimates to flow to a sales contract to an invoice? I can go from an estimate to an invoice, no problem .... however to go from an estimate to a sales contract to an invoice it will not post. I can email…
  • Transaction occurred before previous fiscal year - No it Did not!

    I am trying to adjust a receipt that I made on July 31, 2022. I get a message saying "The transaction cannot be adjusted because the transaction date occurred before the previous fiscal year." Our fiscal year end is June 30th. I KNOW I did not create…
  • Accounts Receivable, Utilities Menu, Global Customer Field Change

    I am trying to make a change to all of our customers and have found the instructions on Sage Knowledge. However, I can't get past the first step because I can't find Utilities Menu under Accounts Receivable. Thank you for your help
  • 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…
  • overflow. maximum entry has been generated for batch

    I have a client whose Accounts receivable batches have not been posting to GL as there was a post in progress batch. I resolved the batch - closed period but when the next batch is posted, the system is processing all the hanging batches and then throw…
  • 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…
  • Paid customer and job remain on AR Aging Detail reports (not crystal)

    Our AR Aging Detail by Job is showing a job that has no balance, and our AR Aging Detail by Customer is showing that customer with no balance. There's nothing that I can find to adjust on this customer. I found some forum posts on receipts and invoices…
  • CSV TS importing or other Service - Ask along

    Hi All, I have been using TimeSlips CSV importing for years now. I have have some knowledge of various functions in TS if you need help or need a person to do importing/export time and expense entries via TS import (CSV file) just le me know. Also…
  • Importing invoices data from Chargebee in Sage 50 CA

    We are using Chargebee to generate our invoices for all recurring customers and we want to import the invoices’ data from Chargebee into Sage 50CA. Any suggestion on how to execute this basic accounting process? Thanks in advance
  • 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…
  • Year End carry over

    Client was invoiced May 16, 2019 and paid invoice in full via Interact May 31, 2019 (Year End) . It was not posted by bank until June 4, 2019 (New fiscal year). What do i do for an entry so i can reconcile May and June properly? Thank you
  • Data Integrity Check - difference between A/R balance and Unpaid Invoices

    I have just noted a difference of 0.01 between my A/R balance and Unpaid invoices when I ran a Data Integrity Check. When I investigated, I found that the difference arose on the translation of a foreign currency receipt to the home currency. The translation…
  • A/R Transaction Listings

    Hello - I'm looking to run a report that shows every amount we invoiced our clients for one year as well as what they paid in that same year. Basically invoice amounts and payments for 1 year. The invoice amounts look correct, but the payments that…
  • A/R invoice reversal

    A number of invoices were added in may however some of the may invoice dates were dated Jan so it ended up in Jan. The invoices were reversed in the general ledger since there were already posted. when the ages trial balance was run for the customers…
  • SAGE 300 CUSTOMER NUMBER CHANGE ERROR

    HI, I have used customer code change. Most of the codes have been changed succesfully. However I have gotten this error on some customers. Any help will be highly aprecciated A/R Customers: 3C0002 to 7C0001, Critical Error: [54353] unknown error…
  • A/R Repetitive Invoice - Change Reference?

    Is there a way to revise/change the reference code listed for a repetitive invoice? Or, do I have to delete and re-create a new one? Thank you!!
  • Re-opening a closed fiscal year

    I need to reopen a closed fiscal year, but I can't find any instructions on how to accomplish this.
  • How can I get Customer Memos to pop-up in Invoice History Inquiry?

    Hi, I have several customers with special requests regarding the sending of their invoices (mail, fax, e-mail to specific parties, etc). We created memos that pop up during Sales Order Entry. Unfortunately, that department doesn't always remember to…