Quickbooks Connector Output Problem

This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.
13 years ago
I am using the QuickBooks Connector module in nopCommerce and I noticed that none of the invoices which are synced with a Quickbooks company file seem to contain anything pertaining to Shipping, Discounts or Taxes on a particular order. After reviewing the code in QBXMLHelper.cs and cross-referencing the Intuit SDK documentation, I am unable to find any details which corroborate how this data is being structured in the web service's response.

The following 3 methods in QBXMLHelper.cs pertain to Shipping, Tax, and Discounts on a given invoice:

private static XmlElement CreateDiscountLineAddNode(XmlDocument xml, decimal amount)
{
  XmlElement el = xml.CreateElement("DiscountLineAdd");
  el.AppendChild(CreateAmtTypeNode(xml, "Amount", amount));
  el.AppendChild(CreateRefNode(xml, "AccountRef", QBManager.QBDiscountAccountRef));
  return el;
}

private static XmlElement CreateShippingLineAddNode(XmlDocument xml, decimal amount)
{
  XmlElement el = xml.CreateElement("ShippingLineAdd");
  el.AppendChild(CreateAmtTypeNode(xml, "Amount", amount));
  el.AppendChild(CreateRefNode(xml, "AccountRef", QBManager.QBShippingAccountRef));
  return el;
}

private static XmlElement CreateSalesTaxLineAddNode(XmlDocument xml, decimal amount)
{
  XmlElement el = xml.CreateElement("SalesTaxLineAdd");
  el.AppendChild(CreateAmtTypeNode(xml, "Amount", amount));
  el.AppendChild(CreateRefNode(xml, "AccountRef", QBManager.QBSalesTaxAccountRef));
  return el;
}


If you note the Intuit SDK Documentation at https://member.developer.intuit.com/qbSDK-current/Common/newOSR/index.html, under the 'InvoiceAdd' message Request overview there are no methods which resemble DiscountLineAdd', 'ShippingLineAdd', or 'SalesTaxLineAdd'. Googling these element names brought me to a few very old posts suggesting the elements were added to the spec, but as far as I can tell, they are no longer valid.

Does anyone happen to know how these are supposed to work?

Edit
-------
After some further digging I found out that 'SalesTaxLineAdd', 'DiscountLineAdd' and 'ShippingLineAdd' methods only apply to Quickbooks Online Edition. http://consolibyte.com/forum/viewtopic.php?id=47

Was QBOE the intended subscriber for these declarations?
13 years ago
Any update on this?  I am also running into this problem and the export is crucial to integration.

Items are importing fine, but like the previous poster the following do not import, even when starting from scratch and following the instructions on the /administration/thirdpartyintegration.aspx page:

Discount
Shipping
Sales Tax

Yes, these were set up as new accounts as per the instructions, but they do not populate with any data from the import, even though the order items are imported.

Can anyone provide any insight?

Thanks

Edit: One of the main issues with this is if an order has a discount, when the order is imported into QuickBooks it shows an amount due (because discount does not make it into the records), which causes all sorts of errors with accounting.
13 years ago
My apologies for the double-post, but I wanted lakario to get this update (don't think edits count as updates for thread watches).

I've reported this in the Bug Reports section (https://www.nopcommerce.com/boards/t/8318/bug-in-quickbooks-logic.aspx#35427).  Hopefully it gets looked at.
This topic was automatically closed 365 days after the last reply. New replies are no longer allowed.