Results 1 to 4 of 4
  1. #1
    Join Date
    May 2011
    Posts
    90
    Plugin Contributions
    0

    Default Item on sale and its rounding problem. It breaks my Quickbooks import

    Zen-cart 1.3.9h
    This seems like a little problem, but when you think about how much trouble it brings on... its just insane. the problem is in rounding calculation that the program does to items placed on sale. It is perfectly fine when it have no other rounded numbers to add to subtotal. But things get incorrect when you add another rounded number that comes from state tax calculation. here is the example:

    Regular Item 28.95
    Regular Item 23.95
    Item on 25% sale 17.21
    Regular Item 48.95
    ..........................
    Subtotal: 119.06
    Shpping: Free Shipping
    Tax 9.3% 11.07
    ..........................
    Total: 130.14

    This 1 Penny that adds up into the total, screws up the whole data import into Quickbooks. Quickbooks rejects this order as an invalid, because of the incorrect calculation. Because one order is not being imported, the rest of orders are being imported with a wrong order number (shifted), that wont match our orders in zen-cart, so our workers have to import this order and orders that came after this during the weekend manually. Its just a 1 penny, but what it does to the system!
    I want to mention this: when there is an order with 2 items on sale, or with no items on sale but with tax charge, there is no problem, everything adds up smooth.
    If anybody have any suggestions how to fix this would be wonderful.
    Last edited by DrByte; 16 Jul 2012 at 07:29 PM. Reason: fixed price as requested

  2. #2
    Join Date
    Jan 2004
    Posts
    66,373
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Item on sale and its rounding problem. HELP!

    The penny-rounding issues were fixed in v1.5.0
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    May 2011
    Posts
    90
    Plugin Contributions
    0

    Default Re: Item on sale and its rounding problem. HELP!

    I know about the fix in the new version, thanks for advise. it will be a very big trouble for us to go with an upgrade right at this moment due to lots of changes we did to the current version.

  4. #4
    Join Date
    May 2011
    Posts
    90
    Plugin Contributions
    0

    Default Re: Item on sale and its rounding problem. HELP! It breaks my Quickbooks

    i have a mistype on my post
    First regular item is Regular Item 28.95 instead of 28.98. I have no way to edit this on first post. so the difference is 1 penny.

 

 

Similar Threads

  1. Quickbooks Import vs. Quickbooks Sync
    By sports guy in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 28 Oct 2011, 02:01 AM
  2. quickbooks point of sale 9 and zen cart auto stock update possible?
    By Xbox Memberships in forum Setting Up Categories, Products, Attributes
    Replies: 7
    Last Post: 3 Sep 2011, 08:56 PM
  3. QuickBooks Import and multiple tax rates
    By d0ugparker in forum Basic Configuration
    Replies: 1
    Last Post: 15 Jun 2009, 03:06 PM
  4. Rounding up and rounding down how to stop this?
    By Kazz in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 9
    Last Post: 24 Jul 2008, 06:40 PM
  5. Import to Quickbooks?
    By opsrcs in forum General Questions
    Replies: 1
    Last Post: 3 Oct 2006, 06:05 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR