Magento – Where is Qty Returned to Stock for Credit Memos Stored?

creditmemoinventory

When creating a credit memo in Magento one has the option to return stock managed products to stock.

How can one tell – by looking at an existing credit memo – whether or not the admin decided to return any units to stock?

I've looked at the backend & the table structure and this information is seemingly not visible anywhere.

Any ideas?

Best Answer

The information about the return to stock is not kept in the database.
When a credit memo is created the method Mage_CatalogInventory_Model_Observer::refundOrderInventory() is called.
In there an array is built with the qtys that need to return to stock based on the fact that the creditmemo item was previously marked with setBackToStock(true) or if the config setting for returning refunded products to stock is set to Yes.

Then the method Mage_CatalogInventory_Model_Stock::revertProductsSale() is called with a parameter consisting of the array built from the item qtys. This method is just a wrapper for Mage_CatalogInventory_Model_resource_Stock::correctItemsQty() that actually runs the queries and updates the product stock.

But there is no code (or table field) that remembers if the qty was returned to stock or not.

Related Solutions

Magento – How to credit-memo and/or return-to-stock a “completed” $0 order

I ran into the same problem but I approached the solution a bit differently using di preferences; here is the code:

My/Module/etc/adminhtml/di.xml

<config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
        xsi:noNamespaceSchemaLocation="urn:magento:framework:ObjectManager/etc/config.xsd">
    <preference for="Magento\Sales\Controller\Adminhtml\Order\CreditmemoLoader" type="My\Module\Controller\Adminhtml\Order\CreditmemoLoader"/>
</config>

My/Module/Controller/Adminhtml/Order/CreditmemoLoader.php

<?php

namespace My\Module\Controller\Adminhtml\Order;

class CreditmemoLoader extends \Magento\Sales\Controller\Adminhtml\Order\CreditmemoLoader {

    protected function _canCreditmemo($order)
    {
        if(!$order->isCanceled() && $order->getState() !== \Magento\Sales\Model\Order::STATE_CLOSED)
            $order->setForcedCanCreditmemo(true);

        return parent::_canCreditmemo($order);
    }

    public function load()
    {
        $result = parent::load();
        if($result instanceof \Magento\Sales\Model\Order\Creditmemo){
            $result->setAllowZeroGrandTotal(true);
        }
        return $result;
    }

}

Here I'm using preferences (we can't use plugins because of the protected function) to override the CreditmemoLoader class which is used to create CMs. I use setForcedCanCreditmemo to make sure we can create the CM on the Order and setAllowZeroGrandTotal to allow a $0 CM. You could perform additional checks on the order here too.

Magento – Magento 2 Credit Memos : Template override doesn’t work after clicking “Update Qty’s” button

First of all, you need to correct: app/code/ATC/CreditMemo/view/adminhtml/layout/sales_order_creditmemo_new.xml

for proper overwrite renderer/default.phtml so change:

<block class="Magento\Sales\Block\Adminhtml\Items\Renderer\DefaultRenderer" as="default" template="ATC_CreditMemo::order/creditmemo/create/items/renderer/default.phtml"/>

to:

<referenceBlock name="order_items.default">
        <action method="setTemplate">
            <argument name="template" translate="true" xsi:type="string">ATC_CreditMemo::order/creditmemo/create/items/renderer/default.phtml</argument>
        </action>
</referenceBlock>

And the reason why after update qty the block is refreshed, because you miss overwriting sales_order_creditmemo_updateqty.xml

Create app/code/ATC/CreditMemo/view/adminhtml/layout/sales_order_creditmemo_updateqty.xml

and paste the same content after fix as you have in sales_order_creditmemo_new.xml

<?xml version="1.0"?>
    <page xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="urn:magento:framework:View/Layout/etc/page_configuration.xsd">
    <body>
    <referenceBlock name="order_items">
        <action method="setTemplate">
            <argument name="template" translate="true" xsi:type="string">ATC_CreditMemo::order/creditmemo/create/items.phtml</argument>
        </action>
    </referenceBlock>
    <referenceBlock name="order_items.default">
        <action method="setTemplate">
            <argument name="template" translate="true" xsi:type="string">ATC_CreditMemo::order/creditmemo/create/items/renderer/default.phtml</argument>
        </action>
    </referenceBlock>
</body>

Best Answer

Related Solutions

Magento – How to credit-memo and/or return-to-stock a “completed” $0 order

Magento – Magento 2 Credit Memos : Template override doesn’t work after clicking “Update Qty’s” button

Related Topic