使用QuickBooks QuickBooks PHP / QuickBooks网络连接器增加库存调整

Question

我很难通过适当的库存调整。它似乎没有在QuickBooks中引用/针对一个适当的帐户。我不清楚它在哪里建立联系，以及如何为它提供服务。

我还在修补它，但任何建议都会很棒。

更新：将AccountRef FullName更改为“库存资产”，以消除错误，并在同步时更新RefNumber、TxnID等。但是，它仍然没有在QuickBooks中更新数量。假设这是因为它只是真正地传递了"QuantityDifference“。

QWCLog.txt

<?xml version="1.0" encoding="utf-8"?>
        <?qbxml version="13.0"?>
        <QBXML>
            <QBXMLMsgsRq onError="stopOnError">
                <InventoryAdjustmentAddRq requestID="13">
                    <InventoryAdjustmentAdd>



                        <AccountRef>
                            <FullName>Inventory Adjustments</FullName>
                        </AccountRef>

                        <TxnDate>2016-12-28</TxnDate>
                        <!--<RefNumber>9051</RefNumber>-->

                        <Memo></Memo>

                        <InventoryAdjustmentLineAdd>
                            <ItemRef>
                                <ListID>TxnLID-9051</ListID>
                            </ItemRef>

                            <QuantityAdjustment>
                                <QuantityDifference>0.00000</QuantityDifference>
                            </QuantityAdjustment>
                        </InventoryAdjustmentLineAdd>


                    </InventoryAdjustmentAdd>
                </InventoryAdjustmentAddRq>
            </QBXMLMsgsRq>
        </QBXML>

20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.do_sendRequestXML() : Request xml received.
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.ProcessRequestXML() : Processing request #2
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.ProcessRequestXML() : REQUEST: received from application: size (bytes) = 1191
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.ProcessRequestXML() : Sending request to QuickBooks.
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.ProcessRequestXML() : Response received from QuickBooks: size (bytes) = 379
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.ProcessRequestXML() : Sending response back to application.
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.do_receiveResponseXML() : *** Calling receiveResponseXML() with following parameters:
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.do_receiveResponseXML() : wcTicket="3388bbdc-18d0-a594-7dfd-70f68aac289e"
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.do_receiveResponseXML() : response =
20161228.19:16:51 UTC   : QBWebConnector.SOAPWebService.do_receiveResponseXML() : XML dump follows: -

<?xml version="1.0" ?>
<QBXML>
<QBXMLMsgsRs>
<InventoryAdjustmentAddRs requestID="13" statusCode="3140" statusSeverity="Error" statusMessage="There is an invalid reference to QuickBooks Account &quot;Inventory Adjustments&quot; in the InventoryAdjustment.  QuickBooks error message: Invalid argument.  The specified record does not exist in the list." />
</QBXMLMsgsRs>
</QBXML>

插入库存调整并将其排队的save.php代码

$Queue = new QuickBooks_WebConnector_Queue($dsn);

// IMPORTANT: ONLY UPDATE CHANGED ROWS. WE DONT WANT INVENTORY ADJUSTMENTS FOR UNCHANGED ITEMS!
foreach ($updates as $update) {
    // Update QuantityOnHand still so our web interface can easily see the new quantity before QB sync
    $sql = "UPDATE qb_item SET QuantityOnHand='" . $update[1] . "' WHERE ListID='" . $update[0] . "'";
    if (!$qb_result = $qb->query($sql)) {
        dErr("Error: Our query failed to execute and here is why: <br />Query: " . $sql . "<br />Errno: " . $qb->errno . "<br />Error: " . $qb->error);
    }

    $sql = "SELECT * FROM qb_item WHERE ListID='" . $update[0] . "'";
    if (!$qb_result = $qb->query($sql)) {
        dErr("Error: Our query failed to execute and here is why: <br />Query: " . $sql . "<br />Errno: " . $qb->errno . "<br />Error: " . $qb->error);
    }

    $row = $qb_result->fetch_assoc();

    // Generate unique TxnID
    // Apparently QuickBooks will overwrite it with the permanent TxnID when it syncs
    $tID = rand(1000, 9999);

    // Insert new Item Adjustment
    $sql = "INSERT INTO `qb_inventoryadjustment` ( `TxnID`, `TimeCreated`, `TimeModified`,  `Account_FullName`, `TxnDate`, `RefNumber`,  `Memo`, `qbsql_discov_datetime`, `qbsql_resync_datetime`, `qbsql_modify_timestamp` ) VALUES ( 'TxnID-" . $tID . "', now(), now(),  'Inventory Adjustments', CURDATE(), '" . $tID . "', NULL, NULL, NULL, now() )";
    if (!$qb_result = $qb->query($sql)) {
        dErr("Error: Our query failed to execute and here is why: <br />Query: " . $sql . "<br />Errno: " . $qb->errno . "<br />Error: " . $qb->error);
    }

    // Get the primary key of the new record
    $id = $qb->insert_id;

    // Queue up the inventory adjustment
    $Queue->enqueue(QUICKBOOKS_ADD_INVENTORYADJUSTMENT, $id);

    // Insert new Item Adjustment Line
    $sql = "INSERT INTO `qb_inventoryadjustment_inventoryadjustmentline` ( `InventoryAdjustment_TxnID`, `SortOrder`, `TxnLineID`, `Item_ListID`, `Item_FullName`, `QuantityAdjustment_NewQuantity` ) VALUES ( 'TxnID-" . $tID . "', '0', 'TxnLID-" . $tID . "', '" . $update[0] . "', '" . $row['FullName'] . "', " . $update[1] . ")";
    if (!$qb_result = $qb->query($sql)) {
        dErr("Error: Our query failed to execute and here is why: <br />Query: " . $sql . "<br />Errno: " . $qb->errno . "<br />Error: " . $qb->error);
    }

    // Get the primary key of the new record
    $id = $qb->insert_id;

    // Queue up the inventory adjusment
    $Queue->enqueue(QUICKBOOKS_ADD_INVENTORYADJUSTMENT, $id);
}

Answer 1

查看QuickBooks UI/帮助或QuickBooks OSR。

QuantityDifference字段定义为：

QuantityDifference 一个正数或负数，表示该清单项目的数量变化。

你正在发送：

<QuantityDifference>0.00000</QuantityDifference>

它告诉QuickBooks你想用.0。您希望将0添加到quantity中，并从quantity中减去0。

您应该能够通过查看QuickBooks UI来判断哪些是允许的帐户。

Answer 2

将此代码用于xml请求：

 <?xml version="1.0" encoding="utf-8"?>
    <?qbxml version="13.0"?>
    <QBXML>
        <QBXMLMsgsRq onError="stopOnError">
            <InventoryAdjustmentAddRq requestID="13">
                <InventoryAdjustmentAdd>
                    <AccountRef>
                        <FullName>Inventory Asset</FullName>
                    </AccountRef>

                    <TxnDate>2016-12-28</TxnDate>
                    <!--<RefNumber>9051</RefNumber>-->
                    <Memo></Memo>

                    <InventoryAdjustmentLineAdd>
                        <ItemRef>
                            <ListID>TxnLID-9051</ListID>
                        </ItemRef>

                        <QuantityAdjustment>
                            <QuantityDifference>-3</QuantityDifference>
                        </QuantityAdjustment>
                    </InventoryAdjustmentLineAdd>


                </InventoryAdjustmentAdd>
            </InventoryAdjustmentAddRq>
        </QBXMLMsgsRq>
    </QBXML>

你的问题是帐户的名字。正确的帐户名称是“库存资产”。Qty应为负值，以降低QB中的qty。