Yes, assemblies work fine.Quote:
Originally Posted by adam5532
Printable View
Yes, assemblies work fine.Quote:
Originally Posted by adam5532
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.
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!
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.Quote:
Originally Posted by samad64
The fix is the following:
In qbi_classes_output.php, at line 238, change this
to this:Code:// Retreive order shipping data
if ($cartorder->order['ship_value']>0) {
$cartorder->order_data.=$ofile->create_shipping($cartcustomer->customer,$cartorder->order);
}
In qbi_classes_out_iif.php, at line 619, change this:Code:// 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);
}
to this:Code:function create_shipping($cust,$order) {
(SHIP_TAX==1) ? $order['taxable']="Y" : $order['taxable']="N";
$text=$this->shipping_us($cust,$order);
return $text;
}
Thanks,Code:function create_shipping($cust,$order) {
$text=$this->shipping_us($cust,$order);
return $text;
}
Adam
Works like a charm. Thanks!!Quote:
Originally Posted by adam5532
Adam, any ideas here?Quote:
Originally Posted by swingandmiss
Make sure you have "Paid with PayPal" set as the payment type in Setup:Payments, 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.Quote:
Originally Posted by swingandmiss
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:Quote:
Originally Posted by adam5532
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.Quote:
Originally Posted by swingandmiss
Thanks,
Adam
Yup, Match: Payment is setup for paypal, cash, and check.Quote:
Originally Posted by adam5532