Hi, I am using VM. I wonder if it is possible.
We have a quarterly order export file. Which lists all orders and order totals. This works great.
But there are orders, which have been paid, but have a partially refunded item. VM displays this as an open "Balance".
The Balance is unfortunately not a separate field, it is the calculation outcome in each order total.
Now the question; in our quarterly report this "Balance" should be subtracted from the order totals. Is this possible somehow?
Hello,
There is paid field in VirtueMart Orders table. So order_total - paid should give the balance amount but you are looking at subtracting balance amount from order totals. Why not export paid field in export? Won't that work?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Log in to reply to this topic.