• Navigating between GL, AP and AR

    I am wondering if it is possible to navigate directly between the A/P ledger or A/R ledger and the General Ledger. For example, if I'm looking at an A/P transaction in the A/P ledger, is there a quick way to navigate to the resulting G/L posting? And…
  • Customer Number Change must be upgraded, but how?

    When attempting a Customer Number Change as part of the day-end process the day after upgrading Sage 300 - 2022's Payroll module to version 8, we encountered the following error: Error: Newer version of US Payroll was detected. Customer Number Change…
  • Load Sample Data and Errors Open/Load View AP0220 and AP0222 - Closing UI due to failure activate Sage 300 data sources [A/P Vendors]. No problem other data just sample !!!

    Hi everyone, I have Sage 300 2022 in my laptop last Update and I get this error when trying to open Vendors. Similar errors with its related AR views ven opening Cusromers. Apparentlky its an issue related to Vendor Contacts (Customer Contacts) but…
  • Sage 300 2014 AR Receipt Entry numbering

    Hi Everyone, I have a client running on Sage 300 2014 and is facing challenges on AR document numbering. The system's AR Receipt document auto-numbering sometimes skip the sequence by a random number hence distorting the trail. Can anyone assist on…
  • Sage 300 AR Credit Card Receipt - can't post

    I have an AR receipt entry with a cc charge that has been settled but the receipt entry will not post. The charge was applied to two invoices. Before the batch was posted, another entry was made to those two invoices with a credit note applied to them…
  • 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 anyone seen…
  • 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…
  • 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'…
  • 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…
  • 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…
  • 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…
  • 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 generated…
  • 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…