Our company has decided they want to change the AR Aging Invoice by Invoice Date to Due Date.
Is there anything I should be aware of or need to run after I change the option? I would assume there is some utility I need to run that will recalculate the…
Please help!!! Very simple VI job has been in use since 2015, maybe earlier. But within the last year, we have had at least 3 incidents, and want to make sure that if user forgets to populate this column of the AR cash receipts excel template, the record…
How do you record a wire transfer from a customer in AR? In AP there is the selection drop down for Wire Transfer, but not in AR. I read if we use ACH/Credit Card, it doesn't post to BR. So do we use Cash and if so, how/where do we enter the long 15 digits…
When we had Sage installed, all of our customers were imported into the system. When I start to type in the 'Customer No.' field, a drop-down menu appears with predictions of those customers. However, when I add a new customer, I have to click the magnifying…
We had a customer use a third party to pay for invoices. They asked for a dummy credit we could send them so they could zero out invoices on their account.
To do this, I was instructed to create a prepayment (as a positive amount) and then a credit…
Hi,
I have several customers with special requests regarding the sending of their invoices (mail, fax, e-mail to specific parties, etc). We created memos that pop up during Sales Order Entry. Unfortunately, that department doesn't always remember to…
i am trying to update a UDF in line level using script on a button click
Dim count Set fso = CreateObject("Scripting.FileSystemObject") Set dict = CreateObject("Scripting.Dictionary") If (fso.FileExists("C:\XIDT\line.txt")) Then Set file = fso.OpenTextFile…
Hi,
We have an AR receipt Entry batch with 2 entries my first entry is ok but I want to undo the 2nd entry in order to put back the document number in the first entry.
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…
Question, I need to run a report showing what I billed our customers for the month of December 2016. But I need to choose customers who only purchased certain products. Which report do I need to run? I'm starting to confuse myself. Help!! Thanks.
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 …
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 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…
dhamelin,
Review the knowledgebase article ID 32673 " Can I change the AR customer on a progress, lump sum or unit price contract after it has already been billed? " You will need to login or register to view the content.
Basically, if there is no…
We have customers with recurring fee for services each month. I've searched but cannot find anywhere to make a billing recurring so we do not have to create a new invoice each month. How can we do this task? TIA
This solution applies to most versions of most software, and to Sage 300, and Ptree 50, too.
Post all o/s AR transaction to AR, and to GL.
Then run the [AR TB], and the [GL TB for the AR control account] at the END of the furthest period open in your…