• 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…
  • Batch date in Sage 300 is previous than the prepayment

    In October I applied a payment received as a prepayment. When I offset the payment I accidentally put Batch date as September, but the receipt date the same as the payment (October). My question is if it will affect the month end in September and October…
  • AR module disappeared

    Sage 2019 app n db on one server. SQL database in use. Users of AR module were complaining of batch posting being slow so a reboot was done. After reboot realized , Ar module completely disappeared. Steps taken: 1. Did a sage full repair yet AR…
  • 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…
  • A/R Statistics

    I accidentally cleared all A/R Statistics instead of doing just the year-end activity. So now I'm in big trouble since we use that a lot. Does anyone know of a way to get it back without having to go to the backup? Or maybe an add-on I can purchase?
  • 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…
  • Hide Delete Button in A/R Receipt

    I'm unable to HIDE the delete button in A/R receipt batch and A/R receipt entry screen using UI profiles. The method works with A/P and other screens. but, not with A/R. Any Advice would be appreciated. Thanks Nish
  • 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…
  • Accounts Receivables SAGE 300

    Hi Good Morning, could some one list all the tables in SQL server that are related to Accounts Receivable Aging Report. We have SAGE 300 2021 version thanks GP
  • 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…
  • Accounts Rec - Balance Sheet and AR Report Don't Balance

    What reports can we used to drill down and identify why there is a difference between our general ledger AR account and the balance shown in the AR Aging report? We have several months that are balanced - and then we will see a difference... than…
  • 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!
  • Accounts Receivable - A/R Document Inquiry Screen - Displaying Amounts that include Tax

    I was wondering if anyone else has an issue with the A/R Document Inquiry Screen including Tax as part of the Detail and Total Amounts? We are still using 2018 PU3 Classic, has this been corrected in a later release or in the web screens? It seems…
  • 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…
  • How to calculate sales commission on aged receipts

    How to calculate sales commission on actual receipts from debtors(credit customers)
  • 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…