• How do a remove a credit card partial payment that was over applied to an invoice

    I have a client that has processed a credit card payment that was supposed to partially pay an invoice. They over applied the payment so the invoice now shows up as paid, but they credit card payment show up in the Aged Receivables because it was over…
  • 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.
  • Invoice number table

    Hi there, Is there a document for Sage 300 2016 to direct the user as to which tables should be edited in order to change an invoice number in the AR module. thanks
  • Overapplied AR Receipts

    Hi all Can anyone advise how you prevent a user from over-applying an AR receipt? and secondly, if a receipt has been overapplied how do you reverse it? Thanks
  • 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…
  • Sage 300 ERP - A/R Invoice Summary

    Hi All How can i run something (and download to excel) that shows all invoiced A/R customers and the amount billed to them for a specific period of time (lets say 2016). something that looks like: Thanks! Vendor A $50,000 Vendor B $100,000 …
  • How to apply an over-payment to an AR invoice?

    I am trying to apply a payment in AR receipts that over pays an invoice and I want the over-payment amount left in the customer account to reference the invoice number. Is there a way to do this in Sage 300 (version 2016)? thanks
  • DEPOSIT DETAILS ARE NOT APPEARING IN THE BANK RECONCILIATION

    HI, SAGE 300 ERP 6.1A PU4 WE HAVE POSTED THE BANK RECONCILIATION WITH A DEPOSIT WHICH WAS HAVING 38 ENTRIES. BY MISTAKE THE DEPOSIT IS RECONCILED WITHOUT SELECTING THE OPTION "CLEARED BY DEPOSIT DETAILS". DUE TO THIS NOW WE ARE NOT ABLE TO SEE THAT…
  • Miscellaneous Receipts with no offsetting sale/Cash-back for customers

    Our company recently held a raffle with the proceeds going to charity. I need to receipt the amount into sage so that later we can write a check for the donation. Is there an easy way to do this with no offsetting sale? I was going to do a General Journal…
  • 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…
  • Importing in AR Receipts using single line items

    I know how to import into AR Receipts in Sage 300. Is there a way where Sage 300 can read single line items per transaction. For example, on the import file, I just want a single line item on the CSV for every cash receipt. Right now, Sage 300 requires…
  • reconcile statement not posted

    Hi there, We are using sage 300 ERP 2014 and We have a transaction in reconcile statements showing not posted, we need to have it outstanding.When we go to the detail of the transaction which has 3 entries, 2 entries are fine with the outstanding status…
  • How to reverse receipt entry as customer cheque bounced

    Does anybody know how to do this? I cant do an adjustment because it has been applied, likewise with a refund entry. I am really stuck and the only way i can think is to do a credit note to an invoice and then re invoice. This seems crazy though. There…
  • Credit Note in OE not having journal entries?

    Hi, Sage300 V2014 SP3 Created a Credit Note In OE using a non-stock item that is NOT applied to an invoice, then created a DN for the same customer with the same non-stock item to correct the first CN and then reentered a second CN. Day End Processing…
  • Sales Tax on a Cash Basis

    How do I create a sales tax report on a cash basis? In Illinois small companies may file their sales tax return on a cash basis. How can I see the items that have sales tax that have been fully paid.
  • Non AR Cash Receipt

    How do I generate a report that shows me the non AR cash receipts? Or how do I generate a report of only the MISC cash receipts? Currently the only way I know how to do this is to print the AR journal and ignore any transactions that include the AR account…
  • Different AR receipt currency

    Hi there, We have a customer with GBP as default currency. They have made a payment in USD with equivalent GBP amount and it has to be deposited in our USD bank account. What has to be entered in the rates override window to reflect this. Our functional…
  • AR and AP Aged Trial Balance

    I have a need to age credit notes just like Invoices in both the AR and AP aged Trial Balance reports. The default report places all Credit notes as current regardless of the credit note dates. There is a need to aged the credit notes just like the invoices…
  • Incorrect Procedure. Exchange Rounding Account is not defined - although can not define rounding account for CAD accounts.

    Some of you have seen this one before - I brought it to the tech support chat but really didn't help me get anywhere as they were effectively asking me to run RV spy nightly on Day end until we caught one of these occurring... (sigh - RVSpying our Day…
  • Sage ERP 2012: Some AR Statements do not print after Product Update 4

    I have a client running Sage 300 ERP 2012 Premium Edition, MSSql. They were fine printing AR statements until we installed Product Update 4 and now only 3 out of approximately 100 statements print, and it is always the same 3 that print. I have run an…
  • Customer Credit Terms - Discount Available

    Hi, One of my clients use the following Terms and Discount for their customer. Their standard credit terms is four month. If the customer paid within four month - 20% Discount on Invoice Amount. within five month - 15 % within six month -…
  • process for overpayment from customer

    Hi everyone, I 'd like to ask about the process to deal with overpayment for our customer. we continually receive overpayment from our customer, eg double payment for one invoice... Our current process is enter as unapplied payment if there is no…
  • RE: AR reconciliation (subledger to general ledger)

    This solution applies to most versions of most software, and to Sage 300, and Ptree 50, too. Post all o/s AR transaction to AR, and to GL. Then run the [AR TB], and the [GL TB for the AR control account] at the END of the furthest period open in your…
  • Reinstate cleared AR paid transactions

    I have a client who has lost a significant number of historical AR Fully paid transactions without explanation . We suspect someone cleared history, but the client can't see how this was possible. In any case, it would appear that only AR was affected…