Sage 300

Hi, we purchase goods from a supplier and we sell items to the supplier as well. therefore, the Supplier A is in both AR and AP Ledgers. so, they settle our payments after deducting their outstanding (our AP balance under the same supplier A) therefore…

Hi All, is it possible to change the document date, post date, fiscal year and period on AR Invoice after posted? Situation: user import AR Invoice to Sage 300 using the Import feature on AR2100 (Invoice Entry). For some reason, the year of the…

Hi all, User are going to import AP Invoice (around 10000 invoices) using the import feature on AP Invoice Entry and posted it everyday. But some of the transactions is not going to be valid a few days later (like a dispute) and needed to be removed…

Does anyone know how to adjust EI insurable and CPP pensionable earnings for T4s on Sage 300?

Hello, How do I record a cash refund to a customer when there is no outstanding balance on the invoice. The refund was already issued in cash for amounts they paid, but it wasn't an overpayment or anything. The balance owing on the invoice is 0, but…

Had a user today accidentally write off a huge QTY of an item today due to using wrong UOM. Just wondering what other users would do to reverse this? Obviously I can just adjust the items back in but our reports would still see that usage number and it…

Hi, Checking on procedure. So we received a payment back from a vendor because they over charged us. How do I apply the payment against the vendor account? I was thinking I could create a credit memo but how do I marry the payment to the credit memo…

Hi have been trying to figure out how I can disable "Clear History" for certain Users.) (last item in screengrab) Tried unticking "Period End Maintenance" and "History/Budget Maintenance" - both did not work. ( please see list of options for GL ) …

We are processing credit card refunds in SAGE 300 by entering Customer account credit in adjustments. Everything is fine but those adjustments are not affecting Bank in Bank services so Bank balance in Bank services and GL do not match. We are doing bank…

Hello everyone, I am new to Sage 300 for payroll. And I entered Probation when create the new hire files under payroll-Class-Schd tab, so the Probation status will show on the Pre-Cheque Payroll Register. But now I would like to clear the Probation status…

We entered 72 quotes in order entry under the wrong customer number. Can I go into OEORDH and change the customer number before we change them to active orders?

Someone entered an incorrect prepayment amount on an OE Entry order. Then they deleted the prepayment receipt from AR and went back and posted the correct prepayment amount. Now the order shows both prepayment amounts added together. What is the best…

I recently joined a company using Sage 300, and I've been trying to get their system working. In the past, they used generic item numbers on purchase orders (i.e. BATHHARDWARE1), so their inventory counts were useless because many items shared the same…

Can I go into the database and change a Payroll Earning/Deductions code frequency? Will it cause integrity errors if I do? Sage 300 2019

I am looking for a work around to void a check in my current accounting period, that pays something in a previous closed accounting period so far back the accounting period can not be opened. What is my JE or work around to void check or to reinstate…

I have a vendor that drafts the full invoice amount out of our bank account. A credit is due but the credit does not reach our bank until the next month. Typically we will enter the Invoice and then enter the credit. Then when we create a Payment Batch…

Hi All, Is there a way to restrict cost posting for inventory with zero quantity on hand? Users can adjust the cost for items with zero qty on hand. Regards, Camy

On occasion, users make mistakes and rather than allowing Sage to assign the next number, the users enters some text. Can I go in to the DB and edit these fields? OEORDH.ORDNUMBER OESHIH.SHINUMBER OEINVH.INVNUMBER POPORH1.PONUMBER

Hi All, Can I reverse revenue recognition in PJC? The contract use Billing and Cost accounting method and the Project type is Fixed Price.

Good morning, During our migration to Sage300 the consulting group left a number of WO with blank amounts in our aging report. How can we get rid of them? Ty.

Hello, We have a serialized items in IC which we need to reduce the quantity. However, we see there is quantity on hand, but it in status unavailable. Any ideas why? Thanks! Helen

Hello, When printing the Aged Trial Balance, the adjustments we did for bank charges during the AR Receipt entry shows on the ATB without any amounts. How do we remove it from showing in the ATB (I know we can unselect Adjustment when printing the ATB…

Our arrangement with our payment processing company is such that when a payment is made by a guest, a transaction fee is deducted from the original payment and the net amount is then deposited into our bank account. I want to show the total amount in…

Hello, We have two different suppliers. We get one invoice from vendor A, but vendor B is paying for it. Is there a way to offset it without doing a credit note on Vendor A? Thanks! Helen

Hello, I noticed that a lot of my items have average costs that are way higher than the Most Recent or Last Cost. I know that I can make an inventory adjustment to bring it in line, but I'm wondering where I would look to troubleshoot why they are all…