Welcome to the Sage 300 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.
Multiple bank accounts that need to be reconciled and posted are being used by our Sage300 company. The problem is that, even when a certain bank isn't being used, it's always necessary to request that users log out. Is there another way to post a bank…
Has there been any progress with getting Canadian Commercial Accounts to work in Bank Feeds?
The bank is available in the list (TD Commercial Banking) but it cannot be connected to.
We have a client running Sage 2022 PU 1. They consistently use the Vendor number change program to combine or change Vendors. When this is done before bank reconciliation, they get a payment not found message when they try to post their Bank Reconciliation…
Hi,
We found a Difference between AR GL balance and AR subledgers as at 31st December 2022 and that difference comes from December 2022. i want to know how to reconcile the month of December 2022 and find the reasons for this difference. Please advice…
Our bank has not been reconciled in Sage from 2018 onwards because of some issues. Now I want to start reconciling in Sage. Our bank balance is as below and there is a book balance of the below amount in the picture. The question I have is where is the…
Hi, I want to know, what is the best way to reconcile shipment clearing account and payable clearing account ? is there an easy way to make it zero at the end of the reporting date. Thank you
We have 2 bank accounts. When we pull one in bank reconciliations and setup the display to "reconciled", cleared items for many months back display. When we do the same for the other account, no transactions are displayed. We cannot figure out what the…
We are running into an issue when reconciling bank accounts. (Common Services/Bank Services/Bank Transactions/ Reconcile Statements). The Journal Entries are missing from the General Ledger/Book Balance calculations. Is there anything we can do to ensure…
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…
How to fix mismatch between I/C quantity and Lot/Serial quantity of an item if there is a variance on the I/C Serial/Lot Number Quantity on Hand Report?
Below is an example in our sample data for this item, A1-405/0 at location 1. As you can see the…
Good Morning All,
I have a question regarding the credit card receipt indexing process via Sage Paperless. I am wondering if it's possible to see a list of already indexed credit card receipts?
For example, when coding an invoice (or doing a new invoice…
Hello,
Is there a way to record individual credit card expense transactions and be able to reconcile the monthly credit card statements like a bank account? Or import the invoice #s for reconciliation?
We have hundreds of credit card transactions…
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…
Currently trying to complete a bank reconciliation for a past month. We have a point of sale system which posts incorrect amounts to Sage daily. These have been corrected in the GL to the appropriate accounts, but the bank reconciliation numbers still…
We have 3 separate bank accounts that roll up to one sweep account. Currently we have to keep a spreadsheet for each account balance to determine what the balance is in our sweep account. We also have to use this spreadsheet for reconciling each account…
It is probably an error we’ve all seen while in Sage 300 ERP, the dreaded “Sage 300 ERP UI Container has stopped working”.
We have blogged about this topic before but it seems that this error message has popped up in a variety situations from opening…
This solution applies to most versions of most software, and to Sage 300, and Ptree 50, too.
Post all o/s AR transaction to AR, and to GL.
Then run the [AR TB], and the [GL TB for the AR control account] at the END of the furthest period open in your…
Recently, I listened in on a call where the customer was having an issue where their book balance didn’t agree with the General Ledger. They noticed this while trying to reconcile their statements in Bank Services.
Here is an example of what that would…
