Sage 300

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…

Bank Reconciliation issue: We had to few receipts incorrectly entered in AR Module. We reversed them using the reversal feature in Bank Rec module. Reversal was recorded correctly in AR Module and GL. But in the Bank Rec these reversals are showing up…

Hi Am getting this error when adding or posting an AR Invoice batch in Sage 300. System error. Call to lnkCommitTrans failed [227] I recently did a database move using the dump and load. Now my AR batches dont want to post. What could be the…

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…

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…

I have a customer that has over 1,000 customer credit cards stored with Sage Payment Solutions (now PAYA). They are planning on changing banks and through Sage 300 if you attempt to change the processing code with a credit card it will delete all the…

Hi, When receiving prepayments from customer in AR (against an Order), the VAT amount of the prepayment has to be reported. How can I record it so it appears in Tax Tracking Reports? Appreciate your input. Thanks & Regards, Ubaidullah Nubar.

When trying our first bank rec after upgrading we discovered that as part of the recent conversion our deposit tables were cleared. It is an easy fix to complete the bank rec, but the issue is that now all the associated payments are showing up in AR…

David Beard and Jeff Richards will be available online to help customers & our reseller partners with technical questions, perhaps brainstorm ideas for deployment, seek advice on marketing & sales + almost anything else SageCRM Drop in via Skype or dial…

I have read all of the questions on here about the reconciliation of the A/R Trial balance to the GL Trial balance. I have run countless reports, and excel files trying to find the differences. Things I know: There are zero postings to the A/R GL…

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…

I am trying to process year end in AR. I have ran/printed all customer statements, interest, printed all posting journals and reports needed. Every batch is posted to the GL and backed up. Every time I click "Process" in Year end I keep getting the error…

Hi, Is there any way to contra transactions and show a net balance if a vendor is also a customer? Priti

Hi all. Something weird happened to two of my A/R batches this morning. Two separate batches combined into one deposit number. Has anyone ever had this happen before? I am wondering if somewhere in Sage there is a way to combine separate batches into…

I have a client that has processed a credit card payment that was supposed to partially pay an invoice. They over applied the payment so the invoice now shows up as paid, but they credit card payment show up in the Aged Receivables because it was over…

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.

Hi all Can anyone advise how you prevent a user from over-applying an AR receipt? and secondly, if a receipt has been overapplied how do you reverse it? Thanks

Hi there, In accounts receivable invoice was entered for customer “ABC” in the amount of $50,000 another Invoice was entered for customer “XXX” in the amount of $500. That was all ok the problem happened when the receipt entry was made. There was…

I am trying to apply a payment in AR receipts that over pays an invoice and I want the over-payment amount left in the customer account to reference the invoice number. Is there a way to do this in Sage 300 (version 2016)? thanks

HI, SAGE 300 ERP 6.1A PU4 WE HAVE POSTED THE BANK RECONCILIATION WITH A DEPOSIT WHICH WAS HAVING 38 ENTRIES. BY MISTAKE THE DEPOSIT IS RECONCILED WITHOUT SELECTING THE OPTION "CLEARED BY DEPOSIT DETAILS". DUE TO THIS NOW WE ARE NOT ABLE TO SEE THAT…

Our company recently held a raffle with the proceeds going to charity. I need to receipt the amount into sage so that later we can write a check for the donation. Is there an easy way to do this with no offsetting sale? I was going to do a General Journal…

We extend 30 days of credit to some customers who we need to stay on top of. At 30 days, we need ACCPAC to disallow anyone from entering a new order or shipment. Is this possible out-of-the-box or with an add-on?

We use OE module to create invoices selling stock and non-stock inventory items from IC module. Sometimes there are errors on the OE invoices that need to be changed such as wrong taxes charged, unit prices don't match customer PO, etc. Sometimes the…

Hi there, We are using sage 300 ERP 2014 and We have a transaction in reconcile statements showing not posted, we need to have it outstanding.When we go to the detail of the transaction which has 3 entries, 2 entries are fine with the outstanding status…

When trying to process the Create Revalation batch in General Ledger, the Batch Description and the Process Botton are not accessible. We are using Sage 300 ERP 2014 , PU3, Microsoft SQL. Any ideas?