Sage 300

We have been working with a customer who has had some issues with their bank rec. We have worked through their issues and are at the point where we are ready to post the reconciliation and we have received this error: Requested payment was cleared previously…

Hi, I have a client that would like to Reconcile E-Statements with Fifth Third Direct not Fifth Third Bank and they cannot. Does anyone no if Fifth Third Direct is supported? Thanks for all you do

We have a client running Sage 300 v2021.5. They have an A/R Receipt batch that was posted in A/R, but in Bank Services bank rec screen, it shows as ‘Not Posted’. Because of this status, they cannot clear the deposit in their bank rec. Has anyone seen…

In Sage 300 version 2020, I have seen in the last 2 days, bank entries doubling up. A entry was done as a withdrawal for 200 and it shows in the bank rec. as 400.00 , and an $100.00 entry was showing as a 200.00 entry on the reconciliation tab. When we…

Problem: Receipt batch with a deposit date in one year and the posting dates of each entry in another year that was reversed Problem specific Details: Receipt batch created and posted as deposit date of 01/12/2022 and all entries in the batch with…

We are starting to do EFT(s) to process some payments. I usually create a batch of invoices and then create a payment batch, In the past they have all been to cheques so I select criteria and then process the cheques. Once posted they will appear in my…

Hello, there is a discrepancy between the adjusted book balance of our bank rec and our gl account over a number of periods. The first variance ties perfectly to one entry that appears like it was posted correctly as a bank entry and cleared on the bank…

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 All, I entered a bank USD entry with the wrong USD to CAD rate. This is messing up the balance of the clearing account and so I would like to reverse the bank entry and re-enter it with the correct USD to CAD rate. However, the bank entry is now…

Ran a bank transaction purge but some records were not removed. What is the requirement for removing old AP/AR records in Bank Services? I saw a document a few years back but cannot find it now?

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…

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

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