errors in awbs import

[merlinpa1969]

Hello,

 

we have found an issue with the awbs import script.....

 

It grabs the due date and next invoice date from the same place

 

 

all of our invoice dates should be 5 days before invoice due date however in the import they are the same this is gonna cause an issue,

thats alot of accounts to manually change before you can actually put them in the live database

[jozeph]

The import script don't work correctly. You need to do adjusts manually.

 

I fix a lot of problems during import. I will send some fixes to Matt, so he can update the import script.

[merlinpa1969]

You wouldnt have a little script handy to remove 5 days from the invoice date on every account do you?

[jozeph]

Use MySQL to fix... something like:

 

UPDATE tblhosting SET nextinvoicedate = DATE_SUB(nextduedate, INTERVAL 5 day);