Browse By Tags

  • 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…
  • 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…
  • 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 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…
  • Journal entry flow when invoicing, and receiving funds through our stripe account.

    Hi, I have just linked our Stripe account with our Sage software. Before I begin using this feature I would like to make sure I have it set up correctly and that I know what the flow of Journal entries will be. When I create an invoice through the…
  • A/R 1200 Control Account

    FormerMember
    FormerMember
    Hello I have a novice question.... but it is really holding up my production. When I issue an invoice in "Revenues" and then a "Receipt" when payment is made, is that payment automatically linked to the1200 A/R Control Account in the COA? I am carrying…
  • A/R Aging does not reconcile to G/L balances.

    I am trying to reconcile the A/R aging to my G/L and I can't get it to match, no matter what report I run. It matched in November, so it has to be something that happened in December. I have checked the G/L accounts and all of the transactions were generated…
  • Removing or Decreasing A/R Invoice

    Hello, I am new to Sage and have found that you can not do a JE to reduce an A/R invoice attached to a job. My client received payment for a particular invoice long ago yet it still shows in A/R so how would I remove that invoice without voiding it…
  • combine two Accounts Receivables

    I am trying to combine tow A/R into one. here is the scenario: A/R account has an account left over from last year. So when I tried to add to it it didn't allow me, the account didn't show up as it is a control account. Than I changed it to A/R general…
  • 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!
  • linking two accounts Receivable to balance data integrity checks

    Hey there, When setting up from our last accounting software we had two accounts receivable, one in cad $ and one in us $, as well as three accounts payable, the extra being for GBP. When linking my accounts receivable to my customers for the linked…
  • How to undo AR Receipt Entry

    Hi, We have an AR receipt Entry batch with 2 entries my first entry is ok but I want to undo the 2nd entry in order to put back the document number in the first entry.
  • Transfer A/P amount to A/C to clear?

    Hello, Instead of making a purchase voucher, I made a general journal entry and cleared the accounts payable account via cash. However, instead of this amount linking to the accounts receivable, I know have amounts in both A/P and A/R. How can I transfer…
  • Unapplied amount AR receipt Entry

    Hi there, In accounts receivable invoice was entered for customer “ABC” in the amount of $50,000 another Invoice was entered for customer “XXX” in the amount of $500. That was all ok the problem happened when the receipt entry was made. There was…
  • I need help finding the cause(s) of my Accounts Receivable being out of balance.

    I am seeking suggestions & guidance on dealing with &/or finding the root of our A/R being out of balance. Here's what I've done/fixed so far: I started filling in for a bookkeeper a couple months ago while she was off work a few weeks (due to a stroke…
  • Foreign Currency Transactions

    Our company is CDN but also does business in the US. So, we have set up a US bank account. We invoice our US customers in US funds and they pay accordingly. We also purchase US products (COGS, etc.) and pay for these using our US account. My problem…
  • Is there a way to disallow new order entry or shipment entry for a customer that has gone past 30 days? or their allotted days of credit extended?

    We extend 30 days of credit to some customers who we need to stay on top of. At 30 days, we need ACCPAC to disallow anyone from entering a new order or shipment. Is this possible out-of-the-box or with an add-on?
  • Is there a way to edit OE invoices in AR?

    We use OE module to create invoices selling stock and non-stock inventory items from IC module. Sometimes there are errors on the OE invoices that need to be changed such as wrong taxes charged, unit prices don't match customer PO, etc. Sometimes the…
  • 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…