Sage 300

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

Hello, How do I apply a credit when selecting all my transactions that passed on my credit card? When I am selection all my transactions that passed on my card and selecting all the different payment that passed. I cannot select a credit that…

Hello, I want to change a customer number. How can I do so? Thank you. Valerie

We try to post in A/P entry, but it generated an Error batch and it says Invoice XXXXX already exists. It seems that we created an P/O invoice and also a credit note with the same number. How can we void or change the number and process to batch? …

Hello, Wondering if anyone might be able to help me. I've overpaid an employee by a few hours on his last pay. We have invoiced him for the net amount as per CRA guidelines, but how do I adjust this on his employee activity? I think I need to add…

Hello Team, I cannot remove posted documents in Sage 300. Could you clarify how I can remove posted documents?

Hi all, I have a case where my customer have a grave mistakes from sales transactions down to GL account, and the data displayed wrongly on the P&L report. It have been happening for few months. So he is asking if is there any way to revert only selected…

Hello Team, In Sage 300, I created the adjustment and allocated it to the invoice. Then, I posted the adjustment. But, I cannot find adjustment by Adjustment Number on the Document Injury page. Also, endpoint ARPostedReceipts doesn't return this adjustment…

Team, Could you help me with the following question. In Sage 300 the user can create a Refund payment. Thus, I can create an Income payment (receipt) and then refund it using refund payment. What type of documents should this payment be attributed to…

AP clerk entered an AP payment in prior fiscal year. Then reversed it in the new fiscal year instead of the PY fiscal year. How do i fix it so that the reversal is in the prior fiscal year not the current one? ie: AP payment was entered on 7/8 and posted…

Hello, We have thousands of small receipts unapplied in our AR module. In most of the cases it's $0.01. Is there a way to just apply them to outstanding documents for those customers? We also have thousands of customers we would have to do this for…

Hello Team, Could you please provide an example of the request for the following method ARPostReceiptsAndAdjustments ? I found the following article https://www.sagecity.com/support_communities/sage300_erp/f/sage-300-general-discussion/156859/help---using…

Good morning, Can I credit an invoice that was already paid? and if so, what happen to the invoice and the payment? do they both come back into my A/R this is what happened. 1. a customer sent us a prepaid payment 2. when they billed the invoice…

We are having an issue in our purchase clearing GL with returns. In April we did a return to a vendor in USD for $67. The exchange rate was 1.2575 so it debited the purchase clearing GL by $84.26. The credit note we received from the vendor was for…

Does anyone know if I can reverse previously posted Journal Entries in Sage 300 V 20.3.1.? Thanks,

There was duplicated payment in December so I booked the overpayment as a prepayment in AR. Now I got the money back. How can I reverse the prepayment ? or what do you suggest to offset the prepayment? Thanks!

Bonjour Team, J'espère que vous allez bien ! Je bosse dans une Entreprise et nous utilisons Sage 300 2020 (ACCPAC) Nous avons emis des requisitions dans le mauvais "CONTRACT -> PROJECT" et nous cherchons comment corriger cett erreur car le PROJECT…

There was an entry made as a UC in accounts receivable in June 2020 the wrong customer. How do I correct it in Jan 2021. Since the UC was entered in the wrong customer, that customer has a negative balance. Thanks Susan

We have a customer account with an open PY (overpayment of an invoice) where the funds will not be refunded to the customer. We want to clear and close the account but the AR receipt batch will not allow us to adjust off the open credit amount via a zero…

Hi, I am new to my company and am wanting to import our year-end inventory counts back into Sage instead of having them manually keyed in. I was able to export and import the 2 workbooks, but after importing I am not sure what steps need to be taken…

Hey it looks like over the past few years they have been recording payments directly into the GL instead of through the AR module. However the documents were entered into the AR module. There are many many transactions / documents setup in AR that need…

Hi All, Accidentally Transfer All WIP to Assets. How to reverse or batch transfer them back to WIP? Waiting online for help. Thanks in advance. Regards, Alex

Hello, I have the EFT module. How can I refund a customer with EFT ? I don't see the option in the refund entry. Even, if I have the "Customer EFT" filled up and in my Customer file, in the processing tab it is specified "payment method: EFT". In…

Hey folks, I am wondering how I apply a credit note to an AR invoice after the credit note has been posted - and wasn't applied when it was posted. Thanks in advance. Dan

Hi, I would like to correct a previously entered invoice. The coding of the invoice is incorrect however I don't want to actually reverse the cheque, I just want to change the coding. Normally, I would do a JE to correct it however I would like to follow…