Results 1 to 8 of 8

Threaded View

  1. #1
    Join Date
    Oct 2012
    Location
    Naples, FL
    Posts
    30
    Plugin Contributions
    0

    Default Discount on Invoices Not Posting to Database Correctly

    Hi, I have hunted around and can't figure this out. My version is 1.50 and I am using TaxCloud to calculate taxes which might be part of the issue but they say it is not. My customer uses a discount coupon code and he is invoiced the correct discounted amount. Everything works fine, they get a copy of the invoice and the orders processed. But in the Zen Cart database, the discount is ADDED to the order total even though it shows a minus sign in front of it. I use CartSpan to import orders, and it works flawlessly until a discounted invoice is in the que and the transfer fails because the invoice does not balance. And Tax Cloud's admin panel only registers the net invoice ignoring the discount. So what I think is happening is that the discount is not posting to the SQL database correctly. Here is a screen shot of the invoice inside my Admin panel showing the discount getting Added to the total instead of deducted. If you could tell me where to look to fix this error I would appreciate it. My store is floridagofishing.com/shop Click image for larger version. 

Name:	invoice-with-discount.jpg 
Views:	136 
Size:	11.5 KB 
ID:	12820 Click image for larger version. 

Name:	invoice-with-discount2.jpg 
Views:	120 
Size:	16.6 KB 
ID:	12821
    Last edited by FloridaGoFishing; 30 Jul 2013 at 12:00 AM. Reason: add picture

 

 

Similar Threads

  1. v151 One Field from Product Info Not Posting to Database
    By kamelion0927 in forum General Questions
    Replies: 5
    Last Post: 17 Aug 2013, 09:57 AM
  2. Reversal_Cancel not posting correctly
    By carlvt88 in forum PayPal Express Checkout support
    Replies: 1
    Last Post: 13 Oct 2010, 07:07 PM
  3. Discount not working correctly?
    By crisscross in forum Setting Up Categories, Products, Attributes
    Replies: 4
    Last Post: 24 Aug 2009, 03:56 PM
  4. Coupon discount not posting at check out.
    By sonquita in forum Discounts/Coupons, Gift Certificates, Newsletters, Ads
    Replies: 9
    Last Post: 18 Jun 2007, 02:57 PM
  5. Tax not Displaying Correctly on Order Slips/Invoices
    By gregoryjameswood in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 3
    Last Post: 28 Feb 2007, 10:37 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg