Sage 300

Hey SageCity Members, I am using bank rec for the first time in Sage 300 2021 Premium. However, we noticed that some of the transactions in the bank rec doesn't have transaction numbers. When we try to use quick clear for range of withdrawals to…

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…

Client is trying to reverse a payment in bank services, They are getting "Exchange Rounding Account is not defined for Account Set... Problem is, client is not using multi-currency and there is no option to even add an exchange rounding account in…

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…

Hi, we frequently get small short pays from our customers for different reasons. How can we enter them at the time of doing the receipt entry? Is it possible to select the GL account to use? Ty.

Client has a request to change the customer id but the customers belong to a national account. Reason for the change is that the customers are changing affiliations and client built in national account identifiers in the customer number. Most of the customers…

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…

Hello, is there any way to force an AP discount (ie: 2% 10/net30) while entering a payment batch, without changing the system date? Thanks.

HI, I am setting up a UK company that needs to submit VAT MTD returns. Does the Sage 300 MTD module that comes with v2022 work with other currencies besides GBP? I am posting some AP EUR invoices and it seems that the VAT Return icon reports these…

Is there a workaround or third-party solution for the limitation with AP system-generated payment batches being limited to only one at a time?

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…

Hello, Is there a way to unmatch a PO invoice already posted without going doing a credit note? More specifically, the person match an AP invoice in PO invoice in PO module by error. Thanks, Helen

Where do i see the accounting entries of AP and AR transactions for a project configured as "completed project' in PJC accounting method? For example, i create a new project in the contract maintenance and set the accounting method as 'completed project…

Hi, Is it possible to reverse a Journal Entry already posted? Best, Helen

Hello, In General Ledger, Batch List, is it possible to set a series of batch to Ready to Post Yes instead of doing it one by one? Best, Helen

So - I apologize - i'm still learning Sage 300 and Accounting processes. Normally when my company pays the credit card bill I create an invoice for each persons card/bill for the month and simply record it as an invoice payment to match to the bank account…

Hi, How can we determine in AROBL the application of a payment to an invoice? Which field links the 2 records (invoice and corresponding payment)? Ty.

So I posted a transaction in Bank Services (deposit) in January - it was the wrong amount (posted say $150 when it was only $100) - so I went in and reversed it and reposted the transaction with the correct amount. No big deal right? well now my boss…

Is there any way to directly move an invoice batch into a payment batch> ie we have an Invoice batch with 3 invoices for 'widget inc.' and 2 invoices for 'xyz corp.' we want to move to a payment batch with 2 checks 1 covering the 3 invoices for…

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 prepaid a vendor for product in the previous month, November. Therefore, we recorded the cash payment as a prepayment so that we could reconcile the books. However, we have now been told that the units will not be available and the supplier has returned…

I added two new general codes however they do not appear on my financial statements why?

Hello, After printing checks we proceeded to post the check run. For some reason the system "hang" for several minutes. We closed the Sage windows in an attempt to make the system work again. Now our AP aging is updated with the checks that were issued…

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…