tuksinet

This was caused by stale data in tables due to a bug in AWBS script. See this post.

AWBS import script is faulty. It should be fixed ASAP! Bug #1: raxrate Script inserts invoices using this query: INSERT INTO tblinvoices (id,date,duedate,datepaid,userid,subtotal,tax,[u]raxrate[/u],total,status,paymentmethod) VALUES ... raxrate? That should be taxrate. Fix: temporarily rename field taxrate into raxrate, import and rename to taxrate again. You can use these commands: ALTER TABLE `tblinvoices` CHANGE `taxrate` `raxrate` DECIMAL( 10, 2 ) NOT NULL ALTER TABLE `tblinvoices` CHANGE `raxrate` `taxrate` DECIMAL( 10, 2 ) NOT NULL That's all for now. I might add I like WHMCS for it's Smarty templating system and native utf-8 support (like our slavic characters), but things like this make me disappointed. After all I am a 'happy' AWBS user trying to ease my life and so far WHMCS without my old data is nothing compared to a 'working' AWBS. Please fix ASAP. Thanks. .. and sorry for the harsh words..

Hi, I am currently testing and customizing the WHMCS portal to see if it fits my company needs. So far so good: I had no bigger problems until now. When the invoice is generated, there are some items on the invoice that I don't know where they come from. I browsed through whole administration area already and found no such items. I also couldn't find the records of these items in the database. My first thought was that these are Billable Items, but I have no billable items at all. The additional items are: -Domain test "-Domain" is sometimes put on the invoice twice. Sometimes it's price is 9.99 and sometimes 20.99. I don't get it. When the client is making his order the price includes the items he chose. When he goes to checkout there are these additional items on invoice. Where can I find these items that are added automatically to the invoice and how can I get rid of them? Someone please help as I'm stuck with this issue Regards