logo
Welcome to our new AbleCommerce forums. As a guest, you may view the information here. To post to this forum, you must have a registered account with us, either as a new user evaluating AbleCommerce or an existing user of the application. For all questions related to the older version of Gold and earlier, please go to AbleCommerce Gold forum. Please use your AbleCommerce username and password to Login. New Registrations are disabled.

Notification

Icon
Error
Clarification on reporting fields - Order table
Options
Go to last post Go to first unread
Previous Topic Next Topic
ray22901031  
#1 Posted : Monday, October 25, 2021 6:17:22 AM(UTC)
ray22901031

Rank: Advanced Member

Groups: Authorized User, Developers
Joined: 2/17/2019(UTC)
Posts: 826

Thanks: 3 times
Was thanked: 13 time(s) in 13 post(s)
Finally, after launching, I can concentrate on creating the reports necessary for us to do our jobs. I need to mimic quite numerous existing reports from our older system.

I just want to verify that these particular fields, in the database, are precisely what they appear to be.

In the order database, please verify these two fields:

TotalCharges - I believe you mean to say order total, is this the total amount of the order including all shipping, minus any discounts?

TotalPayments - is this the total captured amount against this order, not authorize or pending, but actual captured amounts? In other words, if a payment fails, this amount is not taken into consideration.

Thanks,
Ray
Back to top

Wanna join the discussion?! Login to your AbleCommerce Forums forum account. New Registrations are disabled.
Back to top  
shaharyar  
#2 Posted : Wednesday, October 27, 2021 6:45:47 AM(UTC)
shaharyar

Rank: Advanced Member

Groups: Admin, Developers, Registered, HelpDesk, Authorized User
Joined: 10/5/2018(UTC)
Posts: 703

Thanks: 5 times
Was thanked: 113 time(s) in 112 post(s)
Quote:
TotalCharges - I believe you mean to say order total, is this the total amount of the order including all shipping, minus any discounts?


Yes, this is the total sum of all order items excluding discounts and coupons.

Quote:
TotalPayments - is this the total captured amount against this order, not authorize or pending, but actual captured amounts? In other words, if a payment fails, this amount is not taken into consideration.


This is the total of all order payments amount that are captured or partially captured. It will minus the refund amount associated with the order payment.
Back to top
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Privacy Policy | Powered by YAF.NET 2.2.4.14 | YAF.NET © 2003-2024, Yet Another Forum.NET
This page was generated in 0.092 seconds.