All,
I like QBOE, but I am having two issues that are a pain to deal with and so far I haven't seen these addressed anywhere. One is from 6 months ago, and the other I just discovered yesterday.
----------------------------------------------------------------------------
1) The Ref# field
I have found no documentation on this field and have no idea if it is tid to any other part of the system. I began using it to store a check number or other payment identifier when receiving payments, and then found it interfered with the Sales Receipt or Invoice numbers. If this is in fact by design, I would expect the field to be a drop combo prefilled with numbers, not a free text box.
The result of this is annoying. If I receive a payment and enter check number 2225 in this field for example, and in the future try to enter invoice number or sales receipt number 2225, I get a message this number is already in use.
----------------------------------------------------------------------------
2) Customer overpayment treatment in Customer Balance Detail report. What I need is to see customers who have a $0 balance or a credit balance.
What happens is I have customers who routinely round up their payments, so for a customer who owes me $33.10, they will pay me $34.00.
I ran a test to see what happens under three scenarios, paid in full, overpaid, and underpaid. This is assuming I selected AR Paid for the report, which is what I want to see
I created a customer, Test Tester, and created an invoice for $33.10
a) I entered a payment of $34.00, The Customer Balance Detail report showed only the invoice and a positive balance due of $33.10, even though the credit balance was $0.90
b) I entered a payment of $33.00, The Customer Balance Detail report showed only the payment and a negative balance due of $33.00 even though the amount due was only $0.10
c) I entered a payment of $33.10, The Customer Balance Detail report showed both the invoice and payment and a balance due of $0.00
While I am no accountant, I would expect both the invoices and payments to show up in scenario #1 since the balance is paid in full and we owe the customer money. If I am correct, then all that needs to happen is to change the query behind the report to display everything if the sum is <= $0, not = $0
Valeri at support attempted to help me with this one, but so far there is no workaround.
Thanks,
Jaxmeier
|
