• How fix posting

    Invoices were created in AR and posted in the next period by error. Credit Notes were applied , but posted in the current period. In order to fix it, we've tried to use adjustment for Invoice - error that it is overapplied Adjustment to credit notes…
  • how to "unlock"/"release" a credit note for applying to an invoice?

    Normally in Sage 300 when we create and post credit notes in AR, we can apply the credit note to a customer's invoice the next day. We created and posted a credit but on the following day it's not available to apply against an invoice nor does it show…
  • Sage 300 2023 Web screen AR unable to create entries

    When choosing AR Batch or AR Entry via web screens, the page loads but the detail and optional grid spin incessantly, making it impossible to enter any data. IMPORTANT: log in as admin, we are able to enter data. See screenshot.
  • A/R Receipt Batch List -> Default Ordering

    I was recently asked if there was a way that one could change the default sorting method for the selection of documents in an A/R Receipt Entry. It defaults to "Order By: PO Number" however, it was requested that I change this to default to "Order By…
  • Aged Trial Balance Reports

    Hi all, ever since we upgraded to Sage 2018 and now 2020 we are having issues with the Aged Trial Balance Reports mainly in AR. When running open for a customer the report now lists $0 adjustments. If we uncheck adjustments they of course are not listed…
  • Clear open negative balance in A/R

    We have a customer account with an open PY (overpayment of an invoice) where the funds will not be refunded to the customer. We want to clear and close the account but the AR receipt batch will not allow us to adjust off the open credit amount via a zero…
  • Unapplied Cash Excel Import - Error on posting batch

    Hi, We're using Sage ACCPAC 500 ERP. And i was posting an "Unapplied Cash" Receipt Batch (UC) , as i know UC Receipt cannot be applied with invoice. I plan to have another new receipt batch using "Apply Document" which i call for the UC and apply the…
  • AR Statements

    Hello. Does anyone use Sage to email out their monthly AR statements? If so, how is it working for you? Is it easy to set up? Thanks!
  • AR Import

    I am working on an AR Import for Sage 300 in the actual Accounts Receivable Module; I am having trouble with the taxes calculating properly. If I manually enter the invoice I put the total in the top line and the subtotal below as taxable to the right…
  • Correcting a Billing dated in future period

    I have an entry that won't post due to an error in the billing date. How do I correct the date so it will post in the correct period?
  • Deleting inactive A/R Customers

    I am going to delete a batch of inactive customers by dumping them out, changing their status to inactive, re-importing and then using Delete Inactive Records. Will that delete the ship tos as well, or do I have to mark those as inactive as well?
  • Identifying Unposted AR Transactions.

    Is there any other way besides looking at the ARUNPSTH table to identify unposted AR Transactions? Is it possible for transactions to disappear from the ARUNPSTH table without a post being done?
  • how to delete an AR Invoice Entry

    Hi, We are running on Sage300 ERP and we would like to know how to delete an AR invoice entry ( 3 entries).Is it possible to do so. Thanks.
  • Clear unapplied receipt payments from system

    Hi everyone, There has been some instances were receipts were made and applied to invoices in the AR, but some of the balance has remained unapplied. These are on the trial balance as a PY document, and I am unsure how to clear them. Any help is much…
  • find deleted entries

    Hi, Is there a way to find deleted entries in GL and the amount. These entries came from AR and AP and they've been posted in Subledger. And I'd like to know if we can find out the User who deleted these entries.
  • In AR module, I can't figure out how to change the date of a posted transaction. The amount will stay the same.

    In AR module, I can't figure out how to change the date of a posted transaction. The amount will stay the same. There is a few that the incorrect dates were applied and I would like to just go in and change the date. Is there an easy way to do this? …
  • A/R Invoice Posting Errors

    Hi, Have this error message in A/R Invoice Posting Errors: Invalid Input. Document currency (EUR) does not match customer currency (USD) Any idea? thanks for your help.
  • File customer does not exist. Please specify an existing file???

    Please Help! Since I upgraded from 6.0 to 6.2 2014 PU3, when I import file on AR customers I have this error message :'File customer does not exist. Please specify an existing file' Any clue?
  • Sage 300 and Office 365

    I have a client that is using Sage 300 2014 and just installed Office 365. They can still e-mail statements through Sage 300, but get an error when attempting to e-mail an invoice. Any ideas?
  • AR aging report and GL trial balance doesn't tie

    Hello, When I entered receipt, I input the wrong receipt date and posting date as 01/12/2014 while it should be 01/16/2015 to match my batch deposit date. Then, I cleared it in the bank for the month of 1/31/2015's reconciliation. Later, when I reviewed…
  • Edit AR Invoice Date

    Hello, I recently posted about 10 invoices from BL with the invoice date of 1/20/2014. Is there an easy way to change or edit this date in AR, without having to void the invoices and regenerate all 10 from BL? When I go to adjust the invoice in AR, the…
  • Subtotal buttons missing in OE/AR etc.

    Morning. I noticed recently on two new pc installs of Accpac (Version 5.5A) the total buttons are missing or barely visible. See attached. Typically, I see subtotal boxes near the bottom of this page. They are no where to be found. Same thing…
  • Customer Number Changer Error

    MS SQL v2012, V60 SU2, plenty of resources Using the Customer Number Changer am getting "Grid index out of range" entering a valid customer number in either entry box. The customer number is correct. Can access the customer in all other AR programs…
  • Salesperson Changes

    We recently had a salesperson leave. Is there a way to globally change the salesperson to a different sales person or is this a one by one sort of change? What is the easiest way to handle this? Using Sage 300 ERP Premium 2012 with a MS SQL 2008 R2…
  • Error occurred when opening view AR0021 (A/R Customers - Customers)

    Hello All, We face a particular issue on Sage Accpac 6.0 (Windows Server 2008/ Ms SQL 2005) Error occurred when opening view AR0021 Code : 2.788.1020 (Source SvrDBLink) View AR0021 is not a valid ID Code : 1.1768 (DS.adsARCMM) Error occurred when…