Categories
View Replies (1)

Resolved Export Virtuemart order totals without partially refuded order items (Balance)

  1. ptrouw
    ptrouw
  2. RO CSVI
  3. Thursday, 15 February 2024
  4.  Subscribe via email
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?
0
Responses (1)
tharuna
tharuna
Accepted Answer Pending Moderation
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
  1. more than a month ago
  2. RO CSVI
  3. # 1
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!