Help With Reports
When running the payments report, the total is taking into account store accounts as well as other payments. This causes the total to include not only the store account but then also the payment for the store account. Is this the correct behavior?
This is confusing when looking at reports since the store account payment is essentially being factored in twice. The first time it's being recorded as a store account payment on a sale. That same amount is also recorded again when you take a payment on that account. Shouldn't it only factor in the payment on the account?
As I was going though my books, I was very confused why the total amount of payments was not what I was expecting. When I did the math, the extra amount that was show equaled the amount that was taken as a store account payment.
Comments
5 comments
Store config --> hide store account payments in reports
This still does not look like it fixed the problem.
The total is still factoring in the store account payments.
Ah I thought you meant for sales reports. There is a checkbox in that report "Only Count Store Account Payments:"
It isn't counting twice. The orignal charge is under store account and the payment is how they paid for it.
If you want to see a sale total go to reports --> sales --> detailed and that will now filter out store account payments
So I finally figured out why I was having such a problem getting things to match up. I had a sale that was paid on a store account in December 2020 then I did the payment on the account in January 2021. I changed the date of the sale to January 2021 and this has fixed the problem.
One thing, this doesn't make sense because shouldn't it be looking at when I actually got the payment and not when the sale was since it was paid on a store account? The money doesn't actually come in at that time. Do I need to change something in the settings to get it to report in the way I expect?
It should look at payment date. Not too sure without looking at database
Please sign in to leave a comment.