Sage 300

How to apply open credits e.g. prepayments, open credit notes etc directly to an Invoice in A/R while entering the Invoice. The Invoice amount should reduce with the credits amount.

Sage 300 Any solutions that can Auto-Apply mass open documents for all Customers in the A/R? Credits (Open Receipts, CN etc) against Debits (Invoices, DN etc) using a certain criteria e.g. Date etc

Hello Everyone, I am newer to Sage and was wondering if there was an option to select certain checks and assign them to a specific batch? Then run that specific batch when its ready? Thanks Jenny

We set up a future tenant and posted a security deposit. The tenant changed their mind, so we refunded it. The refund entries posted to PM and GL, but not on the tenant ledger. In fact, the security deposit still is on the tenants account. Do we need…

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…

Hello, I have identified a number of bank reconciliations where the adjusted book balance does not tie to the GL amounts. These are bank reconciliations that have been posted and I am unable to modify or look into the transactions that might be throwing…

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…

Is it possible to have quantity on order to default as shipping quantity when shipping. We have a client who shippend a few shipment with zero quantiies resulting in zero value invoices. The client invoices services not not stock items.

I am able to import misc receipts into Sage 300 AR successfully. I create a batch, set my bank and batch date which equals my deposit date, then import a single file of multiple misc receipts to reflect that day of deposits. My question is that I have…

Sage 300 2019 PU7 We can't find Header Optional fields for posted documents in ARPostedDocuments endpoint Which endpoint can provide posted documents header optional fields in AR?

Hi, Our bank reconciliation is in balance and it balances with our GL. We show withdrawals outstanding for $280 but the reconciliation only has one outstanding withdrawal for $260. How we can correct this? We tried doing a bank entry but this also…

I am from Vancouver BC area. We pay 7% PST on expenses. I am trying to enable tax calculations on our Sage 300 which are currently disabled on our AP System. When I do that, system is posting expense and applicable tax as two separate line items in the…

Hello, Our bank recs in Sage contain incorrect information since the installation of the system. Our GL is correct. Any recommendations on how to adjust the reconciliations without affecting our GL? Ty.

Hi, I need help. I was posting the bank reconciliation and instead of 29/06/2021 i selected 29/07/2021 and the balance is now as at 29/07/2021. How can i amend that so that i post to the correct period and date. Thanks

anyone know why Outstanding deposits summary total on recon report & screen would not equal detail listing on recon report any suggestions would be appreciated thanks

We are a charity registered in Canada. As such we receive a portion of the HST that we pay on purchases refunded back. The amount of the HST net of this rebate is recorded as part of the expense. The transaction is recorded as two items - the first is…

Hi All I have case from GL Entries I have Batch 1300 and more some entries I already post this and already look at GL Transaction Listing, we get that amount from this batch-entry But i want reverse 1 entry, i open GL Batch List dan look to batch…

Hi I'm using Sage 300 2020 PU 5 with SQL Server 2017. I found cases where AP Payment batch sometimes become not responding if several user is opening the batch, or processing transaction for the batch. So it comes up with the loading screen, this only…

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…

I paid an employee in error by submitting a timecard and paying through direct deposit. When I realized my error I reversed the paycheck and had the employee e-transfer me the amount back. Just wondering now that my bank rec is happening. How do I account…

I receipted my purchase order and posted it in Sage 300 but I did not put the correct amount down and hence I cannot Invoice it. Is there a way for me to edit or delete the the receipt for the purchase order. Please help me ASAP. Thank you.

Busy client in Sage 2020 suddenly has a problem where GL is unable to create a batch. User clicks "NEW" in the Batch List, and nothing happens. Same when we go to AP and click "Create GL Batch" (which normally would be created automatically, or would…

I had a check deposited in Feb and returned back in March my question is.. can I Reverse transactions in March the date the check was returned? I don’t want the bank to be effect for February it has been reconciled and posted. thank you newbie here!

I have had success setting up our EFT Payroll (Orchid) with Sage 300. However, when I go to reconcile my bank through an OFX statement the bank has processed the payroll as a full total withdrawal and of course, on the Sage side, it sees the individual…

I have created a new single currency database. If I try to post a quote or an order through Order Entry, I get this message. I have posted Shipments through IC and invoices through AR successfully as a test, and checked the Rate Type in the OEOPT table…