• AR Receipts Reversals

    The AR Customer Transactions Report displays the characters "R" alongside some PAYMENTS transactions and the Legend at the end of the report shows this to be "Reversals". We understand that the reversal process triggers some entries which would invariably…

  • A/R deposit shows Not Posted in bank rec

    We have a client running Sage 300 v2021.5.  They have an A/R Receipt batch that was posted in A/R, but in Bank Services bank rec screen, it shows as ‘Not Posted’. 

    Because of this status, they cannot clear the deposit in their bank rec.

    Has…

  • 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…

  • Importing Receipt Batches

    I am able to import misc receipts into Sage 300 AR successfully.  I create a batch, set my bank and batch date which equals my deposit date, then import a single file of multiple misc receipts to reflect that day of deposits.  My question is that I have…

  • Can't find optional field in ARPostedDocuments endpoint

    Sage 300 2019 PU7

    We can't find Header Optional fields for posted documents in ARPostedDocuments endpoint

    Which endpoint can provide posted documents header optional fields in AR?

  • A/R Prepayments Payment Plan

    Customer Receipts are posted in the A/R as Prepayments because there is no Invoice.

    There is a plan on when and how much the Customer should pay.

    How can this Plan be managed in Sage 300 without raising an Invoice?

    An invoice is raised at the end when…

  • Returned check nsf

    I had a check deposited in Feb and returned back in March my question is.. can I Reverse transactions in March the date the check was returned? I don’t want the bank to be effect for February it has been reconciled and posted. 
    thank you newbie here…

  • 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…

  • Sage 300 A/R Source Application

    Sage 300 2019 PU5

    We have Invoices generated in the A/R using Data from different systems through integration.

    There is a need to identify the systems where the Data came from on the Invoices.

    Is there any risk using field  'SRCEAPPL' in 'ARIBH' and 'ARIBC…

  • Negative AR

    1. How do I do negative receipt for knock off the credit note to customer ? 

    2. How do I transfer the outstanding Credit Note of customer 1 to customer 2 ? 

  • How to Delete a Duplicate Credit Card Recipts

    I have a couple of duplicate A/R Receipts that cannot be posted because the invoice is fully paid.  I attempted to delete the receipt, but I get a message that it cannot be deleted since it is a credit card payment that has already been processed by PAYA…

  • 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 the…

  • 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 adding…

  • How to handle Rental Deposits in Accounts Receivable.

    A Rental Company Company is using Sage 300 A/R  for its Tenants.

    They have decided Tenants will have to pay Rental Deposits.

    These Deposits will be refunded to Tenants once they leave.

    How can A/R treat Rental Deposits without affecting the Normal transactions…

  • Adjustment of fully paid AR invoice

    We have 3 invoices where the payment was applied incorrectly last month.

    The early payment discount did not apply automatically, so the first 2 invoices had the full amount applied to them, and the third one had those amounts left outstanding as a balance…

  • 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…

  • AR receipt batch posting slow

    Hi Support,

    One client is have an issue with AR receipt batch posting. The posting hangs even if there are only a few entries to be posted. Sage 6.1, PU1

  • Automatic allocation of payments for customers with zero balances

    We have just completed a large import of about 35,000 invoices and related payments from a large number (to me) of customers. Many of these customers now have a zero balance in A/R.

    We need to allocate prepayments, etc., to apparently clear the prepayment…

  • Question on A/R General Ledger Set Codes - What Happened?

    I believe I may have set the G/L accounts -- in A/R Account Sets -- incorrectly.  Here's my set-up:

    We have just performed a large import of almost four years of invoices, credit notes, and payments.  In some cases the payments could not be auto-matched…

  • AR Invoice not available for allocation

    Our client has an invoice that is not showing up as available to apply to receipts, credit notes or refunds.

    There are no open batches.

    When viewing customer inquiry also I cannot find anything allocated to the invoice.

    I went as far as comparing an invoice…

  • 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

  • AR Interest invoices - Sage 300 2017.2

    Hi,

    Does anyone know of a way (add-on? or Crystal modified?) to print an AR invoice with the original amount and interest due, when appropriate?

    Thanks,

  • AR Subledger Balance by Month

    How can I get the balance of the AR Subledger by month for an entire year or date range? The only way I know is to create an AR Aged Trial Balance Report manually for each month... but I just need the balance.

  • 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…

  • 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.