• 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…
  • Posting AR or AP Batches using accpac advantage

    Hi all, I have already created C# program using Accpac Advantage to import AR and AP Batches into sage in Ready to Post Mode. But my client wants it to auto post after import to sage. So, is there any tutorial or example that I can reference for doing…
  • 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.
  • Error when reprint Customer Statement

    Hi all, My customer statement failed to print for the first time, when I want to print for the second time it prompt me to reprint the failed attempt. The I go to reprint but get this error instead No information on the RVSpy and Event Viewer. …
  • AR Customer default price list

    Every year I have to change AR Customer default price list. We have 90K customers and import from excel takes more than 72 hours. Hardware is definitely not an issue since ship to locations are updated for less than 12 hours. Using minimum of data in…
  • 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…
  • Invoice Details (ARIBD): what is "Extended Amount w/ TIP" ?

    Good morning, I think this is the correct forum, but please advise me if not: Looking at the data dictionary for table ARIBD (that is, the "Invoice Details" table which lives in the ( AR ) module) - every row represents an "invoice line item". Now…
  • Vender Ledger

    my predecessor & I are preparing for my 1st YE. We were looking for a Vendor Ledger and can't seem to find where it could be located. Can anyone point me in the right direction? Please & Thank you...
  • 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?
  • OE Transaction Credit Check 2018 vs 2012

    Hello, In SAGE 2012(right) O/E Transaction Credit Check, we have a brief description for the AR Transaction Exceeds of the Customer, when it exceeds the Transactions Overdue Day and limit amount set in the Customer master . However, the same description…
  • AP and AR Contra entries

    Hi, Is there any way to contra transactions and show a net balance if a vendor is also a customer? Priti
  • 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?
  • AR debit note

    Hi, Just noticed that in AR debit note, the document date and due date is picking as the same date even if the customer has a credit term of 30days. Is there any reason for this and how can this be changed? Sage 300 ERP 6.0 Priti Kumar
  • 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?
  • Excel crashes printing A/R invoices through VBA - MSVCR120.dll

    I have some macro code that is printing A/R Invoices to PDF files. The code works fine on my laptop, but on the client workstation, it crashes. Event Viewer identifies MSVCR120.DLL as the problem. The OS and Excel versions are identical on the workstation…
  • AR Receipt - Special / invalid characters in AR check / receipt field causing Bank Reconciliation issue

    A user entered a '[' within text in the AR Receipt Check/Receipt No. field which then caused an issue in the Bank Reconciliation. We are on version 2014 (300 Premium ERP) (Build 1) (Product Update 1). A posting by Connie H. in Sage Ideas database titled…
  • 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.
  • 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.
  • PJC missing customer number - change from Internal to billed Job

    We are new to the PJC module and when we started to setup the jobs, we ASSUMED that we could add the customer numbers later...i ASSUMED wrong. Now, i have these jobs loaded with transactions and was wondering if there is a way of opening up the job so…