Sage 300

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…

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…

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?

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

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

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…

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…

How to calculate sales commission on actual receipts from debtors(credit customers)

Hi all - When doing A/R Refund Entries in Sage 300 on each detail line you can specify Payment Type. The default values are Check, Cash, Credit Card. I do not see where these values are maintained in setup or otherwise. Does anyone know if you can add…

Sorry if this has been discussed (and answered) a lot, but I can't seem to find a decent search function for the forum. Trying to post an AR invoice batch but it's stuck in Post In Progress. When I run data integrity, it says no errors. When I try to…

Hi Team A client of ours raised some invoices from order entry against some customers. All those invoices came and set in AR Invoice Batch list, the batch list got posted and those invoices were ready for receipt entry Issue: the user did the receipt…

Is there anyway you could help on my query? I have done reverse transaction, unfortunately i have entered an incorrect date. how to reverse the reverse transaction ive made or correct the date?

Greetings, We are running Sage 300. We are having difficulty ascertaining the impact of posting future-dated Accounts Receivable drafts for a customer on their credit limit. Does posting future-dated A/R drafts to a client's account in our Sage…

Hi there We are running on ERP 2017 Outlook 2010 and following error occurred when processing Accounts Receivable Invoice to email:"Error: Description. Mail delivery failed. Use the Email tab on the Company Profile screen to send a test email and confirm…

Is there a way to determine which Invoices are listed as OE Pending from a database level whether it be looking at the OEINVH or some other table as I am trying to build a Crystal Report based off these Pending Invoices.

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.

I imported thousands of customers in Sage 300. How can I delete a range of customers in the system? I called Sage Support and they said you need to delete one at a time. Is this true? I have to click delete 10000+ times. Isn't there a utility to do…

Please Help! Since I upgraded from 6.0 to 6.2 2014 PU3, when I import file on AR customers I have this error message :'File customer does not exist. Please specify an existing file' Any clue?

Hello. We are trying to create a bridge between our custom rental management system and Sage 300. The goal is to push data from our system to Sage using SData to create invoices. Based on what we have read on Stephen Smith's blog and found on Sage Guru…

I was applying prepayments in the AR receipt entry screen. Unfortunately in a moment of distraction, I selected the same prepayment amount twice. Now every time I post a new batch I get an error batch and the amount of the original posting is showing…

I'm trying to assign Optional Fields that I created in Common Services to to the A/R Optional Fields Module. Every time I press Save, I get this message: Incorrect procedure. Cannot insert, update, or delete A/R Optional Fields until all other users…

Hello, I recently posted about 10 invoices from BL with the invoice date of 1/20/2014. Is there an easy way to change or edit this date in AR, without having to void the invoices and regenerate all 10 from BL? When I go to adjust the invoice in AR, the…