Quickbooks Import QBI

[swingandmiss]

Assemblies should work correctly in version 3.21. Let me know if there is still a problem.

Thanks,
Adam

Yes, assemblies work fine.

[swingandmiss]

OK...I thought I had this all set up correctly. However, I now notice that all my imported orders are showing up with a balance due. I use paypal for payments, so all orders are paid at time of placing an order. Soo...the total sales is showing up in Accounts Receivable, instead of Merchandise sales. I'm not sure what option to change, as I've read the manual and thought I had it set up correctly.

[samad64]

I found an issue with this mod.. though I'm not sure if it applies to everyone or just myself.

I charge sales tax on shipping.. so I checked off the box in the configure area. Shipping is taxable only when in Texas (where the business resides).. however this mod is marking shipping taxable on ALL orders. Quickbooks is still accepting the files but its throwing off my tax report by really beefing up the "taxable sales".. so numbers aren't matching up. A quick look at the IIF file created shows that even though the item was marked N for Not Taxable.. the Shipping charge is always Y. Can the same logic for the product be applied for shipping charges?

I haven't taken a look at the file yet that controls that (as its pretty late here, and I'm going through all previous orders and fixing this on the sales receipt) but any help would be nice. Thanks!

[adam5532]

Hi,

I found an issue with this mod.. though I'm not sure if it applies to everyone or just myself.

I charge sales tax on shipping.. so I checked off the box in the configure area. Shipping is taxable only when in Texas (where the business resides).. however this mod is marking shipping taxable on ALL orders.

It looks like you have found a bug! In 2-1/2 years of QBI, it has never come up, probably because shipping is rarely taxed.

The fix is the following:

In qbi_classes_output.php, at line 238, change this

// Retreive order shipping data
			if ($cartorder->order['ship_value']>0) {
				$cartorder->order_data.=$ofile->create_shipping($cartcustomer->customer,$cartorder->order);
			}

to this:

// Retreive order shipping data
			if ($cartorder->order['ship_value']>0) {
				($cartcustomer->customer['tax_status']==Y AND SHIP_TAX==1) ? $cartorder->order['taxable']="Y" : $cartorder->order['taxable']="N";
				$cartorder->order_data.=$ofile->create_shipping($cartcustomer->customer,$cartorder->order);
			}

In qbi_classes_out_iif.php, at line 619, change this:

function create_shipping($cust,$order) {
		(SHIP_TAX==1) ? $order['taxable']="Y" : $order['taxable']="N";
		$text=$this->shipping_us($cust,$order);
		return $text;
	}

to this:

function create_shipping($cust,$order) {
		$text=$this->shipping_us($cust,$order);
		return $text;
	}

Thanks,
Adam

[samad64]

Hi,

It looks like you have found a bug! In 2-1/2 years of QBI, it has never come up, probably because shipping is rarely taxed.

The fix is the following:


Thanks,
Adam

Works like a charm. Thanks!!

[swingandmiss]

OK...I thought I had this all set up correctly. However, I now notice that all my imported orders are showing up with a balance due. I use paypal for payments, so all orders are paid at time of placing an order. Soo...the total sales is showing up in Accounts Receivable, instead of Merchandise sales. I'm not sure what option to change, as I've read the manual and thought I had it set up correctly.

Adam, any ideas here?

[adam5532]

Adam, any ideas here?

Make sure you have "Paid with PayPal" set as the payment type in Setupayments, and then it is matched in Match:Shipping. Also, make sure that the config option near the bottom is set to import as a Sales Receipt.

If you are using PayPal Payments Pro then select "Paid Online." "Paid with PayPal" is only for Payments Basic or PayPal IPN where the user goes off you site to pay.

Since I don't use PayPal in my cart, I haven't done a lot of testing with PayPal - if the above doesn't work, then I'll need to check that it is working properly. This might be in a few weeks.

Thanks,
Adam

[swingandmiss]

Make sure you have "Paid with PayPal" set as the payment type in Setupayments, and then it is matched in Match:Shipping. Also, make sure that the config option near the bottom is set to import as a Sales Receipt.

If you are using PayPal Payments Pro then select "Paid Online." "Paid with PayPal" is only for Payments Basic or PayPal IPN where the user goes off you site to pay.

Since I don't use PayPal in my cart, I haven't done a lot of testing with PayPal - if the above doesn't work, then I'll need to check that it is working properly. This might be in a few weeks.

Thanks,
Adam

In setup, I have three payment types:
Cash - Not Prepaid
Check - Not Prepaid
Paypal - Paid w Paypal

In config, it is set up to import as sales receipt.

I'm using Paypal Express Checkout, where they go to the paypal site to complete the order.

I'm not sure what you mean when you say to make sure the payment type is matched in Match:Shipping. I don't see anything there that says Paypal.

[adam5532]

In setup, I have three payment types:
Cash - Not Prepaid
Check - Not Prepaid
Paypal - Paid w Paypal

In config, it is set up to import as sales receipt.

I'm using Paypal Express Checkout, where they go to the paypal site to complete the order.

I'm not sure what you mean when you say to make sure the payment type is matched in Match:Shipping. I don't see anything there that says Paypal.

Sorry, I meant Match: Payment.

Thanks,
Adam

[swingandmiss]

Sorry, I meant Match: Payment.

Thanks,
Adam

Yup, Match: Payment is setup for paypal, cash, and check.