problem causing LOTS of duplicate records

[Kent Multer]

Hi folks --

I've got a client with an older store, running Merchant 4.12 on Empresa 3.9602, with a customized MMUI, and just a few 3rd-party modules. I tried to pack the store, and found huge numbers of duplicate records in ordrchrg.dbf. They're all tax records, and all contain a zero charge; the store uses the State-Based Sales Tax module, charging tax only on orders to one state. Many orders contain dozens or even hundreds of identical sales-tax records!

This wasn't happening a month ago, so I suppose the client must have change something ... but I thought I'd ask the experts. Has anyone seen this before? Any ideas?

Thanks --

[wcw]

Each time the checkout is run the tax is calculated. If the customer goes back a screen or two or even back to the basket and then proceeds again in checkout, the old tax calculated record is deleted and a new one created based on the conditions (products in basket and location of customer). So one order can have several tax entries in the basket charge database. But only the latest one should not be marked for deletion. It would be interesting to compare the most recent ordrchrg records with the baskchrg records to see if the records in the baskchrg were deleted or for some reason are not getting deleted.

[Kent Multer]

That's a good suggestion, Bill. I just packed the store, so those extra BasketCharge records are gone now; but I can check for them the next time the error occurs. Thanks --