Sage 300

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…

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, 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…

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…

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…

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…

Hi, Sage300 V2014 SP3 Created a Credit Note In OE using a non-stock item that is NOT applied to an invoice, then created a DN for the same customer with the same non-stock item to correct the first CN and then reentered a second CN. Day End Processing…

Hi there, We have a customer with GBP as default currency. They have made a payment in USD with equivalent GBP amount and it has to be deposited in our USD bank account. What has to be entered in the rates override window to reflect this. Our functional…

Some of you have seen this one before - I brought it to the tech support chat but really didn't help me get anywhere as they were effectively asking me to run RV spy nightly on Day end until we caught one of these occurring... (sigh - RVSpying our Day…