StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
17219503
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2013-06-20T16:59:06.073
FavoriteCount
0
LastActivityDate
2014-02-10T23:22:05.933
LastEditDate
2014-02-10T23:22:05.933
LastEditorUserId
94671
OwnerUserId
94671
ParentId
13400358
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
As a followup to the accepted answer, I'd like to point out that people (like me from the past) who are having trouble getting their custom totals reflected on invoices will need to add a few more things. First, your column needs to be added to the <code>sales/invoice</code> table, as well. Second, Mage_Sales uses Convert objects to propagate data from quotes to orders to invoices. To get <code>your_custom_total</code> included in this flow, add a couple config hooks: <pre><code><global> <fieldsets> <sales_convert_quote> <your_custom_total><to_order>*</to_order></your_custom_total> </sales_convert_quote> <sales_convert_order> <your_custom_total><to_invoice>*</to_invoice></your_custom_total> </sales_convert_order> </fieldsets> </global> </code></pre> Now your total will be included when a quote is converted to an order, and that order to an invoice. However, even though your total is saved on the invoice, the invoice does not know how that total affects its grand total. Thus, an invoice total model similar to the quote address total model needs to be added. The config hook: <pre><code><global> <sales> <order_invoice> <totals> <namespace_custom> <class>namespace/sales_order_invoice_total_custom</class> <after>subtotal</after> </namespace_custom> </totals> </order_invoice> </sales> </global> </code></pre> And the class: <pre><code>class Package_Module_Model_Sales_Order_Invoice_Total_Custom extends Mage_Sales_Model_Order_Invoice_Total_Abstract { public function collect(Mage_Sales_Model_Order_Invoice $invoice) { $invoice->setBaseGrandTotal($invoice->getBaseGrandTotal() + $invoice->getYourCustomTotal()) ->setGrandTotal($invoice->getGrandTotal() + $invoice->getYourCustomTotal()); return $this; } } </code></pre> You can mirror the above for converting invoices to credit memos as well, if your total is applicable. This link <a href="http://magento.ikantam.com/qa/how-add-discount-total-magento" rel="nofollow">http://magento.ikantam.com/qa/how-add-discount-total-magento</a> explains how to rewrite adminhtml blocks to show your total on the backend.
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POAdd custom discount order in total with button
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. USkellen
UserOwnerUserId
1. USkellen
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.