Sage 300

I have multiple banks to reconcile and the GL and the Bank Balance is not the same.

I've encountered a challenge reconciling my bank. At month end I input a cash disbursements batch and posted it. Transactions show up fine in the bank account. But when I run the bank rec the transactions are not there. I did some looking online and evidently…

Sage 300 Premium v 2019 PU1 In the last few months the bank reconciliation on one of the banks has become painfully slow again. We have cleared lots of history previously - the history only goes back 2.5 fiscal years at this point, up until a few…

We recently upgraded to Sage 300 and are trying our first Bank Rec. All outstanding deposits pre-conversion are missing from the reconciliation screen, all outstanding checks both pre and post conversion are fine. We also ran the Bank Rec status report…

Sage 300 ERP 2016, working through my data integrity issues and there is a warning that I would like to resolve. The message is "W: G/L Account 'XXXXXXXX' is inactive, but can be used." It does give a sequence number with the error and when I go to BKENTH…

AP Batch contains 3 entries for a particular supplier. Payment entry dates are 5th october, 17th october & 31st October. Payment batch posted and resulting gl batch posted successfully. Zero issues here. (3 entries Payment Batch and 3 entry GL Batch…

Hi, My customer has a difference since a few months between GL Bank Account versus Bank Book Balance, not much - $ 2676.12 pesos - but dont found the issue. Correct balance is the one in G/L but is less by that amount than Bank Book balance figure…

Bank Activity: Item 1: Customer 1 4/2/2018 Wire Transfer $500.00 Item 2: Customer 2 4/26/2018 Check 1234 $500.00 Item 3: Customer 1 4/30/2018 Wire Transfer $500.00 The person who reconciled the bank cleared Item number 1 and 2, instead of Item…

I understand how to correct an imbalance between the Book Balance the GL Balance if the GL is correct - simply post a bank entry to the GL account. But how do you adjust the GL balance if the Book Balance is already correct?

when a deposit or withdrawal is cleared with bank error or Write off, what happens to it? does it show in the GL account which is selected i bank setup for Write off?

I reconciled on 4/30/18 and all was good. Then i realized a bank transfer was entered twice, so i entered a transaction going the opposite way to clear one of them out. When i reconcile the statement for 5/3 and select both of the transactions it shows…

I'm not sure why we can reverse A/R payments and not A/P payments? I have had situations where we have prepaid items and then for whatever reason the funds were returned to us at a later date after I have reconciled the account. Then I have to do a debit…

Hi Support, We need to do a Bank rec for the first time even though Bank, AP and AR have been in use for some time now. What is the correct procedure for this.

Hi Support, An AP check has been cleared and bank rec has been posted. How can this check be reversed now? Priti

We are facing a strange issue in our Bank reconciliation. None of the withdrawals are reconciled but the withdrawals at the bottom of the bank rec screen has a balance. We have double checked and none of the withdrawals are selected. Please assist. …

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…

It looks like this has been asked before, but the posts are ancient history so I thought that I'd ask again in case something has changed in the last eight years. I reversed a cheque, but it was mailed and cleared our bank account. My reconciliation…

Hi there, My bank reconciliation is mismatching gl due to reversed transactions in payroll I think and I would like to know if I can create a bank entry and then post it in bank. This will make bank equal to GL. But I not sure what account I should…

Hi, As a user of Sage 300 v2016 PU2 we have the following error "An error has occurred during the processing of Check Reconciliation. The error returned was 1. Process error." while posting Bank Reconciliation. Data error. Check 0 for BK XX was…

Hi all, I have a situation in how to account for a creditor refund. The scenario is: Prepayment to Goods Supplier 1000 Goods received 900 Supplier invoice 900 Supplier refund 100 As the prepayment as been paid on a proforma invoice, the…

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…

Hi there, Our reconcile statement is out of balance, and we did clear all our outstanding transactions. I know there's a way to bring back the balance to zero but not sure. Any help?

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 I did reverse a check but at the wrong date. Does anyone know how we can fix it?

Bank Reconciliation, Why any deposit transaction still show 'Clear amount' and 'Deposit amount' is 0.00 when status to 'Clear' I was dill down to deposit detail that transaction has show deposit amount (it not 0.00). Anybody founded same this error…