Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
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…
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…
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…
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.
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. …
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…
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…
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…
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…
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…
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…
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...
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…
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…
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?
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
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?
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…
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…
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.
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…