AbleCommerce Shopping Cart Software

I am coming across an issue in our reporting. Some of the reports we are using SKU level sales for, meaning order line totals, to get our sales.

Some of our reports use Payment information.

Obviously, there are some discrepencies because the Order Item totals may not always add up to the payments (partial refund, an extra payment after the order, etc).

Has anyone tacked this? The only idea I Can come up with that sounds solid is to allow the editing of the Order Item, shipping, taxes costs when someone applies a new payment, deletes one, or refunds.

Any other ideas?

I didn't understand what you are trying to achieve, little bit more explanation can be helpful. Regarding order or payment totals they are already been calculated by keeping payment statuses in mind. So if there is a refund payment when counting total payments AbleCommerce will take away the refunded amount. BTW on merchant side try opening an order. In left menu there is an option for editing order items you can check this out as well.

The issue is keeping the order item LINES in synch with the payments. The only solution I can come up with is to keep them in synch as you stated, by editing the lines to reflect the actual amount of the payments.

However, that loses some accounting history we are trying to achieve. For instance, if a refund is made, we want to apply that refund to an item order line, not actually just modify the price of the item to 0 or delete it. We want two transactions to reflect at the order item line level.

I'm not asking how to program this or technically achieve it, just if anyone has tried something similar and how they architected the data.

Thanks!