Sage 300

Hi there, In accounts receivable invoice was entered for customer “ABC” in the amount of $50,000 another Invoice was entered for customer “XXX” in the amount of $500. That was all ok the problem happened when the receipt entry was made. There was…

Hi All How can i run something (and download to excel) that shows all invoiced A/R customers and the amount billed to them for a specific period of time (lets say 2016). something that looks like: Thanks! Vendor A $50,000 Vendor B $100,000 …

Is there any option in AR to warn for duplicate receipt numbers in Sage 6.0?

HI, SAGE 300 ERP 6.1A PU4 WE HAVE POSTED THE BANK RECONCILIATION WITH A DEPOSIT WHICH WAS HAVING 38 ENTRIES. BY MISTAKE THE DEPOSIT IS RECONCILED WITHOUT SELECTING THE OPTION "CLEARED BY DEPOSIT DETAILS". DUE TO THIS NOW WE ARE NOT ABLE TO SEE THAT…

Hi everyone, There has been some instances were receipts were made and applied to invoices in the AR, but some of the balance has remained unapplied. These are on the trial balance as a PY document, and I am unsure how to clear them. Any help is much…

Hi, Is there a way to find deleted entries in GL and the amount. These entries came from AR and AP and they've been posted in Subledger. And I'd like to know if we can find out the User who deleted these entries.

We have some companies that we work with. They are vendors and customers in our Sage 300. There are times when they owe us money in AR and we owe them money in AP. Is there a way to offset the balances? For example, in AP we owe them $100. In AR, they…

In AR module, I can't figure out how to change the date of a posted transaction. The amount will stay the same. There is a few that the incorrect dates were applied and I would like to just go in and change the date. Is there an easy way to do this? …

We currently use Sage 300 ERP for financials. Our MRP (Seradex OrderStream) will export daily AR/AP information and we import it into Sage via the appropriate forms Import. Our China facility is also using Sage 300 ERP for financials but they currently…

When trying to process the Create Revalation batch in General Ledger, the Batch Description and the Process Botton are not accessible. We are using Sage 300 ERP 2014 , PU3, Microsoft SQL. Any ideas?

Hi, Have this error message in A/R Invoice Posting Errors: Invalid Input. Document currency (EUR) does not match customer currency (USD) Any idea? thanks for your help.

I have an unapplied receipt showing as -ve receivable in my AR Sub Léger, how can I go about correcting this? The AR ledger looks okay. Thanks

I am looking at the last invoice date and find a number of customers that have not updated their last invoice date for many years, but I see OE invoices that were created at a much later date. Some customers are fine and others are not. Some customers…

Hi - I have a client that would like to export A/R data from Sage 300 (specifically the Aged Trial Balance report) and upload it to my server (we are a SaaS provider). They have nearly 100 "companies" in Sage that they would like to do this for, and doing…

My client has no problem searching in the customer screen, but cannot search in any way on the customer inquiry screen. Any ideas?

Please Help! Since I upgraded from 6.0 to 6.2 2014 PU3, when I import file on AR customers I have this error message :'File customer does not exist. Please specify an existing file' Any clue?

I have a client who needs an AR invoice form that shows a zero balance if paid in full. It is a request of one of their large customers. Has anybody created this form or would be interested in doing the customization?

Hi there, We have a customer with GBP as default currency. They have made a payment in USD with equivalent GBP amount and it has to be deposited in our USD bank account. What has to be entered in the rates override window to reflect this. Our functional…

A credit card payment was entered, posted to the correct customer, but to the wrong invoice. Is there a way to fix this. We attempted to reverse the entry, but since it was made with Sage Payment Solutions this was not allowed.

I have a client that is using Sage 300 2014 and just installed Office 365. They can still e-mail statements through Sage 300, but get an error when attempting to e-mail an invoice. Any ideas?

I'm to build a report based on project that lists all the invoices associated with that project - does anyone know what links I can use?

I have a client that would like to use the e-mail capabilities in Sage 300, but they only have a Yahoo e-mail account. Will this work and if so, I do we make it work?

Hello, When I entered receipt, I input the wrong receipt date and posting date as 01/12/2014 while it should be 01/16/2015 to match my batch deposit date. Then, I cleared it in the bank for the month of 1/31/2015's reconciliation. Later, when I reviewed…

Hello, I recently posted about 10 invoices from BL with the invoice date of 1/20/2014. Is there an easy way to change or edit this date in AR, without having to void the invoices and regenerate all 10 from BL? When I go to adjust the invoice in AR, the…

Can a recurring batch in AR (not posted) but processed, be modified in terms of dates ? Thanks