[freeside-users] fs-migrate-cust_tax_exempt not migrating the majority of entries

Cal cal361 at yahoo.com
Wed Apr 25 13:04:25 PDT 2007


I am running 1.7.2 migrated from 1.5.7.

When using fs-migrate-cust_tax_exempt only about 10%
of entries are actually migrated.  

The error for the majority of failures is: 

total h_ amount 0.00 != cust_tax_exempt.amount 25.00;
 not migrating exemption 2649 for 5/2004 (custnum
2632)

h_cust_tax_exempt reads:
	historynum 	history_date 	history_user 
history_action 	exemptnum 	custnum 	taxnum 	year 
month 	amount
	2799 	1083427245 	admin 	insert 	2649 	2632 	51 	2004
	5 	25.00


cust_tax_exempt reads:
exemptnum 	custnum 	taxnum 	year 	month 	amount
	2649 	2632 	51 	2004 	5 	25.00

h_cust_tax_exempt.amount is = cust_tax_exempt.amount
from what I see.  

Any help as to what is causing this to fail?  We
typically run our billing today and with this error I
am left hanging.

What purpose does the cust_tax_exempt table serve? 
Will clearing it and going forward cause problems with
anything besides tax reports?

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 


More information about the freeside-users mailing list